Data
The future of the group looks very promising:
Question
1. Revenue Forecast
As a first step, present three revenue forecasts in the Assumptions sheet:
After generating the three Revenue forecasts, analyse their profiles and label each forecast as the Base, Optimistic and Pessimistic scenario.
2. Historical Financial Statements
To start laying out the Statements sheet, please use direct links to reference all historical values in the Income Statement, Balance Sheet, and Cash Flow from the Inputs worksheet.
To start laying out the Statements sheet, please use direct links to reference all historical values in the Income Statement, Balance Sheet, and Cash Flow from the Inputs worksheet.
3. Historical Financial Analysis
Please use ratios in the Assumptions sheet to perform a financial analysis of items in the Income Statement and Balance Sheet for the period June 2018 – June 2023 (Actuals). Use the Building a Financial Model.pdf as a guide of the drivers you could use for each item.
4. Forecast Assumptions
For each of the relevant financial ratios and other inputs, create 3 sets of assumptions (Base, Optimistic, and Pessimistic) for your forecast.
Base your choice of values in your historical financial analysis, your expectations about TPW’s future expected performance in each scenario, as well as any additional information you can access in the company’s documents (TPW Financial Report 2023.pdf and TPW Investor Presentation 2023.pdf).
Here is an important note from the financial report:
The cost of goods sold also includes the shipping costs (Distribution) incurred on delivery of products to customers of $55,726,000 (2022: $56,850,000). This was a change in presentation during the year ended 30 June 2023. The comparative prior year balances were also updated in line with this change in presentation.”
The following items can have the same assumption across the three scenarios: o Income Statement:
5. Outputs
Base Charts Component
In the Dashboard worksheet, please:
Base Written Component
In the Dashboard worksheet,
Refer to the first chart above:
6. Best Practices
Aim to structure and format your Excel solution in the most efficient way possible and use financial modeling best practices. Please refer to the Week 2 material.
BEN02 Planning and Presenting a Micro-Enterprise Idea BTEC Level 1/2
Read MoreBTEC Unit 35: Engineering Services Delivery Plan for Sector-Specific Organizations | HND Level 5 Assignment 2
Read MoreTQUK Level 3 Administering Medication and Monitoring Effects in Adult Care Assignment
Read MoreUnit 10: 3D Modelling and Assembly Drawing for Vice – Engineering Design Portfolio BTEC Level 3
Read MoreWhy is it important that you correlate the appropriate information of the patient when they arrive for their appointment?
Read MoreNCFE Level 3 Roles and Responsibilities in Health And Social Care
Read MoreMP3395 Turbocharger Performance Evaluation and System Analysis CW2 Assessment, AY2024-25
Read MoreKey Research Policies and Funding Models at University of Strathclyde
Read MoreCIPD Level 5 Associate Diploma Key Assessment Questions
Read MoreLaw Assignment Questions Critical Legal Analysis & Solutions
Read More