EXCEL-SKILLS.

COM

LOAN AMORTIZATION TEMPLATE

This loan amortization template enables users to create amortization schedules for multiple lo
repayments and outstanding balances based on any user defined date. The template is suitabl
monthly basis and accommodates variable monthly interest rates.
View all our unique templates!
This free template forms part of our unique range of innovative Excel templates which featu
statements, management accounts, cash flow projections, business valuations, fixed assets, co
and a lot more.

Get more templates!

enable editing to activate the link

PLATE
ation schedules for multiple loans and to review interest, capital
date. The template is suitable for any loan which is repaid on a
.

e Excel templates which features accounting in Excel, financial

ss valuations, fixed assets, costing & inventory, monthly payroll

plates!

ate the link

Loan Amortization Summary
All Loans Review Date
As at 31 December 2024 12/31/2024 12/31/2024 On this sheet:

Sheet Reference Amort01! Amort02! Amort03! Review the interest, capital and outstanding balan
Selected Month - Cell Reference A60 A48 A30 multiple loans at various stages during the loan period by
Loan Start Date 1/1/2021 1/1/2022 7/1/2023
entering a loan review date in cell B3. All the calculations
sheet are automated and based on the individua
Loan Amount 2,000,000.00 600,000.00 1,000,000.00
amortization sheets.
Residual Value 0.00 150,000.00 0.00
© www.excel-skills.com
All Periods To Date
Total Loan Repayments Err:502 Err:502 Err:502 Add more loans!

Total Interest Paid Err:502 Err:502 Err:502 You can add additional loans to the template by copy
Total Capital Repayment Err:502 Err:502 Err:502 column, copying one of the amortization sheets and r
copied sheet to "Amort" and the next two-digit number
Outstanding Capital Balance 1,827,753.13 357,198.73 903,235.49
current sheet names). The calculations in the appropriat
Outstanding Capital % 91.4% 59.5% 90.3%
this sheet will then be updated automatically based
amortization schedule on the new sheet.
Past 12 Months
Total Loan Repayments Err:502 Err:502 Err:502
Example:
Total Interest Paid Err:502 Err:502 Err:502
To add a new loan to the standard template, we need to
Total Capital Repayment Err:502 Err:502 Err:502
D to column E, create a copy of sheet "Amort03" and chan
of the copied sheet to "Amort04". The calculations in c
Next 12 Months then be updated with the amounts on the new "Amort04"
Total Loan Repayments 215,934.23 129,734.04 155,277.07 is no limit on the number of columns and sheets that can
Total Interest Paid 162,322.08 31,288.92 82,701.28 the template!
Total Capital Repayment 53,612.15 98,445.12 72,575.79

Overall Loan Period

Total Loan Repayments 4,318,684.59 648,670.21 1,552,770.69
Total Interest Paid 2,318,684.59 198,670.21 552,770.69
Total Capital Repayment 2,000,000.00 450,000.00 1,000,000.00

Page 3 of 19
 Loan Amortization Summary
All Loans
As at 31 December 2024On this sheet:
Review Sheet
the Reference
interest, capital and outstanding balances of
multiple loans Month
Selected at various stages during the loan period by simply
- Cell Reference
entering a loan review date in cell B3. All the calculations on this
Loan Start Date
sheet are automated and based on the individual loan
Loan Amount
amortization sheets.
Residual Value
© www.excel-skills.com
All Periods To Date
Total Loan Repayments Add more loans!
You can add
Total additional
Interest Paid loans to the template by copying the last
column,Total
copying one of the amortization sheets and renaming the
Capital Repayment
copied sheet to "Amort" and the next two-digit number (refer to the
Outstanding Capital Balance
current sheet names). The calculations in the appropriate column on
Outstanding Capital %
this sheet will then be updated automatically based on the loan
amortization schedule on the new sheet.
Past 12 Months
Total Loan Repayments
Example:
Total Interest Paid
To add a new loan to the standard template, we need to copy column
Total Capital Repayment
D to column E, create a copy of sheet "Amort03" and change the name
of the copied sheet to "Amort04". The calculations in column E will
then beNext 12 Months
updated with the amounts on the new "Amort04" sheet. There
Total Loan
is no limit on the Repayments
number of columns and sheets that can be added to
Total
the template! Interest Paid
Total Capital Repayment

Overall Loan Period

Total Loan Repayments
Total Interest Paid
Total Capital Repayment

Page 4 of 19
Loan Amortization Schedule
Loan 1
© www.excel-skills.com
Loan Principle Amount 2,000,000.00 On this sheet:
Annual Interest Rate 9.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 240.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 17,994.52 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2021 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Jan-2021 A13 1 2,000,000.00 17,994.52 15,000.00 2,994.52 1,997,005.48 99.9% 9.00%
Feb-2021 A14 2 1,997,005.48 17,994.52 14,977.54 3,016.98 1,993,988.50 99.7% 9.00%
Mar-2021 A15 3 1,993,988.50 17,994.52 14,954.91 3,039.61 1,990,948.90 99.5% 9.00%
Apr-2021 A16 4 1,990,948.90 17,994.52 14,932.12 3,062.40 1,987,886.50 99.4% 9.00%
May-2021 A17 5 1,987,886.50 17,994.52 14,909.15 3,085.37 1,984,801.12 99.2% 9.00%
Jun-2021 A18 6 1,984,801.12 17,994.52 14,886.01 3,108.51 1,981,692.61 99.1% 9.00%
Jul-2021 A19 7 1,981,692.61 17,994.52 14,862.69 3,131.82 1,978,560.79 98.9% 9.00%
Aug-2021 A20 8 1,978,560.79 17,994.52 14,839.21 3,155.31 1,975,405.48 98.8% 9.00%
Sep-2021 A21 9 1,975,405.48 17,994.52 14,815.54 3,178.98 1,972,226.50 98.6% 9.00%
Oct-2021 A22 10 1,972,226.50 17,994.52 14,791.70 3,202.82 1,969,023.68 98.5% 9.00%
Nov-2021 A23 11 1,969,023.68 17,994.52 14,767.68 3,226.84 1,965,796.84 98.3% 9.00%
Dec-2021 A24 12 1,965,796.84 17,994.52 14,743.48 3,251.04 1,962,545.79 98.1% 9.00%
Jan-2022 A25 13 1,962,545.79 17,994.52 14,719.09 3,275.43 1,959,270.37 98.0% 9.00%
Feb-2022 A26 14 1,959,270.37 17,994.52 14,694.53 3,299.99 1,955,970.38 97.8% 9.00%
Mar-2022 A27 15 1,955,970.38 17,994.52 14,669.78 3,324.74 1,952,645.64 97.6% 9.00%
Apr-2022 A28 16 1,952,645.64 17,994.52 14,644.84 3,349.68 1,949,295.96 97.5% 9.00%
May-2022 A29 17 1,949,295.96 17,994.52 14,619.72 3,374.80 1,945,921.16 97.3% 9.00%
Jun-2022 A30 18 1,945,921.16 17,994.52 14,594.41 3,400.11 1,942,521.05 97.1% 9.00%
Jul-2022 A31 19 1,942,521.05 17,994.52 14,568.91 3,425.61 1,939,095.44 97.0% 9.00%
Aug-2022 A32 20 1,939,095.44 17,994.52 14,543.22 3,451.30 1,935,644.13 96.8% 9.00%
Sep-2022 A33 21 1,935,644.13 17,994.52 14,517.33 3,477.19 1,932,166.95 96.6% 9.00%
Oct-2022 A34 22 1,932,166.95 17,994.52 14,491.25 3,503.27 1,928,663.68 96.4% 9.00%
Nov-2022 A35 23 1,928,663.68 17,994.52 14,464.98 3,529.54 1,925,134.14 96.3% 9.00%
Dec-2022 A36 24 1,925,134.14 17,994.52 14,438.51 3,556.01 1,921,578.12 96.1% 9.00%
Jan-2023 A37 25 1,921,578.12 17,994.52 14,411.84 3,582.68 1,917,995.44 95.9% 9.00%
Feb-2023 A38 26 1,917,995.44 17,994.52 14,384.97 3,609.55 1,914,385.89 95.7% 9.00%
Mar-2023 A39 27 1,914,385.89 17,994.52 14,357.89 3,636.62 1,910,749.26 95.5% 9.00%
Apr-2023 A40 28 1,910,749.26 17,994.52 14,330.62 3,663.90 1,907,085.36 95.4% 9.00%
May-2023 A41 29 1,907,085.36 17,994.52 14,303.14 3,691.38 1,903,393.98 95.2% 9.00%
Jun-2023 A42 30 1,903,393.98 17,994.52 14,275.45 3,719.06 1,899,674.92 95.0% 9.00%
Jul-2023 A43 31 1,899,674.92 17,994.52 14,247.56 3,746.96 1,895,927.96 94.8% 9.00%
Aug-2023 A44 32 1,895,927.96 17,994.52 14,219.46 3,775.06 1,892,152.90 94.6% 9.00%
Sep-2023 A45 33 1,892,152.90 17,994.52 14,191.15 3,803.37 1,888,349.53 94.4% 9.00%
Oct-2023 A46 34 1,888,349.53 17,994.52 14,162.62 3,831.90 1,884,517.63 94.2% 9.00%
Nov-2023 A47 35 1,884,517.63 17,994.52 14,133.88 3,860.64 1,880,657.00 94.0% 9.00%
Dec-2023 A48 36 1,880,657.00 17,994.52 14,104.93 3,889.59 1,876,767.40 93.8% 9.00%
Jan-2024 A49 37 1,876,767.40 17,994.52 14,075.76 3,918.76 1,872,848.64 93.6% 9.00%
Feb-2024 A50 38 1,872,848.64 17,994.52 14,046.36 3,948.15 1,868,900.49 93.4% 9.00%
Mar-2024 A51 39 1,868,900.49 17,994.52 14,016.75 3,977.77 1,864,922.72 93.2% 9.00%
Apr-2024 A52 40 1,864,922.72 17,994.52 13,986.92 4,007.60 1,860,915.12 93.0% 9.00%
May-2024 A53 41 1,860,915.12 17,994.52 13,956.86 4,037.66 1,856,877.47 92.8% 9.00%
Jun-2024 A54 42 1,856,877.47 17,994.52 13,926.58 4,067.94 1,852,809.53 92.6% 9.00%
Jul-2024 A55 43 1,852,809.53 17,994.52 13,896.07 4,098.45 1,848,711.08 92.4% 9.00%
Aug-2024 A56 44 1,848,711.08 17,994.52 13,865.33 4,129.19 1,844,581.90 92.2% 9.00%
Sep-2024 A57 45 1,844,581.90 17,994.52 13,834.36 4,160.15 1,840,421.74 92.0% 9.00%
Oct-2024 A58 46 1,840,421.74 17,994.52 13,803.16 4,191.36 1,836,230.38 91.8% 9.00%
Nov-2024 A59 47 1,836,230.38 17,994.52 13,771.73 4,222.79 1,832,007.59 91.6% 9.00%
Dec-2024 A60 48 1,832,007.59 17,994.52 13,740.06 4,254.46 1,827,753.13 91.4% 9.00%
Jan-2025 A61 49 1,827,753.13 17,994.52 13,708.15 4,286.37 1,823,466.76 91.2% 9.00%
Feb-2025 A62 50 1,823,466.76 17,994.52 13,676.00 4,318.52 1,819,148.24 91.0% 9.00%
Mar-2025 A63 51 1,819,148.24 17,994.52 13,643.61 4,350.91 1,814,797.33 90.7% 9.00%
Apr-2025 A64 52 1,814,797.33 17,994.52 13,610.98 4,383.54 1,810,413.80 90.5% 9.00%
May-2025 A65 53 1,810,413.80 17,994.52 13,578.10 4,416.42 1,805,997.38 90.3% 9.00%
Jun-2025 A66 54 1,805,997.38 17,994.52 13,544.98 4,449.54 1,801,547.84 90.1% 9.00%
Jul-2025 A67 55 1,801,547.84 17,994.52 13,511.61 4,482.91 1,797,064.93 89.9% 9.00%
Aug-2025 A68 56 1,797,064.93 17,994.52 13,477.99 4,516.53 1,792,548.40 89.6% 9.00%
Sep-2025 A69 57 1,792,548.40 17,994.52 13,444.11 4,550.41 1,787,997.99 89.4% 9.00%
Oct-2025 A70 58 1,787,997.99 17,994.52 13,409.98 4,584.53 1,783,413.46 89.2% 9.00%
Nov-2025 A71 59 1,783,413.46 17,994.52 13,375.60 4,618.92 1,778,794.54 88.9% 9.00%
Dec-2025 A72 60 1,778,794.54 17,994.52 13,340.96 4,653.56 1,774,140.98 88.7% 9.00%
Jan-2026 A73 61 1,774,140.98 17,994.52 13,306.06 4,688.46 1,769,452.52 88.5% 9.00%
Feb-2026 A74 62 1,769,452.52 17,994.52 13,270.89 4,723.63 1,764,728.89 88.2% 9.00%
Mar-2026 A75 63 1,764,728.89 17,994.52 13,235.47 4,759.05 1,759,969.84 88.0% 9.00%
Apr-2026 A76 64 1,759,969.84 17,994.52 13,199.77 4,794.75 1,755,175.10 87.8% 9.00%
May-2026 A77 65 1,755,175.10 17,994.52 13,163.81 4,830.71 1,750,344.39 87.5% 9.00%
Jun-2026 A78 66 1,750,344.39 17,994.52 13,127.58 4,866.94 1,745,477.45 87.3% 9.00%
Jul-2026 A79 67 1,745,477.45 17,994.52 13,091.08 4,903.44 1,740,574.02 87.0% 9.00%
Aug-2026 A80 68 1,740,574.02 17,994.52 13,054.31 4,940.21 1,735,633.80 86.8% 9.00%
Sep-2026 A81 69 1,735,633.80 17,994.52 13,017.25 4,977.27 1,730,656.54 86.5% 9.00%
Oct-2026 A82 70 1,730,656.54 17,994.52 12,979.92 5,014.60 1,725,641.94 86.3% 9.00%
Nov-2026 A83 71 1,725,641.94 17,994.52 12,942.31 5,052.20 1,720,589.74 86.0% 9.00%
Dec-2026 A84 72 1,720,589.74 17,994.52 12,904.42 5,090.10 1,715,499.64 85.8% 9.00%
Jan-2027 A85 73 1,715,499.64 17,994.52 12,866.25 5,128.27 1,710,371.37 85.5% 9.00%

