dawgfan016 asked: I am making an amortization schedule with excel that shows the payments per month and need to make property taxes and insurance increase automatically every year (month 13, 25, 37, etc). I have been told that it can be done with the INT function but I cannot figure it out. Any ideas?
Joe M asked: I have an amortization of 60 months, monthly payment amount and original loan amount. I am trying to find the excel formula that will help me compute the rate.
i tried =rate(nper, pmt, pv)…but i get an error. what am i doing wrong?
Aces asked: i’m making a chart of 36 payments (rows 1-36) so i need to make each column for payment (column A), interest (column B), principle (column C) and balance (column D). I just want to input the loan amount in one cell and get a result for the interest paid, principle paid and balance [...]
Newlywed asked: Is there a template in Excel for an amortization table? I would like to calculate my mortgage but I am hoping I don’t have to build a table myself – I am not that good with Excel:(
Sarah asked: I have made an amortization table, and I now need to figure out how to add 100 dollars to the payment of the loan. It is for a 200,000 loan over 15 years with an interest rate of 4.59%. Right now the payments are at 1539.20 and the formula for that is =0.0459/12. [...]
tshooter79606 asked: I do not have Excel on my new computer and am having trouble transferring a current amortization table onto my that new computer. So, I figured I could just make download a clean table but I am having trouble finding one on the internet that will work with “Works”?
Powered by Yahoo! Answers
