EXCEL-SKILLS.

COM
LOAN AMORTIZATION TEMPLATE
This loan amortization template enables users to create amortization schedules for multiple loans and to review in
balances based on any user defined date. The template is suitable for any loan which is repaid on a monthly basis an
rates.
View all our unique templates!
This free template forms part of our unique range of innovative Excel templates which features accounting in Excel, f
cash flow projections, business valuations, fixed assets, costing & inventory, monthly payroll and a lot more.

Get more templates!

enable editing to activate the link

ATE
for multiple loans and to review interest, capital repayments and outstanding
hich is repaid on a monthly basis and accommodates variable monthly interest

which features accounting in Excel, financial statements, management accounts,

hly payroll and a lot more.

plates!

te the link
Loan Amortization Summary
All Loans Review Date
As at 31 December 2020 12/31/2020 12/31/2020
On this sheet:
Sheet Reference Amort01! Amort02! Amort03! Review the interest, capital and outstanding balances of multiple loans a
Selected Month - Cell Reference A60 A48 A30 stages during the loan period by simply entering a loan review date in cell B
Loan Start Date 1/1/2017 1/1/2018 7/1/2019 calculations on this sheet are automated and based on the individual loan am
Loan Amount 2,000,000.00 600,000.00 1,000,000.00 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
Total Interest Paid Err:502 Err:502 Err:502 Add more loans!

Total Capital Repayment Err:502 Err:502 Err:502 You can add additional loans to the template by copying the last column, c
Outstanding Capital Balance 1,827,753.13 357,198.73 903,235.49
amortization sheets and renaming the copied sheet to "Amort" and the next
(refer to the current sheet names). The calculations in the appropriate colu
Outstanding Capital % 91.4% 59.5% 90.3%
will then be updated automatically based on the loan amortization schedule o

Past 12 Months
Total Loan Repayments Err:502 Err:502 Err:502
Total Interest Paid Err:502 Err:502 Err:502
Example:
Total Capital Repayment Err:502 Err:502 Err:502
To add a new loan to the standard template, we need to copy column D to c
copy of sheet "Amort03" and change the name of the copied sheet to
Next 12 Months calculations in column E will then be updated with the amounts on the new
Total Loan Repayments 215,934.23 129,734.04 155,277.07 There is no limit on the number of columns and sheets that can be added to th
Total Interest Paid 162,322.08 31,288.92 82,701.28
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 2020
On this sheet:
Review theSheet Reference
interest, capital and outstanding balances of multiple loans at various
Selected Month - Cell Reference
stages during the loan period by simply entering a loan review date in cell B3. All the
Loan
calculations onStart
this Date
sheet are automated and based on the individual loan amortization
sheets. Loan Amount
Residual Value
© www.excel-skills.com
All Periods To Date
Total Loan Repayments
Total Interest Paid Add more loans!
You can addTotaladditional loans to the template by copying the last column, copying one of the
Capital Repayment
amortization sheets and renaming
Outstanding Capital Balance
the copied sheet to "Amort" and the next two-digit number
(refer to the current sheet names). The calculations in the appropriate column on this sheet
Outstanding Capital %
will then be updated automatically based on the loan amortization schedule on the new sheet.

