Mortgage Loan Amortization Schedule

A spreadsheet for calculating how much interest and principal you are paying back each month for your mortgage or loan. This gives you a breakdown of what where your money is going exactly. You can also see how much interest you will pay over the lifetime of the loan - based on that you can figure out if overpaying or paying back the mortgage early is a good idea in your case.

finance
mortgage
buying a house
investing
loans
calculator
  1. Home
  2. Google Sheet
  3. Mortgage Loan Amortization Schedule

Mortgage Loan Amortization Schedule

A spreadsheet for calculating how much interest and principal you are paying back each month for your mortgage or loan. This gives you a breakdown of what where your money is going exactly. You can also see how much interest you will pay over the lifetime of the loan - based on that you can figure out if overpaying or paying back the mortgage early is a good idea in your case.

finance, mortgage, buying a house, investing, loans, calculator

Open the source doc to make a copy and edit

Loan Information Summary Frequency

Loan Amount 300,000 Rate (per period) 0.250% Annual

Annual Interest Rate 3.00% Scheduled # of Payments 300 Semi-Annual

Term of Loan in Years 25 Actual # of Payments 300 Quarterly

First Payment Date 1/1/2020 Total Payments 426,790.75 Bi-Monthly

Payment Frequency Monthly Total Interest 126,790.75 Monthly

Compound Period Monthly Est. Interest Savings - Semi-Monthly

Payment Type End of Period . Bi-Weekly

Rounding On .

[42]

Monthly Payment 1,422.63

Yearly Summary

Year Payments Additional Payments Interest Paid Principal Paid Year-End Balance

300,000.00

2020 17,072 0 8,888 8,183 291,817 Periods Per Year 12

2021 17,072 0 8,639 8,432 283,384 Compound Period 12

2022 17,072 0 8,383 8,689 274,695 Payment Type 0

2023 17,072 0 8,118 8,953 265,742 Months Per Period 1

2024 17,072 0 7,846 9,225 256,517 Rounding Option TRUE

2025 17,072 0 7,566 9,506 247,011

2026 17,072 0 7,276 9,795 237,215

2027 17,072 0 6,978 10,093 227,122

2028 17,072 0 6,671 10,400 216,722

2029 17,072 0 6,355 10,716 206,006

2030 17,072 0 6,029 11,042 194,963

2031 17,072 0 5,693 11,378 183,585

2032 17,072 0 5,347 11,724 171,861

2033 17,072 0 4,991 12,081 159,780

2034 17,072 0 4,623 12,448 147,331

2035 17,072 0 4,245 12,827 134,504

2036 17,072 0 3,854 13,217 121,287

2037 17,072 0 3,452 13,619 107,668

2038 17,072 0 3,038 14,033 93,634

2039 17,072 0 2,611 14,460 79,174

2040 17,072 0 2,171 14,900 64,274

2041 17,072 0 1,718 15,353 48,921

2042 17,072 0 1,251 15,820 33,101

2043 17,072 0 770 16,301 16,799

2044 17,073 0 274 16,799 0

2045 0 0 0 0 0

2046 0 0 0 0 0

2047 0 0 0 0 0

2048 0 0 0 0 0

2049 0 0 0 0 0

2050 0 0 0 0 0

Amortization Schedule

No. Due Date Year Payment Due Additional Payment (add) Interest Principal Balance

300,000.00

1 1/1/20 20 1,423 750 673 299,327

2 2/1/20 20 1,423 748 674 298,653

3 3/1/20 20 1,423 747 676 297,977

4 4/1/20 20 1,423 745 678 297,299

5 5/1/20 20 1,423 743 679 296,620

6 6/1/20 20 1,423 742 681 295,939

7 7/1/20 20 1,423 740 683 295,256

8 8/1/20 20 1,423 738 684 294,572

9 9/1/20 20 1,423 736 686 293,885

10 10/1/20 20 1,423 735 688 293,198

11 11/1/20 20 1,423 733 690 292,508

12 12/1/20 20 1,423 731 691 291,817

13 1/1/21 21 1,423 730 693 291,123

14 2/1/21 21 1,423 728 695 290,429

15 3/1/21 21 1,423 726 697 289,732

16 4/1/21 21 1,423 724 698 289,034

17 5/1/21 21 1,423 723 700 288,334

18 6/1/21 21 1,423 721 702 287,632

19 7/1/21 21 1,423 719 704 286,928

20 8/1/21 21 1,423 717 705 286,223

