Answered step by step
Verified Expert Solution
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
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 ? Q1jStep 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