Page 5 of 19
Loan Amortization Schedule
Loan 1
© www.excel-skills.com
Loan Principle Amount 2,000,000.00 On this sheet:
Annual Interest Rate 9.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 240.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 17,994.52 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2021 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Feb-2027 A86 74 1,710,371.37 17,994.52 12,827.79 5,166.73 1,705,204.63 85.3% 9.00%
Mar-2027 A87 75 1,705,204.63 17,994.52 12,789.03 5,205.48 1,699,999.15 85.0% 9.00%
Apr-2027 A88 76 1,699,999.15 17,994.52 12,749.99 5,244.53 1,694,754.62 84.7% 9.00%
May-2027 A89 77 1,694,754.62 17,994.52 12,710.66 5,283.86 1,689,470.76 84.5% 9.00%
Jun-2027 A90 78 1,689,470.76 17,994.52 12,671.03 5,323.49 1,684,147.28 84.2% 9.00%
Jul-2027 A91 79 1,684,147.28 17,994.52 12,631.10 5,363.41 1,678,783.86 83.9% 9.00%
Aug-2027 A92 80 1,678,783.86 17,994.52 12,590.88 5,403.64 1,673,380.22 83.7% 9.00%
Sep-2027 A93 81 1,673,380.22 17,994.52 12,550.35 5,444.17 1,667,936.05 83.4% 9.00%
Oct-2027 A94 82 1,667,936.05 17,994.52 12,509.52 5,485.00 1,662,451.06 83.1% 9.00%
Nov-2027 A95 83 1,662,451.06 17,994.52 12,468.38 5,526.14 1,656,924.92 82.8% 9.00%
Dec-2027 A96 84 1,656,924.92 17,994.52 12,426.94 5,567.58 1,651,357.34 82.6% 9.00%
Jan-2028 A97 85 1,651,357.34 17,994.52 12,385.18 5,609.34 1,645,748.00 82.3% 9.00%
Feb-2028 A98 86 1,645,748.00 17,994.52 12,343.11 5,651.41 1,640,096.59 82.0% 9.00%
Mar-2028 A99 87 1,640,096.59 17,994.52 12,300.72 5,693.79 1,634,402.79 81.7% 9.00%
Apr-2028 A100 88 1,634,402.79 17,994.52 12,258.02 5,736.50 1,628,666.30 81.4% 9.00%
May-2028 A101 89 1,628,666.30 17,994.52 12,215.00 5,779.52 1,622,886.77 81.1% 9.00%
Jun-2028 A102 90 1,622,886.77 17,994.52 12,171.65 5,822.87 1,617,063.91 80.9% 9.00%
Jul-2028 A103 91 1,617,063.91 17,994.52 12,127.98 5,866.54 1,611,197.37 80.6% 9.00%
Aug-2028 A104 92 1,611,197.37 17,994.52 12,083.98 5,910.54 1,605,286.83 80.3% 9.00%
Sep-2028 A105 93 1,605,286.83 17,994.52 12,039.65 5,954.87 1,599,331.96 80.0% 9.00%
Oct-2028 A106 94 1,599,331.96 17,994.52 11,994.99 5,999.53 1,593,332.43 79.7% 9.00%
Nov-2028 A107 95 1,593,332.43 17,994.52 11,949.99 6,044.53 1,587,287.90 79.4% 9.00%
Dec-2028 A108 96 1,587,287.90 17,994.52 11,904.66 6,089.86 1,581,198.04 79.1% 9.00%
Jan-2029 A109 97 1,581,198.04 17,994.52 11,858.99 6,135.53 1,575,062.51 78.8% 9.00%
Feb-2029 A110 98 1,575,062.51 17,994.52 11,812.97 6,181.55 1,568,880.96 78.4% 9.00%
Mar-2029 A111 99 1,568,880.96 17,994.52 11,766.61 6,227.91 1,562,653.05 78.1% 9.00%
Apr-2029 A112 100 1,562,653.05 17,994.52 11,719.90 6,274.62 1,556,378.43 77.8% 9.00%
May-2029 A113 101 1,556,378.43 17,994.52 11,672.84 6,321.68 1,550,056.75 77.5% 9.00%
Jun-2029 A114 102 1,550,056.75 17,994.52 11,625.43 6,369.09 1,543,687.65 77.2% 9.00%
Jul-2029 A115 103 1,543,687.65 17,994.52 11,577.66 6,416.86 1,537,270.79 76.9% 9.00%
Aug-2029 A116 104 1,537,270.79 17,994.52 11,529.53 6,464.99 1,530,805.80 76.5% 9.00%
Sep-2029 A117 105 1,530,805.80 17,994.52 11,481.04 6,513.48 1,524,292.33 76.2% 9.00%
Oct-2029 A118 106 1,524,292.33 17,994.52 11,432.19 6,562.33 1,517,730.00 75.9% 9.00%
Nov-2029 A119 107 1,517,730.00 17,994.52 11,382.98 6,611.54 1,511,118.46 75.6% 9.00%
Dec-2029 A120 108 1,511,118.46 17,994.52 11,333.39 6,661.13 1,504,457.33 75.2% 9.00%
Jan-2030 A121 109 1,504,457.33 17,994.52 11,283.43 6,711.09 1,497,746.24 74.9% 9.00%
Feb-2030 A122 110 1,497,746.24 17,994.52 11,233.10 6,761.42 1,490,984.81 74.5% 9.00%
Mar-2030 A123 111 1,490,984.81 17,994.52 11,182.39 6,812.13 1,484,172.68 74.2% 9.00%
Apr-2030 A124 112 1,484,172.68 17,994.52 11,131.30 6,863.22 1,477,309.46 73.9% 9.00%
May-2030 A125 113 1,477,309.46 17,994.52 11,079.82 6,914.70 1,470,394.76 73.5% 9.00%
Jun-2030 A126 114 1,470,394.76 17,994.52 11,027.96 6,966.56 1,463,428.20 73.2% 9.00%
Jul-2030 A127 115 1,463,428.20 17,994.52 10,975.71 7,018.81 1,456,409.39 72.8% 9.00%
Aug-2030 A128 116 1,456,409.39 17,994.52 10,923.07 7,071.45 1,449,337.94 72.5% 9.00%
Sep-2030 A129 117 1,449,337.94 17,994.52 10,870.03 7,124.48 1,442,213.46 72.1% 9.00%
Oct-2030 A130 118 1,442,213.46 17,994.52 10,816.60 7,177.92 1,435,035.54 71.8% 9.00%
Nov-2030 A131 119 1,435,035.54 17,994.52 10,762.77 7,231.75 1,427,803.79 71.4% 9.00%
Dec-2030 A132 120 1,427,803.79 17,994.52 10,708.53 7,285.99 1,420,517.80 71.0% 9.00%
Jan-2031 A133 121 1,420,517.80 17,994.52 10,653.88 7,340.64 1,413,177.16 70.7% 9.00%
Feb-2031 A134 122 1,413,177.16 17,994.52 10,598.83 7,395.69 1,405,781.47 70.3% 9.00%
Mar-2031 A135 123 1,405,781.47 17,994.52 10,543.36 7,451.16 1,398,330.31 69.9% 9.00%
Apr-2031 A136 124 1,398,330.31 17,994.52 10,487.48 7,507.04 1,390,823.27 69.5% 9.00%
May-2031 A137 125 1,390,823.27 17,994.52 10,431.17 7,563.34 1,383,259.93 69.2% 9.00%
Jun-2031 A138 126 1,383,259.93 17,994.52 10,374.45 7,620.07 1,375,639.86 68.8% 9.00%
Jul-2031 A139 127 1,375,639.86 17,994.52 10,317.30 7,677.22 1,367,962.64 68.4% 9.00%
Aug-2031 A140 128 1,367,962.64 17,994.52 10,259.72 7,734.80 1,360,227.84 68.0% 9.00%
Sep-2031 A141 129 1,360,227.84 17,994.52 10,201.71 7,792.81 1,352,435.03 67.6% 9.00%
Oct-2031 A142 130 1,352,435.03 17,994.52 10,143.26 7,851.26 1,344,583.77 67.2% 9.00%
Nov-2031 A143 131 1,344,583.77 17,994.52 10,084.38 7,910.14 1,336,673.63 66.8% 9.00%
Dec-2031 A144 132 1,336,673.63 17,994.52 10,025.05 7,969.47 1,328,704.16 66.4% 9.00%
Jan-2032 A145 133 1,328,704.16 17,994.52 9,965.28 8,029.24 1,320,674.93 66.0% 9.00%
Feb-2032 A146 134 1,320,674.93 17,994.52 9,905.06 8,089.46 1,312,585.47 65.6% 9.00%
Mar-2032 A147 135 1,312,585.47 17,994.52 9,844.39 8,150.13 1,304,435.34 65.2% 9.00%
Apr-2032 A148 136 1,304,435.34 17,994.52 9,783.27 8,211.25 1,296,224.09 64.8% 9.00%
May-2032 A149 137 1,296,224.09 17,994.52 9,721.68 8,272.84 1,287,951.25 64.4% 9.00%
Jun-2032 A150 138 1,287,951.25 17,994.52 9,659.63 8,334.88 1,279,616.36 64.0% 9.00%
Jul-2032 A151 139 1,279,616.36 17,994.52 9,597.12 8,397.40 1,271,218.97 63.6% 9.00%
Aug-2032 A152 140 1,271,218.97 17,994.52 9,534.14 8,460.38 1,262,758.59 63.1% 9.00%
Sep-2032 A153 141 1,262,758.59 17,994.52 9,470.69 8,523.83 1,254,234.76 62.7% 9.00%
Oct-2032 A154 142 1,254,234.76 17,994.52 9,406.76 8,587.76 1,245,647.00 62.3% 9.00%
Nov-2032 A155 143 1,245,647.00 17,994.52 9,342.35 8,652.17 1,236,994.84 61.8% 9.00%
Dec-2032 A156 144 1,236,994.84 17,994.52 9,277.46 8,717.06 1,228,277.78 61.4% 9.00%
Jan-2033 A157 145 1,228,277.78 17,994.52 9,212.08 8,782.44 1,219,495.34 61.0% 9.00%
Feb-2033 A158 146 1,219,495.34 17,994.52 9,146.22 8,848.30 1,210,647.04 60.5% 9.00%

