mortgage excel capital repayments formula

mortgage excel capital repayments formula is project number 289555 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Project expired)
Selected Providers:	-
Budget:	$30-250
Created:	07/20/2008 at 9:50 EDT
Bidding Ends:	07/21/2008 at 9:50 EDT
Project Creator:	kozrak   Buyer Rating: (3 reviews)
Description:	Hi 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 Additional files submitted: loan capital payments column to be formulisedq.xls
Job Type:	Accounting/Bookkeeping Data Processing Excel
Database:	(None)
Operating system:	(None)
Bid count:	22
Average bid:	$ 94