Answered step by step
Verified Expert Solution
Link Copied!

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 correctimage text in transcribed

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 4

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

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant M. Datar, Madhav V. Rajan

16th edition

134475585, 978-0134475998, 134475992, 978-0134475585

Students also viewed these Finance questions