Question: Please show excel formulas Save ( OFF A 9 9 9 . C .. Chap 6 Excel.xis - Compatibility Mode Insert Draw Page Layout Formulas

Please show excel formulas

Please show excel formulas Save ( OFF A 9 9 9 . C
Save ( OFF A 9 9 9 . C .. Chap 6 Excel.xis - Compatibility Mode Insert Draw Page Layout Formulas Data Review View 9 Tell me Share Comm Arial AA 29 Wrap Text v General E E Merge & Center $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table Styles Filter Select board Font Alignment Number Styles Cells Editing Analy D G H Chapter 6 Input Area: YEAR Terminal EBIT $ 1 10,000,000.00 EBIT Depreciation 1,000,000.00 Depreciation CapEx 1,200.000.00 Change in NWC 800 000 00 OCF tax rate 2170 CapEx EBIT Growth First 4 ys 5% Change in WC Depreciation (10% of EBIT) Year 5 Projected FCF CapEx maintain at 120% of Dep FCF Terminal Value Change in NWC Growth First 4y PV of TV 3 70 PV of FCF Terminal EBIT Grwth Rate 3% Terminal NWC Grwth Rate 3% Risk Free Rate Equity Beta 19 Market Risk Premium 7% Total Firm Value Interest Rate on Debt Debt Market Value Debt Weighting 25% Equity Weighting 75% Enterprise Value 540,000,000.00 Risk Free Rate 3% Equity Beta $12 413 #14 #17 #18 #19 #21 422 #23 #25 #26 #27 #28 #29 #30 #31 + -+ 100% Ready O 3 3 A F command cation

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!