About Financial Essentials

Explore

Gallery

About Financial Essentials

Sample Uses

Loan Amortization Schedule

Generate and analyze a loan amortization schedule from basic loan terms

Loan Terms

All calculations on this page are based on the loan terms entered below

Loan Amount

Annual Interest Rate

Term in Months

Payment

$200,000.00

5.00%

$3,774.25

There are no rows in this table

⁠

Info on Selected Loan Period

Info on Selected Loan Period

Selected Period

Payment

Interest

Principal

Ending Balance

$3,774.25

$15.66

$3,758.59

$0.00

There are no rows in this table

⁠

Loan Analysis

Loan Analysis

Start Period

End Period

Cum Interest Over Range

Cum Principal Over Range

$7,332.40

$37,958.56

There are no rows in this table

⁠

The total interest to be paid on the loan is

$26,454.80

⁠

Amortization Table

If the “Term in Months” of the above loan changes, the amortization table below will turn gray and may not be valid until the “Update Number of Terms in Amortization Table” button is pressed to generate a new table with the correct number of terms.

⁠

Update Number of Terms in Amortization Table

⁠

Period

Beginning Balance

Payment

Interest

Principal

Ending Balance

$200,000.00

$3,774.25

$833.33

$2,940.91

$197,059.09

$3,774.25

$821.08

$2,953.17

$194,105.92

$3,774.25

$808.77

$2,965.47

$191,140.45

$3,774.25

$796.42

$2,977.83

$188,162.62

$3,774.25

$784.01

$2,990.24

$185,172.38

$3,774.25

$771.55

$3,002.70

$182,169.69

$3,774.25

$759.04

$3,015.21

$179,154.48

$3,774.25

$746.48

$3,027.77

$176,126.71

$3,774.25

$733.86

$3,040.39

$173,086.33

$3,774.25

$721.19

$3,053.05

$170,033.27

$3,774.25

$708.47

$3,065.77

$166,967.50

$3,774.25

$695.70

$3,078.55

$163,888.95

$3,774.25

$682.87

$3,091.38

$160,797.57

$3,774.25

$669.99

$3,104.26

$157,693.32

$3,774.25

$657.06

$3,117.19

$154,576.13

$3,774.25

$644.07

$3,130.18

$151,445.95

$3,774.25

$631.02

$3,143.22

$148,302.72

$3,774.25

$617.93

$3,156.32

$145,146.41

$3,774.25

$604.78

$3,169.47

$141,976.93

$3,774.25

$591.57

$3,182.68

$138,794.26

$3,774.25

$578.31

$3,195.94

$135,598.32

$3,774.25

$564.99

$3,209.25

$132,389.07

$3,774.25

$551.62

$3,222.63

$129,166.44

$3,774.25

$538.19

$3,236.05

$125,930.39

$3,774.25

$524.71

$3,249.54

$122,680.85

$3,774.25

$511.17

$3,263.08

$119,417.78

$3,774.25

$497.57

$3,276.67

$116,141.10

$3,774.25

$483.92

$3,290.33

$112,850.78

$3,774.25

$470.21

$3,304.04

$109,546.74

$3,774.25

$456.44

$3,317.80

$106,228.94

$3,774.25

$442.62

$3,331.63

$102,897.31

$3,774.25

$428.74

$3,345.51

$99,551.81

$3,774.25

$414.80

$3,359.45

$96,192.36

$3,774.25

$400.80

$3,373.45

$92,818.91

$3,774.25

$386.75

$3,387.50

$89,431.41

$3,774.25

$372.63

$3,401.62

$86,029.80

$3,774.25

$358.46

$3,415.79

$82,614.01

$3,774.25

$344.23

$3,430.02

$79,183.99

$3,774.25

$329.93

$3,444.31

$75,739.67

$3,774.25

$315.58

$3,458.66

$72,281.01

$3,774.25

$301.17

$3,473.08

$68,807.93

$3,774.25

$286.70

$3,487.55

$65,320.38

$3,774.25

$272.17

$3,502.08

$61,818.31

$3,774.25

$257.58

$3,516.67

$58,301.64

$3,774.25

$242.92

$3,531.32

$54,770.31

$3,774.25

$228.21

$3,546.04

$51,224.28

$3,774.25

$213.43

$3,560.81

$47,663.46

$3,774.25

$198.60

$3,575.65

$44,087.81

$3,774.25

$183.70

$3,590.55

$40,497.27

$3,774.25

$168.74

$3,605.51

$36,891.76

$3,774.25

$153.72

$3,620.53

$33,271.23

$3,774.25

$138.63

$3,635.62

$29,635.61

$3,774.25

$123.48

$3,650.77

$25,984.85

$3,774.25

$108.27

$3,665.98

$22,318.87

$3,774.25

$93.00

$3,681.25

$18,637.62

$3,774.25

$77.66

$3,696.59

$14,941.03

$3,774.25

$62.25

$3,711.99

$11,229.04

$3,774.25

$46.79

$3,727.46

$7,501.58

$3,774.25

$31.26

$3,742.99

$3,758.59

$3,774.25

$15.66

$3,758.59

$0.00

There are no rows in this table

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.