Complete 3-Statement Financial Model
The project involves developing a comprehensive 3-statement financial model derived from three years of transaction data. The model integrates an income statement, balance sheet, and cash flow statement, all dynamically linked and designed for seamless updates. A five-year forecast is included, supported by a scenario-based feature in the income statement, allowing for the analysis of best, base, and worst-case scenarios. Additional schedules, including fixed assets, financial liabilities, and equity, further enhance the model's depth. To see the complete model, please download the complete project file from the button below.
Balance Sheet table created from the list of transactions. An additional 5-year forecast is included
by using the "Days Outstanding" method (DSO,DPO,DIO). A check row is also added to the end of the sheet to ensure the accounting formula (Assets = Liabilities + Equity) holds.
The income Statement table is derived from the list of transactions. Percent changes between items are used as a base while forecasting and estimating different figures for different scenarios.
A sensitivity analysis is also included, with the help of Excel's CHOOSE() function, users may select best-case, base-case, and worst-case scenarios.