Past 12 Months
Total Loan Repayments
Total Interest Paid
Example:
Total Capital Repayment
To add a new loan to the standard template, we need to copy column D to column E, create a
copy of sheet "Amort03" and change the name of the copied sheet to "Amort04". The
Next
calculations in12 MonthsE will then be updated with the amounts on the new "Amort04" sheet.
column
There is no limit on Repayments
Total Loan the number of columns and sheets that can be added to the template!
Total 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
Annual Interest Rate 9.00% On this sheet:
Loan Period (in months) 240.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 17,994.52 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 1/1/2017 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value -

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

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

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

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

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

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

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Apr-2035 A232 220 348,424.25 17,994.52 2,613.18 15,381.34 333,042.91 16.7% 9.00%
May-2035 A233 221 333,042.91 17,994.52 2,497.82 15,496.70 317,546.22 15.9% 9.00%
Jun-2035 A234 222 317,546.22 17,994.52 2,381.60 15,612.92 301,933.29 15.1% 9.00%
Jul-2035 A235 223 301,933.29 17,994.52 2,264.50 15,730.02 286,203.28 14.3% 9.00%
Aug-2035 A236 224 286,203.28 17,994.52 2,146.52 15,847.99 270,355.28 13.5% 9.00%
Sep-2035 A237 225 270,355.28 17,994.52 2,027.66 15,966.85 254,388.43 12.7% 9.00%
Oct-2035 A238 226 254,388.43 17,994.52 1,907.91 16,086.61 238,301.82 11.9% 9.00%
Nov-2035 A239 227 238,301.82 17,994.52 1,787.26 16,207.26 222,094.56 11.1% 9.00%
Dec-2035 A240 228 222,094.56 17,994.52 1,665.71 16,328.81 205,765.75 10.3% 9.00%
Jan-2036 A241 229 205,765.75 17,994.52 1,543.24 16,451.28 189,314.48 9.5% 9.00%
Feb-2036 A242 230 189,314.48 17,994.52 1,419.86 16,574.66 172,739.82 8.6% 9.00%
Mar-2036 A243 231 172,739.82 17,994.52 1,295.55 16,698.97 156,040.85 7.8% 9.00%
Apr-2036 A244 232 156,040.85 17,994.52 1,170.31 16,824.21 139,216.63 7.0% 9.00%
May-2036 A245 233 139,216.63 17,994.52 1,044.12 16,950.39 122,266.24 6.1% 9.00%
Jun-2036 A246 234 122,266.24 17,994.52 917.00 17,077.52 105,188.72 5.3% 9.00%
Jul-2036 A247 235 105,188.72 17,994.52 788.92 17,205.60 87,983.11 4.4% 9.00%
Aug-2036 A248 236 87,983.11 17,994.52 659.87 17,334.65 70,648.47 3.5% 9.00%
Sep-2036 A249 237 70,648.47 17,994.52 529.86 17,464.66 53,183.81 2.7% 9.00%
Oct-2036 A250 238 53,183.81 17,994.52 398.88 17,595.64 35,588.17 1.8% 9.00%
Nov-2036 A251 239 35,588.17 17,994.52 266.91 17,727.61 17,860.56 0.9% 9.00%
Dec-2036 A252 240 17,860.56 17,994.52 133.95 17,860.56 - 0.0% 9.00%
Jan-2037 A253 241 - - - - - 0.0% 9.00%
Feb-2037 A254 242 - - - - - 0.0% 9.00%
Mar-2037 A255 243 - - - - - 0.0% 9.00%
Apr-2037 A256 244 - - - - - 0.0% 9.00%
May-2037 A257 245 - - - - - 0.0% 9.00%
Jun-2037 A258 246 - - - - - 0.0% 9.00%
Jul-2037 A259 247 - - - - - 0.0% 9.00%
Aug-2037 A260 248 - - - - - 0.0% 9.00%
Sep-2037 A261 249 - - - - - 0.0% 9.00%
Oct-2037 A262 250 - - - - - 0.0% 9.00%
Nov-2037 A263 251 - - - - - 0.0% 9.00%
Dec-2037 A264 252 - - - - - 0.0% 9.00%
Jan-2038 A265 253 - - - - - 0.0% 9.00%
Feb-2038 A266 254 - - - - - 0.0% 9.00%
Mar-2038 A267 255 - - - - - 0.0% 9.00%
Apr-2038 A268 256 - - - - - 0.0% 9.00%
May-2038 A269 257 - - - - - 0.0% 9.00%
Jun-2038 A270 258 - - - - - 0.0% 9.00%
Jul-2038 A271 259 - - - - - 0.0% 9.00%
Aug-2038 A272 260 - - - - - 0.0% 9.00%
Sep-2038 A273 261 - - - - - 0.0% 9.00%
Oct-2038 A274 262 - - - - - 0.0% 9.00%
Nov-2038 A275 263 - - - - - 0.0% 9.00%
Dec-2038 A276 264 - - - - - 0.0% 9.00%
Jan-2039 A277 265 - - - - - 0.0% 9.00%
Feb-2039 A278 266 - - - - - 0.0% 9.00%
Mar-2039 A279 267 - - - - - 0.0% 9.00%
Apr-2039 A280 268 - - - - - 0.0% 9.00%
May-2039 A281 269 - - - - - 0.0% 9.00%
Jun-2039 A282 270 - - - - - 0.0% 9.00%
Jul-2039 A283 271 - - - - - 0.0% 9.00%
Aug-2039 A284 272 - - - - - 0.0% 9.00%
Sep-2039 A285 273 - - - - - 0.0% 9.00%
Oct-2039 A286 274 - - - - - 0.0% 9.00%
Nov-2039 A287 275 - - - - - 0.0% 9.00%
Dec-2039 A288 276 - - - - - 0.0% 9.00%
Jan-2040 A289 277 - - - - - 0.0% 9.00%
Feb-2040 A290 278 - - - - - 0.0% 9.00%
Mar-2040 A291 279 - - - - - 0.0% 9.00%
Apr-2040 A292 280 - - - - - 0.0% 9.00%
May-2040 A293 281 - - - - - 0.0% 9.00%
Jun-2040 A294 282 - - - - - 0.0% 9.00%
Jul-2040 A295 283 - - - - - 0.0% 9.00%
Aug-2040 A296 284 - - - - - 0.0% 9.00%
Sep-2040 A297 285 - - - - - 0.0% 9.00%
Oct-2040 A298 286 - - - - - 0.0% 9.00%
Nov-2040 A299 287 - - - - - 0.0% 9.00%
Dec-2040 A300 288 - - - - - 0.0% 9.00%
Jan-2041 A301 289 - - - - - 0.0% 9.00%
Feb-2041 A302 290 - - - - - 0.0% 9.00%
Mar-2041 A303 291 - - - - - 0.0% 9.00%
Apr-2041 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
Annual Interest Rate 9.00% On this sheet:
Loan Period (in months) 240.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 17,994.52 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 1/1/2017 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value -

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
May-2041 A305 293 - - - - - 0.0% 9.00%
Jun-2041 A306 294 - - - - - 0.0% 9.00%
Jul-2041 A307 295 - - - - - 0.0% 9.00%
Aug-2041 A308 296 - - - - - 0.0% 9.00%
Sep-2041 A309 297 - - - - - 0.0% 9.00%
Oct-2041 A310 298 - - - - - 0.0% 9.00%
Nov-2041 A311 299 - - - - - 0.0% 9.00%
Dec-2041 A312 300 - - - - - 0.0% 9.00%
Jan-2042 A313 301 - - - - - 0.0% 9.00%
Feb-2042 A314 302 - - - - - 0.0% 9.00%
Mar-2042 A315 303 - - - - - 0.0% 9.00%
Apr-2042 A316 304 - - - - - 0.0% 9.00%
May-2042 A317 305 - - - - - 0.0% 9.00%
Jun-2042 A318 306 - - - - - 0.0% 9.00%
Jul-2042 A319 307 - - - - - 0.0% 9.00%
Aug-2042 A320 308 - - - - - 0.0% 9.00%
Sep-2042 A321 309 - - - - - 0.0% 9.00%
Oct-2042 A322 310 - - - - - 0.0% 9.00%
Nov-2042 A323 311 - - - - - 0.0% 9.00%
Dec-2042 A324 312 - - - - - 0.0% 9.00%
Jan-2043 A325 313 - - - - - 0.0% 9.00%
Feb-2043 A326 314 - - - - - 0.0% 9.00%
Mar-2043 A327 315 - - - - - 0.0% 9.00%
Apr-2043 A328 316 - - - - - 0.0% 9.00%
May-2043 A329 317 - - - - - 0.0% 9.00%
Jun-2043 A330 318 - - - - - 0.0% 9.00%
Jul-2043 A331 319 - - - - - 0.0% 9.00%
Aug-2043 A332 320 - - - - - 0.0% 9.00%
Sep-2043 A333 321 - - - - - 0.0% 9.00%
Oct-2043 A334 322 - - - - - 0.0% 9.00%
Nov-2043 A335 323 - - - - - 0.0% 9.00%
Dec-2043 A336 324 - - - - - 0.0% 9.00%
Jan-2044 A337 325 - - - - - 0.0% 9.00%
Feb-2044 A338 326 - - - - - 0.0% 9.00%
Mar-2044 A339 327 - - - - - 0.0% 9.00%
Apr-2044 A340 328 - - - - - 0.0% 9.00%
May-2044 A341 329 - - - - - 0.0% 9.00%
Jun-2044 A342 330 - - - - - 0.0% 9.00%
Jul-2044 A343 331 - - - - - 0.0% 9.00%
Aug-2044 A344 332 - - - - - 0.0% 9.00%
Sep-2044 A345 333 - - - - - 0.0% 9.00%
Oct-2044 A346 334 - - - - - 0.0% 9.00%
Nov-2044 A347 335 - - - - - 0.0% 9.00%
Dec-2044 A348 336 - - - - - 0.0% 9.00%
Jan-2045 A349 337 - - - - - 0.0% 9.00%
Feb-2045 A350 338 - - - - - 0.0% 9.00%
Mar-2045 A351 339 - - - - - 0.0% 9.00%
Apr-2045 A352 340 - - - - - 0.0% 9.00%
May-2045 A353 341 - - - - - 0.0% 9.00%
Jun-2045 A354 342 - - - - - 0.0% 9.00%
Jul-2045 A355 343 - - - - - 0.0% 9.00%
Aug-2045 A356 344 - - - - - 0.0% 9.00%
Sep-2045 A357 345 - - - - - 0.0% 9.00%
Oct-2045 A358 346 - - - - - 0.0% 9.00%
Nov-2045 A359 347 - - - - - 0.0% 9.00%
Dec-2045 A360 348 - - - - - 0.0% 9.00%
Jan-2046 A361 349 - - - - - 0.0% 9.00%
Feb-2046 A362 350 - - - - - 0.0% 9.00%
Mar-2046 A363 351 - - - - - 0.0% 9.00%
Apr-2046 A364 352 - - - - - 0.0% 9.00%
May-2046 A365 353 - - - - - 0.0% 9.00%
Jun-2046 A366 354 - - - - - 0.0% 9.00%
Jul-2046 A367 355 - - - - - 0.0% 9.00%
Aug-2046 A368 356 - - - - - 0.0% 9.00%
Sep-2046 A369 357 - - - - - 0.0% 9.00%
Oct-2046 A370 358 - - - - - 0.0% 9.00%
Nov-2046 A371 359 - - - - - 0.0% 9.00%
Dec-2046 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
Annual Interest Rate 10.00% On this sheet:
Loan Period (in months) 60.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 10,811.17 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 1/1/2018 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value 150,000.00

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

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

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Feb-2024 A86 74 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2024 A87 75 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2024 A88 76 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2024 A89 77 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2024 A90 78 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2024 A91 79 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2024 A92 80 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2024 A93 81 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2024 A94 82 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2024 A95 83 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2024 A96 84 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2025 A97 85 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2025 A98 86 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2025 A99 87 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2025 A100 88 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2025 A101 89 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2025 A102 90 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2025 A103 91 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2025 A104 92 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2025 A105 93 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2025 A106 94 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2025 A107 95 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2025 A108 96 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2026 A109 97 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2026 A110 98 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2026 A111 99 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2026 A112 100 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2026 A113 101 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2026 A114 102 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2026 A115 103 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2026 A116 104 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2026 A117 105 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2026 A118 106 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2026 A119 107 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2026 A120 108 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2027 A121 109 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2027 A122 110 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2027 A123 111 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2027 A124 112 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2027 A125 113 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2027 A126 114 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2027 A127 115 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2027 A128 116 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2027 A129 117 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2027 A130 118 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2027 A131 119 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2027 A132 120 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2028 A133 121 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2028 A134 122 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2028 A135 123 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2028 A136 124 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2028 A137 125 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2028 A138 126 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2028 A139 127 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2028 A140 128 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2028 A141 129 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2028 A142 130 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2028 A143 131 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2028 A144 132 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2029 A145 133 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2029 A146 134 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2029 A147 135 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2029 A148 136 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2029 A149 137 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2029 A150 138 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2029 A151 139 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2029 A152 140 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2029 A153 141 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2029 A154 142 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2029 A155 143 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2029 A156 144 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2030 A157 145 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2030 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
Annual Interest Rate 10.00% On this sheet:
Loan Period (in months) 60.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 10,811.17 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 1/1/2018 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value 150,000.00

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Mar-2030 A159 147 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2030 A160 148 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2030 A161 149 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2030 A162 150 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2030 A163 151 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2030 A164 152 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2030 A165 153 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2030 A166 154 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2030 A167 155 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2030 A168 156 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2031 A169 157 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2031 A170 158 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2031 A171 159 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2031 A172 160 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2031 A173 161 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2031 A174 162 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2031 A175 163 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2031 A176 164 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2031 A177 165 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2031 A178 166 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2031 A179 167 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2031 A180 168 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2032 A181 169 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2032 A182 170 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2032 A183 171 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2032 A184 172 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2032 A185 173 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2032 A186 174 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2032 A187 175 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2032 A188 176 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2032 A189 177 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2032 A190 178 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2032 A191 179 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2032 A192 180 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2033 A193 181 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2033 A194 182 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2033 A195 183 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2033 A196 184 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2033 A197 185 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2033 A198 186 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2033 A199 187 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2033 A200 188 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2033 A201 189 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2033 A202 190 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2033 A203 191 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2033 A204 192 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2034 A205 193 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2034 A206 194 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2034 A207 195 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2034 A208 196 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2034 A209 197 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2034 A210 198 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2034 A211 199 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2034 A212 200 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2034 A213 201 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2034 A214 202 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2034 A215 203 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2034 A216 204 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2035 A217 205 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2035 A218 206 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2035 A219 207 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2035 A220 208 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2035 A221 209 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2035 A222 210 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2035 A223 211 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2035 A224 212 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2035 A225 213 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2035 A226 214 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2035 A227 215 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2035 A228 216 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2036 A229 217 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2036 A230 218 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2036 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
Annual Interest Rate 10.00% On this sheet:
Loan Period (in months) 60.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 10,811.17 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 1/1/2018 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value 150,000.00

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Apr-2036 A232 220 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2036 A233 221 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2036 A234 222 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2036 A235 223 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2036 A236 224 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2036 A237 225 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2036 A238 226 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2036 A239 227 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2036 A240 228 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2037 A241 229 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2037 A242 230 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2037 A243 231 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2037 A244 232 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2037 A245 233 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2037 A246 234 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2037 A247 235 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2037 A248 236 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2037 A249 237 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2037 A250 238 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2037 A251 239 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2037 A252 240 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2038 A253 241 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2038 A254 242 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2038 A255 243 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2038 A256 244 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2038 A257 245 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2038 A258 246 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2038 A259 247 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2038 A260 248 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2038 A261 249 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2038 A262 250 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2038 A263 251 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2038 A264 252 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2039 A265 253 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2039 A266 254 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2039 A267 255 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2039 A268 256 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2039 A269 257 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2039 A270 258 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2039 A271 259 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2039 A272 260 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2039 A273 261 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2039 A274 262 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2039 A275 263 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2039 A276 264 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2040 A277 265 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2040 A278 266 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2040 A279 267 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2040 A280 268 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2040 A281 269 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2040 A282 270 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2040 A283 271 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2040 A284 272 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2040 A285 273 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2040 A286 274 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2040 A287 275 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2040 A288 276 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2041 A289 277 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2041 A290 278 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2041 A291 279 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2041 A292 280 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2041 A293 281 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2041 A294 282 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2041 A295 283 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2041 A296 284 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2041 A297 285 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2041 A298 286 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2041 A299 287 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2041 A300 288 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2042 A301 289 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2042 A302 290 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2042 A303 291 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2042 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
Annual Interest Rate 10.00% On this sheet:
Loan Period (in months) 60.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 10,811.17 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 1/1/2018 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value 150,000.00

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
May-2042 A305 293 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2042 A306 294 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2042 A307 295 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2042 A308 296 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2042 A309 297 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2042 A310 298 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2042 A311 299 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2042 A312 300 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2043 A313 301 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2043 A314 302 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2043 A315 303 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2043 A316 304 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2043 A317 305 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2043 A318 306 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2043 A319 307 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2043 A320 308 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2043 A321 309 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2043 A322 310 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2043 A323 311 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2043 A324 312 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2044 A325 313 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2044 A326 314 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2044 A327 315 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2044 A328 316 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2044 A329 317 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2044 A330 318 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2044 A331 319 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2044 A332 320 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2044 A333 321 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2044 A334 322 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2044 A335 323 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2044 A336 324 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2045 A337 325 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2045 A338 326 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2045 A339 327 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2045 A340 328 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2045 A341 329 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2045 A342 330 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2045 A343 331 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2045 A344 332 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2045 A345 333 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2045 A346 334 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2045 A347 335 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2045 A348 336 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2046 A349 337 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2046 A350 338 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2046 A351 339 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2046 A352 340 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2046 A353 341 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2046 A354 342 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2046 A355 343 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2046 A356 344 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2046 A357 345 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2046 A358 346 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2046 A359 347 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2046 A360 348 150,000.00 - - - 150,000.00 25.0% 10.00%
Jan-2047 A361 349 150,000.00 - - - 150,000.00 25.0% 10.00%
Feb-2047 A362 350 150,000.00 - - - 150,000.00 25.0% 10.00%
Mar-2047 A363 351 150,000.00 - - - 150,000.00 25.0% 10.00%
Apr-2047 A364 352 150,000.00 - - - 150,000.00 25.0% 10.00%
May-2047 A365 353 150,000.00 - - - 150,000.00 25.0% 10.00%
Jun-2047 A366 354 150,000.00 - - - 150,000.00 25.0% 10.00%
Jul-2047 A367 355 150,000.00 - - - 150,000.00 25.0% 10.00%
Aug-2047 A368 356 150,000.00 - - - 150,000.00 25.0% 10.00%
Sep-2047 A369 357 150,000.00 - - - 150,000.00 25.0% 10.00%
Oct-2047 A370 358 150,000.00 - - - 150,000.00 25.0% 10.00%
Nov-2047 A371 359 150,000.00 - - - 150,000.00 25.0% 10.00%
Dec-2047 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
Annual Interest Rate 9.50% On this sheet:
Loan Period (in months) 120.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 12,939.76 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 7/1/2019 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value -

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

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

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

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

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Sep-2031 A159 147 - - - - - 0.0% 9.50%
Oct-2031 A160 148 - - - - - 0.0% 9.50%
Nov-2031 A161 149 - - - - - 0.0% 9.50%
Dec-2031 A162 150 - - - - - 0.0% 9.50%
Jan-2032 A163 151 - - - - - 0.0% 9.50%
Feb-2032 A164 152 - - - - - 0.0% 9.50%
Mar-2032 A165 153 - - - - - 0.0% 9.50%
Apr-2032 A166 154 - - - - - 0.0% 9.50%
May-2032 A167 155 - - - - - 0.0% 9.50%
Jun-2032 A168 156 - - - - - 0.0% 9.50%
Jul-2032 A169 157 - - - - - 0.0% 9.50%
Aug-2032 A170 158 - - - - - 0.0% 9.50%
Sep-2032 A171 159 - - - - - 0.0% 9.50%
Oct-2032 A172 160 - - - - - 0.0% 9.50%
Nov-2032 A173 161 - - - - - 0.0% 9.50%
Dec-2032 A174 162 - - - - - 0.0% 9.50%
Jan-2033 A175 163 - - - - - 0.0% 9.50%
Feb-2033 A176 164 - - - - - 0.0% 9.50%
Mar-2033 A177 165 - - - - - 0.0% 9.50%
Apr-2033 A178 166 - - - - - 0.0% 9.50%
May-2033 A179 167 - - - - - 0.0% 9.50%
Jun-2033 A180 168 - - - - - 0.0% 9.50%
Jul-2033 A181 169 - - - - - 0.0% 9.50%
Aug-2033 A182 170 - - - - - 0.0% 9.50%
Sep-2033 A183 171 - - - - - 0.0% 9.50%
Oct-2033 A184 172 - - - - - 0.0% 9.50%
Nov-2033 A185 173 - - - - - 0.0% 9.50%
Dec-2033 A186 174 - - - - - 0.0% 9.50%
Jan-2034 A187 175 - - - - - 0.0% 9.50%
Feb-2034 A188 176 - - - - - 0.0% 9.50%
Mar-2034 A189 177 - - - - - 0.0% 9.50%
Apr-2034 A190 178 - - - - - 0.0% 9.50%
May-2034 A191 179 - - - - - 0.0% 9.50%
Jun-2034 A192 180 - - - - - 0.0% 9.50%
Jul-2034 A193 181 - - - - - 0.0% 9.50%
Aug-2034 A194 182 - - - - - 0.0% 9.50%
Sep-2034 A195 183 - - - - - 0.0% 9.50%
Oct-2034 A196 184 - - - - - 0.0% 9.50%
Nov-2034 A197 185 - - - - - 0.0% 9.50%
Dec-2034 A198 186 - - - - - 0.0% 9.50%
Jan-2035 A199 187 - - - - - 0.0% 9.50%
Feb-2035 A200 188 - - - - - 0.0% 9.50%
Mar-2035 A201 189 - - - - - 0.0% 9.50%
Apr-2035 A202 190 - - - - - 0.0% 9.50%
May-2035 A203 191 - - - - - 0.0% 9.50%
Jun-2035 A204 192 - - - - - 0.0% 9.50%
Jul-2035 A205 193 - - - - - 0.0% 9.50%
Aug-2035 A206 194 - - - - - 0.0% 9.50%
Sep-2035 A207 195 - - - - - 0.0% 9.50%
Oct-2035 A208 196 - - - - - 0.0% 9.50%
Nov-2035 A209 197 - - - - - 0.0% 9.50%
Dec-2035 A210 198 - - - - - 0.0% 9.50%
Jan-2036 A211 199 - - - - - 0.0% 9.50%
Feb-2036 A212 200 - - - - - 0.0% 9.50%
Mar-2036 A213 201 - - - - - 0.0% 9.50%
Apr-2036 A214 202 - - - - - 0.0% 9.50%
May-2036 A215 203 - - - - - 0.0% 9.50%
Jun-2036 A216 204 - - - - - 0.0% 9.50%
Jul-2036 A217 205 - - - - - 0.0% 9.50%
Aug-2036 A218 206 - - - - - 0.0% 9.50%
Sep-2036 A219 207 - - - - - 0.0% 9.50%
Oct-2036 A220 208 - - - - - 0.0% 9.50%
Nov-2036 A221 209 - - - - - 0.0% 9.50%
Dec-2036 A222 210 - - - - - 0.0% 9.50%
Jan-2037 A223 211 - - - - - 0.0% 9.50%
Feb-2037 A224 212 - - - - - 0.0% 9.50%
Mar-2037 A225 213 - - - - - 0.0% 9.50%
Apr-2037 A226 214 - - - - - 0.0% 9.50%
May-2037 A227 215 - - - - - 0.0% 9.50%
Jun-2037 A228 216 - - - - - 0.0% 9.50%
Jul-2037 A229 217 - - - - - 0.0% 9.50%
Aug-2037 A230 218 - - - - - 0.0% 9.50%
Sep-2037 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
Annual Interest Rate 9.50% On this sheet:
Loan Period (in months) 120.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 12,939.76 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 7/1/2019 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value -

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

