Standard Loan Calculator
Developed by Excely.com (c) 2007
Loan Calculator
Printer friendly Spreadsheet for creating a loan amortization schedule
Loan Data
Loan Amount
$ 75,000.00
Annual Interest Rate
6.50%
Loan Period in Years
20
Number of Payments Per Year
12
Start Date
12-Sep-2007
Summary
Payment (per period)
$ 559.18
Number of Payments 240
Actual Number of Payments 240
Total Interest Paid $ 59,203.27
Total Interest
78.94%
Total Extra Payments
$ -
Total Payment
$ 134,203.27
Payment Principal Interest
12-Sep-2007
1 12-Oct-2007 $ 559.18 $ 152.93 $ 406.25
2 12-Nov-2007 $ 559.18 $ 153.76 $ 405.42
3 12-Dec-2007 $ 559.18 $ 154.59 $ 404.59
4 12-Jan-2008 $ 559.18 $ 155.43 $ 403.75
5 12-Feb-2008 $ 559.18 $ 156.27 $ 402.91
6 12-Mar-2008 $ 559.18 $ 157.12 $ 402.06
7 12-Apr-2008 $ 559.18 $ 157.97 $ 401.21
8 12-May-2008 $ 559.18 $ 158.82 $ 400.36
9 12-Jun-2008 $ 559.18 $ 159.68 $ 399.50
10 12-Jul-2008 $ 559.18 $ 160.55 $ 398.63
11 12-Aug-2008 $ 559.18 $ 161.42 $ 397.76
12 12-Sep-2008 $ 559.18 $ 162.29 $ 396.89
13 12-Oct-2008 $ 559.18 $ 163.17 $ 396.01
14 12-Nov-2008 $ 559.18 $ 164.06 $ 395.12
15 12-Dec-2008 $ 559.18 $ 164.94 $ 394.24
16 12-Jan-2009 $ 559.18 $ 165.84 $ 393.34
17 12-Feb-2009 $ 559.18 $ 166.74 $ 392.44
18 12-Mar-2009 $ 559.18 $ 167.64 $ 391.54
19 12-Apr-2009 $ 559.18 $ 168.55 $ 390.63
20 12-May-2009 $ 559.18 $ 169.46 $ 389.72
21 12-Jun-2009 $ 559.18 $ 170.38 $ 388.80
22 12-Jul-2009 $ 559.18 $ 171.30 $ 387.88
23 12-Aug-2009 $ 559.18 $ 172.23 $ 386.95
24 12-Sep-2009 $ 559.18 $ 173.16 $ 386.02
25 12-Oct-2009 $ 559.18 $ 174.10 $ 385.08
26 12-Nov-2009 $ 559.18 $ 175.04 $ 384.14
27 12-Dec-2009 $ 559.18 $ 175.99 $ 383.19
28 12-Jan-2010 $ 559.18 $ 176.94 $ 382.24
29 12-Feb-2010 $ 559.18 $ 177.90 $ 381.28
30 12-Mar-2010 $ 559.18 $ 178.87 $ 380.31
31 12-Apr-2010 $ 559.18 $ 179.84 $ 379.34
32 12-May-2010 $ 559.18 $ 180.81 $ 378.37
33 12-Jun-2010 $ 559.18 $ 181.79 $ 377.39
34 12-Jul-2010 $ 559.18 $ 182.77 $ 376.41
35 12-Aug-2010 $ 559.18 $ 183.76 $ 375.42
36 12-Sep-2010 $ 559.18 $ 184.76 $ 374.42
37 12-Oct-2010 $ 559.18 $ 185.76 $ 373.42
38 12-Nov-2010 $ 559.18 $ 186.77 $ 372.41
39 12-Dec-2010 $ 559.18 $ 187.78 $ 371.40
Excel Template by Excely.com
Payment
No.
Payment
Date
Extra Payments
12-Oct-2007
12-Nov-2007
12-Dec-2007
12-Jan-2008
12-Feb-2008
12-Mar-2008
12-Apr-2008
12-May-2008
12-Jun-2008
12-Jul-2008
12-Aug-2008
12-Sep-2008
12-Oct-2008
12-Nov-2008
12-Dec-2008
12-Jan-2009
12-Feb-2009
12-Mar-2009
12-Apr-2009
12-May-2009
12-Jun-2009
12-Jul-2009
12-Aug-2009
12-Sep-2009
12-Oct-2009
12-Nov-2009
12-Dec-2009
12-Jan-2010
12-Feb-2010
12-Mar-2010
12-Apr-2010
12-May-2010
12-Jun-2010
12-Jul-2010
12-Aug-2010
12-Sep-2010
12-Oct-2010
12-Nov-2010
12-Dec-2010
12-Jan-2011
12-Feb-2011
12-Mar-2011
12-Apr-2011
12-May-2011
12-Jun-2011
12-Jul-2011
12-Aug-2011
12-Sep-2011
12-Oct-2011
12-Nov-2011
12-Dec-2011
12-Jan-2012
12-Feb-2012
12-Mar-2012
12-Apr-2012
12-May-2012
12-Jun-2012
12-Jul-2012
12-Aug-2012
12-Sep-2012
12-Oct-2012
12-Nov-2012
12-Dec-2012
12-Jan-2013
12-Feb-2013
12-Mar-2013
12-Apr-2013
12-May-2013
12-Jun-2013
12-Jul-2013
12-Aug-2013
12-Sep-2013
12-Oct-2013
12-Nov-2013
12-Dec-2013
12-Jan-2014
12-Feb-2014
12-Mar-2014
12-Apr-2014
12-May-2014
12-Jun-2014
12-Jul-2014
12-Aug-2014
12-Sep-2014
12-Oct-2014
12-Nov-2014
12-Dec-2014
12-Jan-2015
12-Feb-2015
12-Mar-2015
12-Apr-2015
12-May-2015
12-Jun-2015
12-Jul-2015
12-Aug-2015
12-Sep-2015
12-Oct-2015
12-Nov-2015
12-Dec-2015
12-Jan-2016
12-Feb-2016
12-Mar-2016
12-Apr-2016
12-May-2016
12-Jun-2016
12-Jul-2016
12-Aug-2016
12-Sep-2016
12-Oct-2016
12-Nov-2016
12-Dec-2016
12-Jan-2017
12-Feb-2017
12-Mar-2017
12-Apr-2017
12-May-2017
12-Jun-2017
12-Jul-2017
12-Aug-2017
12-Sep-2017
12-Oct-2017
12-Nov-2017
12-Dec-2017
12-Jan-2018
12-Feb-2018
12-Mar-2018
12-Apr-2018
12-May-2018
12-Jun-2018
12-Jul-2018
12-Aug-2018
12-Sep-2018
12-Oct-2018
12-Nov-2018
12-Dec-2018
12-Jan-2019
12-Feb-2019
12-Mar-2019
12-Apr-2019
12-May-2019
12-Jun-2019
12-Jul-2019
12-Aug-2019
12-Sep-2019
12-Oct-2019
12-Nov-2019
12-Dec-2019
12-Jan-2020
12-Feb-2020
12-Mar-2020
12-Apr-2020
12-May-2020
12-Jun-2020
12-Jul-2020
12-Aug-2020
12-Sep-2020
12-Oct-2020
12-Nov-2020
12-Dec-2020
12-Jan-2021
12-Feb-2021
12-Mar-2021
12-Apr-2021
12-May-2021
12-Jun-2021
12-Jul-2021
12-Aug-2021
12-Sep-2021
12-Oct-2021
12-Nov-2021
12-Dec-2021
12-Jan-2022
12-Feb-2022
12-Mar-2022
12-Apr-2022
12-May-2022
12-Jun-2022
12-Jul-2022
12-Aug-2022
12-Sep-2022
12-Oct-2022
12-Nov-2022
12-Dec-2022
12-Jan-2023
12-Feb-2023
12-Mar-2023
12-Apr-2023
12-May-2023
12-Jun-2023
12-Jul-2023
12-Aug-2023
12-Sep-2023
12-Oct-2023
12-Nov-2023
12-Dec-2023
12-Jan-2024
12-Feb-2024
12-Mar-2024
12-Apr-2024
12-May-2024
12-Jun-2024
12-Jul-2024
12-Aug-2024
12-Sep-2024
12-Oct-2024
12-Nov-2024
12-Dec-2024
12-Jan-2025
12-Feb-2025
12-Mar-2025
12-Apr-2025
12-May-2025
12-Jun-2025
12-Jul-2025
12-Aug-2025
12-Sep-2025
12-Oct-2025
12-Nov-2025
12-Dec-2025
12-Jan-2026
12-Feb-2026
12-Mar-2026
12-Apr-2026
12-May-2026
12-Jun-2026
12-Jul-2026
12-Aug-2026
12-Sep-2026
12-Oct-2026
12-Nov-2026
12-Dec-2026
12-Jan-2027
12-Feb-2027
12-Mar-2027
12-Apr-2027
12-May-2027
12-Jun-2027
12-Jul-2027
12-Aug-2027
12-Sep-2027
$-
$100.00
$200.00
$300.00
$400.00
$500.00
$600.00
Principal
Page 1/24
Free Download
Standard Loan Calculator XLS
Favor this template? Just fancy it by voting!
(0 Votes)
0.0
Related Forms
