I am considering getting a mortgage, but i don’t know which kind of mortgage would be best suited. I am inteding on borrowng between £45,000 and £55,000 over 20-25 years but i don’t know what type of mortgage is best to get and how much monthly repayments would be. If anyone can give me an [...]
Category Archives: mortgage interest rate calculator
I need help with what type of mortgage to get and interest rates?
Posted by admin on June 25, 2010
2 comments
Excel function – which is used for calculating interest rate for annuity ?
Posted by admin on June 25, 2010
2 comments
Hi, i got a question concern with Excel function. I’m trying to create the mortgage calculator through Excel for my assignment. For the Normal Mortgage, with the output is Present Value of a Loan amount, i use this formula: PVoa = PMT [(1 - (1 / (1 + i)n)) / i] where : PVoa = [...]
When calculating tax savings from mortgage interest, should you use your marginal tax rate or average tax rate
Posted by admin on June 21, 2010
5 comments
The TurboTax and HR Block quick calulators appear to use average tax rate to determine tax savings. Our average tax rate was 15% this year. Most other calculators specifically designed for calculating mortgage interest tax savings use marginal tax rate, which for us is 25%. Which are we supposed to use for an accurate estimation [...]