Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Question: A relative, who just turned 60, is looking at purchasing an investment product which promises to pay $40,000 next year (on his 61st birthday) and will pay an amount that grows by 2% each year until his 80th birthday (a total of 20 payments). The appropriate interest rate is 6%. He has asked you for your advice on what price he should be willing to pay for this investment product. How much is the investment product worth today? If possible how would you do this in excel?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M93058481

Have any Question?


Related Questions in Basic Finance

A firm is considering the two mutually exclusive

A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay of $600 and will return $160 per year for the next seven years; Project Beta requires an initial outlay of $ ...

Thsi estimates that their project will initially cost 523

THSI estimates that their project will initially cost $5.23 million to setup and will generate $20 million in revenues during its first and only year in operation (paid in one year). Operating expenses are expected to to ...

Burke tires just paid a dividend of d0 134 analysts expect

Burke Tires just paid a dividend of D0 = $1.34. Analysts expect the company's dividend to grow by 30% this year, by 19.25% in Year 2, and at a constant rate of 5% in Year 3 and thereafter. The required return on this low ...

You are 25 years old and have not started saving for

You are 25 years old and have not started saving for retirement yet. You want to retire at 55. You want $1,000,000 in your account. You can earn 5% on average over the next 30 years. How much do you have to save each mon ...

What is the present value of a security that will pay 9000

What is the present value of a security that will pay $9,000 in 20 years if securities of equal risk pay 12% annually? Round your answer to the nearest cent

Polycorp has a debt equity ratio of 065 what is the correct

Polycorp has a debt equity ratio of 0.65. What is the correct debt ratio D/V that should be used in the WACC formula? WACC = ke x E/V + kd x (1-t) x D/V Provide an answer as a decimal accurate to two decimal places eg 60 ...

If you deposit 806 into an account paying 2300 annual

If you deposit $806 into an account paying 23.00% annual interest compounded quarterly, how many years until there is $14,806 in the account? If you deposit $214 into an account paying 07.00% annual interest compounded m ...

Old xyz corp has total assets of 1000000 and a debt ratio

Old XYZ Corp has total assets of $1,000,000 and a debt ratio of 30%. Currently it has sales of $2,500,000, total fixed costs of $1,000,000, and EBIT of $50,000. If XYZ pays 6% interest on debt, what is XYZ's ROE?

Looking at the financials for the good old xyz corp in 2016

Looking at the financials for the good old XYZ Corp, in 2016 they had a retained earnings balance of $7,933 million. In 2017, just one year later, it was $9,557 million! XYZ sold no stock during the year BUT they did pay ...

Question - you are given one-year stock options with an

Question - You are given one-year stock options with an exercise price of $30. The current stock price is $30, so the options are at-the-money. Without hedging, the stock price at year-end will either be $28 or $38 with ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As