# Internal Rate of return , Net present value, and component costs.

### Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

# 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?