Question
Task 3: Your third task is to use your pro forma spreadsheet to perform a sensitivity and scenario analysis. First, answer the following questions: Question
Task 3: Your third task is to use your pro forma spreadsheet to perform a sensitivity and scenario analysis. First, answer the following questions: Question 1: Perform a sensitivity analysis with respect to operating revenue. How should operating revenue change (from 2022 to 2023) for the external funding requirement to be zero? Question 2: Consider a scenario in which international travel to Australia grows quicker than expected. In such a scenario, assume that operating revenue will bounce back to 90% of the 2019 level, but that the accounts receivable item will also increase due to the large increase in sales. If the accounts receivable item is also assumed to be 90% of its 2019 value in this scenario, what is Footlooses expected funding requirement for FY2023? Question 3: One option that management is considering is to further cut their fixed operating costs by terminating the lease on various office buildings and to transition to more permanent working-from-home (WFH) arrangements. If this decision is made, then the companys fixed costs are expected to decrease to $75 million and its variable costs are expected to increase slightly from 0.5 to 0.55; hence operating expenses = $75 million + 0.55 operating revenue. What is the expected funding requirement in 2023 under this scenario? Guidance on Task 3: Write a 250500-word report on your analysis for Q1-3 above. Think of additional sensible scenarios/sensitivities and include that analysis in your report. It would be a good idea to present some of the results graphically, if possible. Having thoroughly assessed the robustness of your forecasts you turn your attention to how best to raise the external funding required. In other words, the financing choice between debt or equity securities.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started