Page 6 of 19
Loan Amortization Schedule
Loan 1
© www.excel-skills.com
Loan Principle Amount 2,000,000.00 On this sheet:
Annual Interest Rate 9.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 240.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 17,994.52 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2021 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Mar-2033 A159 147 1,210,647.04 17,994.52 9,079.85 8,914.67 1,201,732.37 60.1% 9.00%
Apr-2033 A160 148 1,201,732.37 17,994.52 9,012.99 8,981.53 1,192,750.84 59.6% 9.00%
May-2033 A161 149 1,192,750.84 17,994.52 8,945.63 9,048.89 1,183,701.96 59.2% 9.00%
Jun-2033 A162 150 1,183,701.96 17,994.52 8,877.76 9,116.75 1,174,585.20 58.7% 9.00%
Jul-2033 A163 151 1,174,585.20 17,994.52 8,809.39 9,185.13 1,165,400.07 58.3% 9.00%
Aug-2033 A164 152 1,165,400.07 17,994.52 8,740.50 9,254.02 1,156,146.05 57.8% 9.00%
Sep-2033 A165 153 1,156,146.05 17,994.52 8,671.10 9,323.42 1,146,822.63 57.3% 9.00%
Oct-2033 A166 154 1,146,822.63 17,994.52 8,601.17 9,393.35 1,137,429.28 56.9% 9.00%
Nov-2033 A167 155 1,137,429.28 17,994.52 8,530.72 9,463.80 1,127,965.48 56.4% 9.00%
Dec-2033 A168 156 1,127,965.48 17,994.52 8,459.74 9,534.78 1,118,430.70 55.9% 9.00%
Jan-2034 A169 157 1,118,430.70 17,994.52 8,388.23 9,606.29 1,108,824.41 55.4% 9.00%
Feb-2034 A170 158 1,108,824.41 17,994.52 8,316.18 9,678.34 1,099,146.08 55.0% 9.00%
Mar-2034 A171 159 1,099,146.08 17,994.52 8,243.60 9,750.92 1,089,395.16 54.5% 9.00%
Apr-2034 A172 160 1,089,395.16 17,994.52 8,170.46 9,824.06 1,079,571.10 54.0% 9.00%
May-2034 A173 161 1,079,571.10 17,994.52 8,096.78 9,897.74 1,069,673.36 53.5% 9.00%
Jun-2034 A174 162 1,069,673.36 17,994.52 8,022.55 9,971.97 1,059,701.39 53.0% 9.00%
Jul-2034 A175 163 1,059,701.39 17,994.52 7,947.76 10,046.76 1,049,654.64 52.5% 9.00%
Aug-2034 A176 164 1,049,654.64 17,994.52 7,872.41 10,122.11 1,039,532.53 52.0% 9.00%
Sep-2034 A177 165 1,039,532.53 17,994.52 7,796.49 10,198.03 1,029,334.50 51.5% 9.00%
Oct-2034 A178 166 1,029,334.50 17,994.52 7,720.01 10,274.51 1,019,059.99 51.0% 9.00%
Nov-2034 A179 167 1,019,059.99 17,994.52 7,642.95 10,351.57 1,008,708.42 50.4% 9.00%
Dec-2034 A180 168 1,008,708.42 17,994.52 7,565.31 10,429.21 998,279.22 49.9% 9.00%
Jan-2035 A181 169 998,279.22 17,994.52 7,487.09 10,507.42 987,771.79 49.4% 9.00%
Feb-2035 A182 170 987,771.79 17,994.52 7,408.29 10,586.23 977,185.56 48.9% 9.00%
Mar-2035 A183 171 977,185.56 17,994.52 7,328.89 10,665.63 966,519.93 48.3% 9.00%
Apr-2035 A184 172 966,519.93 17,994.52 7,248.90 10,745.62 955,774.31 47.8% 9.00%
May-2035 A185 173 955,774.31 17,994.52 7,168.31 10,826.21 944,948.10 47.2% 9.00%
Jun-2035 A186 174 944,948.10 17,994.52 7,087.11 10,907.41 934,040.69 46.7% 9.00%
Jul-2035 A187 175 934,040.69 17,994.52 7,005.31 10,989.21 923,051.48 46.2% 9.00%
Aug-2035 A188 176 923,051.48 17,994.52 6,922.89 11,071.63 911,979.85 45.6% 9.00%
Sep-2035 A189 177 911,979.85 17,994.52 6,839.85 11,154.67 900,825.18 45.0% 9.00%
Oct-2035 A190 178 900,825.18 17,994.52 6,756.19 11,238.33 889,586.85 44.5% 9.00%
Nov-2035 A191 179 889,586.85 17,994.52 6,671.90 11,322.62 878,264.23 43.9% 9.00%
Dec-2035 A192 180 878,264.23 17,994.52 6,586.98 11,407.54 866,856.69 43.3% 9.00%
Jan-2036 A193 181 866,856.69 17,994.52 6,501.43 11,493.09 855,363.60 42.8% 9.00%
Feb-2036 A194 182 855,363.60 17,994.52 6,415.23 11,579.29 843,784.30 42.2% 9.00%
Mar-2036 A195 183 843,784.30 17,994.52 6,328.38 11,666.14 832,118.17 41.6% 9.00%
Apr-2036 A196 184 832,118.17 17,994.52 6,240.89 11,753.63 820,364.53 41.0% 9.00%
May-2036 A197 185 820,364.53 17,994.52 6,152.73 11,841.79 808,522.75 40.4% 9.00%
Jun-2036 A198 186 808,522.75 17,994.52 6,063.92 11,930.60 796,592.15 39.8% 9.00%
Jul-2036 A199 187 796,592.15 17,994.52 5,974.44 12,020.08 784,572.07 39.2% 9.00%
Aug-2036 A200 188 784,572.07 17,994.52 5,884.29 12,110.23 772,461.84 38.6% 9.00%
Sep-2036 A201 189 772,461.84 17,994.52 5,793.46 12,201.06 760,260.79 38.0% 9.00%
Oct-2036 A202 190 760,260.79 17,994.52 5,701.96 12,292.56 747,968.23 37.4% 9.00%
Nov-2036 A203 191 747,968.23 17,994.52 5,609.76 12,384.76 735,583.47 36.8% 9.00%
Dec-2036 A204 192 735,583.47 17,994.52 5,516.88 12,477.64 723,105.83 36.2% 9.00%
Jan-2037 A205 193 723,105.83 17,994.52 5,423.29 12,571.23 710,534.60 35.5% 9.00%
Feb-2037 A206 194 710,534.60 17,994.52 5,329.01 12,665.51 697,869.09 34.9% 9.00%
Mar-2037 A207 195 697,869.09 17,994.52 5,234.02 12,760.50 685,108.59 34.3% 9.00%
Apr-2037 A208 196 685,108.59 17,994.52 5,138.31 12,856.20 672,252.39 33.6% 9.00%
May-2037 A209 197 672,252.39 17,994.52 5,041.89 12,952.63 659,299.76 33.0% 9.00%
Jun-2037 A210 198 659,299.76 17,994.52 4,944.75 13,049.77 646,249.99 32.3% 9.00%
Jul-2037 A211 199 646,249.99 17,994.52 4,846.87 13,147.64 633,102.34 31.7% 9.00%
Aug-2037 A212 200 633,102.34 17,994.52 4,748.27 13,246.25 619,856.09 31.0% 9.00%
Sep-2037 A213 201 619,856.09 17,994.52 4,648.92 13,345.60 606,510.49 30.3% 9.00%
Oct-2037 A214 202 606,510.49 17,994.52 4,548.83 13,445.69 593,064.80 29.7% 9.00%
Nov-2037 A215 203 593,064.80 17,994.52 4,447.99 13,546.53 579,518.27 29.0% 9.00%
Dec-2037 A216 204 579,518.27 17,994.52 4,346.39 13,648.13 565,870.14 28.3% 9.00%
Jan-2038 A217 205 565,870.14 17,994.52 4,244.03 13,750.49 552,119.65 27.6% 9.00%
Feb-2038 A218 206 552,119.65 17,994.52 4,140.90 13,853.62 538,266.02 26.9% 9.00%
Mar-2038 A219 207 538,266.02 17,994.52 4,037.00 13,957.52 524,308.50 26.2% 9.00%
Apr-2038 A220 208 524,308.50 17,994.52 3,932.31 14,062.21 510,246.29 25.5% 9.00%
May-2038 A221 209 510,246.29 17,994.52 3,826.85 14,167.67 496,078.62 24.8% 9.00%
Jun-2038 A222 210 496,078.62 17,994.52 3,720.59 14,273.93 481,804.69 24.1% 9.00%
Jul-2038 A223 211 481,804.69 17,994.52 3,613.54 14,380.98 467,423.71 23.4% 9.00%
Aug-2038 A224 212 467,423.71 17,994.52 3,505.68 14,488.84 452,934.87 22.6% 9.00%
Sep-2038 A225 213 452,934.87 17,994.52 3,397.01 14,597.51 438,337.36 21.9% 9.00%
Oct-2038 A226 214 438,337.36 17,994.52 3,287.53 14,706.99 423,630.37 21.2% 9.00%
Nov-2038 A227 215 423,630.37 17,994.52 3,177.23 14,817.29 408,813.08 20.4% 9.00%
Dec-2038 A228 216 408,813.08 17,994.52 3,066.10 14,928.42 393,884.66 19.7% 9.00%
Jan-2039 A229 217 393,884.66 17,994.52 2,954.13 15,040.38 378,844.27 18.9% 9.00%
Feb-2039 A230 218 378,844.27 17,994.52 2,841.33 15,153.19 363,691.09 18.2% 9.00%
Mar-2039 A231 219 363,691.09 17,994.52 2,727.68 15,266.84 348,424.25 17.4% 9.00%

