What is the future value of the cash flows

Assignment Help Financial Management

Reference no: EM131577450

Using Excel, provide solutions for the following problems. Use one tab for each solution. Must show work to earn credit. Submit one file with several tabs.

Part A - You are offered an investment that will pay you $100 in one year, $500 the next year, $700 the next year, and $900 at the end of the next year. You can earn 8 percent on very similar investments. What is the most you should pay for this one?

Part B - You are offered an investment that will make three $3,000 payments. The first payment will occur five years from today. The second will occur in six years, and the third will follow in seven years. If you can earn 9 percent, what is the most this investment is worth today? What is the future value of the cash flows?

Part C - What is the price of a bond with 10% annual coupon with 5 years left to maturity, if the current interest rate is 10%. calculate the price if the current market interest rates are 5% and 15%. Compare and contrast three valuation prices, explain why they are different.

Reference no: EM131577450

Questions Cloud

Acquired when making real estate investment : The text begins by stating that it is important to understand both the physical nature and property rights being acquired when making a real estate investment.

Required amount to buy the house of your dreams : How much money should you place in this savings account every month in order to accumulate the required amount to buy the house of your dreams?

What is your internal rate of return on investment : You are thinking about letting friend borrow $10,000 today given that she will repay you $15,000 in 5 years. What is your internal rate of return on investment?

Calculate? cobalts net operating profits after taxes : Calculate? Cobalt's net operating profits after taxes? (NOPAT?), and use it to estimate the value of the firm.?

What is the future value of the cash flows : what is the most this investment is worth today? What is the future value of the cash flows?

What is bond yield to maturity : The coupon rate is 6.20 percent and the quoted price is 114:11. What is the bond's yield to maturity?

What must the expected return on market be : A stock has an expected return of 14 percent, its beta is 1.20, and the risk-free rate is 5.8 percent. What must the expected return on the market be?

Push approach to promotion of prescription drugs : In the past, US pharmaceutical firms relied exclusively on a push approach to the promotion of prescription drugs.

Decided to place equal year-end deposits in savings account : You have decided to place equal year-end deposits in a savings account for the next 18 years.

User Account

All Pages