
Calculate the gross debt service ratio to assess mortgage affordability by comparing housing costs to gross income, using a 30% threshold; evaluate the total debt service ratio with other debts.
Use an Excel template to calculate mortgage details: set property value, 80% LTV loan, down payment, monthly rate, 360 payments, and pmt-based monthly payments.
Explore calculating principal paid with subtraction and the PMT function on a $400,000 loan in Excel, noting how interest declines as principal rises and beginning and ending balances change.
Monitor mortgage progress by totaling payments, principal, and interest, and verify the ending balance reaches zero. Learn how extra payments and annual 10% of the loan amount reduce interest.
Explore how equal principal payments respond to rising interest rates using a what-if data table to assess month-one payments and prepare for rate increases.
Use Excel goal seek to determine the affordable interest rate that yields a target monthly mortgage payment under fixed-rate terms, and explore scenarios with different property values.
You may have been thinking about buying a home for quite some time now and thinking about going to get a mortgage for your home or property, but something is pulling you away from doing so. Whether it's been the unaffordability of your housing market or the uncertainty of your employment situation.
In this situation you need to be well informed of what is going to happen from the day you get a mortgage until the day you pay back all your debts. You need to be aware that it's not always going to go as you think it might go, you need to have more than one scenario with real numbers telling you how your mortgage is going to go for the total loan period.
This course will help you estimate what home you can afford so you can know how much money you need to set aside. The course will also help you estimate your mortgage payments from today until the ending of your loan period. We will apply different scenarios for different interest rate to see how this affects our mortgage and to see how much of interest we will be paying after 20, 25 or even 30 years. The course will look at fixed monthly payment and fixed principle payments with fixed rate or variable rate mortgages.