Page 7 of 19
Loan Amortization Schedule
Loan 1
© www.excel-skills.com
Loan Principle Amount 2,000,000.00 On this sheet:
Annual Interest Rate 9.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 240.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 17,994.52 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2021 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Apr-2039 A232 220 348,424.25 17,994.52 2,613.18 15,381.34 333,042.91 16.7% 9.00%
May-2039 A233 221 333,042.91 17,994.52 2,497.82 15,496.70 317,546.22 15.9% 9.00%
Jun-2039 A234 222 317,546.22 17,994.52 2,381.60 15,612.92 301,933.29 15.1% 9.00%
Jul-2039 A235 223 301,933.29 17,994.52 2,264.50 15,730.02 286,203.28 14.3% 9.00%
Aug-2039 A236 224 286,203.28 17,994.52 2,146.52 15,847.99 270,355.28 13.5% 9.00%
Sep-2039 A237 225 270,355.28 17,994.52 2,027.66 15,966.85 254,388.43 12.7% 9.00%
Oct-2039 A238 226 254,388.43 17,994.52 1,907.91 16,086.61 238,301.82 11.9% 9.00%
Nov-2039 A239 227 238,301.82 17,994.52 1,787.26 16,207.26 222,094.56 11.1% 9.00%
Dec-2039 A240 228 222,094.56 17,994.52 1,665.71 16,328.81 205,765.75 10.3% 9.00%
Jan-2040 A241 229 205,765.75 17,994.52 1,543.24 16,451.28 189,314.48 9.5% 9.00%
Feb-2040 A242 230 189,314.48 17,994.52 1,419.86 16,574.66 172,739.82 8.6% 9.00%
Mar-2040 A243 231 172,739.82 17,994.52 1,295.55 16,698.97 156,040.85 7.8% 9.00%
Apr-2040 A244 232 156,040.85 17,994.52 1,170.31 16,824.21 139,216.63 7.0% 9.00%
May-2040 A245 233 139,216.63 17,994.52 1,044.12 16,950.39 122,266.24 6.1% 9.00%
Jun-2040 A246 234 122,266.24 17,994.52 917.00 17,077.52 105,188.72 5.3% 9.00%
Jul-2040 A247 235 105,188.72 17,994.52 788.92 17,205.60 87,983.11 4.4% 9.00%
Aug-2040 A248 236 87,983.11 17,994.52 659.87 17,334.65 70,648.47 3.5% 9.00%
Sep-2040 A249 237 70,648.47 17,994.52 529.86 17,464.66 53,183.81 2.7% 9.00%
Oct-2040 A250 238 53,183.81 17,994.52 398.88 17,595.64 35,588.17 1.8% 9.00%
Nov-2040 A251 239 35,588.17 17,994.52 266.91 17,727.61 17,860.56 0.9% 9.00%
Dec-2040 A252 240 17,860.56 17,994.52 133.95 17,860.56 - 0.0% 9.00%
Jan-2041 A253 241 - - - - - 0.0% 9.00%
Feb-2041 A254 242 - - - - - 0.0% 9.00%
Mar-2041 A255 243 - - - - - 0.0% 9.00%
Apr-2041 A256 244 - - - - - 0.0% 9.00%
May-2041 A257 245 - - - - - 0.0% 9.00%
Jun-2041 A258 246 - - - - - 0.0% 9.00%
Jul-2041 A259 247 - - - - - 0.0% 9.00%
Aug-2041 A260 248 - - - - - 0.0% 9.00%
Sep-2041 A261 249 - - - - - 0.0% 9.00%
Oct-2041 A262 250 - - - - - 0.0% 9.00%
Nov-2041 A263 251 - - - - - 0.0% 9.00%
Dec-2041 A264 252 - - - - - 0.0% 9.00%
Jan-2042 A265 253 - - - - - 0.0% 9.00%
Feb-2042 A266 254 - - - - - 0.0% 9.00%
Mar-2042 A267 255 - - - - - 0.0% 9.00%
Apr-2042 A268 256 - - - - - 0.0% 9.00%
May-2042 A269 257 - - - - - 0.0% 9.00%
Jun-2042 A270 258 - - - - - 0.0% 9.00%
Jul-2042 A271 259 - - - - - 0.0% 9.00%
Aug-2042 A272 260 - - - - - 0.0% 9.00%
Sep-2042 A273 261 - - - - - 0.0% 9.00%
Oct-2042 A274 262 - - - - - 0.0% 9.00%
Nov-2042 A275 263 - - - - - 0.0% 9.00%
Dec-2042 A276 264 - - - - - 0.0% 9.00%
Jan-2043 A277 265 - - - - - 0.0% 9.00%
Feb-2043 A278 266 - - - - - 0.0% 9.00%
Mar-2043 A279 267 - - - - - 0.0% 9.00%
Apr-2043 A280 268 - - - - - 0.0% 9.00%
May-2043 A281 269 - - - - - 0.0% 9.00%
Jun-2043 A282 270 - - - - - 0.0% 9.00%
Jul-2043 A283 271 - - - - - 0.0% 9.00%
Aug-2043 A284 272 - - - - - 0.0% 9.00%
Sep-2043 A285 273 - - - - - 0.0% 9.00%
Oct-2043 A286 274 - - - - - 0.0% 9.00%
Nov-2043 A287 275 - - - - - 0.0% 9.00%
Dec-2043 A288 276 - - - - - 0.0% 9.00%
Jan-2044 A289 277 - - - - - 0.0% 9.00%
Feb-2044 A290 278 - - - - - 0.0% 9.00%
Mar-2044 A291 279 - - - - - 0.0% 9.00%
Apr-2044 A292 280 - - - - - 0.0% 9.00%
May-2044 A293 281 - - - - - 0.0% 9.00%
Jun-2044 A294 282 - - - - - 0.0% 9.00%
Jul-2044 A295 283 - - - - - 0.0% 9.00%
Aug-2044 A296 284 - - - - - 0.0% 9.00%
Sep-2044 A297 285 - - - - - 0.0% 9.00%
Oct-2044 A298 286 - - - - - 0.0% 9.00%
Nov-2044 A299 287 - - - - - 0.0% 9.00%
Dec-2044 A300 288 - - - - - 0.0% 9.00%
Jan-2045 A301 289 - - - - - 0.0% 9.00%
Feb-2045 A302 290 - - - - - 0.0% 9.00%
Mar-2045 A303 291 - - - - - 0.0% 9.00%
Apr-2045 A304 292 - - - - - 0.0% 9.00%

Page 8 of 19
Loan Amortization Schedule
Loan 1
© www.excel-skills.com
Loan Principle Amount 2,000,000.00 On this sheet:
Annual Interest Rate 9.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 240.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 17,994.52 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2021 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
May-2045 A305 293 - - - - - 0.0% 9.00%
Jun-2045 A306 294 - - - - - 0.0% 9.00%
Jul-2045 A307 295 - - - - - 0.0% 9.00%
Aug-2045 A308 296 - - - - - 0.0% 9.00%
Sep-2045 A309 297 - - - - - 0.0% 9.00%
Oct-2045 A310 298 - - - - - 0.0% 9.00%
Nov-2045 A311 299 - - - - - 0.0% 9.00%
Dec-2045 A312 300 - - - - - 0.0% 9.00%
Jan-2046 A313 301 - - - - - 0.0% 9.00%
Feb-2046 A314 302 - - - - - 0.0% 9.00%
Mar-2046 A315 303 - - - - - 0.0% 9.00%
Apr-2046 A316 304 - - - - - 0.0% 9.00%
May-2046 A317 305 - - - - - 0.0% 9.00%
Jun-2046 A318 306 - - - - - 0.0% 9.00%
Jul-2046 A319 307 - - - - - 0.0% 9.00%
Aug-2046 A320 308 - - - - - 0.0% 9.00%
Sep-2046 A321 309 - - - - - 0.0% 9.00%
Oct-2046 A322 310 - - - - - 0.0% 9.00%
Nov-2046 A323 311 - - - - - 0.0% 9.00%
Dec-2046 A324 312 - - - - - 0.0% 9.00%
Jan-2047 A325 313 - - - - - 0.0% 9.00%
Feb-2047 A326 314 - - - - - 0.0% 9.00%
Mar-2047 A327 315 - - - - - 0.0% 9.00%
Apr-2047 A328 316 - - - - - 0.0% 9.00%
May-2047 A329 317 - - - - - 0.0% 9.00%
Jun-2047 A330 318 - - - - - 0.0% 9.00%
Jul-2047 A331 319 - - - - - 0.0% 9.00%
Aug-2047 A332 320 - - - - - 0.0% 9.00%
Sep-2047 A333 321 - - - - - 0.0% 9.00%
Oct-2047 A334 322 - - - - - 0.0% 9.00%
Nov-2047 A335 323 - - - - - 0.0% 9.00%
Dec-2047 A336 324 - - - - - 0.0% 9.00%
Jan-2048 A337 325 - - - - - 0.0% 9.00%
Feb-2048 A338 326 - - - - - 0.0% 9.00%
Mar-2048 A339 327 - - - - - 0.0% 9.00%
Apr-2048 A340 328 - - - - - 0.0% 9.00%
May-2048 A341 329 - - - - - 0.0% 9.00%
Jun-2048 A342 330 - - - - - 0.0% 9.00%
Jul-2048 A343 331 - - - - - 0.0% 9.00%
Aug-2048 A344 332 - - - - - 0.0% 9.00%
Sep-2048 A345 333 - - - - - 0.0% 9.00%
Oct-2048 A346 334 - - - - - 0.0% 9.00%
Nov-2048 A347 335 - - - - - 0.0% 9.00%
Dec-2048 A348 336 - - - - - 0.0% 9.00%
Jan-2049 A349 337 - - - - - 0.0% 9.00%
Feb-2049 A350 338 - - - - - 0.0% 9.00%
Mar-2049 A351 339 - - - - - 0.0% 9.00%
Apr-2049 A352 340 - - - - - 0.0% 9.00%
May-2049 A353 341 - - - - - 0.0% 9.00%
Jun-2049 A354 342 - - - - - 0.0% 9.00%
Jul-2049 A355 343 - - - - - 0.0% 9.00%
Aug-2049 A356 344 - - - - - 0.0% 9.00%
Sep-2049 A357 345 - - - - - 0.0% 9.00%
Oct-2049 A358 346 - - - - - 0.0% 9.00%
Nov-2049 A359 347 - - - - - 0.0% 9.00%
Dec-2049 A360 348 - - - - - 0.0% 9.00%
Jan-2050 A361 349 - - - - - 0.0% 9.00%
Feb-2050 A362 350 - - - - - 0.0% 9.00%
Mar-2050 A363 351 - - - - - 0.0% 9.00%
Apr-2050 A364 352 - - - - - 0.0% 9.00%
May-2050 A365 353 - - - - - 0.0% 9.00%
Jun-2050 A366 354 - - - - - 0.0% 9.00%
Jul-2050 A367 355 - - - - - 0.0% 9.00%
Aug-2050 A368 356 - - - - - 0.0% 9.00%
Sep-2050 A369 357 - - - - - 0.0% 9.00%
Oct-2050 A370 358 - - - - - 0.0% 9.00%
Nov-2050 A371 359 - - - - - 0.0% 9.00%
Dec-2050 A372 360 - - - - - 0.0% 9.00%
4,318,684.59 2,318,684.59 2,000,000.00

