| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | List Price | $350,000.00 | ||||||||||||||||||||||||
2 | Loan Amount | $280,000.00 | Down Payment | $70,000.00 | 20% | |||||||||||||||||||||
3 | Annual Rate | 3.00% | Insurance | $900.00 | ||||||||||||||||||||||
4 | Pmts | 360 | ||||||||||||||||||||||||
5 | Payment Amount | $1,180.49 | ||||||||||||||||||||||||
6 | ||||||||||||||||||||||||||
7 | Misc Updates | |||||||||||||||||||||||||
8 | Yard reseeding | $750.00 | Avg Month Total | $2,193.96 | ||||||||||||||||||||||
9 | Windows | $8,000.00 | ||||||||||||||||||||||||
10 | Kitchen | $10,000.00 | Amount owed now | $90,250.00 | ||||||||||||||||||||||
11 | Washer/Dryer | $1,500.00 | Total Mortgage | $424,976.87 | ||||||||||||||||||||||
12 | Item 4 | Grand Total | $515,226.87 | |||||||||||||||||||||||
13 | Item 5 | |||||||||||||||||||||||||
14 | $20,250.00 | |||||||||||||||||||||||||
15 | ||||||||||||||||||||||||||
16 | Totals | $424,976.87 | $144,976.87 | $337,848.13 | ||||||||||||||||||||||
17 | Beginning Balance | Payment | Principal | Interest | End Balance | Taxes | $9,000.00 | 1.50% | ||||||||||||||||||
18 | 7/1/2018 | $280,000.00 | $1,180.49 | $480.49 | $700.00 | $279,519.51 | $750.00 | |||||||||||||||||||
19 | 8/1/2018 | $279,519.51 | $1,180.49 | $481.69 | $698.80 | $279,037.82 | $750.00 | |||||||||||||||||||
20 | 9/1/2018 | $279,037.82 | $1,180.49 | $482.90 | $697.59 | $278,554.92 | $750.00 | |||||||||||||||||||
21 | 10/1/2018 | $278,554.92 | $1,180.49 | $484.10 | $696.39 | $278,070.82 | $750.00 | |||||||||||||||||||
22 | 11/1/2018 | $278,070.82 | $1,180.49 | $485.31 | $695.18 | $277,585.50 | $750.00 | |||||||||||||||||||
23 | 12/1/2018 | $277,585.50 | $1,180.49 | $486.53 | $693.96 | $277,098.97 | $750.00 | |||||||||||||||||||
24 | 1/1/2019 | $277,098.97 | $1,180.49 | $487.74 | $692.75 | $276,611.23 | $750.00 | |||||||||||||||||||
25 | 2/1/2019 | $276,611.23 | $1,180.49 | $488.96 | $691.53 | $276,122.27 | $750.00 | |||||||||||||||||||
26 | 3/1/2019 | $276,122.27 | $1,180.49 | $490.19 | $690.31 | $275,632.08 | $750.00 | |||||||||||||||||||
27 | 4/1/2019 | $275,632.08 | $1,180.49 | $491.41 | $689.08 | $275,140.67 | $750.00 | |||||||||||||||||||
28 | 5/1/2019 | $275,140.67 | $1,180.49 | $492.64 | $687.85 | $274,648.03 | $750.00 | |||||||||||||||||||
29 | 6/1/2019 | $274,648.03 | $1,180.49 | $493.87 | $686.62 | $274,154.16 | $750.00 | |||||||||||||||||||
30 | 7/1/2019 | $274,154.16 | $1,180.49 | $495.11 | $685.39 | $273,659.05 | $761.25 | |||||||||||||||||||
31 | 8/1/2019 | $273,659.05 | $1,180.49 | $496.34 | $684.15 | $273,162.71 | $761.25 | |||||||||||||||||||
32 | 9/1/2019 | $273,162.71 | $1,180.49 | $497.58 | $682.91 | $272,665.12 | $761.25 | |||||||||||||||||||
33 | 10/1/2019 | $272,665.12 | $1,180.49 | $498.83 | $681.66 | $272,166.30 | $761.25 | |||||||||||||||||||
34 | 11/1/2019 | $272,166.30 | $1,180.49 | $500.08 | $680.42 | $271,666.22 | $761.25 | |||||||||||||||||||
35 | 12/1/2019 | $271,666.22 | $1,180.49 | $501.33 | $679.17 | $271,164.90 | $761.25 | |||||||||||||||||||
36 | 1/1/2020 | $271,164.90 | $1,180.49 | $502.58 | $677.91 | $270,662.32 | $761.25 | |||||||||||||||||||
37 | 2/1/2020 | $270,662.32 | $1,180.49 | $503.84 | $676.66 | $270,158.48 | $761.25 | |||||||||||||||||||
38 | 3/1/2020 | $270,158.48 | $1,180.49 | $505.10 | $675.40 | $269,653.39 | $761.25 | |||||||||||||||||||
39 | 4/1/2020 | $269,653.39 | $1,180.49 | $506.36 | $674.13 | $269,147.03 | $761.25 | |||||||||||||||||||
40 | 5/1/2020 | $269,147.03 | $1,180.49 | $507.62 | $672.87 | $268,639.40 | $761.25 | |||||||||||||||||||
41 | 6/1/2020 | $268,639.40 | $1,180.49 | $508.89 | $671.60 | $268,130.51 | $761.25 | |||||||||||||||||||
42 | 7/1/2020 | $268,130.51 | $1,180.49 | $510.17 | $670.33 | $267,620.35 | $772.67 | |||||||||||||||||||
43 | 8/1/2020 | $267,620.35 | $1,180.49 | $511.44 | $669.05 | $267,108.91 | $772.67 | |||||||||||||||||||
44 | 9/1/2020 | $267,108.91 | $1,180.49 | $512.72 | $667.77 | $266,596.19 | $772.67 | |||||||||||||||||||
45 | 10/1/2020 | $266,596.19 | $1,180.49 | $514.00 | $666.49 | $266,082.19 | $772.67 | |||||||||||||||||||
46 | 11/1/2020 | $266,082.19 | $1,180.49 | $515.29 | $665.21 | $265,566.90 | $772.67 | |||||||||||||||||||
47 | 12/1/2020 | $265,566.90 | $1,180.49 | $516.57 | $663.92 | $265,050.33 | $772.67 | |||||||||||||||||||
48 | 1/1/2021 | $265,050.33 | $1,180.49 | $517.87 | $662.63 | $264,532.46 | $772.67 | |||||||||||||||||||
49 | 2/1/2021 | $264,532.46 | $1,180.49 | $519.16 | $661.33 | $264,013.30 | $772.67 | |||||||||||||||||||
50 | 3/1/2021 | $264,013.30 | $1,180.49 | $520.46 | $660.03 | $263,492.84 | $772.67 | |||||||||||||||||||
51 | 4/1/2021 | $263,492.84 | $1,180.49 | $521.76 | $658.73 | $262,971.08 | $772.67 | |||||||||||||||||||
52 | 5/1/2021 | $262,971.08 | $1,180.49 | $523.06 | $657.43 | $262,448.02 | $772.67 | |||||||||||||||||||
53 | 6/1/2021 | $262,448.02 | $1,180.49 | $524.37 | $656.12 | $261,923.65 | $772.67 | |||||||||||||||||||
54 | 7/1/2021 | $261,923.65 | $1,180.49 | $525.68 | $654.81 | $261,397.97 | $784.26 | |||||||||||||||||||
55 | 8/1/2021 | $261,397.97 | $1,180.49 | $527.00 | $653.49 | $260,870.97 | $784.26 | |||||||||||||||||||
56 | 9/1/2021 | $260,870.97 | $1,180.49 | $528.31 | $652.18 | $260,342.66 | $784.26 | |||||||||||||||||||
57 | 10/1/2021 | $260,342.66 | $1,180.49 | $529.63 | $650.86 | $259,813.02 | $784.26 | |||||||||||||||||||
58 | 11/1/2021 | $259,813.02 | $1,180.49 | $530.96 | $649.53 | $259,282.06 | $784.26 | |||||||||||||||||||
59 | 12/1/2021 | $259,282.06 | $1,180.49 | $532.29 | $648.21 | $258,749.78 | $784.26 | |||||||||||||||||||
60 | 1/1/2022 | $258,749.78 | $1,180.49 | $533.62 | $646.87 | $258,216.16 | $784.26 | |||||||||||||||||||
61 | 2/1/2022 | $258,216.16 | $1,180.49 | $534.95 | $645.54 | $257,681.21 | $784.26 | |||||||||||||||||||
62 | 3/1/2022 | $257,681.21 | $1,180.49 | $536.29 | $644.20 | $257,144.92 | $784.26 | |||||||||||||||||||
63 | 4/1/2022 | $257,144.92 | $1,180.49 | $537.63 | $642.86 | $256,607.29 | $784.26 | |||||||||||||||||||
64 | 5/1/2022 | $256,607.29 | $1,180.49 | $538.97 | $641.52 | $256,068.32 | $784.26 | |||||||||||||||||||
65 | 6/1/2022 | $256,068.32 | $1,180.49 | $540.32 | $640.17 | $255,528.00 | $784.26 | |||||||||||||||||||
66 | 7/1/2022 | $255,528.00 | $1,180.49 | $541.67 | $638.82 | $254,986.33 | $796.02 | |||||||||||||||||||
67 | 8/1/2022 | $254,986.33 | $1,180.49 | $543.03 | $637.47 | $254,443.30 | $796.02 | |||||||||||||||||||
68 | 9/1/2022 | $254,443.30 | $1,180.49 | $544.38 | $636.11 | $253,898.92 | $796.02 | |||||||||||||||||||
69 | 10/1/2022 | $253,898.92 | $1,180.49 | $545.74 | $634.75 | $253,353.17 | $796.02 | |||||||||||||||||||
70 | 11/1/2022 | $253,353.17 | $1,180.49 | $547.11 | $633.38 | $252,806.07 | $796.02 | |||||||||||||||||||
71 | 12/1/2022 | $252,806.07 | $1,180.49 | $548.48 | $632.02 | $252,257.59 | $796.02 | |||||||||||||||||||
72 | 1/1/2023 | $252,257.59 | $1,180.49 | $549.85 | $630.64 | $251,707.74 | $796.02 | |||||||||||||||||||
73 | 2/1/2023 | $251,707.74 | $1,180.49 | $551.22 | $629.27 | $251,156.52 | $796.02 | |||||||||||||||||||
74 | 3/1/2023 | $251,156.52 | $1,180.49 | $552.60 | $627.89 | $250,603.92 | $796.02 | |||||||||||||||||||
75 | 4/1/2023 | $250,603.92 | $1,180.49 | $553.98 | $626.51 | $250,049.94 | $796.02 | |||||||||||||||||||
76 | 5/1/2023 | $250,049.94 | $1,180.49 | $555.37 | $625.12 | $249,494.57 | $796.02 | |||||||||||||||||||
77 | 6/1/2023 | $249,494.57 | $1,180.49 | $556.75 | $623.74 | $248,937.82 | $796.02 | |||||||||||||||||||
78 | 7/1/2023 | $248,937.82 | $1,180.49 | $558.15 | $622.34 | $248,379.67 | $807.96 | |||||||||||||||||||
79 | 8/1/2023 | $248,379.67 | $1,180.49 | $559.54 | $620.95 | $247,820.13 | $807.96 | |||||||||||||||||||
80 | 9/1/2023 | $247,820.13 | $1,180.49 | $560.94 | $619.55 | $247,259.19 | $807.96 | |||||||||||||||||||
81 | 10/1/2023 | $247,259.19 | $1,180.49 | $562.34 | $618.15 | $246,696.84 | $807.96 | |||||||||||||||||||
82 | 11/1/2023 | $246,696.84 | $1,180.49 | $563.75 | $616.74 | $246,133.10 | $807.96 | |||||||||||||||||||
83 | 12/1/2023 | $246,133.10 | $1,180.49 | $565.16 | $615.33 | $245,567.94 | $807.96 | |||||||||||||||||||
84 | 1/1/2024 | $245,567.94 | $1,180.49 | $566.57 | $613.92 | $245,001.37 | $807.96 | |||||||||||||||||||
85 | 2/1/2024 | $245,001.37 | $1,180.49 | $567.99 | $612.50 | $244,433.38 | $807.96 | |||||||||||||||||||
86 | 3/1/2024 | $244,433.38 | $1,180.49 | $569.41 | $611.08 | $243,863.97 | $807.96 | |||||||||||||||||||
87 | 4/1/2024 | $243,863.97 | $1,180.49 | $570.83 | $609.66 | $243,293.14 | $807.96 | |||||||||||||||||||
88 | 5/1/2024 | $243,293.14 | $1,180.49 | $572.26 | $608.23 | $242,720.88 | $807.96 | |||||||||||||||||||
89 | 6/1/2024 | $242,720.88 | $1,180.49 | $573.69 | $606.80 | $242,147.19 | $807.96 | |||||||||||||||||||
90 | 7/1/2024 | $242,147.19 | $1,180.49 | $575.12 | $605.37 | $241,572.07 | $820.08 | |||||||||||||||||||
91 | 8/1/2024 | $241,572.07 | $1,180.49 | $576.56 | $603.93 | $240,995.51 | $820.08 | |||||||||||||||||||
92 | 9/1/2024 | $240,995.51 | $1,180.49 | $578.00 | $602.49 | $240,417.50 | $820.08 | |||||||||||||||||||
93 | 10/1/2024 | $240,417.50 | $1,180.49 | $579.45 | $601.04 | $239,838.06 | $820.08 | |||||||||||||||||||
94 | 11/1/2024 | $239,838.06 | $1,180.49 | $580.90 | $599.60 | $239,257.16 | $820.08 | |||||||||||||||||||
95 | 12/1/2024 | $239,257.16 | $1,180.49 | $582.35 | $598.14 | $238,674.81 | $820.08 | |||||||||||||||||||
96 | 1/1/2025 | $238,674.81 | $1,180.49 | $583.80 | $596.69 | $238,091.01 | $820.08 | |||||||||||||||||||
97 | 2/1/2025 | $238,091.01 | $1,180.49 | $585.26 | $595.23 | $237,505.74 | $820.08 | |||||||||||||||||||
98 | 3/1/2025 | $237,505.74 | $1,180.49 | $586.73 | $593.76 | $236,919.02 | $820.08 | |||||||||||||||||||
99 | 4/1/2025 | $236,919.02 | $1,180.49 | $588.19 | $592.30 | $236,330.82 | $820.08 | |||||||||||||||||||
100 | 5/1/2025 | $236,330.82 | $1,180.49 | $589.66 | $590.83 | $235,741.16 | $820.08 |