amortization (1).xlsx - Loan Amortization Schedule Loan...

This preview shows page 1 - 7 out of 42 pages.

Loan Amortization Schedule Enter values Loan amount $ 2,000,000.00 Annual interest rate 10.50 % No. of annual installments 12.00 Loan period in years 20 Number of payments per year 12 Start date of loan 10/1/2012 Optional extra payments $ 20,000.00 Lender name: Beginning Balance Scheduled Payment 1 11/1/2012 $ 2,000,000.00 $ 19,967.60 2 12/1/2012 1,997,532.40 19,967.60 3 1/1/2013 1,995,043.21 19,967.60 4 2/1/2013 1,992,532.24 19,967.60 5 3/1/2013 1,989,999.30 19,967.60 6 4/1/2013 1,987,444.20 19,967.60 20,000.00 7 5/1/2013 1,964,866.74 19,967.60 20,000.00 8 6/1/2013 1,942,091.72 19,967.60 9 7/1/2013 1,939,117.43 19,967.60 10 8/1/2013 1,936,117.11 19,967.60 11 9/1/2013 1,933,090.54 19,967.60 12 10/1/2013 1,930,037.48 19,967.60 13 11/1/2013 1,926,957.71 19,967.60 14 12/1/2013 1,923,850.99 19,967.60 PmtNo . Payment Date Extra Payment
Image of page 1

Subscribe to view the full document.

Beginning Balance Scheduled Payment PmtNo . Payment Date Extra Payment 15 1/1/2014 1,920,717.09 19,967.60 16 2/1/2014 1,917,555.77 19,967.60 17 3/1/2014 1,914,366.78 19,967.60 18 4/1/2014 1,911,149.89 19,967.60 19 5/1/2014 1,907,904.86 19,967.60 20 6/1/2014 1,904,631.43 19,967.60 21 7/1/2014 1,901,329.36 19,967.60 22 8/1/2014 1,897,998.39 19,967.60 23 9/1/2014 1,894,638.28 19,967.60 24 10/1/2014 1,891,248.77 19,967.60 25 11/1/2014 1,887,829.59 19,967.60 26 12/1/2014 1,884,380.51 19,967.60 27 1/1/2015 1,880,901.24 19,967.60 28 2/1/2015 1,877,391.53 19,967.60 29 3/1/2015 1,873,851.10 19,967.60 30 4/1/2015 1,870,279.70 19,967.60 31 5/1/2015 1,866,677.05 19,967.60 32 6/1/2015 1,863,042.88 19,967.60 33 7/1/2015 1,859,376.91 19,967.60 34 8/1/2015 1,855,678.86 19,967.60 35 9/1/2015 1,851,948.45 19,967.60 36 10/1/2015 1,848,185.40 19,967.60 37 11/1/2015 1,844,389.42 19,967.60 38 12/1/2015 1,840,560.23 19,967.60 39 1/1/2016 1,836,697.54 19,967.60 40 2/1/2016 1,832,801.04 19,967.60 41 3/1/2016 1,828,870.46 19,967.60
Image of page 2
Beginning Balance Scheduled Payment PmtNo . Payment Date Extra Payment 42 4/1/2016 1,824,905.47 19,967.60 43 5/1/2016 1,820,905.80 19,967.60 44 6/1/2016 1,816,871.13 19,967.60 45 7/1/2016 1,812,801.15 19,967.60 46 8/1/2016 1,808,695.56 19,967.60 47 9/1/2016 1,804,554.05 19,967.60 48 10/1/2016 1,800,376.30 19,967.60 49 11/1/2016 1,796,162.00 19,967.60 50 12/1/2016 1,791,910.82 19,967.60 51 1/1/2017 1,787,622.44 19,967.60 52 2/1/2017 1,783,296.54 19,967.60 53 3/1/2017 1,778,932.79 19,967.60 54 4/1/2017 1,774,530.85 19,967.60 55 5/1/2017 1,770,090.40 19,967.60 56 6/1/2017 1,765,611.09 19,967.60 57 7/1/2017 1,761,092.59 19,967.60 58 8/1/2017 1,756,534.55 19,967.60 59 9/1/2017 1,751,936.63 19,967.60 60 10/1/2017 1,747,298.48 19,967.60 61 11/1/2017 1,742,619.74 19,967.60 62 12/1/2017 1,737,900.07 19,967.60 63 1/1/2018 1,733,139.10 19,967.60 64 2/1/2018 1,728,336.46 19,967.60 65 3/1/2018 1,723,491.81 19,967.60 66 4/1/2018 1,718,604.77 19,967.60 67 5/1/2018 1,713,674.96 19,967.60 68 6/1/2018 1,708,702.02 19,967.60
Image of page 3

Subscribe to view the full document.