Page 9 of 19
Loan Amortization Schedule
Loan 2
© www.excel-skills.com
Loan Principle Amount 600,000.00 On this sheet:
Annual Interest Rate 10.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 60.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 10,811.17 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2022 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value 150,000.00 Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Jan-2022 A13 1 600,000.00 10,811.17 5,000.00 5,811.17 594,188.83 99.0% 10.00%
Feb-2022 A14 2 594,188.83 10,811.17 4,951.57 5,859.60 588,329.23 98.1% 10.00%
Mar-2022 A15 3 588,329.23 10,811.17 4,902.74 5,908.43 582,420.81 97.1% 10.00%
Apr-2022 A16 4 582,420.81 10,811.17 4,853.51 5,957.66 576,463.14 96.1% 10.00%
May-2022 A17 5 576,463.14 10,811.17 4,803.86 6,007.31 570,455.83 95.1% 10.00%
Jun-2022 A18 6 570,455.83 10,811.17 4,753.80 6,057.37 564,398.46 94.1% 10.00%
Jul-2022 A19 7 564,398.46 10,811.17 4,703.32 6,107.85 558,290.61 93.0% 10.00%
Aug-2022 A20 8 558,290.61 10,811.17 4,652.42 6,158.75 552,131.86 92.0% 10.00%
Sep-2022 A21 9 552,131.86 10,811.17 4,601.10 6,210.07 545,921.79 91.0% 10.00%
Oct-2022 A22 10 545,921.79 10,811.17 4,549.35 6,261.82 539,659.97 89.9% 10.00%
Nov-2022 A23 11 539,659.97 10,811.17 4,497.17 6,314.00 533,345.97 88.9% 10.00%
Dec-2022 A24 12 533,345.97 10,811.17 4,444.55 6,366.62 526,979.35 87.8% 10.00%
Jan-2023 A25 13 526,979.35 10,811.17 4,391.49 6,419.68 520,559.67 86.8% 10.00%
Feb-2023 A26 14 520,559.67 10,811.17 4,338.00 6,473.17 514,086.50 85.7% 10.00%
Mar-2023 A27 15 514,086.50 10,811.17 4,284.05 6,527.12 507,559.38 84.6% 10.00%
Apr-2023 A28 16 507,559.38 10,811.17 4,229.66 6,581.51 500,977.87 83.5% 10.00%
May-2023 A29 17 500,977.87 10,811.17 4,174.82 6,636.35 494,341.52 82.4% 10.00%
Jun-2023 A30 18 494,341.52 10,811.17 4,119.51 6,691.66 487,649.86 81.3% 10.00%
Jul-2023 A31 19 487,649.86 10,811.17 4,063.75 6,747.42 480,902.44 80.2% 10.00%
Aug-2023 A32 20 480,902.44 10,811.17 4,007.52 6,803.65 474,098.79 79.0% 10.00%
Sep-2023 A33 21 474,098.79 10,811.17 3,950.82 6,860.35 467,238.44 77.9% 10.00%
Oct-2023 A34 22 467,238.44 10,811.17 3,893.65 6,917.52 460,320.93 76.7% 10.00%
Nov-2023 A35 23 460,320.93 10,811.17 3,836.01 6,975.16 453,345.76 75.6% 10.00%
Dec-2023 A36 24 453,345.76 10,811.17 3,777.88 7,033.29 446,312.48 74.4% 10.00%
Jan-2024 A37 25 446,312.48 10,811.17 3,719.27 7,091.90 439,220.58 73.2% 10.00%
Feb-2024 A38 26 439,220.58 10,811.17 3,660.17 7,151.00 432,069.58 72.0% 10.00%
Mar-2024 A39 27 432,069.58 10,811.17 3,600.58 7,210.59 424,858.99 70.8% 10.00%
Apr-2024 A40 28 424,858.99 10,811.17 3,540.49 7,270.68 417,588.31 69.6% 10.00%
May-2024 A41 29 417,588.31 10,811.17 3,479.90 7,331.27 410,257.04 68.4% 10.00%
Jun-2024 A42 30 410,257.04 10,811.17 3,418.81 7,392.36 402,864.68 67.1% 10.00%
Jul-2024 A43 31 402,864.68 10,811.17 3,357.21 7,453.96 395,410.72 65.9% 10.00%
Aug-2024 A44 32 395,410.72 10,811.17 3,295.09 7,516.08 387,894.63 64.6% 10.00%
Sep-2024 A45 33 387,894.63 10,811.17 3,232.46 7,578.71 380,315.92 63.4% 10.00%
Oct-2024 A46 34 380,315.92 10,811.17 3,169.30 7,641.87 372,674.05 62.1% 10.00%
Nov-2024 A47 35 372,674.05 10,811.17 3,105.62 7,705.55 364,968.50 60.8% 10.00%
Dec-2024 A48 36 364,968.50 10,811.17 3,041.40 7,769.77 357,198.73 59.5% 10.00%
Jan-2025 A49 37 357,198.73 10,811.17 2,976.66 7,834.51 349,364.22 58.2% 10.00%
Feb-2025 A50 38 349,364.22 10,811.17 2,911.37 7,899.80 341,464.41 56.9% 10.00%
Mar-2025 A51 39 341,464.41 10,811.17 2,845.54 7,965.63 333,498.78 55.6% 10.00%
Apr-2025 A52 40 333,498.78 10,811.17 2,779.16 8,032.01 325,466.77 54.2% 10.00%
May-2025 A53 41 325,466.77 10,811.17 2,712.22 8,098.95 317,367.82 52.9% 10.00%
Jun-2025 A54 42 317,367.82 10,811.17 2,644.73 8,166.44 309,201.38 51.5% 10.00%
Jul-2025 A55 43 309,201.38 10,811.17 2,576.68 8,234.49 300,966.89 50.2% 10.00%
Aug-2025 A56 44 300,966.89 10,811.17 2,508.06 8,303.11 292,663.78 48.8% 10.00%
Sep-2025 A57 45 292,663.78 10,811.17 2,438.86 8,372.31 284,291.47 47.4% 10.00%
Oct-2025 A58 46 284,291.47 10,811.17 2,369.10 8,442.07 275,849.40 46.0% 10.00%
Nov-2025 A59 47 275,849.40 10,811.17 2,298.74 8,512.43 267,336.97 44.6% 10.00%
Dec-2025 A60 48 267,336.97 10,811.17 2,227.81 8,583.36 258,753.61 43.1% 10.00%
Jan-2026 A61 49 258,753.61 10,811.17 2,156.28 8,654.89 250,098.72 41.7% 10.00%
Feb-2026 A62 50 250,098.72 10,811.17 2,084.16 8,727.01 241,371.71 40.2% 10.00%
Mar-2026 A63 51 241,371.71 10,811.17 2,011.43 8,799.74 232,571.97 38.8% 10.00%
Apr-2026 A64 52 232,571.97 10,811.17 1,938.10 8,873.07 223,698.90 37.3% 10.00%
May-2026 A65 53 223,698.90 10,811.17 1,864.16 8,947.01 214,751.88 35.8% 10.00%
Jun-2026 A66 54 214,751.88 10,811.17 1,789.60 9,021.57 205,730.31 34.3% 10.00%
Jul-2026 A67 55 205,730.31 10,811.17 1,714.42 9,096.75 196,633.56 32.8% 10.00%
Aug-2026 A68 56 196,633.56 10,811.17 1,638.61 9,172.56 187,461.00 31.2% 10.00%
Sep-2026 A69 57 187,461.00 10,811.17 1,562.18 9,249.00 178,212.01 29.7% 10.00%
Oct-2026 A70 58 178,212.01 10,811.17 1,485.10 9,326.07 168,885.94 28.1% 10.00%
Nov-2026 A71 59 168,885.94 10,811.17 1,407.38 9,403.79 159,482.15 26.6% 10.00%
Dec-2026 A72 60 159,482.15 10,811.17 1,329.02 9,482.15 150,000.00 25.0% 10.00%
Jan-2027 A73 61 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2027 A74 62 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2027 A75 63 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2027 A76 64 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2027 A77 65 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2027 A78 66 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2027 A79 67 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2027 A80 68 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2027 A81 69 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2027 A82 70 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2027 A83 71 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2027 A84 72 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2028 A85 73 150,000.00 - - - 150,000.00 25.0% 10.00%

Page 10 of 19
Loan Amortization Schedule
Loan 2
© www.excel-skills.com
Loan Principle Amount 600,000.00 On this sheet:
Annual Interest Rate 10.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 60.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 10,811.17 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2022 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value 150,000.00 Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Feb-2028 A86 74 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2028 A87 75 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2028 A88 76 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2028 A89 77 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2028 A90 78 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2028 A91 79 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2028 A92 80 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2028 A93 81 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2028 A94 82 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2028 A95 83 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2028 A96 84 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2029 A97 85 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2029 A98 86 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2029 A99 87 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2029 A100 88 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2029 A101 89 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2029 A102 90 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2029 A103 91 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2029 A104 92 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2029 A105 93 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2029 A106 94 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2029 A107 95 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2029 A108 96 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2030 A109 97 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2030 A110 98 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2030 A111 99 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2030 A112 100 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2030 A113 101 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2030 A114 102 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2030 A115 103 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2030 A116 104 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2030 A117 105 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2030 A118 106 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2030 A119 107 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2030 A120 108 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2031 A121 109 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2031 A122 110 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2031 A123 111 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2031 A124 112 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2031 A125 113 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2031 A126 114 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2031 A127 115 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2031 A128 116 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2031 A129 117 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2031 A130 118 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2031 A131 119 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2031 A132 120 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2032 A133 121 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2032 A134 122 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2032 A135 123 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2032 A136 124 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2032 A137 125 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2032 A138 126 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2032 A139 127 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2032 A140 128 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2032 A141 129 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2032 A142 130 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2032 A143 131 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2032 A144 132 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2033 A145 133 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2033 A146 134 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2033 A147 135 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2033 A148 136 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2033 A149 137 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2033 A150 138 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2033 A151 139 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2033 A152 140 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2033 A153 141 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2033 A154 142 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2033 A155 143 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2033 A156 144 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2034 A157 145 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2034 A158 146 150,000.00 - - - 150,000.00 25.0% 10.00%

Page 11 of 19
Loan Amortization Schedule
Loan 2
© www.excel-skills.com
Loan Principle Amount 600,000.00 On this sheet:
Annual Interest Rate 10.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 60.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 10,811.17 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2022 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value 150,000.00 Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Mar-2034 A159 147 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2034 A160 148 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2034 A161 149 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2034 A162 150 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2034 A163 151 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2034 A164 152 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2034 A165 153 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2034 A166 154 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2034 A167 155 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2034 A168 156 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2035 A169 157 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2035 A170 158 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2035 A171 159 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2035 A172 160 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2035 A173 161 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2035 A174 162 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2035 A175 163 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2035 A176 164 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2035 A177 165 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2035 A178 166 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2035 A179 167 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2035 A180 168 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2036 A181 169 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2036 A182 170 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2036 A183 171 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2036 A184 172 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2036 A185 173 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2036 A186 174 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2036 A187 175 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2036 A188 176 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2036 A189 177 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2036 A190 178 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2036 A191 179 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2036 A192 180 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2037 A193 181 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2037 A194 182 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2037 A195 183 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2037 A196 184 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2037 A197 185 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2037 A198 186 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2037 A199 187 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2037 A200 188 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2037 A201 189 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2037 A202 190 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2037 A203 191 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2037 A204 192 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2038 A205 193 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2038 A206 194 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2038 A207 195 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2038 A208 196 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2038 A209 197 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2038 A210 198 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2038 A211 199 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2038 A212 200 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2038 A213 201 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2038 A214 202 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2038 A215 203 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2038 A216 204 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2039 A217 205 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2039 A218 206 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2039 A219 207 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2039 A220 208 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2039 A221 209 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2039 A222 210 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2039 A223 211 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2039 A224 212 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2039 A225 213 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2039 A226 214 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2039 A227 215 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2039 A228 216 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2040 A229 217 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2040 A230 218 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2040 A231 219 150,000.00 - - - 150,000.00 25.0% 10.00%

Page 12 of 19
Loan Amortization Schedule
Loan 2
© www.excel-skills.com
Loan Principle Amount 600,000.00 On this sheet:
Annual Interest Rate 10.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 60.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 10,811.17 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2022 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value 150,000.00 Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Apr-2040 A232 220 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2040 A233 221 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2040 A234 222 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2040 A235 223 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2040 A236 224 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2040 A237 225 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2040 A238 226 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2040 A239 227 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2040 A240 228 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2041 A241 229 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2041 A242 230 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2041 A243 231 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2041 A244 232 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2041 A245 233 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2041 A246 234 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2041 A247 235 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2041 A248 236 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2041 A249 237 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2041 A250 238 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2041 A251 239 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2041 A252 240 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2042 A253 241 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2042 A254 242 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2042 A255 243 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2042 A256 244 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2042 A257 245 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2042 A258 246 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2042 A259 247 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2042 A260 248 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2042 A261 249 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2042 A262 250 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2042 A263 251 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2042 A264 252 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2043 A265 253 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2043 A266 254 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2043 A267 255 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2043 A268 256 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2043 A269 257 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2043 A270 258 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2043 A271 259 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2043 A272 260 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2043 A273 261 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2043 A274 262 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2043 A275 263 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2043 A276 264 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2044 A277 265 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2044 A278 266 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2044 A279 267 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2044 A280 268 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2044 A281 269 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2044 A282 270 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2044 A283 271 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2044 A284 272 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2044 A285 273 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2044 A286 274 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2044 A287 275 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2044 A288 276 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2045 A289 277 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2045 A290 278 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2045 A291 279 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2045 A292 280 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2045 A293 281 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2045 A294 282 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2045 A295 283 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2045 A296 284 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2045 A297 285 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2045 A298 286 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2045 A299 287 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2045 A300 288 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2046 A301 289 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2046 A302 290 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2046 A303 291 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2046 A304 292 150,000.00 - - - 150,000.00 25.0% 10.00%

Page 13 of 19
Loan Amortization Schedule
Loan 2
© www.excel-skills.com
Loan Principle Amount 600,000.00 On this sheet:
Annual Interest Rate 10.00% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 60.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 10,811.17 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 1/1/2022 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value 150,000.00 Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
May-2046 A305 293 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2046 A306 294 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2046 A307 295 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2046 A308 296 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2046 A309 297 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2046 A310 298 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2046 A311 299 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2046 A312 300 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2047 A313 301 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2047 A314 302 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2047 A315 303 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2047 A316 304 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2047 A317 305 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2047 A318 306 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2047 A319 307 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2047 A320 308 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2047 A321 309 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2047 A322 310 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2047 A323 311 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2047 A324 312 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2048 A325 313 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2048 A326 314 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2048 A327 315 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2048 A328 316 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2048 A329 317 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2048 A330 318 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2048 A331 319 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2048 A332 320 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2048 A333 321 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2048 A334 322 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2048 A335 323 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2048 A336 324 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2049 A337 325 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2049 A338 326 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2049 A339 327 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2049 A340 328 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2049 A341 329 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2049 A342 330 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2049 A343 331 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2049 A344 332 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2049 A345 333 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2049 A346 334 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2049 A347 335 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2049 A348 336 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2050 A349 337 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2050 A350 338 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2050 A351 339 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2050 A352 340 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2050 A353 341 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2050 A354 342 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2050 A355 343 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2050 A356 344 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2050 A357 345 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2050 A358 346 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2050 A359 347 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2050 A360 348 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2051 A361 349 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2051 A362 350 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2051 A363 351 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2051 A364 352 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2051 A365 353 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2051 A366 354 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2051 A367 355 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2051 A368 356 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2051 A369 357 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2051 A370 358 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2051 A371 359 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2051 A372 360 150,000.00 - - - 150,000.00 25.0% 10.00%
648,670.21 198,670.21 450,000.00

Page 14 of 19
Loan Amortization Schedule
Loan 3
© www.excel-skills.com
Loan Principle Amount 1,000,000.00 On this sheet:
Annual Interest Rate 9.50% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 120.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 12,939.76 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 7/1/2023 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Jul-2023 A13 1 1,000,000.00 12,939.76 7,916.67 5,023.09 994,976.91 99.5% 9.50%
Aug-2023 A14 2 994,976.91 12,939.76 7,876.90 5,062.86 989,914.06 99.0% 9.50%
Sep-2023 A15 3 989,914.06 12,939.76 7,836.82 5,102.94 984,811.12 98.5% 9.50%
Oct-2023 A16 4 984,811.12 12,939.76 7,796.42 5,143.33 979,667.79 98.0% 9.50%
Nov-2023 A17 5 979,667.79 12,939.76 7,755.70 5,184.05 974,483.73 97.4% 9.50%
Dec-2023 A18 6 974,483.73 12,939.76 7,714.66 5,225.09 969,258.64 96.9% 9.50%
Jan-2024 A19 7 969,258.64 12,939.76 7,673.30 5,266.46 963,992.18 96.4% 9.50%
Feb-2024 A20 8 963,992.18 12,939.76 7,631.60 5,308.15 958,684.03 95.9% 9.50%
Mar-2024 A21 9 958,684.03 12,939.76 7,589.58 5,350.17 953,333.86 95.3% 9.50%
Apr-2024 A22 10 953,333.86 12,939.76 7,547.23 5,392.53 947,941.33 94.8% 9.50%
May-2024 A23 11 947,941.33 12,939.76 7,504.54 5,435.22 942,506.11 94.3% 9.50%
Jun-2024 A24 12 942,506.11 12,939.76 7,461.51 5,478.25 937,027.86 93.7% 9.50%
Jul-2024 A25 13 937,027.86 12,939.76 7,418.14 5,521.62 931,506.24 93.2% 9.50%
Aug-2024 A26 14 931,506.24 12,939.76 7,374.42 5,565.33 925,940.91 92.6% 9.50%
Sep-2024 A27 15 925,940.91 12,939.76 7,330.37 5,609.39 920,331.52 92.0% 9.50%
Oct-2024 A28 16 920,331.52 12,939.76 7,285.96 5,653.80 914,677.72 91.5% 9.50%
Nov-2024 A29 17 914,677.72 12,939.76 7,241.20 5,698.56 908,979.16 90.9% 9.50%
Dec-2024 A30 18 908,979.16 12,939.76 7,196.09 5,743.67 903,235.49 90.3% 9.50%
Jan-2025 A31 19 903,235.49 12,939.76 7,150.61 5,789.14 897,446.35 89.7% 9.50%
Feb-2025 A32 20 897,446.35 12,939.76 7,104.78 5,834.97 891,611.38 89.2% 9.50%
Mar-2025 A33 21 891,611.38 12,939.76 7,058.59 5,881.17 885,730.21 88.6% 9.50%
Apr-2025 A34 22 885,730.21 12,939.76 7,012.03 5,927.72 879,802.49 88.0% 9.50%
May-2025 A35 23 879,802.49 12,939.76 6,965.10 5,974.65 873,827.84 87.4% 9.50%
Jun-2025 A36 24 873,827.84 12,939.76 6,917.80 6,021.95 867,805.88 86.8% 9.50%
Jul-2025 A37 25 867,805.88 12,939.76 6,870.13 6,069.63 861,736.26 86.2% 9.50%
Aug-2025 A38 26 861,736.26 12,939.76 6,822.08 6,117.68 855,618.58 85.6% 9.50%
Sep-2025 A39 27 855,618.58 12,939.76 6,773.65 6,166.11 849,452.47 84.9% 9.50%
Oct-2025 A40 28 849,452.47 12,939.76 6,724.83 6,214.92 843,237.55 84.3% 9.50%
Nov-2025 A41 29 843,237.55 12,939.76 6,675.63 6,264.13 836,973.42 83.7% 9.50%
Dec-2025 A42 30 836,973.42 12,939.76 6,626.04 6,313.72 830,659.71 83.1% 9.50%
Jan-2026 A43 31 830,659.71 12,939.76 6,576.06 6,363.70 824,296.01 82.4% 9.50%
Feb-2026 A44 32 824,296.01 12,939.76 6,525.68 6,414.08 817,881.93 81.8% 9.50%
Mar-2026 A45 33 817,881.93 12,939.76 6,474.90 6,464.86 811,417.07 81.1% 9.50%
Apr-2026 A46 34 811,417.07 12,939.76 6,423.72 6,516.04 804,901.03 80.5% 9.50%
May-2026 A47 35 804,901.03 12,939.76 6,372.13 6,567.62 798,333.41 79.8% 9.50%
Jun-2026 A48 36 798,333.41 12,939.76 6,320.14 6,619.62 791,713.79 79.2% 9.50%
Jul-2026 A49 37 791,713.79 12,939.76 6,267.73 6,672.02 785,041.77 78.5% 9.50%
Aug-2026 A50 38 785,041.77 12,939.76 6,214.91 6,724.84 778,316.93 77.8% 9.50%
Sep-2026 A51 39 778,316.93 12,939.76 6,161.68 6,778.08 771,538.85 77.2% 9.50%
Oct-2026 A52 40 771,538.85 12,939.76 6,108.02 6,831.74 764,707.11 76.5% 9.50%
Nov-2026 A53 41 764,707.11 12,939.76 6,053.93 6,885.82 757,821.29 75.8% 9.50%
Dec-2026 A54 42 757,821.29 12,939.76 5,999.42 6,940.34 750,880.95 75.1% 9.50%
Jan-2027 A55 43 750,880.95 12,939.76 5,944.47 6,995.28 743,885.67 74.4% 9.50%
Feb-2027 A56 44 743,885.67 12,939.76 5,889.09 7,050.66 736,835.01 73.7% 9.50%
Mar-2027 A57 45 736,835.01 12,939.76 5,833.28 7,106.48 729,728.53 73.0% 9.50%
Apr-2027 A58 46 729,728.53 12,939.76 5,777.02 7,162.74 722,565.79 72.3% 9.50%
May-2027 A59 47 722,565.79 12,939.76 5,720.31 7,219.44 715,346.35 71.5% 9.50%
Jun-2027 A60 48 715,346.35 12,939.76 5,663.16 7,276.60 708,069.75 70.8% 9.50%
Jul-2027 A61 49 708,069.75 12,939.76 5,605.55 7,334.20 700,735.55 70.1% 9.50%
Aug-2027 A62 50 700,735.55 12,939.76 5,547.49 7,392.27 693,343.28 69.3% 9.50%
Sep-2027 A63 51 693,343.28 12,939.76 5,488.97 7,450.79 685,892.49 68.6% 9.50%
Oct-2027 A64 52 685,892.49 12,939.76 5,429.98 7,509.77 678,382.72 67.8% 9.50%
Nov-2027 A65 53 678,382.72 12,939.76 5,370.53 7,569.23 670,813.49 67.1% 9.50%
Dec-2027 A66 54 670,813.49 12,939.76 5,310.61 7,629.15 663,184.34 66.3% 9.50%
Jan-2028 A67 55 663,184.34 12,939.76 5,250.21 7,689.55 655,494.80 65.5% 9.50%
Feb-2028 A68 56 655,494.80 12,939.76 5,189.33 7,750.42 647,744.38 64.8% 9.50%
Mar-2028 A69 57 647,744.38 12,939.76 5,127.98 7,811.78 639,932.60 64.0% 9.50%
Apr-2028 A70 58 639,932.60 12,939.76 5,066.13 7,873.62 632,058.97 63.2% 9.50%
May-2028 A71 59 632,058.97 12,939.76 5,003.80 7,935.96 624,123.02 62.4% 9.50%
Jun-2028 A72 60 624,123.02 12,939.76 4,940.97 7,998.78 616,124.24 61.6% 9.50%
Jul-2028 A73 61 616,124.24 12,939.76 4,877.65 8,062.11 608,062.13 60.8% 9.50%
Aug-2028 A74 62 608,062.13 12,939.76 4,813.83 8,125.93 599,936.20 60.0% 9.50%
Sep-2028 A75 63 599,936.20 12,939.76 4,749.49 8,190.26 591,745.94 59.2% 9.50%
Oct-2028 A76 64 591,745.94 12,939.76 4,684.66 8,255.10 583,490.84 58.3% 9.50%
Nov-2028 A77 65 583,490.84 12,939.76 4,619.30 8,320.45 575,170.39 57.5% 9.50%
Dec-2028 A78 66 575,170.39 12,939.76 4,553.43 8,386.32 566,784.06 56.7% 9.50%
Jan-2029 A79 67 566,784.06 12,939.76 4,487.04 8,452.72 558,331.35 55.8% 9.50%
Feb-2029 A80 68 558,331.35 12,939.76 4,420.12 8,519.63 549,811.71 55.0% 9.50%
Mar-2029 A81 69 549,811.71 12,939.76 4,352.68 8,587.08 541,224.63 54.1% 9.50%
Apr-2029 A82 70 541,224.63 12,939.76 4,284.70 8,655.06 532,569.57 53.3% 9.50%
May-2029 A83 71 532,569.57 12,939.76 4,216.18 8,723.58 523,845.99 52.4% 9.50%
Jun-2029 A84 72 523,845.99 12,939.76 4,147.11 8,792.64 515,053.35 51.5% 9.50%
Jul-2029 A85 73 515,053.35 12,939.76 4,077.51 8,862.25 506,191.10 50.6% 9.50%

