Transcribed Image Text
Your brother has offered to give you $ 175?, starting next?year, and after that growing at 3.1 % per year for the next 20years. You would like to calculate the value of this offer bycalculating how much money you would need to deposit in a localbank so that the amount will generate the same cash flows as he isoffering you. Your local bank will guarantee a 6.3 % annualinterest 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?), andthen withdrew the required payments each? year, calculate theremaining balance at the end of years? 1, 2, 10 and 19.? (Hint: Tosolve this problem it is best to use an excel? spreadsheet.)Please round these numbers to the nearest centYour brother has offered to give you $ 175?, starting next?year, and after that growing at 3.1 % per year for the next 20years. You would like to calculate the value of this offer bycalculating how much money you would need to deposit in a localbank so that the amount will generate the same cash flows as he isoffering you. Your local bank will guarantee a 6.3 % annualinterest 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?), andthen withdrew the required payments each? year, calculate theremaining balance at the end of years? 1, 2, 10 and 19.? (Hint: Tosolve this problem it is best to use an excel? spreadsheet.)Please round these numbers to the nearest cent
Other questions asked by students
8. Bond A has a yield to maturity 20% and trades at $100. This bond pays...
Give a brief description of chaos. What features must a Hamiltonian system have in order to...
Consider a steam power plant operating on a simple ideal Rankine cycle and having a net...
Consider the two linear functions f x and g x Several values of f x...
Find the basis and rank of the vector system. Express non basis vectors with basis...
PROBLEM SET B Problem 21-1B Cost estimation using high-low method P1 Sun Co.'s monthly data...