# I now have \$16,000 in the bank earning interest of 1.00% per month. I need \$26,000 to make a down payment on a house. I can save an additional \$100 per month. How long will it take me to accumulate the \$26,000? (Do not round intermediate calculations. (Round your answer to 2 decimal places.)

Question
35 views

I now have \$16,000 in the bank earning interest of 1.00% per month. I need \$26,000 to make a down payment on a house. I can save an additional \$100 per month. How long will it take me to accumulate the \$26,000? (Do not round intermediate calculations. (Round your answer to 2 decimal places.)

check_circle

star
star
star
star
star
1 Rating
Step 1

Calculation of Duration of the Investment:

The Duration of the Investment can be calculated using a excel function =NPER, which denotes the number of periods of any investment. The excel spreadsheet with excel function is shown below:

Step 2

The excel spreadsheet workings are shown below:

...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in