Question: How do i work out the OFCF? You can see the words when you transcribe the image 1 1 Past Past Past Past Forecast Forecast
How do i work out the OFCF? You can see the words when you transcribe the image 
1 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) 30-Jun-18 30-Jun-19 30-Jun-20 30-Jun-21 30-Jun-2230-Jun-23 30-Jun-24 30-Jun-25 30-Jun-26 4 Ola 5 Revenue growth rate (For past: calculate based on past reve -0.0860129 -0.0736137 -0.0398112 0.01 0.03 0.04 0.02 0.025 5 Q1b 2 Revenue (For past: retrieve from P&L. For forec 21,332 19,497 18,062 17,343 17,516 18,042 18,764 19,139 19,617 6 Qic 1 Net Income (For past: retrieve from P&L. For fo 2,656 1,510 1,256 1,392 1,471 1,557 1,616 1,633 1,669 7 Qid Depreciation & amortisation expense calculate based on growth rates, or estimate based on fore 2,697 2,778 2,889 2,947 3,021 8 Qle 1 Tangible and intangible capital assets, carrying amount (For past: retrieve from balan 23,901 21,268 21,883 22,728 23,167 23,727 9 oif 4 Capex (calculate based on above net capital assets and other items) -2,633 615 845 439 560 10 Qig 1 Net operating working capital (For past: retrieve from balance sheet. For forecast: cal -2,482 -1,720 -1,801 -1,873" -1,911 -1,959 11 Qih 2 DeltaNWC (calculate based on above operating working capital and other items) 762 -81 -72 -37 -48 12 oli 1 Interest expense (calculate based on growth rates, or estimate based on forecast P&L done some 392 331 351 379 395 13 tc, corporate tax rate (feel free to change this if you wish) 0.3 0.3 0.3 0.3 0.3 0.3 14 Q1j 4 OFCF (calculate based on above items) ) 1 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) 30-Jun-18 30-Jun-19 30-Jun-20 30-Jun-21 30-Jun-2230-Jun-23 30-Jun-24 30-Jun-25 30-Jun-26 4 Ola 5 Revenue growth rate (For past: calculate based on past reve -0.0860129 -0.0736137 -0.0398112 0.01 0.03 0.04 0.02 0.025 5 Q1b 2 Revenue (For past: retrieve from P&L. For forec 21,332 19,497 18,062 17,343 17,516 18,042 18,764 19,139 19,617 6 Qic 1 Net Income (For past: retrieve from P&L. For fo 2,656 1,510 1,256 1,392 1,471 1,557 1,616 1,633 1,669 7 Qid Depreciation & amortisation expense calculate based on growth rates, or estimate based on fore 2,697 2,778 2,889 2,947 3,021 8 Qle 1 Tangible and intangible capital assets, carrying amount (For past: retrieve from balan 23,901 21,268 21,883 22,728 23,167 23,727 9 oif 4 Capex (calculate based on above net capital assets and other items) -2,633 615 845 439 560 10 Qig 1 Net operating working capital (For past: retrieve from balance sheet. For forecast: cal -2,482 -1,720 -1,801 -1,873" -1,911 -1,959 11 Qih 2 DeltaNWC (calculate based on above operating working capital and other items) 762 -81 -72 -37 -48 12 oli 1 Interest expense (calculate based on growth rates, or estimate based on forecast P&L done some 392 331 351 379 395 13 tc, corporate tax rate (feel free to change this if you wish) 0.3 0.3 0.3 0.3 0.3 0.3 14 Q1j 4 OFCF (calculate based on above items) )
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
