A simple but flexible calculator for calculating the total cost of a mortgage

The full cost of an apartment purchased in a mortgage


Do you want to figure out what the apartment will actually cost you exactly with your complicated schedule of paying for insurance, repairs and the fact that you plan to pay a communal apartment for only a few months until you rent the apartment to a tenant?


Here you can download the excel file with a calculator , here - look in Google Sheets ( copy yourself to modify).


Feel free to add columns for the types of payments you want to take into account, change the numbers to your conditions and get the result.



, , , . — , . , , , .


, , , , .


, , , , , , " / , , , ".


, . , - .



, , - .


2019 . , , , , .




  • : , .
  • ,
    • , 115% : ( , ), ( ) — ( )
    • . , . , , , ,
  • . ,
  • , , - , , ,


Illustrated Costs
, , :


  • 20 , . 5.2, , , 20 — 8.7. , — , 8.7.
  • Interest-percent-interest is who eats your money. Decide for yourself how much it makes sense to first accumulate more for the first installment and it is possible to bargain with banks for every percentage
  • Repair may not be such a small factor in the total cost of expenses
  • But the costs of state fees and realtors may not be so large and perhaps paying a good realtor will pay off thanks to the selection of a more appropriate object

What's next


Is the calculator useful to you? Would you use it yourself or throw a link to a friend? What to improve? What is better to focus on in the future: on calculating the revenue side, on accounting for inflation, on convenience, on something else?


Help improve the calculator by answering a couple of questions .


All Articles