21 9/1/21 21 1,423 716 707 285,516

22 10/1/21 21 1,423 714 709 284,807

23 11/1/21 21 1,423 712 711 284,097

24 12/1/21 21 1,423 710 712 283,384

25 1/1/22 22 1,423 708 714 282,670

26 2/1/22 22 1,423 707 716 281,954

27 3/1/22 22 1,423 705 718 281,236

28 4/1/22 22 1,423 703 720 280,517

29 5/1/22 22 1,423 701 721 279,795

30 6/1/22 22 1,423 699 723 279,072

31 7/1/22 22 1,423 698 725 278,347

32 8/1/22 22 1,423 696 727 277,621

33 9/1/22 22 1,423 694 729 276,892

34 10/1/22 22 1,423 692 730 276,162

35 11/1/22 22 1,423 690 732 275,429

36 12/1/22 22 1,423 689 734 274,695

37 1/1/23 23 1,423 687 736 273,959

38 2/1/23 23 1,423 685 738 273,222

39 3/1/23 23 1,423 683 740 272,482

40 4/1/23 23 1,423 681 741 271,741

41 5/1/23 23 1,423 679 743 270,997

42 6/1/23 23 1,423 677 745 270,252

43 7/1/23 23 1,423 676 747 269,505

44 8/1/23 23 1,423 674 749 268,756

45 9/1/23 23 1,423 672 751 268,006

46 10/1/23 23 1,423 670 753 267,253

47 11/1/23 23 1,423 668 755 266,498

48 12/1/23 23 1,423 666 756 265,742

49 1/1/24 24 1,423 664 758 264,984

50 2/1/24 24 1,423 662 760 264,224

51 3/1/24 24 1,423 661 762 263,462

52 4/1/24 24 1,423 659 764 262,698

53 5/1/24 24 1,423 657 766 261,932

54 6/1/24 24 1,423 655 768 261,164

55 7/1/24 24 1,423 653 770 260,394

56 8/1/24 24 1,423 651 772 259,623

57 9/1/24 24 1,423 649 774 258,849

58 10/1/24 24 1,423 647 776 258,073

59 11/1/24 24 1,423 645 777 257,296

60 12/1/24 24 1,423 643 779 256,517

61 1/1/25 25 1,423 641 781 255,735

62 2/1/25 25 1,423 639 783 254,952

63 3/1/25 25 1,423 637 785 254,167

64 4/1/25 25 1,423 635 787 253,380

65 5/1/25 25 1,423 633 789 252,590

66 6/1/25 25 1,423 631 791 251,799

67 7/1/25 25 1,423 630 793 251,006

68 8/1/25 25 1,423 628 795 250,211

69 9/1/25 25 1,423 626 797 249,414

70 10/1/25 25 1,423 624 799 248,615

71 11/1/25 25 1,423 622 801 247,814

72 12/1/25 25 1,423 620 803 247,011

73 1/1/26 26 1,423 618 805 246,205

74 2/1/26 26 1,423 616 807 245,398

75 3/1/26 26 1,423 614 809 244,589

76 4/1/26 26 1,423 611 811 243,778

77 5/1/26 26 1,423 609 813 242,965

78 6/1/26 26 1,423 607 815 242,150

79 7/1/26 26 1,423 605 817 241,332

80 8/1/26 26 1,423 603 819 240,513

81 9/1/26 26 1,423 601 821 239,692

82 10/1/26 26 1,423 599 823 238,868

83 11/1/26 26 1,423 597 825 238,043

84 12/1/26 26 1,423 595 828 237,215

85 1/1/27 27 1,423 593 830 236,386

86 2/1/27 27 1,423 591 832 235,554

87 3/1/27 27 1,423 589 834 234,720

88 4/1/27 27 1,423 587 836 233,885

89 5/1/27 27 1,423 585 838 233,047

90 6/1/27 27 1,423 583 840 232,207

91 7/1/27 27 1,423 581 842 231,365

92 8/1/27 27 1,423 578 844 230,520

93 9/1/27 27 1,423 576 846 229,674

94 10/1/27 27 1,423 574 848 228,826

95 11/1/27 27 1,423 572 851 227,975

96 12/1/27 27 1,423 570 853 227,122

97 1/1/28 28 1,423 568 855 226,267

98 2/1/28 28 1,423 566 857 225,410

99 3/1/28 28 1,423 564 859 224,551

100 4/1/28 28 1,423 561 861 223,690

