How many years will it take you to accumulate $30,000 for a down payment on a house if you deposit $12,000 today and you expect
to earn a 10% annual return on your investment?
1 answer:
Answer:
9.61 years
Explanation:
For this question , we use the NPER formula that is presented in the attached spreadsheet
Given that,
Present value = $12,000
Future value = $30,000
Rate of interest = 10%
PMT = $0
The formula is shown below:
= NPER(Rate;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the answer is 9.61 years
You might be interested in
Answer:
$61,175
Explanation:
Base on the scenario been described in the question, we expected to solve for the future worth
The table of the cash flow is shows in the picture
We can find that by calculating the Future worth
Future Worth = {2,500 + 1,500(P/A 7%,10) 100 + (P/G 7%,10) } [F/P 7%, 20]
Future worth = { 2,500 + 1500(7.024) + 100(27.716)}
Future worth = $61,175
