Question: 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%
 Please answer questions D and E shown in the excel sheet,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!