22 Nov 2020
Solve the following problems in an Excel spreadsheet, # 1 for present values and #2 for rates.
PV | YR | Interest | FV | |
13 | 9% | 15451 | ||
4 | 7% | 51557 | ||
29 | 24% | 886073 | ||
PV | 40 | 35% | 550164 | |
181 | YR | Interest | FV | |
335 | 4 | 297 | ||
48000 | 18 | 1080 | ||
40353 | 19 | 185382 | ||
25 | 531618 |
#3 Solve current price for a 23 year bond with a coupon rate of 5.8% and a yield to maturity of 4.7%
#4 Solve for current price of a stock that paid a $1.95 dividend and expected to grow at a 4% rate with a required return of 10.5%.
#5 A company is expecting yearly cash inflows for the next four years in their new expansion investment of $50,000, $55,000, $80,000, and $120,000. Using a 8.5% discount rate, what is the sum of the present values of these expected cash inflows and should the company continue with this investment if the initial outlay is $200,000?