n an attempt to have funds for a down payment in five years, James Dupont plans to save $3,800 a year for the next five years. W
ith an interest rate of 4 percent, what amount will James have available for a down payment after the five years? Use Exhibit 1-B. (Round FVA factor to 3 decimal places and final answer to 2 decimal places.)
1 answer:
Answer:
$20,582.03
Explanation:
For this question, we have to determine the future value that is shown on the attachment. Kindly find it below:
Data provided in the question
NPER = 5 years
PMT = $3,800
Rate of interest = 4%
PV = $0
The formula is shown below:
= -FV(Rate;NPER;PMT;PV;type)
So, after solving this, the future value is $20,582.03
You might be interested in
Answer:
Expected withdrawal is $45,000 for 30 years = total of $1,350,000
You will be required to invest in $25.063 every year.
Explanation:
By applying the goal seek formula in excel to determine the annual invested fund, based on a compounded interest rate of 6% over a duration of up to a maximum of 25 years from Year 0, we can clearly see that Savings ought to be $25,063 for every year.
The future Value of each saved fund is derived and added to future value of each years subsequent saved fund to arrive at a total expectation of $1,350,000 expected value after 25 years (i.e. $45,000 annual withdrawal x 30 years of withdrawal)
This brings total savings to $626,572 for the entire 25 years
Kindly refer to the attachment for breakdown of workings.
