Answer:
the number of years for triple the money is 15.74 years
Step-by-step explanation:
The computation of the number of years for triple the money is shown below:
Here we used the NPER which is
Given that
RATE = 7% ÷ 12 = 0.58333%
Assuming
Present value be $1,000
And, future value be $1,000 × 3 = $3,000
PMT = $0
The formula is shown below:
= NPER(RATE;PMT;-PV;FV;TYPE)
The present value comes in positive
After applying the above formula
The number of years is
= 188.8833850497 ÷ 12
= 15.74 years
hence, the number of years for triple the money is 15.74 years