[mage lang="en|fr|es|cs|en" source="flickr"]mortgage equation excel[/mage]
Need Excel Formula mortgage?

C2-ready: 750.000 C3-rate: 6.5% year-C4: 15 C5 Monthly payment: $ 6533-End balance C8: D8-719 451 Total paid via Credit: 78,399 Given this information, what formula would calculate the interest years? Or just a normal algebra equations to solve this would be good too.

The answer would be to simply take a number of ready soon (750000) reduced by the amount of loan End (719 451). This corresponds to 30 549 is paid at the beginning. Then the total payments (78 399) lower amount paid at the beginning (30 549) that comes to 47,850 paid. To do this in Excel, you can use some formula. Put in 750 000 D2, 6.5%, divided by twelve (the number of payments per annum) in the E1, E2 E1 D2 multiplied by (E1 Anchor in your formula if you drag down formula, each multiplied E1), a type of 6533 negative (the amount of your monthly payment) in F2, G2, and enter the sum formula D2, E2 and F2. D3 of G2. Now just drag the formula down (you have to copy and paste the monthly payments, but 6533). His recipe on interest payments equal to the total amount paid less the reduction in principle.

Home Mortgage Calculator – Vertex42