Question

In: Finance

Your brother has offered to give you $ 175​, starting next​ year, and after that growing...

Your brother has offered to give you $ 175​, starting next​ year, and after that growing at 3.1 % per year for the next 20 years. You would like to calculate the value of this offer by calculating how much money you would need to deposit in a local bank so that the amount will generate the same cash flows as he is offering you. Your local bank will guarantee a 6.3 % annual interest rate so long as you have money in the account.

a. How much money will you need to deposit into the account​ today?

b. Assuming you deposited the amount of money in part ​(a​), and then withdrew the required payments each​ year, calculate the remaining balance at the end of years​ 1, 2, 10 and 19.​ (Hint: To solve this problem it is best to use an excel​ spreadsheet.) Please round these numbers to the nearest cent

Your brother has offered to give you $ 175​, starting next​ year, and after that growing at 3.1 % per year for the next 20 years. You would like to calculate the value of this offer by calculating how much money you would need to deposit in a local bank so that the amount will generate the same cash flows as he is offering you. Your local bank will guarantee a 6.3 % annual interest rate so long as you have money in the account.

a. How much money will you need to deposit into the account​ today?

b. Assuming you deposited the amount of money in part ​(a​), and then withdrew the required payments each​ year, calculate the remaining balance at the end of years​ 1, 2, 10 and 19.​ (Hint: To solve this problem it is best to use an excel​ spreadsheet.) Please round these numbers to the nearest cent

Solutions

Expert Solution

(a) Annual Withdrawal = $ 175, Interest Rate = 6.3 % and Withdrawal Tenure = 20 years, Deposit Growth Rate = 3.1%

Amount Required to be Deposited at Present = Total Present Value of Annual Withdrawals = 175 / (0.063-0.031) x [1-{(1.031)/(1.063)}^(20)}] = $ 2501.21

(b)

jeff jeffy answered 5 months ago
Next > < Previous

Related Solutions

Your brother has offered to give you $165?, starting next? year, and after that growing at...
Your brother has offered to give you $165?, starting next? year, and after that growing at 2.5% per year for the next 2020 years. You would like to calculate the value of this offer by calculating how much money you would need to deposit in a local bank so that the amount will generate the same cash flows as he is offering you. Your local bank will guarantee a 5.8% annual interest rate so long as you have money in...
Your brother has offered to give you $ 165​, starting next​ year, and after that growing...
Your brother has offered to give you $ 165​, starting next​ year, and after that growing at 2.8 % per year for the next 20 years. You would like to calculate the value of this offer by calculating how much money you would need to deposit in a local bank so that the amount will generate the same cash flows as he is offering you. Your local bank will guarantee a 6.4 % annual interest rate so long as you...
   Your brother has offered to give you $ 160​, starting next​ year, and after that growing...
   Your brother has offered to give you $ 160​, starting next​ year, and after that growing at 2.5 % per year for the next 20 years. You would like to calculate the value of this offer by calculating how much money you would need to deposit in a local bank so that the amount will generate the same cash flows as he is offering you. Your local bank will guarantee a 5.5 % annual interest rate so long as you...
Your brother has offered to give you either $12,000 today or $20,000 in 13 years. If...
Your brother has offered to give you either $12,000 today or $20,000 in 13 years. If the interest rate is 9% per year, which option is preferable? A. Take the future amount because its present value is greated than the present amount offered B. Take the present amount offered because it is greater than the present value of the future amount C. Take the present amount offered because it is less than the future amount D. Take the future amount...
Your brother wants to borrow 10,000 from you. He has offered to pay you back $13,250...
Your brother wants to borrow 10,000 from you. He has offered to pay you back $13,250 in a year. If the cost of capital of this investment opportunity is 9% what is its NPV? Should you undertake the investment opportunity? calculate the IRR and use it to determine the maximum deviation allowable in the cost of capital estimate to leave the decision unchanged. If the cost of capital of this investment opportunity is 12 %   ------ What is its​ NPV?...
Suppose you are offered a $1,000 payment each year until you die. After that, your children...
Suppose you are offered a $1,000 payment each year until you die. After that, your children will inherit the payment. Then their children. Forever. (And you love your progeny as much as you love yourself.) The payment is guaranteed by the Bank of Japan, and you want a 4% return on your investment. What is the maximum price you should pay for this perpetuity? Select one: a. $10,000 b. $20,000 c. $25,000 d. $100,000
You are offered a deal that pays you $1,000/yr (end of year) for 5 years, starting...
You are offered a deal that pays you $1,000/yr (end of year) for 5 years, starting 5 y from today. At a discount rate of 6%, what’s that deal worth right now? (CF’s: 0,0,0,0,0,1000,1000,1000,1000,1000). Nominal annual interest is quoted at 7.50%. With monthly payments, what’s effective annual interest? (1pt) What about daily payments? (1pt) What about payments every other year?
After graduation, you start your job with a salary of $70,000 per year (paid annually). Starting...
After graduation, you start your job with a salary of $70,000 per year (paid annually). Starting the second year, your salary increases by a rate of 3% per year through year 30 and then you retire. Determine the amount available in your retirement account when you retire if you put 12% of salary in the retirement account on an annual basis. Suppose the interest rate on the retirement account is 5% per year.
Your brother has asked you for a loan and has promised to payyou $7,350 at...
Your brother has asked you for a loan and has promised to pay you $7,350 at the end of three years. If you normally invest to earn 6.00 percent per year, how much will you be willing to lend to your brother if you view this purely as a financial transaction (i.e., you don’t give your brother a special deal)? (If you solve this problem with algebra round intermediate calculations to 6 decimal places, in all cases round your final...
After getting trounced by your little brother in a children’s game, you suspect the die he...
After getting trounced by your little brother in a children’s game, you suspect the die he gave you to roll may be unfair. To check, you roll it 60 times, recording the number of times each face appears. Do these results cast doubt on the die’s fairness? a) If the die is fair, how many times would you expect each face to show? b) To see if these results are unusual, will you test goodness-of-fit, homogeneity, or independence? c) State...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT