Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How to find DeltaNOWC ? What I did in excel isn't correct 16,148 1 Past Past Past Past Forecast Forecast Forecast Forecast Forecast 2 Question
How to find DeltaNOWC ?
What I did in excel isn't correct
16,148 1 Past Past Past Past Forecast Forecast Forecast Forecast Forecast 2 Question Marks Year index -3 -2 -1 0 1 2 3 4 5 3 Year (replace with your firm's year end dates) 24-Sep-16 30-Sep-17 29-Sep-18 28-Sep-19 30-Sep-20 30-Sep-21 30-Sep-22 30-Sep-23 30-Sep-24 4 Ola 5 Revenue growth rate (For past: calculate based on past revenue 0.063045182 0.158619577 -0.0204108 0.06 0.087 0.117 0.159 0.2163807 5 01b 2 Revenue (For past: retrieve from P&L. For forecast: 215,639 229,234 265,595 260,174 275,784 299,778 334,852 388,093 472,069 6 Qlc 1 Net Income (For past: retrieve from P&L. For foreca 45,687 48,351 59,531 55,256 51,222 58,628 66,137 77,542 95,272 7 Qid 1 Depr & amortisation expense (estimate based on forecast P&L done somewhere below line 100) 13,300 14,457 18,716 22,766 8 Qle 8 1 Tangible intangible capital assets, carrying amount, net of depreciation and amortisation (estim 28,303 30,001 32,611 36,427 42,219 51,354 9 Qif 4 CapEx (calculate based on above net capital assets and other items) -232,483 -252,709 -282,277 -327,158 -397,949 10 Qig 1 Operating net working capital (estimate based on forecast balance sheet done somewhere below line 73,341 -13,318 -5,193 -1,387 4,390 13,502 11 Qih 2 DeltaNOWC (calculate based on above operating working capital and other items) -87,634 6,628 1,616 2,454 3,870 12 011 1 Interest expense (estimate based on forecast P&L done somewhere below line 100) 3,375 -64 -895 -2,163 -3.835 13 tc, corporate tax rate 0.21 0.21 0.21 0.21 0.21 0.21! 14 Qaj OFCF (calculate based on above items) 387,305 319,115 362,239 419,254 509,087 15 4 16,148 1 Past Past Past Past Forecast Forecast Forecast Forecast Forecast 2 Question Marks Year index -3 -2 -1 0 1 2 3 4 5 3 Year (replace with your firm's year end dates) 24-Sep-16 30-Sep-17 29-Sep-18 28-Sep-19 30-Sep-20 30-Sep-21 30-Sep-22 30-Sep-23 30-Sep-24 4 Ola 5 Revenue growth rate (For past: calculate based on past revenue 0.063045182 0.158619577 -0.0204108 0.06 0.087 0.117 0.159 0.2163807 5 01b 2 Revenue (For past: retrieve from P&L. For forecast: 215,639 229,234 265,595 260,174 275,784 299,778 334,852 388,093 472,069 6 Qlc 1 Net Income (For past: retrieve from P&L. For foreca 45,687 48,351 59,531 55,256 51,222 58,628 66,137 77,542 95,272 7 Qid 1 Depr & amortisation expense (estimate based on forecast P&L done somewhere below line 100) 13,300 14,457 18,716 22,766 8 Qle 8 1 Tangible intangible capital assets, carrying amount, net of depreciation and amortisation (estim 28,303 30,001 32,611 36,427 42,219 51,354 9 Qif 4 CapEx (calculate based on above net capital assets and other items) -232,483 -252,709 -282,277 -327,158 -397,949 10 Qig 1 Operating net working capital (estimate based on forecast balance sheet done somewhere below line 73,341 -13,318 -5,193 -1,387 4,390 13,502 11 Qih 2 DeltaNOWC (calculate based on above operating working capital and other items) -87,634 6,628 1,616 2,454 3,870 12 011 1 Interest expense (estimate based on forecast P&L done somewhere below line 100) 3,375 -64 -895 -2,163 -3.835 13 tc, corporate tax rate 0.21 0.21 0.21 0.21 0.21 0.21! 14 Qaj OFCF (calculate based on above items) 387,305 319,115 362,239 419,254 509,087 15 4Step 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