Excel Online Structured Activity: Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts...

Corporate valuation Dollars/shares in millions FCF FOF2 FCF Constant growth rate. WACC Market value of debt Common shares outstanding -\$8.00 \$22.00 \$36.00 5.00% 11.00% \$33.00 22 \$36.00 3 FCFS 4 Horizon value Total FCFs 7 PV of FCFs to investors 9 Firm value today 1 Market value of equity, MV Equity 2 Price per share, Po Formulas -\$8.00 \$22.00 6 FCFS Horizon value Total FCFs \$30.00 NA #NIJA WNIA =N/A PV of FCFs to investors #N/A ANA ΕΝΑ Firm value today #NIA Market value of equity, MV Equity Price per share, Po #N/A #N/A

1.
=36*1.05/(11%-5%)=630

2.
=-8/1.11+22/1.11^2+36/1.11^3+36/1.11^3*1.05/(11%-5%)=497.621946270595

3.
=(-8/1.11+22/1.11^2+36/1.11^3+36/1.11^3*1.05/(11%-5%)-33)/22=21.1191793759361

Earn Coin

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• Excel Online Structured Activity: Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts...

Excel Online Structured Activity: Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 11%. Year FCF (\$ millions) - \$14 \$17 \$36 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a....

• Excel Online Structured Activity: Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts...

Excel Online Structured Activity: Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 11%. Year FCF (\$ millions) - \$14 \$17 || \$36 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet...

• Excel Online Structured Activity: Corporate valuation Dantzler Corporation is a fast-growing supplier of office products...

Excel Online Structured Activity: Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 4% rate. Dantzler's WACC is 10%. Year   0   1   2   3 .......   .......   .......   .......   .......   .......   .......   ....... FCF (\$ millions)   .......   .......   .......   .......   .......   .......   .......   ...... - \$14   \$15   \$42 The data has been collected in the Microsoft...

• Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows...

Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 8% rate. Dantzler's WACC is 11%. Year 0 1 2 3 ....... ....... ....... ....... ....... ....... ....... ....... FCF (\$ millions) ....... ....... ....... ....... ....... ....... ....... ...... - \$19 \$26 \$35 a. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all...

• 8. CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the followi...

8. CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 4% rate. Dantzler's WACC is 11%. Year 1 2 3 FCF (\$ millions) - \$15 \$13 \$37 a. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer...

• CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free...

CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 16%. Year -TA FCF (\$ millions) a. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two decimal places. Enter your answer...

• CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free...

CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 7% rate. Dantzler's WACC is 12%. Year 1 2 FCF (\$ millions) - \$18 \$25 \$40 a. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two...

• CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free...

CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 13%. Year 1 2 FCF (\$ millions) - \$12 \$23 \$40 a. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two...

• Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free...

Corporate valuation Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 8% rate. Dantzler's WACC is 15%. Year HH FCF (S millions) NA - \$16 \$32 \$37 a. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two...

• CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free...

CORPORATE VALUATION Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 6% rate. Dantzler's WACC is 12%. Year 0 1 2 3 ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ...... FCF (\$ millions) - \$8 \$21 \$45 What is Dantzler's horizon, or continuing, value? (Hint: Find the value of...