excel morgage payment formula

excel morgage payment formula is project number 287622 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Cancelled by Service Buyer)

Status:	Closed
Budget:	$30-250
Created:	07/15/2008 at 20:47 EDT
Bidding Ends:	07/16/2008 at 20:47 EDT
Project Creator:	kozrak   Buyer Rating: (3 reviews)
Description:	we have a morgage spread sheet that can be run for different senerios ie different payment amounts different interest rates etc so all columms are formulaised for this effect except cannot work out how to formulise columm j capitol payments This calculation should be a standard accounting one for a repayment or captial and interest mortgage...ie the monthly payments have a component of interest which is I and capital repayments which is column J. There is a formula for calculating this which we think is based on the interest charging balance of column F, adjusted for the number of months in the mortgage etc This may be complicated in this instance because the interest rate column C only applies to anything over £30,000. The interest rate for the first £30,000 has miras which is a old uk discount allowance which starts at 25% of column C, please dont bid if you dont have the answer to this as this is what the job is ie to correctly formalise that columm J Additional files submitted: mortgage calcs please formularise column J.xls
Job Type:	Accounting/Bookkeeping Data Processing Excel
Database:	(None)
Operating system:	(None)
Bid count:	11
Average bid:	$ 45