Page 15 of 19
Loan Amortization Schedule
Loan 3
© www.excel-skills.com
Loan Principle Amount 1,000,000.00 On this sheet:
Annual Interest Rate 9.50% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 120.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 12,939.76 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 7/1/2023 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Aug-2029 A86 74 506,191.10 12,939.76 4,007.35 8,932.41 497,258.69 49.7% 9.50%
Sep-2029 A87 75 497,258.69 12,939.76 3,936.63 9,003.12 488,255.57 48.8% 9.50%
Oct-2029 A88 76 488,255.57 12,939.76 3,865.36 9,074.40 479,181.17 47.9% 9.50%
Nov-2029 A89 77 479,181.17 12,939.76 3,793.52 9,146.24 470,034.93 47.0% 9.50%
Dec-2029 A90 78 470,034.93 12,939.76 3,721.11 9,218.65 460,816.28 46.1% 9.50%
Jan-2030 A91 79 460,816.28 12,939.76 3,648.13 9,291.63 451,524.66 45.2% 9.50%
Feb-2030 A92 80 451,524.66 12,939.76 3,574.57 9,365.19 442,159.47 44.2% 9.50%
Mar-2030 A93 81 442,159.47 12,939.76 3,500.43 9,439.33 432,720.15 43.3% 9.50%
Apr-2030 A94 82 432,720.15 12,939.76 3,425.70 9,514.05 423,206.09 42.3% 9.50%
May-2030 A95 83 423,206.09 12,939.76 3,350.38 9,589.37 413,616.72 41.4% 9.50%
Jun-2030 A96 84 413,616.72 12,939.76 3,274.47 9,665.29 403,951.43 40.4% 9.50%
Jul-2030 A97 85 403,951.43 12,939.76 3,197.95 9,741.81 394,209.62 39.4% 9.50%
Aug-2030 A98 86 394,209.62 12,939.76 3,120.83 9,818.93 384,390.69 38.4% 9.50%
Sep-2030 A99 87 384,390.69 12,939.76 3,043.09 9,896.66 374,494.03 37.4% 9.50%
Oct-2030 A100 88 374,494.03 12,939.76 2,964.74 9,975.01 364,519.02 36.5% 9.50%
Nov-2030 A101 89 364,519.02 12,939.76 2,885.78 10,053.98 354,465.04 35.4% 9.50%
Dec-2030 A102 90 354,465.04 12,939.76 2,806.18 10,133.57 344,331.46 34.4% 9.50%
Jan-2031 A103 91 344,331.46 12,939.76 2,725.96 10,213.80 334,117.66 33.4% 9.50%
Feb-2031 A104 92 334,117.66 12,939.76 2,645.10 10,294.66 323,823.01 32.4% 9.50%
Mar-2031 A105 93 323,823.01 12,939.76 2,563.60 10,376.16 313,446.85 31.3% 9.50%
Apr-2031 A106 94 313,446.85 12,939.76 2,481.45 10,458.30 302,988.55 30.3% 9.50%
May-2031 A107 95 302,988.55 12,939.76 2,398.66 10,541.10 292,447.45 29.2% 9.50%
Jun-2031 A108 96 292,447.45 12,939.76 2,315.21 10,624.55 281,822.90 28.2% 9.50%
Jul-2031 A109 97 281,822.90 12,939.76 2,231.10 10,708.66 271,114.25 27.1% 9.50%
Aug-2031 A110 98 271,114.25 12,939.76 2,146.32 10,793.43 260,320.81 26.0% 9.50%
Sep-2031 A111 99 260,320.81 12,939.76 2,060.87 10,878.88 249,441.93 24.9% 9.50%
Oct-2031 A112 100 249,441.93 12,939.76 1,974.75 10,965.01 238,476.92 23.8% 9.50%
Nov-2031 A113 101 238,476.92 12,939.76 1,887.94 11,051.81 227,425.11 22.7% 9.50%
Dec-2031 A114 102 227,425.11 12,939.76 1,800.45 11,139.31 216,285.80 21.6% 9.50%
Jan-2032 A115 103 216,285.80 12,939.76 1,712.26 11,227.49 205,058.31 20.5% 9.50%
Feb-2032 A116 104 205,058.31 12,939.76 1,623.38 11,316.38 193,741.93 19.4% 9.50%
Mar-2032 A117 105 193,741.93 12,939.76 1,533.79 11,405.97 182,335.97 18.2% 9.50%
Apr-2032 A118 106 182,335.97 12,939.76 1,443.49 11,496.26 170,839.70 17.1% 9.50%
May-2032 A119 107 170,839.70 12,939.76 1,352.48 11,587.27 159,252.43 15.9% 9.50%
Jun-2032 A120 108 159,252.43 12,939.76 1,260.75 11,679.01 147,573.42 14.8% 9.50%
Jul-2032 A121 109 147,573.42 12,939.76 1,168.29 11,771.47 135,801.95 13.6% 9.50%
Aug-2032 A122 110 135,801.95 12,939.76 1,075.10 11,864.66 123,937.30 12.4% 9.50%
Sep-2032 A123 111 123,937.30 12,939.76 981.17 11,958.59 111,978.71 11.2% 9.50%
Oct-2032 A124 112 111,978.71 12,939.76 886.50 12,053.26 99,925.45 10.0% 9.50%
Nov-2032 A125 113 99,925.45 12,939.76 791.08 12,148.68 87,776.78 8.8% 9.50%
Dec-2032 A126 114 87,776.78 12,939.76 694.90 12,244.86 75,531.92 7.6% 9.50%
Jan-2033 A127 115 75,531.92 12,939.76 597.96 12,341.79 63,190.12 6.3% 9.50%
Feb-2033 A128 116 63,190.12 12,939.76 500.26 12,439.50 50,750.62 5.1% 9.50%
Mar-2033 A129 117 50,750.62 12,939.76 401.78 12,537.98 38,212.64 3.8% 9.50%
Apr-2033 A130 118 38,212.64 12,939.76 302.52 12,637.24 25,575.40 2.6% 9.50%
May-2033 A131 119 25,575.40 12,939.76 202.47 12,737.28 12,838.12 1.3% 9.50%
Jun-2033 A132 120 12,838.12 12,939.76 101.64 12,838.12 - 0.0% 9.50%
Jul-2033 A133 121 - - - - - 0.0% 9.50%
Aug-2033 A134 122 - - - - - 0.0% 9.50%
Sep-2033 A135 123 - - - - - 0.0% 9.50%
Oct-2033 A136 124 - - - - - 0.0% 9.50%
Nov-2033 A137 125 - - - - - 0.0% 9.50%
Dec-2033 A138 126 - - - - - 0.0% 9.50%
Jan-2034 A139 127 - - - - - 0.0% 9.50%
Feb-2034 A140 128 - - - - - 0.0% 9.50%
Mar-2034 A141 129 - - - - - 0.0% 9.50%
Apr-2034 A142 130 - - - - - 0.0% 9.50%
May-2034 A143 131 - - - - - 0.0% 9.50%
Jun-2034 A144 132 - - - - - 0.0% 9.50%
Jul-2034 A145 133 - - - - - 0.0% 9.50%
Aug-2034 A146 134 - - - - - 0.0% 9.50%
Sep-2034 A147 135 - - - - - 0.0% 9.50%
Oct-2034 A148 136 - - - - - 0.0% 9.50%
Nov-2034 A149 137 - - - - - 0.0% 9.50%
Dec-2034 A150 138 - - - - - 0.0% 9.50%
Jan-2035 A151 139 - - - - - 0.0% 9.50%
Feb-2035 A152 140 - - - - - 0.0% 9.50%
Mar-2035 A153 141 - - - - - 0.0% 9.50%
Apr-2035 A154 142 - - - - - 0.0% 9.50%
May-2035 A155 143 - - - - - 0.0% 9.50%
Jun-2035 A156 144 - - - - - 0.0% 9.50%
Jul-2035 A157 145 - - - - - 0.0% 9.50%
Aug-2035 A158 146 - - - - - 0.0% 9.50%

Page 16 of 19
Loan Amortization Schedule
Loan 3
© www.excel-skills.com
Loan Principle Amount 1,000,000.00 On this sheet:
Annual Interest Rate 9.50% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 120.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 12,939.76 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 7/1/2023 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Sep-2035 A159 147 - - - - - 0.0% 9.50%
Oct-2035 A160 148 - - - - - 0.0% 9.50%
Nov-2035 A161 149 - - - - - 0.0% 9.50%
Dec-2035 A162 150 - - - - - 0.0% 9.50%
Jan-2036 A163 151 - - - - - 0.0% 9.50%
Feb-2036 A164 152 - - - - - 0.0% 9.50%
Mar-2036 A165 153 - - - - - 0.0% 9.50%
Apr-2036 A166 154 - - - - - 0.0% 9.50%
May-2036 A167 155 - - - - - 0.0% 9.50%
Jun-2036 A168 156 - - - - - 0.0% 9.50%
Jul-2036 A169 157 - - - - - 0.0% 9.50%
Aug-2036 A170 158 - - - - - 0.0% 9.50%
Sep-2036 A171 159 - - - - - 0.0% 9.50%
Oct-2036 A172 160 - - - - - 0.0% 9.50%
Nov-2036 A173 161 - - - - - 0.0% 9.50%
Dec-2036 A174 162 - - - - - 0.0% 9.50%
Jan-2037 A175 163 - - - - - 0.0% 9.50%
Feb-2037 A176 164 - - - - - 0.0% 9.50%
Mar-2037 A177 165 - - - - - 0.0% 9.50%
Apr-2037 A178 166 - - - - - 0.0% 9.50%
May-2037 A179 167 - - - - - 0.0% 9.50%
Jun-2037 A180 168 - - - - - 0.0% 9.50%
Jul-2037 A181 169 - - - - - 0.0% 9.50%
Aug-2037 A182 170 - - - - - 0.0% 9.50%
Sep-2037 A183 171 - - - - - 0.0% 9.50%
Oct-2037 A184 172 - - - - - 0.0% 9.50%
Nov-2037 A185 173 - - - - - 0.0% 9.50%
Dec-2037 A186 174 - - - - - 0.0% 9.50%
Jan-2038 A187 175 - - - - - 0.0% 9.50%
Feb-2038 A188 176 - - - - - 0.0% 9.50%
Mar-2038 A189 177 - - - - - 0.0% 9.50%
Apr-2038 A190 178 - - - - - 0.0% 9.50%
May-2038 A191 179 - - - - - 0.0% 9.50%
Jun-2038 A192 180 - - - - - 0.0% 9.50%
Jul-2038 A193 181 - - - - - 0.0% 9.50%
Aug-2038 A194 182 - - - - - 0.0% 9.50%
Sep-2038 A195 183 - - - - - 0.0% 9.50%
Oct-2038 A196 184 - - - - - 0.0% 9.50%
Nov-2038 A197 185 - - - - - 0.0% 9.50%
Dec-2038 A198 186 - - - - - 0.0% 9.50%
Jan-2039 A199 187 - - - - - 0.0% 9.50%
Feb-2039 A200 188 - - - - - 0.0% 9.50%
Mar-2039 A201 189 - - - - - 0.0% 9.50%
Apr-2039 A202 190 - - - - - 0.0% 9.50%
May-2039 A203 191 - - - - - 0.0% 9.50%
Jun-2039 A204 192 - - - - - 0.0% 9.50%
Jul-2039 A205 193 - - - - - 0.0% 9.50%
Aug-2039 A206 194 - - - - - 0.0% 9.50%
Sep-2039 A207 195 - - - - - 0.0% 9.50%
Oct-2039 A208 196 - - - - - 0.0% 9.50%
Nov-2039 A209 197 - - - - - 0.0% 9.50%
Dec-2039 A210 198 - - - - - 0.0% 9.50%
Jan-2040 A211 199 - - - - - 0.0% 9.50%
Feb-2040 A212 200 - - - - - 0.0% 9.50%
Mar-2040 A213 201 - - - - - 0.0% 9.50%
Apr-2040 A214 202 - - - - - 0.0% 9.50%
May-2040 A215 203 - - - - - 0.0% 9.50%
Jun-2040 A216 204 - - - - - 0.0% 9.50%
Jul-2040 A217 205 - - - - - 0.0% 9.50%
Aug-2040 A218 206 - - - - - 0.0% 9.50%
Sep-2040 A219 207 - - - - - 0.0% 9.50%
Oct-2040 A220 208 - - - - - 0.0% 9.50%
Nov-2040 A221 209 - - - - - 0.0% 9.50%
Dec-2040 A222 210 - - - - - 0.0% 9.50%
Jan-2041 A223 211 - - - - - 0.0% 9.50%
Feb-2041 A224 212 - - - - - 0.0% 9.50%
Mar-2041 A225 213 - - - - - 0.0% 9.50%
Apr-2041 A226 214 - - - - - 0.0% 9.50%
May-2041 A227 215 - - - - - 0.0% 9.50%
Jun-2041 A228 216 - - - - - 0.0% 9.50%
Jul-2041 A229 217 - - - - - 0.0% 9.50%
Aug-2041 A230 218 - - - - - 0.0% 9.50%
Sep-2041 A231 219 - - - - - 0.0% 9.50%

