Individual, Submit an Excel spreadsheet with the following problem’s solutions.
Internal rate of return, Net present value, and component costs.
#1 Investment x pays $4,700 per year for 8 years and investment y pays $6,700 a year for 5 years. Which investment has the higher present value if the discount rate is 5% and 15%?
#2 Determine the NPV and the IRR of a potential project with an initial outlay of $220,000 and expected yearly cash inflows of $100,000 for 2 years then $120,000 for the next 2 years. With a required return of 12.5%, should the company take the project?
#3 The company paid a $2.50 dividend last year with an expected growth rate of 5% and a required return of 10.5 %. What is the price value of the stock now?
#4 What is the value of a 20 year bond with 7.5% coupon rate and a 4.7% yield to maturity?
#5 What is the break even quantity for a product with $1,000 of fixed costs, $20 of variable costs, and a price of $45?