Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how to solve question 1j, what formula should i put into cell to calculate OFCF Past Past Past Past Forecast Forecast Forecast Forecast Forecast Question

image text in transcribedhow to solve question 1j, what formula should i put into cell to calculate OFCF

Past Past Past Past Forecast Forecast Forecast Forecast Forecast Question Marks Year index -3 -2 -1 0 1 2 3 3 4 5 Year (replace with your firm's year end dates) 30-Jun-18 30-Jun-19 30-Jun-20 30-Jun-21 30-Jun-22 30-Jun-23 30-Jun-24 30-Jun-25 30-Jun-26 Qla 5 Revenue growth rate (For past: calculate based on past revenues. For 0.04323133 0.10479943 0.10033716 0.05 0.05 0.01 0.05 0.025 Q1b 2 Revenue (For past: retrieve from P&L. For forecast: cald 26,763 27,920 30,846 33,941 35,638 37,420 37,794 39,684 40,676 Q1c 1 Net Income (For past: retrieve from P&L. For forecast: 1,197 5,510 1,697 2,380 4,645 4,877 4,926 5,172 5,301 Q1d 1 Depreciation & amortisation expense (calculate based on growth rates, or estimate based on forecast P&L done sa 685 720 727 763 782 Q1e 1 Tangible and intangible capital assets, carrying amount (For past: retrieve from balance sheet. For fi 11430 16501.41285 17326.4835 17499.7483 18374.7357 18834.1041 Q1f 4 CapEx (calculate based on above net capital assets and other items) 5,071 825 173 875 459 Q1g 1 Net operating working capital (For past: retrieve from balance sheet. For forecast: calculate based o 18,299 22,272 23,433 23,677 24,908 25,555 Q1h 2 DeltaNWC (calculate based on above operating working capital and other items) 3,973 1,161 244 1,231 646 Q1i 1 Interest expense (calculate based on growth rates, or estimate based on forecast P&L done somewhere below line 161 165 202 195 173 tc, corporate tax rate (feel free to change this if you wish) 0.3 0.3 0.3 0.3 0.3 0.3 Q1j 4 OFCF (calculate based on above items)

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

Core Concepts Of Accounting Information Systems

Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman

11th Edition

9780470507025, 0470507020

More Books

Students also viewed these Accounting questions

Question

ANSWER IS Y ( 1 + adT )

Answered: 1 week ago