Model enables the user to export final reports to a separate workbook. It is also possible to create multiple budgets and scenarios within the model.
As discussed in Section 7 Outputs: Standard Reports, all three financial statements can be reviewed by clicking on corresponding buttons in the View Outputs group:
Because the Statement of Profit and Loss, Balance Sheet and Cash Flow Statement are the final outputs of our model, we often need to review & communicate them separately without including the entire model.
We also may need to export Budgets of all three Financial Statements as well as the Scenarios to excel workbooks. For instructions on how to create budgets and scenarios, please, review Section 8.2 Creating Budget & Section 8.3 Scenario Analysis.
Outputs can be exported into a workbook by clicking on Reports Budgets > Export Reports.
In case there are multiple budgets and scenarios in the model, we will see them all listed under Budgets & Scenarios, respectively. User can select which reports to export by ticking the corresponding box.
The resulting output is the excel workbook with all the previously selected reports on separate worksheets.