   Your brother has offered to give you $ 160​, starting next​ year, and after that growing...
Free
90.2K
Verified Solution
Link Copied!
Question
Finance
  
Your brother has offered to give you $ 160​, starting next​year, and after that growing at 2.5 % 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 5.5 % 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.)  
  
Your brother has offered to give you $ 160​, starting next​year, and after that growing at 2.5 % 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 5.5 % 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.)  
Answer & Explanation Solved by verified expert
A. To calculate the money to deposit in the account today
We need to find the present value of growing annuity = p/(r-g)*
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.