101 5/1/28 28 1,423 559 863 222,827

102 6/1/28 28 1,423 557 866 221,961

103 7/1/28 28 1,423 555 868 221,093

104 8/1/28 28 1,423 553 870 220,224

105 9/1/28 28 1,423 551 872 219,351

106 10/1/28 28 1,423 548 874 218,477

107 11/1/28 28 1,423 546 876 217,601

108 12/1/28 28 1,423 544 879 216,722

109 1/1/29 29 1,423 542 881 215,841

110 2/1/29 29 1,423 540 883 214,958

111 3/1/29 29 1,423 537 885 214,073

112 4/1/29 29 1,423 535 887 213,186

113 5/1/29 29 1,423 533 890 212,296

114 6/1/29 29 1,423 531 892 211,404

115 7/1/29 29 1,423 529 894 210,510

116 8/1/29 29 1,423 526 896 209,614

117 9/1/29 29 1,423 524 899 208,715

118 10/1/29 29 1,423 522 901 207,814

119 11/1/29 29 1,423 520 903 206,911

120 12/1/29 29 1,423 517 905 206,006

121 1/1/30 30 1,423 515 908 205,098

122 2/1/30 30 1,423 513 910 204,188

123 3/1/30 30 1,423 510 912 203,276

124 4/1/30 30 1,423 508 914 202,362

125 5/1/30 30 1,423 506 917 201,445

126 6/1/30 30 1,423 504 919 200,526

127 7/1/30 30 1,423 501 921 199,605

128 8/1/30 30 1,423 499 924 198,681

129 9/1/30 30 1,423 497 926 197,755

130 10/1/30 30 1,423 494 928 196,827

131 11/1/30 30 1,423 492 931 195,896

132 12/1/30 30 1,423 490 933 194,963

133 1/1/31 31 1,423 487 935 194,028

134 2/1/31 31 1,423 485 938 193,091

135 3/1/31 31 1,423 483 940 192,151

136 4/1/31 31 1,423 480 942 191,208

137 5/1/31 31 1,423 478 945 190,264

138 6/1/31 31 1,423 476 947 189,317

139 7/1/31 31 1,423 473 949 188,367

140 8/1/31 31 1,423 471 952 187,416

141 9/1/31 31 1,423 469 954 186,462

142 10/1/31 31 1,423 466 956 185,505

143 11/1/31 31 1,423 464 959 184,546

144 12/1/31 31 1,423 461 961 183,585

145 1/1/32 32 1,423 459 964 182,621

146 2/1/32 32 1,423 457 966 181,655

147 3/1/32 32 1,423 454 968 180,687

148 4/1/32 32 1,423 452 971 179,716

149 5/1/32 32 1,423 449 973 178,743

150 6/1/32 32 1,423 447 976 177,767

151 7/1/32 32 1,423 444 978 176,789

152 8/1/32 32 1,423 442 981 175,808

153 9/1/32 32 1,423 440 983 174,825

154 10/1/32 32 1,423 437 986 173,839

155 11/1/32 32 1,423 435 988 172,851

156 12/1/32 32 1,423 432 991 171,861

157 1/1/33 33 1,423 430 993 170,868

158 2/1/33 33 1,423 427 995 169,872

159 3/1/33 33 1,423 425 998 168,874

160 4/1/33 33 1,423 422 1,000 167,874

161 5/1/33 33 1,423 420 1,003 166,871

162 6/1/33 33 1,423 417 1,005 165,865

163 7/1/33 33 1,423 415 1,008 164,857

164 8/1/33 33 1,423 412 1,010 163,847

165 9/1/33 33 1,423 410 1,013 162,834

166 10/1/33 33 1,423 407 1,016 161,818

167 11/1/33 33 1,423 405 1,018 160,800

168 12/1/33 33 1,423 402 1,021 159,780

169 1/1/34 34 1,423 399 1,023 158,757

170 2/1/34 34 1,423 397 1,026 1

Mortgage Loan Amortization Schedule
Info
Tags Finance, Mortgage, Buying a house, Investing, Loans, Calculator
Type Google Sheet
Published 14/10/2021, 16:10:34

Resources

Open Source DAO Market Research
The Freelancer Rate Calculator
Analysing the Values and Limitations of Cooperative Firms
Buy a Business v2.1
Ways To Make Money On The Internet Project
Tesla - Affordability Worksheet
CompiledSanity Personal Savings Template v2.3.3 - ?? UK Version
Book Publishing Salary Transparency (UK)