Category Archives: mortgage interest rate calculator

I need help with what type of mortgage to get and interest rates?

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 [...]

Excel function – which is used for calculating interest rate for annuity ?

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

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 [...]