Cement Business Financial Model
Budget: $30 – $250 USD
I need a fully-integrated Excel model for a cement company built and delivered within the next ten hours. I will supply the complete historical financial statements; your task is to structure those actuals, then extend the file into clean projections with built-in sensitivity and multi-scenario capability.
Key elements to incorporate
• Separate assumptions sheet that drives market growth rate, cost of production, pricing strategy and capacity utilisation inputs.
• Automated projections that roll into an income statement, balance sheet, cash-flow statement and a concise valuation summary.
• Switchable scenarios (base, downside, upside) plus tornado or data-table style sensitivity so I can instantly see the impact of the core drivers above.
• Clear, print-ready report tabs and a brief guide that shows how to update the model.
Acceptance criteria
1. Historical numbers reconcile to the source statements.
2. The three primary financials remain fully linked and balance throughout the forecast period.
3. Scenario toggles and sensitivity tables recalculate without circularity or errors.
4. All hard-codes are confined to the assumptions sheet.
Please deliver the Excel file along with any quick start notes so I can review results immediately after completion.
Key elements to incorporate
• Separate assumptions sheet that drives market growth rate, cost of production, pricing strategy and capacity utilisation inputs.
• Automated projections that roll into an income statement, balance sheet, cash-flow statement and a concise valuation summary.
• Switchable scenarios (base, downside, upside) plus tornado or data-table style sensitivity so I can instantly see the impact of the core drivers above.
• Clear, print-ready report tabs and a brief guide that shows how to update the model.
Acceptance criteria
1. Historical numbers reconcile to the source statements.
2. The three primary financials remain fully linked and balance throughout the forecast period.
3. Scenario toggles and sensitivity tables recalculate without circularity or errors.
4. All hard-codes are confined to the assumptions sheet.
Please deliver the Excel file along with any quick start notes so I can review results immediately after completion.
Related categories:
Accounting
Excel
Finance
Business Analysis
Excel VBA
Data Analysis
Financial Forecasting
Financial Modeling