Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer questions D and E shown in the excel sheet, please add formula's for answer. Thank you. Inputs Actual Projected Projected Projected Projected 1

Please answer questions D and E shown in the excel sheet, please add formula's for answer. Thank you.
Inputs Actual Projected Projected Projected Projected
12/31/202312/31/2412/31/2512/31/2612/31/27
Sales Growth Rate 7%5%3%2%
Costs/Sales 72%73%74%75%77%
Depreciation/(Net PPE)10%10%10%10%10%
Cash/Sales 1%1%1%1%1%
(Acct. Rec.)/Sales 10%10%10%11%11%
Inventories/Sales 20%21%23%25%27%
(Net PPE)/Sales 75%75%75%75%75%
(Acct. Pay.)/Sales 2%2%2%2%2%
Accruals/Sales 5%5%5%5%5%
Tax rate 40%21%21%21%21%
Weighted average cost of capital (WACC)8.5%8.5%8.5%8.5%8.5%
Actual Projected Projected Projected Projected
Calculation of FCF 12/31/202312/31/2412/31/2512/31/2612/31/27
Operating current assets $248.0 $273.4 $285.2 $304.6 $318.1
Operating current liabilities $56.0 $59.9 $58.8 $57.7 $57.1
Net operating working capital $192.0 $213.4 $226.4 $247.0 $261.0
Net PPE $600.0 $642.0 $630.0 $618.0 $612.0
Total net operating capital $792.0 $855.4 $856.4 $865.0 $873.0
NOPAT $98.4 $131.9 $122.8 $113.9 $99.9
Investment in total net operating capital na $63.4 $1.0 $8.6 $8.0
Free cash flow na $68.5 $121.8 $105.3 $91.9
Growth in FCF na na 756.25%77.82%-13.55%
Growth in sales 7.0%5.0%3.0%2.0%
image text in transcribed

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

Python For Finance

Authors: Yves Hilpisch

2nd Edition

1492024333, 978-1492024330

More Books

Students also viewed these Finance questions

Question

Which form of proof do you find most persuasive? Why?

Answered: 1 week ago