Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to find Q1h and Q1j Question Forecast 5 30-Jun-25 -0.01 21,597 -505 Qla Qib Q1c Qid Qle Qif Qig Qih 011 Past Past Past

How to find Q1h and Q1j

image text in transcribed

Question Forecast 5 30-Jun-25 -0.01 21,597 -505 Qla Qib Q1c Qid Qle Qif Qig Qih 011 Past Past Past Past Forecast Marks Year index -3 -2 -1 0 1 Year (replace with your firm's year end dates) 30-Jun-17 30-Jun-18 30-Jun-19 30-Jun-20 30-Jun-21 5 Revenue growth rate (For past: calculate based on past revenues. For -0.00007688 -0.02891085 -0.0986579 0.05 2 Revenue (For past: retrieve from P&L. For forecast: cal 26,013 26,011 25,259 22,767 23,905 1 Net Income (For past: retrieve from P&L. For forecast: 3,891 3,563 2,154 1,819 1,488 1 Depr & amortisation expense (estimate based on forecast P&L done somewhere below line 100) 5,604.9 1 Tangible and intangible capital assets, carrying amount, net of depreciation and amortisation (estir 30,856 30,616 4 CapEx (calculate based on above net capital assets and other items) 5,365 1 Operating net working capital (estimate based on forecast balance sheet done somewhere below -797 -709 2 DeltaNOWC (calculate based on above operating working capital and other items) ? 1 Interest expense (estimate based on forecast P&L done somewhere below line 100) 873 tc, corporate tax rate 0.3 0.3 4 OFCF (calculate based on above items) ? Forecast 2 30-Jun-22 -0.04 22,949 891 5,380.7 23,685 -1,551 -783 Forecast Forecast 3 4 30-Jun-23 30-Jun-24 -0.03 -0.02 22,261 21,815 403 -58 5,219.3 5,114.9 17,743 12,671 -723 42 -836 -871 ? ? 880 854 0.3 0.3 ? ? 5,063.7 8,377 770 -888 ? 837 ? 917 0.3 ? 0.3 ? Q1j

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

Step: 3

blur-text-image

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

Forecasting And Predictive Analytics With Forecast X

Authors: Barry Keating, J. Holton Wilson, John Solutions Inc.

7th International Edition

1260085236, 9781260085235

More Books

Students also viewed these Finance questions

Question

What are the application procedures?

Answered: 1 week ago

Question

What does this public not want on this issue?

Answered: 1 week ago

Question

What does this public want on this issue?

Answered: 1 week ago