Page 17 of 19
Loan Amortization Schedule
Loan 3
© www.excel-skills.com
Loan Principle Amount 1,000,000.00 On this sheet:
Annual Interest Rate 9.50% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 120.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 12,939.76 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 7/1/2023 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Oct-2041 A232 220 - - - - - 0.0% 9.50%
Nov-2041 A233 221 - - - - - 0.0% 9.50%
Dec-2041 A234 222 - - - - - 0.0% 9.50%
Jan-2042 A235 223 - - - - - 0.0% 9.50%
Feb-2042 A236 224 - - - - - 0.0% 9.50%
Mar-2042 A237 225 - - - - - 0.0% 9.50%
Apr-2042 A238 226 - - - - - 0.0% 9.50%
May-2042 A239 227 - - - - - 0.0% 9.50%
Jun-2042 A240 228 - - - - - 0.0% 9.50%
Jul-2042 A241 229 - - - - - 0.0% 9.50%
Aug-2042 A242 230 - - - - - 0.0% 9.50%
Sep-2042 A243 231 - - - - - 0.0% 9.50%
Oct-2042 A244 232 - - - - - 0.0% 9.50%
Nov-2042 A245 233 - - - - - 0.0% 9.50%
Dec-2042 A246 234 - - - - - 0.0% 9.50%
Jan-2043 A247 235 - - - - - 0.0% 9.50%
Feb-2043 A248 236 - - - - - 0.0% 9.50%
Mar-2043 A249 237 - - - - - 0.0% 9.50%
Apr-2043 A250 238 - - - - - 0.0% 9.50%
May-2043 A251 239 - - - - - 0.0% 9.50%
Jun-2043 A252 240 - - - - - 0.0% 9.50%
Jul-2043 A253 241 - - - - - 0.0% 9.50%
Aug-2043 A254 242 - - - - - 0.0% 9.50%
Sep-2043 A255 243 - - - - - 0.0% 9.50%
Oct-2043 A256 244 - - - - - 0.0% 9.50%
Nov-2043 A257 245 - - - - - 0.0% 9.50%
Dec-2043 A258 246 - - - - - 0.0% 9.50%
Jan-2044 A259 247 - - - - - 0.0% 9.50%
Feb-2044 A260 248 - - - - - 0.0% 9.50%
Mar-2044 A261 249 - - - - - 0.0% 9.50%
Apr-2044 A262 250 - - - - - 0.0% 9.50%
May-2044 A263 251 - - - - - 0.0% 9.50%
Jun-2044 A264 252 - - - - - 0.0% 9.50%
Jul-2044 A265 253 - - - - - 0.0% 9.50%
Aug-2044 A266 254 - - - - - 0.0% 9.50%
Sep-2044 A267 255 - - - - - 0.0% 9.50%
Oct-2044 A268 256 - - - - - 0.0% 9.50%
Nov-2044 A269 257 - - - - - 0.0% 9.50%
Dec-2044 A270 258 - - - - - 0.0% 9.50%
Jan-2045 A271 259 - - - - - 0.0% 9.50%
Feb-2045 A272 260 - - - - - 0.0% 9.50%
Mar-2045 A273 261 - - - - - 0.0% 9.50%
Apr-2045 A274 262 - - - - - 0.0% 9.50%
May-2045 A275 263 - - - - - 0.0% 9.50%
Jun-2045 A276 264 - - - - - 0.0% 9.50%
Jul-2045 A277 265 - - - - - 0.0% 9.50%
Aug-2045 A278 266 - - - - - 0.0% 9.50%
Sep-2045 A279 267 - - - - - 0.0% 9.50%
Oct-2045 A280 268 - - - - - 0.0% 9.50%
Nov-2045 A281 269 - - - - - 0.0% 9.50%
Dec-2045 A282 270 - - - - - 0.0% 9.50%
Jan-2046 A283 271 - - - - - 0.0% 9.50%
Feb-2046 A284 272 - - - - - 0.0% 9.50%
Mar-2046 A285 273 - - - - - 0.0% 9.50%
Apr-2046 A286 274 - - - - - 0.0% 9.50%
May-2046 A287 275 - - - - - 0.0% 9.50%
Jun-2046 A288 276 - - - - - 0.0% 9.50%
Jul-2046 A289 277 - - - - - 0.0% 9.50%
Aug-2046 A290 278 - - - - - 0.0% 9.50%
Sep-2046 A291 279 - - - - - 0.0% 9.50%
Oct-2046 A292 280 - - - - - 0.0% 9.50%
Nov-2046 A293 281 - - - - - 0.0% 9.50%
Dec-2046 A294 282 - - - - - 0.0% 9.50%
Jan-2047 A295 283 - - - - - 0.0% 9.50%
Feb-2047 A296 284 - - - - - 0.0% 9.50%
Mar-2047 A297 285 - - - - - 0.0% 9.50%
Apr-2047 A298 286 - - - - - 0.0% 9.50%
May-2047 A299 287 - - - - - 0.0% 9.50%
Jun-2047 A300 288 - - - - - 0.0% 9.50%
Jul-2047 A301 289 - - - - - 0.0% 9.50%
Aug-2047 A302 290 - - - - - 0.0% 9.50%
Sep-2047 A303 291 - - - - - 0.0% 9.50%
Oct-2047 A304 292 - - - - - 0.0% 9.50%

Page 18 of 19
Loan Amortization Schedule
Loan 3
© www.excel-skills.com
Loan Principle Amount 1,000,000.00 On this sheet:
Annual Interest Rate 9.50% Enter the appropriate loan terms in the cells with yellow cell backgrounds at
Loan Period (in months) 120.00 the top of the sheet. The template accommodates variable monthly interest
Original Repayment Amount 12,939.76 rates which can be entered in column K. All the other cells on this sheet
Loan Start Date 7/1/2023 contain formulas which are automatically updated based on the values
Repayment Type End entered. The calculations on this sheet are included in column B on the
Residual Value - Summary sheet.

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Nov-2047 A305 293 - - - - - 0.0% 9.50%
Dec-2047 A306 294 - - - - - 0.0% 9.50%
Jan-2048 A307 295 - - - - - 0.0% 9.50%
Feb-2048 A308 296 - - - - - 0.0% 9.50%
Mar-2048 A309 297 - - - - - 0.0% 9.50%
Apr-2048 A310 298 - - - - - 0.0% 9.50%
May-2048 A311 299 - - - - - 0.0% 9.50%
Jun-2048 A312 300 - - - - - 0.0% 9.50%
Jul-2048 A313 301 - - - - - 0.0% 9.50%
Aug-2048 A314 302 - - - - - 0.0% 9.50%
Sep-2048 A315 303 - - - - - 0.0% 9.50%
Oct-2048 A316 304 - - - - - 0.0% 9.50%
Nov-2048 A317 305 - - - - - 0.0% 9.50%
Dec-2048 A318 306 - - - - - 0.0% 9.50%
Jan-2049 A319 307 - - - - - 0.0% 9.50%
Feb-2049 A320 308 - - - - - 0.0% 9.50%
Mar-2049 A321 309 - - - - - 0.0% 9.50%
Apr-2049 A322 310 - - - - - 0.0% 9.50%
May-2049 A323 311 - - - - - 0.0% 9.50%
Jun-2049 A324 312 - - - - - 0.0% 9.50%
Jul-2049 A325 313 - - - - - 0.0% 9.50%
Aug-2049 A326 314 - - - - - 0.0% 9.50%
Sep-2049 A327 315 - - - - - 0.0% 9.50%
Oct-2049 A328 316 - - - - - 0.0% 9.50%
Nov-2049 A329 317 - - - - - 0.0% 9.50%
Dec-2049 A330 318 - - - - - 0.0% 9.50%
Jan-2050 A331 319 - - - - - 0.0% 9.50%
Feb-2050 A332 320 - - - - - 0.0% 9.50%
Mar-2050 A333 321 - - - - - 0.0% 9.50%
Apr-2050 A334 322 - - - - - 0.0% 9.50%
May-2050 A335 323 - - - - - 0.0% 9.50%
Jun-2050 A336 324 - - - - - 0.0% 9.50%
Jul-2050 A337 325 - - - - - 0.0% 9.50%
Aug-2050 A338 326 - - - - - 0.0% 9.50%
Sep-2050 A339 327 - - - - - 0.0% 9.50%
Oct-2050 A340 328 - - - - - 0.0% 9.50%
Nov-2050 A341 329 - - - - - 0.0% 9.50%
Dec-2050 A342 330 - - - - - 0.0% 9.50%
Jan-2051 A343 331 - - - - - 0.0% 9.50%
Feb-2051 A344 332 - - - - - 0.0% 9.50%
Mar-2051 A345 333 - - - - - 0.0% 9.50%
Apr-2051 A346 334 - - - - - 0.0% 9.50%
May-2051 A347 335 - - - - - 0.0% 9.50%
Jun-2051 A348 336 - - - - - 0.0% 9.50%
Jul-2051 A349 337 - - - - - 0.0% 9.50%
Aug-2051 A350 338 - - - - - 0.0% 9.50%
Sep-2051 A351 339 - - - - - 0.0% 9.50%
Oct-2051 A352 340 - - - - - 0.0% 9.50%
Nov-2051 A353 341 - - - - - 0.0% 9.50%
Dec-2051 A354 342 - - - - - 0.0% 9.50%
Jan-2052 A355 343 - - - - - 0.0% 9.50%
Feb-2052 A356 344 - - - - - 0.0% 9.50%
Mar-2052 A357 345 - - - - - 0.0% 9.50%
Apr-2052 A358 346 - - - - - 0.0% 9.50%
May-2052 A359 347 - - - - - 0.0% 9.50%
Jun-2052 A360 348 - - - - - 0.0% 9.50%
Jul-2052 A361 349 - - - - - 0.0% 9.50%
Aug-2052 A362 350 - - - - - 0.0% 9.50%
Sep-2052 A363 351 - - - - - 0.0% 9.50%
Oct-2052 A364 352 - - - - - 0.0% 9.50%
Nov-2052 A365 353 - - - - - 0.0% 9.50%
Dec-2052 A366 354 - - - - - 0.0% 9.50%
Jan-2053 A367 355 - - - - - 0.0% 9.50%
Feb-2053 A368 356 - - - - - 0.0% 9.50%
Mar-2053 A369 357 - - - - - 0.0% 9.50%
Apr-2053 A370 358 - - - - - 0.0% 9.50%
May-2053 A371 359 - - - - - 0.0% 9.50%
Jun-2053 A372 360 - - - - - 0.0% 9.50%
1,552,770.69 552,770.69 1,000,000.00

Page 19 of 19