Required Accounting,Microsoft Power BI,Excel,Budgeting & Forecasting,Cost Accounting freelancer for Direct/Indirect costs calculation, Cash Flow, Unit cost, Unit price, job

Creating an Excel file is a comprehensive financial proposal for a project structured into several key sections. It includes detailed estimates of both capital expenditures (CAPEX) and operating expenses (OPEX) on the "CAPEX-OPEX Estimate" sheet, which provides itemized costs, timeframes, and assumptions. Include an "Exec Summary" sheet that offers a high-level overview of the financials, highlighting key metrics, total costs, and projected returns. Include Labor costs, including salaries, benefits, and related expenses, are detailed in the "Labor" sheet. Include a "Capital" sheet outlining capital investments such as equipment and infrastructure, including purchase costs and depreciation. Ongoing maintenance costs are estimated in the "Maintenance" sheet, covering regular upkeep and repairs. Also, the "Other" sheet includes miscellaneous expenses that do not fit into the other categories. Finally, include the "Loan/Financing" spreadsheet that will fully analyse the loans and repayment scheme, which will reflect and be connected to the cash flow.

The file has to be designed to ensure accurate and consistent data entry, with automated calculations, conditional formatting, and clear visualizations to support decision-making and arriving at the selling price, which will ensure profits.

Skills & Expertise Required