Please check out:-
- item number 6 right at the bottom of the page.
Pull up the Workbook in front of you and then look at the
Int Rate goes in cell E4.
Period (in months) goes in cell E6.
Principal (capital) goes in cell E8.
Monthly repayment gets shown in cell C11.
There are another 2 Worksheets which are fairly self explanatory.
Just plug your (inputs) details into the blue cells and the answer is shown
in the red ones.
Please hit Yes if my comments have helped.
for given int rate
for a capital available
and reverse of the same. Thanks