In this section I have solved examples on simple interest. The formula for Compound Amount. N The duration of the loan using the number of periods.
A P 1 rn nt.
By referring these you can solve your questions. The trick to using a spreadsheet for compound interest is using compounding periods instead of simply thinking in years. P R 2 1 0 0 2 3 0 0 R 1 0 0. Start by opening a document and labeling the top cell in columns A B and C Year Value and Interest Earned respectively.