Financial Analysis Projects in LagosFinancial Analysis Projects in Lagos
Projects
People
Cover image for The model is essentially a
The model is essentially a fully integrated 10-year three-statement financial model that links the Income Statement, Balance Sheet, and Cash Flow Statement dynamically, meaning any operational shift automatically updates the entire ecosystem. It handles forecasting by anchoring line items to fixed percentage drivers, such as setting accounts receivable to 20% of revenue and inventory to 25% of the cost of sales to maintain structured working capital cycles. Structurally, it separates capital management into an aggressive repayment schedule for legacy debt and a continuous financing loop where 70% of annual CAPEX is funded via new debt. Finally, it layered in a scenario manager to stress-test these mechanics across Base, Best, and Worst-case outcomes, while feeding a Dupont analysis matrix to track true return on equity performance.
0
26