In: Finance
Over the next three years, a firm is expected to earn economic profits of $60,000 in the first year, $50,000 in the second year, and $20,000 in the third year. After the end of the third year, the firm will go out of business. a. If the risk-adjusted discount rate is 6 percent for each of the next three years, the value of the firm is $________. The firm can be sold today for a price of $________. b. If the risk-adjusted discount rate is 11 percent for each of the next three years, the value of the firm is $________. The firm can be sold today for a price of $________.

Formula sheet
| A | B | C | D | E | F | G | H |
| 2 | |||||||
| 3 | a) | ||||||
| 4 | Value of the firm today will be the present value of the expected future cash flows. | ||||||
| 5 | Cash Flow of the firm will be as follows: | ||||||
| 6 | Year | 0 | 1 | 2 | 3 | ||
| 7 | Cash Flow | 60000 | 50000 | 20000 | |||
| 8 | |||||||
| 9 | Calculation of value of the firm at discount rate of 6%: | ||||||
| 10 | |||||||
| 11 | Year | 0 | 1 | 2 | 3 | ||
| 12 | Cash Flow | =E7 | =F7 | =G7 | |||
| 13 | MARR (i) | 0.06 | |||||
| 14 | (P/F,i,n) for each year | =1/((1+$D13)^E11) | =1/((1+$D13)^F11) | =1/((1+$D13)^G11) | |||
| 15 | Present Value of cash flows = FCF*(P/F,i,n) | =E12*E14 | =F12*F14 | =G12*G14 | |||
| 16 | Present value if future cash flows | =SUM(E15:G15) | =SUM(E15:G15) | ||||
| 17 | |||||||
| 18 | Hence value of the firm at 6% discount rate is | =D16 | |||||
| 19 | |||||||
| 20 | The firm can be sold today at the value calculated above. | ||||||
| 21 | |||||||
| 22 | Hence firm can be sold today at the price of | =D18 | |||||
| 23 | |||||||
| 24 | b) | ||||||
| 25 | |||||||
| 26 | Calculation of value of the firm at discount rate of 11%: | ||||||
| 27 | |||||||
| 28 | Year | 0 | 1 | 2 | 3 | ||
| 29 | Cash Flow | =E7 | =F7 | =G7 | |||
| 30 | MARR (i) | 0.11 | |||||
| 31 | (P/F,i,n) for each year | =1/((1+$D30)^E28) | =1/((1+$D30)^F28) | =1/((1+$D30)^G28) | |||
| 32 | Present Value of cash flows = FCF*(P/F,i,n) | =E29*E31 | =F29*F31 | =G29*G31 | |||
| 33 | Present value if future cash flows | =SUM(E32:G32) | =SUM(E32:G32) | ||||
| 34 | |||||||
| 35 | Hence value of the firm at 11% discount rate is | =D33 | |||||
| 36 | |||||||
| 37 | The firm can be sold today at the value calculated above. | ||||||
| 38 | |||||||
| 39 | Hence firm can be sold today at the price of | =D35 | |||||
| 40 | |||||||