Delivery trucks enter and leave a depot through a controlled gate. At the depot, each truck is loaded with packages, which will
1 answer:
You might be interested in
Answer:
$24,681.41
Explanation:
In this question, we use the present value formula which is shown in the spreadsheet.
The NPER reflected the time period.
Provided that,
Future value = $50,000
Rate of interest = 4%
NPER = 18 years
The formula is presented below:
= -PV(Rate;NPER;PMT;FV;type)
So, after solving this, the answer would be $24,681.41
Answer:
The correct answer is A. $18,276
Explanation:
First you have to calculate how much you'd end up having at the end of the 25 years period in your savings account.
You calculate the total amount saved for each year, using the formula:
Where
is the total amount in the savings account for this period.
is the total amount in the savings account from the previous period.
is the interest rate.
are the annual deposits being made into the savings account.
Therefore for the first year you'd do:
For the second year:
And so on. You can help yourself calculate the value of this series using programs like Excel.
I have attached an Excel file that has a table with the savings values for each of the 25 years.
So, the 25th year you’ll have $365,529.70 in your savings account. Now you simply divide this number by 20 (that will be the number of years you’ll be withdrawing the same dollar amount from your savings account):
In conclusion, you’d be able to withdraw $18,276.485 each year for the following 20 years after the 25th deposit, if all withdrawals are the same dollar amount.