{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["MortgageCalculator","About"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"MortgageCalculator","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[0,1,0,6],[2,3,2,6]]}
[null,"Mortgage Payment Calculator"]
[{"$nulls":8},"MORTGAGE CALCULATORS by Vertex42.com"]
[null,"Compound Period",12," Enter 12 for US mortgages or 2 for Canadian mortgages.",{"$nulls":4},"https://www.vertex42.com/Calculators/mortgage-calculators.html"]
[]
[null,"Mortgage Information","Option #1","Option #2","Option #3","Option #4","Option #5"]
[null,"Loan Amount",{"v":175000,"d":"175,000.00"},{"v":200000,"d":"200,000.00"},{"v":225000,"d":"225,000.00"},{"$nulls":3},"← Enter each loan amount"]
[null,"Annual Interest Rate",{"v":0.06,"d":"6.000%"},{"v":0.06,"d":"6.000%"},{"v":0.06,"d":"6.000%"},{"$nulls":3},"← Enter each Interest Rate"]
[null,"Term of Loan (in Years)",30,30,30,{"$nulls":3},"← Enter the length of the loan in years"]
[]
[null,"PAYMENT"]
[null,"Monthly Interest Rate",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",((1+C7/$C$3)^($C$3/12))-1)","v":{"v":0.004999999999999893,"d":"0.500%"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",((1+D7/$C$3)^($C$3/12))-1)","v":{"v":0.004999999999999893,"d":"0.500%"}},{"v":0.004999999999999893,"d":"0.500%"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",((1+F7/$C$3)^($C$3/12))-1)","v":" - "}," - "]
[null,"Monthly Payment (PI)",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",PMT(C11,C8*12,-C6))","v":{"v":1049.2134190173022,"d":"1,049.21"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",PMT(D11,D8*12,-D6))","v":{"v":1199.1010503054883,"d":"1,199.10"}},{"v":1348.9886815936745,"d":"1,348.99"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",PMT(F11,F8*12,-F6))","v":" - "}," - "]
[null,"Extra Monthly Payment",{"$nulls":6},"← (optional) Enter extra monthly payments"]
[null,"Total MONTHLY PAYMENT",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C12+C13)","v":{"v":1049.2134190173022,"d":"1,049.21"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D12+D13)","v":{"v":1199.1010503054883,"d":"1,199.10"}},{"v":1348.9886815936745,"d":"1,348.99"}," - "," - "]
[]
[null,"TOTALS"]
[null,"Number of Payments",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",NPER(C11,-C14,C6))","v":{"v":360.0000000000001,"d":"360.0"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",NPER(D11,-D14,D6))","v":{"v":359.99999999999994,"d":"360.0"}},{"v":359.99999999999994,"d":"360.0"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",NPER(F11,-F14,F6))","v":" - "}," - "]
[null,"Number of Years to Payoff",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C17/12)","v":{"v":30.00000000000001,"d":"30.00"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D17/12)","v":{"v":29.999999999999996,"d":"30.00"}},{"v":29.999999999999996,"d":"30.00"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",F17/12)","v":" - "}," - "]
[null,"Total Payments",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C17*C14)","v":{"v":377716.83084622887,"d":"377,716.83"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D17*D14)","v":{"v":431676.3781099757,"d":"431,676.38"}},{"v":485635.92537372274,"d":"485,635.93"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",F17*F14)","v":" - "}," - "]
[null,"Total INTEREST Paid",{"$f":"IF(COUNTA(C6,C7,C8)<3,\" - \",C19-C6)","v":{"v":202716.83084622887,"d":"202,716.83"}},{"$f":"IF(COUNTA(D6,D7,D8)<3,\" - \",D19-D6)","v":{"v":231676.37810997572,"d":"231,676.38"}},{"v":260635.92537372274,"d":"260,635.93"},{"$f":"IF(COUNTA(F6,F7,F8)<3,\" - \",F19-F6)","v":" - "}," - "]
[]
[null,"BALANCE at Year …",5,5,5,{"$nulls":3},"← Enter the year to estimate the balance and equity"]
[null,"Property Value",{"$f":"C6","v":{"v":175000,"d":"175,000.00"}},{"$f":"D6","v":{"v":200000,"d":"200,000.00"}},{"v":225000,"d":"225,000.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"← Enter the estimated property value at the specified year"]
[null,"Loan Balance Due",{"$f":"IF(COUNTA(C6,C7,C8,C22)<4,\" - \",-FV(C11,C22*12,-C14,C6))","v":{"v":162845.1244399341,"d":"162,845.12"}},{"$f":"IF(COUNTA(D6,D7,D8,D22)<4,\" - \",-FV(D11,D22*12,-D14,D6))","v":{"v":186108.71364563896,"d":"186,108.71"}},{"v":209372.30285134388,"d":"209,372.30"}," - "," - "]
[null,"OWNER'S EQUITY",{"$f":"IF(COUNTA(C6,C7,C8,C22,C23)<5,\" - \",C23-C24)","v":{"v":12154.875560065906,"d":"12,154.88"}},{"$f":"IF(COUNTA(D6,D7,D8,D22,D23)<5,\" - \",D23-D24)","v":{"v":13891.286354361044,"d":"13,891.29"}},{"v":15627.697148656123,"d":"15,627.70"}," - "," - "]

{"sheet":"About","index":1,"n_rows":22,"n_cols":2,"rows_kept":22}
[]
[null,"MORTGAGE PAYMENT CALCULATOR by Vertex42.com"]
[null,"https://www.vertex42.com/Calculators/mortgage-payment-calculator.html"]
[]
[null,"About This Template"]
[null,"Calculate the monthly principal and interest payment for a traditional home mortgage using this simple mortgage calculator provided by Vertex42.com. Enter the loan amount, interest rate, term, and extra monthly payments to compare different scenarios. Estimate the home equity and balance due after a specific number of years."]
[]
[null,"How to Use this Template"]
[null,"Click on the link below to visit vertex42.com and learn more about how to use this template."]
[null,"How to Use this Template"]
[]
[null,"More Mortgage Calculators"]
[null,"Click on the link below to visit Vertex42.com and download other mortgage calculators."]
[null,"More Mortgage Calculators"]
[]
[null,"Disclaimer"]
[null,"This calculator is for educational purposes. The calculator does not include rounding, fees, missed payments, property tax, insurance, and other factors that may be important when making loan or home buying/selling decisions. Please consult a qualified professional regarding financial decisions."]
[]
[null,"About Vertex42"]
[null,"Vertex42.com provides professionally designed spreadsheet templates for business, home, and education - most of which are free to download. Their collection includes a variety of calendars, planners, and schedules as well as personal finance spreadsheets for budgeting, debt reduction, and loan amortisation."]
[]
[null,"Businesses will find invoices, time sheets, inventory trackers, financial statements, and project planning templates. Teachers and students will find resources such as class schedules, grade books, and attendance sheets. Organise your family life with meal planners, checklists, and exercise logs. Each template is thoroughly researched, refined, and improved over time through feedback from thousands of users."]