Month Ref Number Balance Repayment Charged Repaid Balance Outstanding Rate
Oct-2037 A232 220 - - - - - 0.0% 9.50%
Nov-2037 A233 221 - - - - - 0.0% 9.50%
Dec-2037 A234 222 - - - - - 0.0% 9.50%
Jan-2038 A235 223 - - - - - 0.0% 9.50%
Feb-2038 A236 224 - - - - - 0.0% 9.50%
Mar-2038 A237 225 - - - - - 0.0% 9.50%
Apr-2038 A238 226 - - - - - 0.0% 9.50%
May-2038 A239 227 - - - - - 0.0% 9.50%
Jun-2038 A240 228 - - - - - 0.0% 9.50%
Jul-2038 A241 229 - - - - - 0.0% 9.50%
Aug-2038 A242 230 - - - - - 0.0% 9.50%
Sep-2038 A243 231 - - - - - 0.0% 9.50%
Oct-2038 A244 232 - - - - - 0.0% 9.50%
Nov-2038 A245 233 - - - - - 0.0% 9.50%
Dec-2038 A246 234 - - - - - 0.0% 9.50%
Jan-2039 A247 235 - - - - - 0.0% 9.50%
Feb-2039 A248 236 - - - - - 0.0% 9.50%
Mar-2039 A249 237 - - - - - 0.0% 9.50%
Apr-2039 A250 238 - - - - - 0.0% 9.50%
May-2039 A251 239 - - - - - 0.0% 9.50%
Jun-2039 A252 240 - - - - - 0.0% 9.50%
Jul-2039 A253 241 - - - - - 0.0% 9.50%
Aug-2039 A254 242 - - - - - 0.0% 9.50%
Sep-2039 A255 243 - - - - - 0.0% 9.50%
Oct-2039 A256 244 - - - - - 0.0% 9.50%
Nov-2039 A257 245 - - - - - 0.0% 9.50%
Dec-2039 A258 246 - - - - - 0.0% 9.50%
Jan-2040 A259 247 - - - - - 0.0% 9.50%
Feb-2040 A260 248 - - - - - 0.0% 9.50%
Mar-2040 A261 249 - - - - - 0.0% 9.50%
Apr-2040 A262 250 - - - - - 0.0% 9.50%
May-2040 A263 251 - - - - - 0.0% 9.50%
Jun-2040 A264 252 - - - - - 0.0% 9.50%
Jul-2040 A265 253 - - - - - 0.0% 9.50%
Aug-2040 A266 254 - - - - - 0.0% 9.50%
Sep-2040 A267 255 - - - - - 0.0% 9.50%
Oct-2040 A268 256 - - - - - 0.0% 9.50%
Nov-2040 A269 257 - - - - - 0.0% 9.50%
Dec-2040 A270 258 - - - - - 0.0% 9.50%
Jan-2041 A271 259 - - - - - 0.0% 9.50%
Feb-2041 A272 260 - - - - - 0.0% 9.50%
Mar-2041 A273 261 - - - - - 0.0% 9.50%
Apr-2041 A274 262 - - - - - 0.0% 9.50%
May-2041 A275 263 - - - - - 0.0% 9.50%
Jun-2041 A276 264 - - - - - 0.0% 9.50%
Jul-2041 A277 265 - - - - - 0.0% 9.50%
Aug-2041 A278 266 - - - - - 0.0% 9.50%
Sep-2041 A279 267 - - - - - 0.0% 9.50%
Oct-2041 A280 268 - - - - - 0.0% 9.50%
Nov-2041 A281 269 - - - - - 0.0% 9.50%
Dec-2041 A282 270 - - - - - 0.0% 9.50%
Jan-2042 A283 271 - - - - - 0.0% 9.50%
Feb-2042 A284 272 - - - - - 0.0% 9.50%
Mar-2042 A285 273 - - - - - 0.0% 9.50%
Apr-2042 A286 274 - - - - - 0.0% 9.50%
May-2042 A287 275 - - - - - 0.0% 9.50%
Jun-2042 A288 276 - - - - - 0.0% 9.50%
Jul-2042 A289 277 - - - - - 0.0% 9.50%
Aug-2042 A290 278 - - - - - 0.0% 9.50%
Sep-2042 A291 279 - - - - - 0.0% 9.50%
Oct-2042 A292 280 - - - - - 0.0% 9.50%
Nov-2042 A293 281 - - - - - 0.0% 9.50%
Dec-2042 A294 282 - - - - - 0.0% 9.50%
Jan-2043 A295 283 - - - - - 0.0% 9.50%
Feb-2043 A296 284 - - - - - 0.0% 9.50%
Mar-2043 A297 285 - - - - - 0.0% 9.50%
Apr-2043 A298 286 - - - - - 0.0% 9.50%
May-2043 A299 287 - - - - - 0.0% 9.50%
Jun-2043 A300 288 - - - - - 0.0% 9.50%
Jul-2043 A301 289 - - - - - 0.0% 9.50%
Aug-2043 A302 290 - - - - - 0.0% 9.50%
Sep-2043 A303 291 - - - - - 0.0% 9.50%
Oct-2043 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
Annual Interest Rate 9.50% On this sheet:
Loan Period (in months) 120.00 Enter the appropriate loan terms in the cells with yellow cell backgrounds at the top of the sheet. The
Original Repayment Amount 12,939.76 template accommodates variable monthly interest rates which can be entered in column K. All the other
Loan Start Date 7/1/2019 cells on this sheet contain formulas which are automatically updated based on the values entered. The
Repayment Type End calculations on this sheet are included in column B on the Summary sheet.
Residual Value -

Cell Repayment Opening Loan Interest Capital Closing % Capital Interest

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

Page 19 of 19