Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your brother has offered to give you $100 , starting nextyear, and after that growing at 3.1% per year for the next 20 years. You

Your brother has offered to give you $100, starting nextyear, 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 accounttoday?

b. Assuming you deposited the amount of money in part (a), and then withdrew the required payments eachyear, calculate the remaining balance at the end of years1, 2, 10 and 19.(Hint: To solve this problem it is best to use an excelspreadsheet.)

I can't seem to figure out how to calculate..... I don't know how to set up in a calculator or an excel sheet. please help!!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forecasting Methods And Applications

Authors: Spyros G. Makridakis, Steven C. Wheelwright, Rob J Hyndman

3rd Edition

0471532339, 9780471532330

More Books

Students also viewed these Finance questions