Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Todays Mood Is Sponsored By Auditing

Authors: Ruby Publishing

1st Edition

B08BG52SST, 979-8655512771

More Books

Students also viewed these Accounting questions

Question

Differentiate 3sin(9x+2x)

Answered: 1 week ago

Question

Compute the derivative f(x)=(x-a)(x-b)

Answered: 1 week ago