The following worksheet shows Account no. , Name, Deposit amount, yearly rate of interest and no. of years of deposit. Assuming that the amount is compounded annually ,write steps to compute maturity amount in column F .(Excel Problems)
The following worksheet shows Account no. , Name, Deposit amount, yearly rate of interest and no. of years of deposit. Assuming that the amount is compounded annually ,write steps to compute maturity amount in column F .
To compute Compound interest in column F,
Enter the formula
=FV(D2,E2,0,C2)-C2 in cell F2 and then press enter key,
using the fill handle of cell F2, copy the formula to cells F3 :F15
by dragging the fill handle up to cell F15.
0 comments:
Post a Comment