Mortgage Spreadsheet I Am Looking For A Formula To Calculate The Repayment Terms For An Interest And Capital Mortgage.?
I am looking for a formula to calculate the repayment terms for an interest and capital mortgage.? - mortgage spreadsheet
I look forward to remortgage (UK) at home and I am looking for a formula that will be placed in a table to calculate the monthly repayment can. The loan amount is £ 158,000 is the limit at 21 years and the interest rate is 6%. I want a formula that could be the term to change to reduce interest payments. This is a mortgage interest and depreciation of capital. Thanks
|
4 comments:
Ok I said yesterday, here goes:
Using Excel to sort the numbers in columns
Then go to the toolbar and click on the Insert function, and then click PMT give their numbers in the correct boxes and click OK to have the formula! If you have any problems, click the "Help" link at the bottom of the page and have left.
http://www.mortgagesorter.co.uk/mortgage
Most software worksheet with functions for the simple calculation prepared. With the function of the software
PMT (top,) the nature, duration, where, when the monthly payments that you divide the rate of 12 The term is the number of payments you make.
The formula is:
i = interest rate
n = number of years
i / (1 - (1 + i) **- n) multiplied by the amount of the loan
Try this site has all kinds of big computers.
http://www.dinkytown.com
Good luck
Post a Comment