What we want is a formula put in column F to automatically calculate the capital repayments figures.
This is a mortgage account put on an excel spreadsheet
column C is the interest rate charged, D is the capital owed or current balance and column E is the interest charged and column F is the capital payments.
Of course in a repayment (interest and capital) mortgage the monthly premium is made up of the interest and a portion of the capital. The capital amount starts of small and towards the end of the mortgage it is a greater part of the payments and is caluclated according to an accounting formula.
This is what we want we want a formula put into column F that will automatically calculate the capital repayments.
This mortgage started off in dec 1988 for a term of 25 years, and started off as an interest only. In january 1995 the mortgage was changed to a capital and interest formula, therefore from that point there were capital payments calculated to make sure the balance was paid off not just the interest.
Therefore as we have said we only want column F formulised to automatically calculate the capital repayments
everything in blue is irrelevant to the calculation and should be ignored
22 freelancers are bidding on average $94 for this job
I will be able to do the work perfectly. Because I am working as an Assistant Accounting Manager in a large group of industries. So You can give me the project.