Beginning Balance Scheduled Payment PmtNo . Payment Date Extra Payment 69 7/1/2018 1,703,685.56 19,967.60 70 8/1/2018 1,698,625.21 19,967.60 71 9/1/2018 1,693,520.59 19,967.60 72 10/1/2018 1,688,371.30 19,967.60 73 11/1/2018 1,683,176.95 19,967.60 74 12/1/2018 1,677,937.15 19,967.60 75 1/1/2019 1,672,651.50 19,967.60 76 2/1/2019 1,667,319.60 19,967.60 77 3/1/2019 1,661,941.05 19,967.60 78 4/1/2019 1,656,515.44 19,967.60 79 5/1/2019 1,651,042.35 19,967.60 80 6/1/2019 1,645,521.37 19,967.60 81 7/1/2019 1,639,952.09 19,967.60 82 8/1/2019 1,634,334.07 19,967.60 83 9/1/2019 1,628,666.89 19,967.60 84 10/1/2019 1,622,950.13 19,967.60 85 11/1/2019 1,617,183.35 19,967.60 86 12/1/2019 1,611,366.11 19,967.60 87 1/1/2020 1,605,497.96 19,967.60 88 2/1/2020 1,599,578.47 19,967.60 89 3/1/2020 1,593,607.18 19,967.60 90 4/1/2020 1,587,583.65 19,967.60 91 5/1/2020 1,581,507.41 19,967.60 92 6/1/2020 1,575,378.00 19,967.60 93 7/1/2020 1,569,194.96 19,967.60 94 8/1/2020 1,562,957.82 19,967.60 95 9/1/2020 1,556,666.10 19,967.60
Image of page 4
Beginning Balance Scheduled Payment PmtNo . Payment Date Extra Payment 96 10/1/2020 1,550,319.33 19,967.60 97 11/1/2020 1,543,917.03 19,967.60 98 12/1/2020 1,537,458.70 19,967.60 99 1/1/2021 1,530,943.87 19,967.60 100 2/1/2021 1,524,372.03 19,967.60 101 3/1/2021 1,517,742.69 19,967.60 102 4/1/2021 1,511,055.34 19,967.60 103 5/1/2021 1,504,309.48 19,967.60 104 6/1/2021 1,497,504.59 19,967.60 105 7/1/2021 1,490,640.15 19,967.60 106 8/1/2021 1,483,715.66 19,967.60 107 9/1/2021 1,476,730.57 19,967.60 108 10/1/2021 1,469,684.37 19,967.60 109 11/1/2021 1,462,576.51 19,967.60 110 12/1/2021 1,455,406.45 19,967.60 111 1/1/2022 1,448,173.66 19,967.60 112 2/1/2022 1,440,877.58 19,967.60 113 3/1/2022 1,433,517.67 19,967.60 114 4/1/2022 1,426,093.35 19,967.60 115 5/1/2022 1,418,604.07 19,967.60 116 6/1/2022 1,411,049.25 19,967.60 117 7/1/2022 1,403,428.34 19,967.60 118 8/1/2022 1,395,740.74 19,967.60 119 9/1/2022 1,387,985.87 19,967.60 120 10/1/2022 1,380,163.15 19,967.60 121 11/1/2022 1,372,271.98 19,967.60 122 12/1/2022 1,364,311.76 19,967.60
Image of page 5

Subscribe to view the full document.

Beginning Balance Scheduled Payment PmtNo . Payment Date Extra Payment 123 1/1/2023 1,356,281.89 19,967.60 124 2/1/2023 1,348,181.76 19,967.60 125 3/1/2023 1,340,010.75 19,967.60 126 4/1/2023 1,331,768.25 19,967.60 127 5/1/2023 1,323,453.62 19,967.60 128 6/1/2023 1,315,066.25 19,967.60 129 7/1/2023 1,306,605.48 19,967.60 130 8/1/2023 1,298,070.68 19,967.60 131 9/1/2023 1,289,461.20 19,967.60 132 10/1/2023 1,280,776.39 19,967.60 133 11/1/2023 1,272,015.58 19,967.60 20,000.00 134 12/1/2023 1,243,178.12 19,967.60 20,000.00 135 1/1/2024 1,214,088.33 19,967.60 20,000.00 136 2/1/2024 1,184,744.01 19,967.60 20,000.00 137 3/1/2024 1,155,142.92 19,967.60 20,000.00 138 4/1/2024 1,125,282.82 19,967.60 20,000.00 139 5/1/2024 1,095,161.45 19,967.60 20,000.00 140 6/1/2024 1,064,776.51 19,967.60 20,000.00 141 7/1/2024 1,034,125.71 19,967.60 20,000.00 142 8/1/2024 1,003,206.71 19,967.60 20,000.00 143 9/1/2024 972,017.17 19,967.60 20,000.00 144 10/1/2024 940,554.73 19,967.60 20,000.00 145 11/1/2024 908,816.98 19,967.60 20,000.00 146 12/1/2024 876,801.53 19,967.60 20,000.00 147 1/1/2025 844,505.95 19,967.60 20,000.00 148 2/1/2025 811,927.78 19,967.60 20,000.00 149 3/1/2025 779,064.55 19,967.60 20,000.00
Image of page 6
Beginning Balance Scheduled Payment PmtNo .
Image of page 7
You've reached the end of this preview.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern