Sourceful

Discover the best public
Google docs

Find docs created by community members like you. Give feedback, collaborate and create your own.
 
  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 21/01/2021, 17:52:43

Resources

The Freelancer Rate Calculator
Buy a Business v2.1
Tesla - Affordability Worksheet
Simple Banking Alternatives
Book Publishing Salary Transparency (UK)
9-15-20 Billionaires Data
HW Startup Business model list
Kids investing game - 1