Lucy and Fred want to begin saving for their baby's college education. They estimate that they will need $120,000 in eighteen ye
1 answer:
You might be interested in
Answer:
$7,112.73
Explanation:
We can use the financial calcualtor and some formulas or use the easy way and use excel goal seek.
We contruct the table and find the value of the principal cell that makes the principal after 60 payment zero with payment of $1,000 decreasing 2% each month
the following is made:
A1 period
1 to 60
B1 couta
1,000 x (power(0.98;period cell)
C1 interest
previous principal x 9/1200
D1 amortization B1 - C1 that is installment less interest
E1 principal: previous principal - current period amortization
--loan schedule is attached to provide more help--
