Loan Amortization - Google SheetsABCDEFGHIJKLMNOPQRSTUVWXYZAA1To use this document, go to the File menu and "Make a copy" for your own use (do not request access)#REF!Learn more:https://www.thebalance.com/how-amortization-works-3155222Or click here for your own copy*IMPORTANT: These numbers and formulas might not be accurate or appropriate for your situation. You MUST verify all details, calculations, and projections with your financial institution before making Consult your tax advisor, financial advisor, and legal counsel before taking any action or making any decisions.34Enter your loan details in the green boxes5Loan AmountInterest RateTerm in YearsMonthly PaymentExtra Monthly6$100,000.006.00%30$599.55078Instructions:Double click the video below, or visit9MonthStartingBalanceYou PaidInterestPrincipalEndingBalanceTotalInterest(3 Minutes)https://youtu.be/1mRGK8Zggf4101$100,000.00$599.55$500.00$99.55$99,900.45$500.00112$99,900.45$599.55$499.50$100.05$99,800.40$999.50123$99,800.40$599.55$499.00$100.55$99,699.85$1,498.50134$99,699.85$599.55$498.50$101.05$99,598.80$1,997.00145$99,598.80$599.55$497.99$101.56$99,497.24$2,495.00156$99,497.24$599.55$497.49$102.06$99,395.18$2,992.48167$99,395.18$599.55$496.98$102.57$99,292.61$3,489.46178$99,292.61$599.55$496.46$103.09$99,189.52$3,985.92189$99,189.52$599.55$495.95$103.60$99,085.92$4,481.871910$99,085.92$599.55$495.43$104.12$98,981.79$4,977.302011$98,981.79$599.55$494.91$104.64$98,877.15$5,472.212112$98,877.15$599.55$494.39$105.16$98,771.99$5,966.592213$98,771.99$599.55$493.86$105.69$98,666.30$6,460.452314$98,666.30$599.55$493.33$106.22$98,560.08$6,953.792415$98,560.08$599.55$492.80$106.75$98,453.33$7,446.592516$98,453.33$599.55$492.27$107.28$98,346.04$7,938.852617$98,346.04$599.55$491.73$107.82$98,238.22$8,430.582718$98,238.22$599.55$491.19$108.36$98,129.86$8,921.77Other tips:Double click the video below, or visit2819$98,129.86$599.55$490.65$108.90$98,020.96$9,412.42https://youtu.be/Utzru1S2vAI2920$98,020.96$599.55$490.10$109.45$97,911.52$9,902.533021$97,911.52$599.55$489.56$109.99$97,801.53$10,392.093122$97,801.53$599.55$489.01$110.54$97,690.98$10,881.093223$97,690.98$599.55$488.45$111.10$97,579.89$11,369.553324$97,579.89$599.55$487.90$111.65$97,468.24$11,857.453425$97,468.24$599.55$487.34$112.21$97,356.03$12,344.793526$97,356.03$599.55$486.78$112.77$97,243.26$12,831.573627$97,243.26$599.55$486.22$113.33$97,129.92$13,317.793728$97,129.92$599.55$485.65$113.90$97,016.02$13,803.443829$97,016.02$599.55$485.08$114.47$96,901.55$14,288.523930$96,901.55$599.55$484.51$115.04$96,786.51$14,773.024031$96,786.51$599.55$483.93$115.62$96,670.89$15,256.964132$96,670.89$599.55$483.35$116.20$96,554.69$15,740.314233$96,554.69$599.55$482.77$116.78$96,437.92$16,223.084334$96,437.92$599.55$482.19$117.36$96,320.56$16,705.274435$96,320.56$599.55$481.60$117.95$96,202.61$17,186.884536$96,202.61$599.55$481.01$118.54$96,084.07$17,667.894637$96,084.07$599.55$480.42$119.13$95,964.94$18,148.314738$95,964.94$599.55$479.82$119.73$95,845.21$18,628.134839$95,845.21$599.55$479.23$120.32$95,724.89$19,107.364940$95,724.89$599.55$478.62$120.93$95,603.96$19,585.985041$95,603.96$599.55$478.02$121.53$95,482.43$20,064.005142$95,482.43$599.55$477.41$122.14$95,360.29$20,541.425243$95,360.29$599.55$476.80$122.75$95,237.55$21,018.225344$95,237.55$599.55$476.19$123.36$95,114.18$21,494.415445$95,114.18$599.55$475.57$123.98$94,990.20$21,969.985546$94,990.20$599.55$474.95$124.60$94,865.60$22,444.935647$94,865.60$599.55$474.33$125.22$94,740.38$22,919.265748$94,740.38$599.55$473.70$125.85$94,614.53$23,392.965849$94,614.53$599.55$473.07$126.48$94,488.05$23,866.035950$94,488.05$599.55$472.44$127.11$94,360.94$24,338.476051$94,360.94$599.55$471.80$127.75$94,233.20$24,810.286152$94,233.20$599.55$471.17$128.38$94,104.81$25,281.446253$94,104.81$599.55$470.52$129.03$93,975.79$25,751.976354$93,975.79$599.55$469.88$129.67$93,846.12$26,221.846455$93,846.12$599.55$469.23$130.32$93,715.80$26,691.076556$93,715.80$599.55$468.58$130.97$93,584.82$27,159.656657$93,584.82$599.55$467.92$131.63$93,453.20$27,627.586758$93,453.20$599.55$467.27$132.28$93,320.91$28,094.846859$93,320.91$599.55$466.60$132.95$93,187.97$28,561.456960$93,187.97$599.55$465.94$133.61$93,054.36$29,027.397061$93,054.36$599.55$465.27$134.28$92,920.08$29,492.667162$92,920.08$599.55$464.60$134.95$92,785.13$29,957.267263$92,785.13$599.55$463.93$135.62$92,649.50$30,421.197364$92,649.50$599.55$463.25$136.30$92,513.20$30,884.437465$92,513.20$599.55$462.57$136.98$92,376.22$31,347.007566$92,376.22$599.55$461.88$137.67$92,238.55$31,808.887667$92,238.55$599.55$461.19$138.36$92,100.19$32,270.077768$92,100.19$599.55$460.50$139.05$91,961.14$32,730.577869$91,961.14$599.55$459.81$139.74$91,821.39$33,190.387970$91,821.39$599.55$459.11$140.44$91,680.95$33,649.498071$91,680.95$599.55$458.40$141.15$91,539.80$34,107.898172$91,539.80$599.55$457.70$141.85$91,397.95$34,565.598273$91,397.95$599.55$456.99$142.56$91,255.39$35,022.588374$91,255.39$599.55$456.28$143.27$91,112.12$35,478.868475$91,112.12$599.55$455.56$143.99$90,968.13$35,934.428576$90,968.13$599.55$454.84$144.71$90,823.42$36,389.268677$90,823.42$599.55$454.12$145.43$90,677.99$36,843.388778$90,677.99$599.55$453.39$146.16$90,531.82$37,296.778879$90,531.82$599.55$452.66$146.89$90,384.93$37,749.428980$90,384.93$599.55$451.92$147.63$90,237.31$38,201.359081$90,237.31$599.55$451.19$148.36$90,088.94$38,652.549182$90,088.94$599.55$450.44$149.11$89,939.84$39,102.989283$89,939.84$599.55$449.70$149.85$89,789.99$39,552.689384$89,789.99$599.55$448.95$150.60$89,639.39$40,001.639485$89,639.39$599.55$448.20$151.35$89,488.03$40,449.839586$89,488.03$599.55$447.44$152.11$89,335.92$40,897.279687$89,335.92$599.55$446.68$152.87$89,183.05$41,343.959788$89,183.05$599.55$445.92$153.64$89,029.42$41,789.869889$89,029.42$599.55$445.15$154.40$88,875.01$42,235.019990$88,875.01$599.55$444.38$155.18$88,719.84$42,679.3810091$88,719.84$599.55$443.60$155.95$88,563.89$43,122.98Quotes are not sourced from all markets and may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.Disclaimer Sheet1 A browser error has occurred.Please hold the Shift key and click the Refresh button to try again., Create and edit web-based documents, spreadsheets, and presentations. Store documents online and access them from any computer., Access Google Docs with a personal Google account or Google Workspace account (for business use)..