Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total Debt 25,000 25,000 25,000 25,000 25,000 25,000 EBITDA 4,500 4,800 5,200 6,000 6,500 7,200 Free Cash Flow before Debt Service (1,250) (2,500)...

Please help meYear 0<br>Year 1<br>Year 2<br>Year 3<br>Year 4<br>Year 5<br>Year 6<br>Total Debt<br>25,000<br>25,000<br>25,000<br>25,000<br>25,000<br>25,000<br>EBITDA<br>4,500<br>4,800<br>5,200<br>6,000<br>6,500<br>7,200<br>Free Cash Flow before Debt Service<br>(1,250)<br>(2,500)<br>1,550<br>2,450<br>3,250<br>3,650<br>4,250<br>Net Equity Cash Flows<br>300<br>1,200<br>2,000<br>2,400<br>3,000<br>Expected Equity Return<br>20%<br>Exit Year<br>Year 5<br>Terminal Value<br>1. EBITDA Multiple<br>8.0x<br>2. Perputity Method (use Next Year's Cash Flow)<br>WACC<br>10.0%<br>Growth Rate<br>5.0%<br>OUTPUT<br>CASH FLOW PROJECTIONS FOR DCF<br>1<br>2<br>3<br>4<br>5<br>Year 0<br>Year 1<br>Year 2<br>Year 3<br>Year 4<br>Year 5<br>Year 6<br>Equity Cash Flows<br>Terminal Value (Exit Year)<br>1. EBITDA Multiple<br>2. Perputity Method (use Next Year's Cash Flow)<br>Average<br>Debt<br>Equity TV<br>Equity Cash Flows + TV<br>Net Present Value<br>IRR<br>

Extracted text: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Total Debt 25,000 25,000 25,000 25,000 25,000 25,000 EBITDA 4,500 4,800 5,200 6,000 6,500 7,200 Free Cash Flow before Debt Service (1,250) (2,500) 1,550 2,450 3,250 3,650 4,250 Net Equity Cash Flows 300 1,200 2,000 2,400 3,000 Expected Equity Return 20% Exit Year Year 5 Terminal Value 1. EBITDA Multiple 8.0x 2. Perputity Method (use Next Year's Cash Flow) WACC 10.0% Growth Rate 5.0% OUTPUT CASH FLOW PROJECTIONS FOR DCF 1 2 3 4 5 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Equity Cash Flows Terminal Value (Exit Year) 1. EBITDA Multiple 2. Perputity Method (use Next Year's Cash Flow) Average Debt Equity TV Equity Cash Flows + TV Net Present Value IRR

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here