Instructions
Before making any changes save this file to a different name (see below ins
This way you will always have a clean master to start from.
1. This file is called Property Analysis or sometimes referred to as an APOD, Annual Property O
2. Light grey areas are to be filled out by you. Start by filling out the next sheet (called Property,
Then fill out each sheet in order.
3. All sheets are protected. You can only enter data in specific cells. This protects the formulas
(except this one - Instructions) by selecting Tools/Protection/Unprotect Sheet (no password).
** Instructions: Follow these steps to save a copy (and not overwrite the original).
1 Select File/Save As
2 Select a location (or directory) for your file.
3 Enter in a descriptive file name (e.g. Address, Tract, Street or City).
4 Select Save.
5 Now you can make changes without affecting the original.
Author
This spread sheet was developed by Randall Ijams over many frustrating hours. It started sm
suggestions and have incorporated many. If you find it useful I would appreciate a token paym
address.
Randall Ijams
24374 El Pilar
Laguna Niguel, CA 92677-3509
RRI00@SalesTime.com
http://www.SalesTime.com/docs/excel/apod.xls
Pre-distribution instructions:
1 Select first editable field in each sheet.
2 Verify header is aligned properly.
3 Protect each sheet.
4 Save as apod.xls.
5 Copy to local site.
6 Upload to remote site.
Instructions
making any changes save this file to a different name (see below instructions)**.
This way you will always have a clean master to start from.
perty Analysis or sometimes referred to as an APOD, Annual Property Operating Data.
o be filled out by you. Start by filling out the next sheet (called Property, see worksheet tabs below).
et in order.
ed. You can only enter data in specific cells. This protects the formulas. You can unprotect any sheet
tructions) by selecting Tools/Protection/Unprotect Sheet (no password).
hese steps to save a copy (and not overwrite the original).
As
(or directory) for your file.
ptive file name (e.g. Address, Tract, Street or City).
ke changes without affecting the original.
s developed by Randall Ijams over many frustrating hours. It started small and grew. I appreciate
e incorporated many. If you find it useful I would appreciate a token payment of $10 sent to the below
(Latest update)
Property Information
Property
Name Name
Location Address
Type House
Style SFH
Size (sf) 1500
Bedrooms 3
Baths 1.5
Parking 2
Landscaping Natural, Pine Trees
Lot Location 4th from end of dead end street
Lot Size 75'x100'
Year Built 1980
Builder History None
Agent
Name AgentName
Office YES Homes
Web Site Stuff.com
Phone 949.123.4567
Address 123 A Street, Las Vegas, NV, 90123
Email Joe@Stuff.com
Other
Area Information
Parks
Schools
Vacancy Factors
Appreciation
Home Depot
Starbucks
Management
Background
Recommendations
Repair Info-structure
Competition's Rates
Building Materials
Paint Treatment
Plumbing Type
Roofing
Siding
Comments
Needs work. Holes in walls, Acoustics ceiling, slider framed, stair railing missing, window A/C, Roo
Property Information
(Street or City)
(Address)
(House, Condo, Rental, 4-Plex, Commercial, etc.)
(Rancher, …)
sf = Square Feet
(#, Garage, Carport, Limited, Gravel, Asphalt, etc.)
(Done, Needs work, Natural, if new, is landscaping included?, etc.)
(Reputation, litigation history, etc.)
(Reputation, Awards, Nationwide/State Testing Ranking)
(Rates)
(Quantity and Distance)
(Quantity and Distance)
(Primer used)
(Copper, Steel, Plastic, etc.)
(20, 25, 30yr, composite, tile, etc.)
(Stucco, Wood, Brick, etc.)
ustics ceiling, slider framed, stair railing missing, window A/C, Rooms good size.
Configuration
Purchase Information
$ 210,000 Purchase Price
$ 42,000 Down Payment 20%
2006.07.05 Purchase Date ($106.75)
($69.39)
Loan Values
6.500% Loan Interest Rate (APR) $1,080.80
$ 170,994 Loan Amount (including fees)
Rental Values monthly annually
4.00% Vacancy Rate $42.00 $504.00
1.15% Tax Rate $201.25 $2,415.00
5.00% Management $52.50 $630.00
3.00% Maintenance $31.50 $378.00
$ 1,050 Monthly Rent (for single unit properties) $12,600.00
Sales Costs %
2.00% Agents
1.00% Escrow
0.00% Title Insurance
1.00% Miscellaneous
4.00% Total %
Sales Costs $
$ 500 Title Insurance
$ 500 Miscellaneous
$ 1,000 Total $
Assessed Values (from tax records)
$ 100,000 27.78% Land (not depreciable)
$ 260,000 72.22% Improvements (building - Depreciable)
$ 360,000 100.00% Total
Tax Values
30 Years of depreciation
25% Tax on Depreciation
72% Improvements (Building value) as % of total purchase price
1.5% Real Estate Tax increase per year (Not implemented)
35% Your Tax Bracket (Federal and State)
20% Capital Gain Tax
No 2nd Home? (Yes or No) (not implemented)
Forecasting
7% Annual Appreciation Increase
Equity Sharing (Not implemented)
100% Your Percent of Equity Sharing (100% if not equity sharing)
Configuration
CFADMo
CFATMo
1st & 2nd Loans P&I
Tax Rate Adjustment
0.05%
$105.00 /yr
records)
$151,667
mented)
Loan Fees
Washington Mutual Loans4Less GreenLight Average
Funding & Review Fee $ 430 $ 430 $ 430 $ 430
Flood Certification $ 13 $ 13 $ 13 $ 13
Tax Research Fee $ 81 $ 81 $ 81 $ 81
Settlement or Closing fee $ 120 $ 120 $ 120 $ 120
Title Insurance $ 375 $ 375 $ 375 $ 375
Reconveyance Fee $ 150 $ 150 $ 150 $ 150
Recording Fee $ 140 $ 150 $ 160 $ 150
Other $ 5 $ - $ - $ 2
Total $ 1,314 $ 1,319 $ 1,329 $ 1,321
Lowest Total Fees $ 1,314
1st Loan
Notes
- Gray areas are to be filled out. Only adjust other areas when needed. Be very careful when changing formulas.
- Take careful note of Date calculation in Date column.
- Notice the Yearly Interest column is based on Month in the Date column.
- Monthly loan payment will be based on calculation if nothing is entered into Different Payment (D20).
- Notice Payment column will stop early when principal is paid off.
- Final payment includes the Balloon payment if used.
Starting Date 7/5/2006 Improvements Land Value Total Value (should match Purchase Price)
Purchase Price $ 210,000 $ 151,667 $ 58,333 $ 210,000
Down Payment $ 42,000 20% =% Down
Points % 1% $ 1,680 = Points
Fees $ 1,314 Closing Costs = Points + Fees???
Balloon Pmt $ - $ 2,994.00
Interest Rate 6.50% 0.54% = Monthly Interest Rate
Term (years) 30 360 = Months
Different Payment $ - $ - = Payment Difference Monthly CFAD ($106.75)
Loan Amount $ 170,994.00 P&I Calculated Int Only Principal
Loan Payment $ 1,080.80 $1,080.80 $ 926.22 $ 154.58
Total Interest Paid $ 218,092.13 $ - = underpayment due to decreased monthly payments (for 30y loan only).
Date Month Payment Principal Interest Total Total Total Yearly Ending
Paid Principal Interest Interest Balance
7/5/2006 0 $ - $ - $ - $ - $ - $ - $ 170,994.00
8/5/2006 1 $ 1,080.80 $ 154.58 $ 926.22 $ 1,080.80 $ 154.58 $ 926.22 $ 926.22 $ 170,839.42
9/5/2006 2 $ 1,080.80 $ 155.42 $ 925.38 $ 2,161.60 $ 310.00 $ 1,851.60 $ 1,851.60 $ 170,684.00
10/5/2006 3 $ 1,080.80 $ 156.26 $ 924.54 $ 3,242.40 $ 466.26 $ 2,776.14 $ 2,776.14 $ 170,527.74
11/5/2006 4 $ 1,080.80 $ 157.11 $ 923.69 $ 4,323.20 $ 623.37 $ 3,699.83 $ 3,699.83 $ 170,370.63
12/5/2006 5 $ 1,080.80 $ 157.96 $ 922.84 $ 5,404.00 $ 781.33 $ 4,622.67 $ 4,622.67 $ 170,212.67
1/5/2007 6 $ 1,080.80 $ 158.81 $ 921.99 $ 6,484.80 $ 940.14 $ 5,544.66 $ 921.99 $ 170,053.86
2/5/2007 7 $ 1,080.80 $ 159.67 $ 921.13 $ 7,565.60 $ 1,099.81 $ 6,465.79 $ 1,843.12 $ 169,894.19
3/5/2007 8 $ 1,080.80 $ 160.54 $ 920.26 $ 8,646.40 $ 1,260.35 $ 7,386.05 $ 2,763.38 $ 169,733.65
4/5/2007 9 $ 1,080.80 $ 161.41 $ 919.39 $ 9,727.20 $ 1,421.76 $ 8,305.44 $ 3,682.77 $ 169,572.24
5/5/2007 10 $ 1,080.80 $ 162.28 $ 918.52 $ 10,808.00 $ 1,584.04 $ 9,223.96 $ 4,601.29 $ 169,409.96
6/5/2007 11 $ 1,080.80 $ 163.16 $ 917.64 $ 11,888.80 $ 1,747.20 $ 10,141.60 $ 5,518.93 $ 169,246.80
7/5/2007 12 $ 1,080.80 $ 164.05 $ 916.75 $ 12,969.60 $ 1,911.25 $ 11,058.35 $ 6,435.68 $ 169,082.75
8/5/2007 13 $ 1,080.80 $ 164.94 $ 915.86 $ 14,050.40 $ 2,076.19 $ 11,974.21 $ 7,351.54 $ 168,917.81
9/5/2007 14 $ 1,080.80 $ 165.83 $ 914.97 $ 15,131.20 $ 2,242.02 $ 12,889.18 $ 8,266.51 $ 168,751.98
10/5/2007 15 $ 1,080.80 $ 166.73 $ 914.07 $ 16,212.00 $ 2,408.75 $ 13,803.25 $ 9,180.58 $ 168,585.25
11/5/2007 16 $ 1,080.80 $ 167.63 $ 913.17 $ 17,292.80 $ 2,576.38 $ 14,716.42 $ 10,093.75 $ 168,417.62
12/5/2007 17 $ 1,080.80 $ 168.54 $ 912.26 $ 18,373.60 $ 2,744.92 $ 15,628.68 $ 11,006.01 $ 168,249.08
1/5/2008 18 $ 1,080.80 $ 169.45 $ 911.35 $ 19,454.40 $ 2,914.37 $ 16,540.03 $ 911.35 $ 168,079.63
2/5/2008 19 $ 1,080.80 $ 170.37 $ 910.43 $ 20,535.20 $ 3,084.74 $ 17,450.46 $ 1,821.78 $ 167,909.26
3/5/2008 20 $ 1,080.80 $ 171.29 $ 909.51 $ 21,616.00 $ 3,256.03 $ 18,359.97 $ 2,731.29 $ 167,737.97
4/5/2008 21 $ 1,080.80 $ 172.22 $ 908.58 $ 22,696.80 $ 3,428.25 $ 19,268.55 $ 3,639.87 $ 167,565.75
5/5/2008 22 $ 1,080.80 $ 173.15 $ 907.65 $ 23,777.60 $ 3,601.40 $ 20,176.20 $ 4,547.52 $ 167,392.60
6/5/2008 23 $ 1,080.80 $ 174.09 $ 906.71 $ 24,858.40 $ 3,775.49 $ 21,082.91 $ 5,454.23 $ 167,218.51
7/5/2008 24 $ 1,080.80 $ 175.03 $ 905.77 $ 25,939.20 $ 3,950.52 $ 21,988.68 $ 6,360.00 $ 167,043.48
8/5/2008 25 $ 1,080.80 $ 175.98 $ 904.82 $ 27,020.00 $ 4,126.50 $ 22,893.50 $ 7,264.82 $ 166,867.50
9/5/2008 26 $ 1,080.80 $ 176.93 $ 903.87 $ 28,100.80 $ 4,303.43 $ 23,797.37 $ 8,168.69 $ 166,690.57
10/5/2008 27 $ 1,080.80 $ 177.89 $ 902.91 $ 29,181.60 $ 4,481.32 $ 24,700.28 $ 9,071.60 $ 166,512.68
11/5/2008 28 $ 1,080.80 $ 178.86 $ 901.94 $ 30,262.40 $ 4,660.18 $ 25,602.22 $ 9,973.54 $ 166,333.82
12/5/2008 29 $ 1,080.80 $ 179.83 $ 900.97 $ 31,343.20 $ 4,840.01 $ 26,503.19 $ 10,874.51 $ 166,153.99
1/5/2009 30 $ 1,080.80 $ 180.80 $ 900.00 $ 32,424.00 $ 5,020.81 $ 27,403.19 $ 900.00 $ 165,973.19
2/5/2009 31 $ 1,080.80 $ 181.78 $ 899.02 $ 33,504.80 $ 5,202.59 $ 28,302.21 $ 1,799.02 $ 165,791.41
3/5/2009 32 $ 1,080.80 $ 182.76 $ 898.04 $ 34,585.60 $ 5,385.35 $ 29,200.25 $ 2,697.06 $ 165,608.65
4/5/2009 33 $ 1,080.80 $ 183.75 $ 897.05 $ 35,666.40 $ 5,569.10 $ 30,097.30 $ 3,594.11 $ 165,424.90
5/5/2009 34 $ 1,080.80 $ 184.75 $ 896.05 $ 36,747.20 $ 5,753.85 $ 30,993.35 $ 4,490.16 $ 165,240.15
6/5/2009 35 $ 1,080.80 $ 185.75 $ 895.05 $ 37,828.00 $ 5,939.60 $ 31,888.40 $ 5,385.21 $ 165,054.40
7/5/2009 36 $ 1,080.80 $ 186.76 $ 894.04 $ 38,908.80 $ 6,126.36 $ 32,782.44 $ 6,279.25 $ 164,867.64
8/5/2009 37 $ 1,080.80 $ 187.77 $ 893.03 $ 39,989.60 $ 6,314.13 $ 33,675.47 $ 7,172.28 $ 164,679.87
9/5/2009 38 $ 1,080.80 $ 188.78 $ 892.02 $ 41,070.40 $ 6,502.91 $ 34,567.49 $ 8,064.30 $ 164,491.09
10/5/2009 39 $ 1,080.80 $ 189.81 $ 890.99 $ 42,151.20 $ 6,692.72 $ 35,458.48 $ 8,955.29 $ 164,301.28
11/5/2009 40 $ 1,080.80 $ 190.83 $ 889.97 $ 43,232.00 $ 6,883.55 $ 36,348.45 $ 9,845.26 $ 164,110.45
12/5/2009 41 $ 1,080.80 $ 191.87 $ 888.93 $ 44,312.80 $ 7,075.42 $ 37,237.38 $ 10,734.19 $ 163,918.58
1/5/2010 42 $ 1,080.80 $ 192.91 $ 887.89 $ 45,393.60 $ 7,268.33 $ 38,125.27 $ 887.89 $ 163,725.67
2/5/2010 43 $ 1,080.80 $ 193.95 $ 886.85 $ 46,474.40 $ 7,462.28 $ 39,012.12 $ 1,774.74 $ 163,531.72
3/5/2010 44 $ 1,080.80 $ 195.00 $ 885.80 $ 47,555.20 $ 7,657.28 $ 39,897.92 $ 2,660.54 $ 163,336.72
4/5/2010 45 $ 1,080.80 $ 196.06 $ 884.74 $ 48,636.00 $ 7,853.34 $ 40,782.66 $ 3,545.28 $ 163,140.66
5/5/2010 46 $ 1,080.80 $ 197.12 $ 883.68 $ 49,716.80 $ 8,050.46 $ 41,666.34 $ 4,428.96 $ 162,943.54
6/5/2010 47 $ 1,080.80 $ 198.19 $ 882.61 $ 50,797.60 $ 8,248.65 $ 42,548.95 $ 5,311.57 $ 162,745.35
7/5/2010 48 $ 1,080.80 $ 199.26 $ 881.54 $ 51,878.40 $ 8,447.91 $ 43,430.49 $ 6,193.11 $ 162,546.09
8/5/2010 49 $ 1,080.80 $ 200.34 $ 880.46 $ 52,959.20 $ 8,648.25 $ 44,310.95 $ 7,073.57 $ 162,345.75
9/5/2010 50 $ 1,080.80 $ 201.43 $ 879.37 $ 54,040.00 $ 8,849.68 $ 45,190.32 $ 7,952.94 $ 162,144.32
10/5/2010 51 $ 1,080.80 $ 202.52 $ 878.28 $ 55,120.80 $ 9,052.20 $ 46,068.60 $ 8,831.22 $ 161,941.80
11/5/2010 52 $ 1,080.80 $ 203.62 $ 877.18 $ 56,201.60 $ 9,255.82 $ 46,945.78 $ 9,708.40 $ 161,738.18
12/5/2010 53 $ 1,080.80 $ 204.72 $ 876.08 $ 57,282.40 $ 9,460.54 $ 47,821.86 $ 10,584.48 $ 161,533.46
1/5/2011 54 $ 1,080.80 $ 205.83 $ 874.97 $ 58,363.20 $ 9,666.37 $ 48,696.83 $ 874.97 $ 161,327.63
2/5/2011 55 $ 1,080.80 $ 206.94 $ 873.86 $ 59,444.00 $ 9,873.31 $ 49,570.69 $ 1,748.83 $ 161,120.69
3/5/2011 56 $ 1,080.80 $ 208.06 $ 872.74 $ 60,524.80 $ 10,081.37 $ 50,443.43 $ 2,621.57 $ 160,912.63
4/5/2011 57 $ 1,080.80 $ 209.19 $ 871.61 $ 61,605.60 $ 10,290.56 $ 51,315.04 $ 3,493.18 $ 160,703.44
5/5/2011 58 $ 1,080.80 $ 210.32 $ 870.48 $ 62,686.40 $ 10,500.88 $ 52,185.52 $ 4,363.66 $ 160,493.12
6/5/2011 59 $ 1,080.80 $ 211.46 $ 869.34 $ 63,767.20 $ 10,712.34 $ 53,054.86 $ 5,233.00 $ 160,281.66
7/5/2011 60 $ 1,080.80 $ 212.61 $ 868.19 $ 64,848.00 $ 10,924.95 $ 53,923.05 $ 6,101.19 $ 160,069.05
8/5/2011 61 $ 1,080.80 $ 213.76 $ 867.04 $ 65,928.80 $ 11,138.71 $ 54,790.09 $ 6,968.23 $ 159,855.29
9/5/2011 62 $ 1,080.80 $ 214.92 $ 865.88 $ 67,009.60 $ 11,353.63 $ 55,655.97 $ 7,834.11 $ 159,640.37
10/5/2011 63 $ 1,080.80 $ 216.08 $ 864.72 $ 68,090.40 $ 11,569.71 $ 56,520.69 $ 8,698.83 $ 159,424.29
11/5/2011 64 $ 1,080.80 $ 217.25 $ 863.55 $ 69,171.20 $ 11,786.96 $ 57,384.24 $ 9,562.38 $ 159,207.04
12/5/2011 65 $ 1,080.80 $ 218.43 $ 862.37 $ 70,252.00 $ 12,005.39 $ 58,246.61 $ 10,424.75 $ 158,988.61
1/5/2012 66 $ 1,080.80 $ 219.61 $ 861.19 $ 71,332.80 $ 12,225.00 $ 59,107.80 $ 861.19 $ 158,769.00
2/5/2012 67 $ 1,080.80 $ 220.80 $ 860.00 $ 72,413.60 $ 12,445.80 $ 59,967.80 $ 1,721.19 $ 158,548.20
3/5/2012 68 $ 1,080.80 $ 222.00 $ 858.80 $ 73,494.40 $ 12,667.80 $ 60,826.60 $ 2,579.99 $ 158,326.20
4/5/2012 69 $ 1,080.80 $ 223.20 $ 857.60 $ 74,575.20 $ 12,891.00 $ 61,684.20 $ 3,437.59 $ 158,103.00
5/5/2012 70 $ 1,080.80 $ 224.41 $ 856.39 $ 75,656.00 $ 13,115.41 $ 62,540.59 $ 4,293.98 $ 157,878.59
6/5/2012 71 $ 1,080.80 $ 225.62 $ 855.18 $ 76,736.80 $ 13,341.03 $ 63,395.77 $ 5,149.16 $ 157,652.97
7/5/2012 72 $ 1,080.80 $ 226.85 $ 853.95 $ 77,817.60 $ 13,567.88 $ 64,249.72 $ 6,003.11 $ 157,426.12
8/5/2012 73 $ 1,080.80 $ 228.08 $ 852.72 $ 78,898.40 $ 13,795.96 $ 65,102.44 $ 6,855.83 $ 157,198.04
9/5/2012 74 $ 1,080.80 $ 229.31 $ 851.49 $ 79,979.20 $ 14,025.27 $ 65,953.93 $ 7,707.32 $ 156,968.73
10/5/2012 75 $ 1,080.80 $ 230.55 $ 850.25 $ 81,060.00 $ 14,255.82 $ 66,804.18 $ 8,557.57 $ 156,738.18
11/5/2012 76 $ 1,080.80 $ 231.80 $ 849.00 $ 82,140.80 $ 14,487.62 $ 67,653.18 $ 9,406.57 $ 156,506.38
12/5/2012 77 $ 1,080.80 $ 233.06 $ 847.74 $ 83,221.60 $ 14,720.68 $ 68,500.92 $ 10,254.31 $ 156,273.32
1/5/2013 78 $ 1,080.80 $ 234.32 $ 846.48 $ 84,302.40 $ 14,955.00 $ 69,347.40 $ 846.48 $ 156,039.00
2/5/2013 79 $ 1,080.80 $ 235.59 $ 845.21 $ 85,383.20 $ 15,190.59 $ 70,192.61 $ 1,691.69 $ 155,803.41
3/5/2013 80 $ 1,080.80 $ 236.86 $ 843.94 $ 86,464.00 $ 15,427.45 $ 71,036.55 $ 2,535.63 $ 155,566.55
4/5/2013 81 $ 1,080.80 $ 238.15 $ 842.65 $ 87,544.80 $ 15,665.60 $ 71,879.20 $ 3,378.28 $ 155,328.40
5/5/2013 82 $ 1,080.80 $ 239.44 $ 841.36 $ 88,625.60 $ 15,905.04 $ 72,720.56 $ 4,219.64 $ 155,088.96
6/5/2013 83 $ 1,080.80 $ 240.73 $ 840.07 $ 89,706.40 $ 16,145.77 $ 73,560.63 $ 5,059.71 $ 154,848.23
7/5/2013 84 $ 1,080.80 $ 242.04 $ 838.76 $ 90,787.20 $ 16,387.81 $ 74,399.39 $ 5,898.47 $ 154,606.19
8/5/2013 85 $ 1,080.80 $ 243.35 $ 837.45 $ 91,868.00 $ 16,631.16 $ 75,236.84 $ 6,735.92 $ 154,362.84
9/5/2013 86 $ 1,080.80 $ 244.67 $ 836.13 $ 92,948.80 $ 16,875.83 $ 76,072.97 $ 7,572.05 $ 154,118.17
10/5/2013 87 $ 1,080.80 $ 245.99 $ 834.81 $ 94,029.60 $ 17,121.82 $ 76,907.78 $ 8,406.86 $ 153,872.18
11/5/2013 88 $ 1,080.80 $ 247.33 $ 833.47 $ 95,110.40 $ 17,369.15 $ 77,741.25 $ 9,240.33 $ 153,624.85
12/5/2013 89 $ 1,080.80 $ 248.67 $ 832.13 $ 96,191.20 $ 17,617.82 $ 78,573.38 $ 10,072.46 $ 153,376.18
1/5/2014 90 $ 1,080.80 $ 250.01 $ 830.79 $ 97,272.00 $ 17,867.83 $ 79,404.17 $ 830.79 $ 153,126.17
2/5/2014 91 $ 1,080.80 $ 251.37 $ 829.43 $ 98,352.80 $ 18,119.20 $ 80,233.60 $ 1,660.22 $ 152,874.80
3/5/2014 92 $ 1,080.80 $ 252.73 $ 828.07 $ 99,433.60 $ 18,371.93 $ 81,061.67 $ 2,488.29 $ 152,622.07
4/5/2014 93 $ 1,080.80 $ 254.10 $ 826.70 $ 100,514.40 $ 18,626.03 $ 81,888.37 $ 3,314.99 $ 152,367.97
5/5/2014 94 $ 1,080.80 $ 255.47 $ 825.33 $ 101,595.20 $ 18,881.50 $ 82,713.70 $ 4,140.32 $ 152,112.50
6/5/2014 95 $ 1,080.80 $ 256.86 $ 823.94 $ 102,676.00 $ 19,138.36 $ 83,537.64 $ 4,964.26 $ 151,855.64
7/5/2014 96 $ 1,080.80 $ 258.25 $ 822.55 $ 103,756.80 $ 19,396.61 $ 84,360.19 $ 5,786.81 $ 151,597.39
8/5/2014 97 $ 1,080.80 $ 259.65 $ 821.15 $ 104,837.60 $ 19,656.26 $ 85,181.34 $ 6,607.96 $ 151,337.74
9/5/2014 98 $ 1,080.80 $ 261.05 $ 819.75 $ 105,918.40 $ 19,917.31 $ 86,001.09 $ 7,427.71 $ 151,076.69
10/5/2014 99 $ 1,080.80 $ 262.47 $ 818.33 $ 106,999.20 $ 20,179.78 $ 86,819.42 $ 8,246.04 $ 150,814.22
11/5/2014 100 $ 1,080.80 $ 263.89 $ 816.91 $ 108,080.00 $ 20,443.67 $ 87,636.33 $ 9,062.95 $ 150,550.33
12/5/2014 101 $ 1,080.80 $ 265.32 $ 815.48 $ 109,160.80 $ 20,708.99 $ 88,451.81 $ 9,878.43 $ 150,285.01
1/5/2015 102 $ 1,080.80 $ 266.76 $ 814.04 $ 110,241.60 $ 20,975.75 $ 89,265.85 $ 814.04 $ 150,018.25
2/5/2015 103 $ 1,080.80 $ 268.20 $ 812.60 $ 111,322.40 $ 21,243.95 $ 90,078.45 $ 1,626.64 $ 149,750.05
3/5/2015 104 $ 1,080.80 $ 269.65 $ 811.15 $ 112,403.20 $ 21,513.60 $ 90,889.60 $ 2,437.79 $ 149,480.40
4/5/2015 105 $ 1,080.80 $ 271.11 $ 809.69 $ 113,484.00 $ 21,784.71 $ 91,699.29 $ 3,247.48 $ 149,209.29
5/5/2015 106 $ 1,080.80 $ 272.58 $ 808.22 $ 114,564.80 $ 22,057.29 $ 92,507.51 $ 4,055.70 $ 148,936.71
6/5/2015 107 $ 1,080.80 $ 274.06 $ 806.74 $ 115,645.60 $ 22,331.35 $ 93,314.25 $ 4,862.44 $ 148,662.65
7/5/2015 108 $ 1,080.80 $ 275.54 $ 805.26 $ 116,726.40 $ 22,606.89 $ 94,119.51 $ 5,667.70 $ 148,387.11
8/5/2015 109 $ 1,080.80 $ 277.04 $ 803.76 $ 117,807.20 $ 22,883.93 $ 94,923.27 $ 6,471.46 $ 148,110.07
9/5/2015 110 $ 1,080.80 $ 278.54 $ 802.26 $ 118,888.00 $ 23,162.47 $ 95,725.53 $ 7,273.72 $ 147,831.53
10/5/2015 111 $ 1,080.80 $ 280.05 $ 800.75 $ 119,968.80 $ 23,442.52 $ 96,526.28 $ 8,074.47 $ 147,551.48
11/5/2015 112 $ 1,080.80 $ 281.56 $ 799.24 $ 121,049.60 $ 23,724.08 $ 97,325.52 $ 8,873.71 $ 147,269.92
12/5/2015 113 $ 1,080.80 $ 283.09 $ 797.71 $ 122,130.40 $ 24,007.17 $ 98,123.23 $ 9,671.42 $ 146,986.83
1/5/2016 114 $ 1,080.80 $ 284.62 $ 796.18 $ 123,211.20 $ 24,291.79 $ 98,919.41 $ 796.18 $ 146,702.21
2/5/2016 115 $ 1,080.80 $ 286.16 $ 794.64 $ 124,292.00 $ 24,577.95 $ 99,714.05 $ 1,590.82 $ 146,416.05
3/5/2016 116 $ 1,080.80 $ 287.71 $ 793.09 $ 125,372.80 $ 24,865.66 $ 100,507.14 $ 2,383.91 $ 146,128.34
4/5/2016 117 $ 1,080.80 $ 289.27 $ 791.53 $ 126,453.60 $ 25,154.93 $ 101,298.67 $ 3,175.44 $ 145,839.07
5/5/2016 118 $ 1,080.80 $ 290.84 $ 789.96 $ 127,534.40 $ 25,445.77 $ 102,088.63 $ 3,965.40 $ 145,548.23
6/5/2016 119 $ 1,080.80 $ 292.41 $ 788.39 $ 128,615.20 $ 25,738.18 $ 102,877.02 $ 4,753.79 $ 145,255.82
7/5/2016 120 $ 1,080.80 $ 294.00 $ 786.80 $ 129,696.00 $ 26,032.18 $ 103,663.82 $ 5,540.59 $ 144,961.82
8/5/2016 121 $ 1,080.80 $ 295.59 $ 785.21 $ 130,776.80 $ 26,327.77 $ 104,449.03 $ 6,325.80 $ 144,666.23
9/5/2016 122 $ 1,080.80 $ 297.19 $ 783.61 $ 131,857.60 $ 26,624.96 $ 105,232.64 $ 7,109.41 $ 144,369.04
10/5/2016 123 $ 1,080.80 $ 298.80 $ 782.00 $ 132,938.40 $ 26,923.76 $ 106,014.64 $ 7,891.41 $ 144,070.24
11/5/2016 124 $ 1,080.80 $ 300.42 $ 780.38 $ 134,019.20 $ 27,224.18 $ 106,795.02 $ 8,671.79 $ 143,769.82
12/5/2016 125 $ 1,080.80 $ 302.05 $ 778.75 $ 135,100.00 $ 27,526.23 $ 107,573.77 $ 9,450.54 $ 143,467.77
1/5/2017 126 $ 1,080.80 $ 303.68 $ 777.12 $ 136,180.80 $ 27,829.91 $ 108,350.89 $ 777.12 $ 143,164.09
2/5/2017 127 $ 1,080.80 $ 305.33 $ 775.47 $ 137,261.60 $ 28,135.24 $ 109,126.36 $ 1,552.59 $ 142,858.76
3/5/2017 128 $ 1,080.80 $ 306.98 $ 773.82 $ 138,342.40 $ 28,442.22 $ 109,900.18 $ 2,326.41 $ 142,551.78
4/5/2017 129 $ 1,080.80 $ 308.64 $ 772.16 $ 139,423.20 $ 28,750.86 $ 110,672.34 $ 3,098.57 $ 142,243.14
5/5/2017 130 $ 1,080.80 $ 310.32 $ 770.48 $ 140,504.00 $ 29,061.18 $ 111,442.82 $ 3,869.05 $ 141,932.82
6/5/2017 131 $ 1,080.80 $ 312.00 $ 768.80 $ 141,584.80 $ 29,373.18 $ 112,211.62 $ 4,637.85 $ 141,620.82
7/5/2017 132 $ 1,080.80 $ 313.69 $ 767.11 $ 142,665.60 $ 29,686.87 $ 112,978.73 $ 5,404.96 $ 141,307.13
8/5/2017 133 $ 1,080.80 $ 315.39 $ 765.41 $ 143,746.40 $ 30,002.26 $ 113,744.14 $ 6,170.37 $ 140,991.74
9/5/2017 134 $ 1,080.80 $ 317.09 $ 763.71 $ 144,827.20 $ 30,319.35 $ 114,507.85 $ 6,934.08 $ 140,674.65
10/5/2017 135 $ 1,080.80 $ 318.81 $ 761.99 $ 145,908.00 $ 30,638.16 $ 115,269.84 $ 7,696.07 $ 140,355.84
11/5/2017 136 $ 1,080.80 $ 320.54 $ 760.26 $ 146,988.80 $ 30,958.70 $ 116,030.10 $ 8,456.33 $ 140,035.30
12/5/2017 137 $ 1,080.80 $ 322.28 $ 758.52 $ 148,069.60 $ 31,280.98 $ 116,788.62 $ 9,214.85 $ 139,713.02
1/5/2018 138 $ 1,080.80 $ 324.02 $ 756.78 $ 149,150.40 $ 31,605.00 $ 117,545.40 $ 756.78 $ 139,389.00
2/5/2018 139 $ 1,080.80 $ 325.78 $ 755.02 $ 150,231.20 $ 31,930.78 $ 118,300.42 $ 1,511.80 $ 139,063.22
3/5/2018 140 $ 1,080.80 $ 327.54 $ 753.26 $ 151,312.00 $ 32,258.32 $ 119,053.68 $ 2,265.06 $ 138,735.68
4/5/2018 141 $ 1,080.80 $ 329.32 $ 751.48 $ 152,392.80 $ 32,587.64 $ 119,805.16 $ 3,016.54 $ 138,406.36
5/5/2018 142 $ 1,080.80 $ 331.10 $ 749.70 $ 153,473.60 $ 32,918.74 $ 120,554.86 $ 3,766.24 $ 138,075.26
6/5/2018 143 $ 1,080.80 $ 332.89 $ 747.91 $ 154,554.40 $ 33,251.63 $ 121,302.77 $ 4,514.15 $ 137,742.37
7/5/2018 144 $ 1,080.80 $ 334.70 $ 746.10 $ 155,635.20 $ 33,586.33 $ 122,048.87 $ 5,260.25 $ 137,407.67
8/5/2018 145 $ 1,080.80 $ 336.51 $ 744.29 $ 156,716.00 $ 33,922.84 $ 122,793.16 $ 6,004.54 $ 137,071.16
9/5/2018 146 $ 1,080.80 $ 338.33 $ 742.47 $ 157,796.80 $ 34,261.17 $ 123,535.63 $ 6,747.01 $ 136,732.83
10/5/2018 147 $ 1,080.80 $ 340.16 $ 740.64 $ 158,877.60 $ 34,601.33 $ 124,276.27 $ 7,487.65 $ 136,392.67
11/5/2018 148 $ 1,080.80 $ 342.01 $ 738.79 $ 159,958.40 $ 34,943.34 $ 125,015.06 $ 8,226.44 $ 136,050.66
12/5/2018 149 $ 1,080.80 $ 343.86 $ 736.94 $ 161,039.20 $ 35,287.20 $ 125,752.00 $ 8,963.38 $ 135,706.80
1/5/2019 150 $ 1,080.80 $ 345.72 $ 735.08 $ 162,120.00 $ 35,632.92 $ 126,487.08 $ 735.08 $ 135,361.08
2/5/2019 151 $ 1,080.80 $ 347.59 $ 733.21 $ 163,200.80 $ 35,980.51 $ 127,220.29 $ 1,468.29 $ 135,013.49
3/5/2019 152 $ 1,080.80 $ 349.48 $ 731.32 $ 164,281.60 $ 36,329.99 $ 127,951.61 $ 2,199.61 $ 134,664.01
4/5/2019 153 $ 1,080.80 $ 351.37 $ 729.43 $ 165,362.40 $ 36,681.36 $ 128,681.04 $ 2,929.04 $ 134,312.64
5/5/2019 154 $ 1,080.80 $ 353.27 $ 727.53 $ 166,443.20 $ 37,034.63 $ 129,408.57 $ 3,656.57 $ 133,959.37
6/5/2019 155 $ 1,080.80 $ 355.19 $ 725.61 $ 167,524.00 $ 37,389.82 $ 130,134.18 $ 4,382.18 $ 133,604.18
7/5/2019 156 $ 1,080.80 $ 357.11 $ 723.69 $ 168,604.80 $ 37,746.93 $ 130,857.87 $ 5,105.87 $ 133,247.07
8/5/2019 157 $ 1,080.80 $ 359.05 $ 721.75 $ 169,685.60 $ 38,105.98 $ 131,579.62 $ 5,827.62 $ 132,888.02
9/5/2019 158 $ 1,080.80 $ 360.99 $ 719.81 $ 170,766.40 $ 38,466.97 $ 132,299.43 $ 6,547.43 $ 132,527.03
10/5/2019 159 $ 1,080.80 $ 362.95 $ 717.85 $ 171,847.20 $ 38,829.92 $ 133,017.28 $ 7,265.28 $ 132,164.08
11/5/2019 160 $ 1,080.80 $ 364.91 $ 715.89 $ 172,928.00 $ 39,194.83 $ 133,733.17 $ 7,981.17 $ 131,799.17
12/5/2019 161 $ 1,080.80 $ 366.89 $ 713.91 $ 174,008.80 $ 39,561.72 $ 134,447.08 $ 8,695.08 $ 131,432.28
1/5/2020 162 $ 1,080.80 $ 368.88 $ 711.92 $ 175,089.60 $ 39,930.60 $ 135,159.00 $ 711.92 $ 131,063.40
2/5/2020 163 $ 1,080.80 $ 370.87 $ 709.93 $ 176,170.40 $ 40,301.47 $ 135,868.93 $ 1,421.85 $ 130,692.53
3/5/2020 164 $ 1,080.80 $ 372.88 $ 707.92 $ 177,251.20 $ 40,674.35 $ 136,576.85 $ 2,129.77 $ 130,319.65
4/5/2020 165 $ 1,080.80 $ 374.90 $ 705.90 $ 178,332.00 $ 41,049.25 $ 137,282.75 $ 2,835.67 $ 129,944.75
5/5/2020 166 $ 1,080.80 $ 376.93 $ 703.87 $ 179,412.80 $ 41,426.18 $ 137,986.62 $ 3,539.54 $ 129,567.82
6/5/2020 167 $ 1,080.80 $ 378.97 $ 701.83 $ 180,493.60 $ 41,805.15 $ 138,688.45 $ 4,241.37 $ 129,188.85
7/5/2020 168 $ 1,080.80 $ 381.03 $ 699.77 $ 181,574.40 $ 42,186.18 $ 139,388.22 $ 4,941.14 $ 128,807.82
8/5/2020 169 $ 1,080.80 $ 383.09 $ 697.71 $ 182,655.20 $ 42,569.27 $ 140,085.93 $ 5,638.85 $ 128,424.73
9/5/2020 170 $ 1,080.80 $ 385.17 $ 695.63 $ 183,736.00 $ 42,954.44 $ 140,781.56 $ 6,334.48 $ 128,039.56
10/5/2020 171 $ 1,080.80 $ 387.25 $ 693.55 $ 184,816.80 $ 43,341.69 $ 141,475.11 $ 7,028.03 $ 127,652.31
11/5/2020 172 $ 1,080.80 $ 389.35 $ 691.45 $ 185,897.60 $ 43,731.04 $ 142,166.56 $ 7,719.48 $ 127,262.96
12/5/2020 173 $ 1,080.80 $ 391.46 $ 689.34 $ 186,978.40 $ 44,122.50 $ 142,855.90 $ 8,408.82 $ 126,871.50
1/5/2021 174 $ 1,080.80 $ 393.58 $ 687.22 $ 188,059.20 $ 44,516.08 $ 143,543.12 $ 687.22 $ 126,477.92
2/5/2021 175 $ 1,080.80 $ 395.71 $ 685.09 $ 189,140.00 $ 44,911.79 $ 144,228.21 $ 1,372.31 $ 126,082.21
3/5/2021 176 $ 1,080.80 $ 397.85 $ 682.95 $ 190,220.80 $ 45,309.64 $ 144,911.16 $ 2,055.26 $ 125,684.36
4/5/2021 177 $ 1,080.80 $ 400.01 $ 680.79 $ 191,301.60 $ 45,709.65 $ 145,591.95 $ 2,736.05 $ 125,284.35
5/5/2021 178 $ 1,080.80 $ 402.18 $ 678.62 $ 192,382.40 $ 46,111.83 $ 146,270.57 $ 3,414.67 $ 124,882.17
6/5/2021 179 $ 1,080.80 $ 404.35 $ 676.45 $ 193,463.20 $ 46,516.18 $ 146,947.02 $ 4,091.12 $ 124,477.82
7/5/2021 180 $ 1,080.80 $ 406.55 $ 674.25 $ 194,544.00 $ 46,922.73 $ 147,621.27 $ 4,765.37 $ 124,071.27
8/5/2021 181 $ 1,080.80 $ 408.75 $ 672.05 $ 195,624.80 $ 47,331.48 $ 148,293.32 $ 5,437.42 $ 123,662.52
9/5/2021 182 $ 1,080.80 $ 410.96 $ 669.84 $ 196,705.60 $ 47,742.44 $ 148,963.16 $ 6,107.26 $ 123,251.56
10/5/2021 183 $ 1,080.80 $ 413.19 $ 667.61 $ 197,786.40 $ 48,155.63 $ 149,630.77 $ 6,774.87 $ 122,838.37
11/5/2021 184 $ 1,080.80 $ 415.43 $ 665.37 $ 198,867.20 $ 48,571.06 $ 150,296.14 $ 7,440.24 $ 122,422.94
12/5/2021 185 $ 1,080.80 $ 417.68 $ 663.12 $ 199,948.00 $ 48,988.74 $ 150,959.26 $ 8,103.36 $ 122,005.26
1/5/2022 186 $ 1,080.80 $ 419.94 $ 660.86 $ 201,028.80 $ 49,408.68 $ 151,620.12 $ 660.86 $ 121,585.32
2/5/2022 187 $ 1,080.80 $ 422.21 $ 658.59 $ 202,109.60 $ 49,830.89 $ 152,278.71 $ 1,319.45 $ 121,163.11
3/5/2022 188 $ 1,080.80 $ 424.50 $ 656.30 $ 203,190.40 $ 50,255.39 $ 152,935.01 $ 1,975.75 $ 120,738.61
4/5/2022 189 $ 1,080.80 $ 426.80 $ 654.00 $ 204,271.20 $ 50,682.19 $ 153,589.01 $ 2,629.75 $ 120,311.81
5/5/2022 190 $ 1,080.80 $ 429.11 $ 651.69 $ 205,352.00 $ 51,111.30 $ 154,240.70 $ 3,281.44 $ 119,882.70
6/5/2022 191 $ 1,080.80 $ 431.44 $ 649.36 $ 206,432.80 $ 51,542.74 $ 154,890.06 $ 3,930.80 $ 119,451.26
7/5/2022 192 $ 1,080.80 $ 433.77 $ 647.03 $ 207,513.60 $ 51,976.51 $ 155,537.09 $ 4,577.83 $ 119,017.49
8/5/2022 193 $ 1,080.80 $ 436.12 $ 644.68 $ 208,594.40 $ 52,412.63 $ 156,181.77 $ 5,222.51 $ 118,581.37
9/5/2022 194 $ 1,080.80 $ 438.48 $ 642.32 $ 209,675.20 $ 52,851.11 $ 156,824.09 $ 5,864.83 $ 118,142.89
10/5/2022 195 $ 1,080.80 $ 440.86 $ 639.94 $ 210,756.00 $ 53,291.97 $ 157,464.03 $ 6,504.77 $ 117,702.03
11/5/2022 196 $ 1,080.80 $ 443.25 $ 637.55 $ 211,836.80 $ 53,735.22 $ 158,101.58 $ 7,142.32 $ 117,258.78
12/5/2022 197 $ 1,080.80 $ 445.65 $ 635.15 $ 212,917.60 $ 54,180.87 $ 158,736.73 $ 7,777.47 $ 116,813.13
1/5/2023 198 $ 1,080.80 $ 448.06 $ 632.74 $ 213,998.40 $ 54,628.93 $ 159,369.47 $ 632.74 $ 116,365.07
2/5/2023 199 $ 1,080.80 $ 450.49 $ 630.31 $ 215,079.20 $ 55,079.42 $ 159,999.78 $ 1,263.05 $ 115,914.58
3/5/2023 200 $ 1,080.80 $ 452.93 $ 627.87 $ 216,160.00 $ 55,532.35 $ 160,627.65 $ 1,890.92 $ 115,461.65
4/5/2023 201 $ 1,080.80 $ 455.38 $ 625.42 $ 217,240.80 $ 55,987.73 $ 161,253.07 $ 2,516.34 $ 115,006.27
5/5/2023 202 $ 1,080.80 $ 457.85 $ 622.95 $ 218,321.60 $ 56,445.58 $ 161,876.02 $ 3,139.29 $ 114,548.42
6/5/2023 203 $ 1,080.80 $ 460.33 $ 620.47 $ 219,402.40 $ 56,905.91 $ 162,496.49 $ 3,759.76 $ 114,088.09
7/5/2023 204 $ 1,080.80 $ 462.82 $ 617.98 $ 220,483.20 $ 57,368.73 $ 163,114.47 $ 4,377.74 $ 113,625.27
8/5/2023 205 $ 1,080.80 $ 465.33 $ 615.47 $ 221,564.00 $ 57,834.06 $ 163,729.94 $ 4,993.21 $ 113,159.94
9/5/2023 206 $ 1,080.80 $ 467.85 $ 612.95 $ 222,644.80 $ 58,301.91 $ 164,342.89 $ 5,606.16 $ 112,692.09
10/5/2023 207 $ 1,080.80 $ 470.38 $ 610.42 $ 223,725.60 $ 58,772.29 $ 164,953.31 $ 6,216.58 $ 112,221.71
11/5/2023 208 $ 1,080.80 $ 472.93 $ 607.87 $ 224,806.40 $ 59,245.22 $ 165,561.18 $ 6,824.45 $ 111,748.78
12/5/2023 209 $ 1,080.80 $ 475.49 $ 605.31 $ 225,887.20 $ 59,720.71 $ 166,166.49 $ 7,429.76 $ 111,273.29
1/5/2024 210 $ 1,080.80 $ 478.07 $ 602.73 $ 226,968.00 $ 60,198.78 $ 166,769.22 $ 602.73 $ 110,795.22
2/5/2024 211 $ 1,080.80 $ 480.66 $ 600.14 $ 228,048.80 $ 60,679.44 $ 167,369.36 $ 1,202.87 $ 110,314.56
3/5/2024 212 $ 1,080.80 $ 483.26 $ 597.54 $ 229,129.60 $ 61,162.70 $ 167,966.90 $ 1,800.41 $ 109,831.30
4/5/2024 213 $ 1,080.80 $ 485.88 $ 594.92 $ 230,210.40 $ 61,648.58 $ 168,561.82 $ 2,395.33 $ 109,345.42
5/5/2024 214 $ 1,080.80 $ 488.51 $ 592.29 $ 231,291.20 $ 62,137.09 $ 169,154.11 $ 2,987.62 $ 108,856.91
6/5/2024 215 $ 1,080.80 $ 491.16 $ 589.64 $ 232,372.00 $ 62,628.25 $ 169,743.75 $ 3,577.26 $ 108,365.75
7/5/2024 216 $ 1,080.80 $ 493.82 $ 586.98 $ 233,452.80 $ 63,122.07 $ 170,330.73 $ 4,164.24 $ 107,871.93
8/5/2024 217 $ 1,080.80 $ 496.49 $ 584.31 $ 234,533.60 $ 63,618.56 $ 170,915.04 $ 4,748.55 $ 107,375.44
9/5/2024 218 $ 1,080.80 $ 499.18 $ 581.62 $ 235,614.40 $ 64,117.74 $ 171,496.66 $ 5,330.17 $ 106,876.26
10/5/2024 219 $ 1,080.80 $ 501.89 $ 578.91 $ 236,695.20 $ 64,619.63 $ 172,075.57 $ 5,909.08 $ 106,374.37
11/5/2024 220 $ 1,080.80 $ 504.61 $ 576.19 $ 237,776.00 $ 65,124.24 $ 172,651.76 $ 6,485.27 $ 105,869.76
12/5/2024 221 $ 1,080.80 $ 507.34 $ 573.46 $ 238,856.80 $ 65,631.58 $ 173,225.22 $ 7,058.73 $ 105,362.42
1/5/2025 222 $ 1,080.80 $ 510.09 $ 570.71 $ 239,937.60 $ 66,141.67 $ 173,795.93 $ 570.71 $ 104,852.33
2/5/2025 223 $ 1,080.80 $ 512.85 $ 567.95 $ 241,018.40 $ 66,654.52 $ 174,363.88 $ 1,138.66 $ 104,339.48
3/5/2025 224 $ 1,080.80 $ 515.63 $ 565.17 $ 242,099.20 $ 67,170.15 $ 174,929.05 $ 1,703.83 $ 103,823.85
4/5/2025 225 $ 1,080.80 $ 518.42 $ 562.38 $ 243,180.00 $ 67,688.57 $ 175,491.43 $ 2,266.21 $ 103,305.43
5/5/2025 226 $ 1,080.80 $ 521.23 $ 559.57 $ 244,260.80 $ 68,209.80 $ 176,051.00 $ 2,825.78 $ 102,784.20
6/5/2025 227 $ 1,080.80 $ 524.05 $ 556.75 $ 245,341.60 $ 68,733.85 $ 176,607.75 $ 3,382.53 $ 102,260.15
7/5/2025 228 $ 1,080.80 $ 526.89 $ 553.91 $ 246,422.40 $ 69,260.74 $ 177,161.66 $ 3,936.44 $ 101,733.26
8/5/2025 229 $ 1,080.80 $ 529.74 $ 551.06 $ 247,503.20 $ 69,790.48 $ 177,712.72 $ 4,487.50 $ 101,203.52
9/5/2025 230 $ 1,080.80 $ 532.61 $ 548.19 $ 248,584.00 $ 70,323.09 $ 178,260.91 $ 5,035.69 $ 100,670.91
10/5/2025 231 $ 1,080.80 $ 535.50 $ 545.30 $ 249,664.80 $ 70,858.59 $ 178,806.21 $ 5,580.99 $ 100,135.41
11/5/2025 232 $ 1,080.80 $ 538.40 $ 542.40 $ 250,745.60 $ 71,396.99 $ 179,348.61 $ 6,123.39 $ 99,597.01
12/5/2025 233 $ 1,080.80 $ 541.32 $ 539.48 $ 251,826.40 $ 71,938.31 $ 179,888.09 $ 6,662.87 $ 99,055.69
1/5/2026 234 $ 1,080.80 $ 544.25 $ 536.55 $ 252,907.20 $ 72,482.56 $ 180,424.64 $ 536.55 $ 98,511.44
2/5/2026 235 $ 1,080.80 $ 547.20 $ 533.60 $ 253,988.00 $ 73,029.76 $ 180,958.24 $ 1,070.15 $ 97,964.24
3/5/2026 236 $ 1,080.80 $ 550.16 $ 530.64 $ 255,068.80 $ 73,579.92 $ 181,488.88 $ 1,600.79 $ 97,414.08
4/5/2026 237 $ 1,080.80 $ 553.14 $ 527.66 $ 256,149.60 $ 74,133.06 $ 182,016.54 $ 2,128.45 $ 96,860.94
5/5/2026 238 $ 1,080.80 $ 556.14 $ 524.66 $ 257,230.40 $ 74,689.20 $ 182,541.20 $ 2,653.11 $ 96,304.80
6/5/2026 239 $ 1,080.80 $ 559.15 $ 521.65 $ 258,311.20 $ 75,248.35 $ 183,062.85 $ 3,174.76 $ 95,745.65
7/5/2026 240 $ 1,080.80 $ 562.18 $ 518.62 $ 259,392.00 $ 75,810.53 $ 183,581.47 $ 3,693.38 $ 95,183.47
8/5/2026 241 $ 1,080.80 $ 565.22 $ 515.58 $ 260,472.80 $ 76,375.75 $ 184,097.05 $ 4,208.96 $ 94,618.25
9/5/2026 242 $ 1,080.80 $ 568.28 $ 512.52 $ 261,553.60 $ 76,944.03 $ 184,609.57 $ 4,721.48 $ 94,049.97
10/5/2026 243 $ 1,080.80 $ 571.36 $ 509.44 $ 262,634.40 $ 77,515.39 $ 185,119.01 $ 5,230.92 $ 93,478.61
11/5/2026 244 $ 1,080.80 $ 574.46 $ 506.34 $ 263,715.20 $ 78,089.85 $ 185,625.35 $ 5,737.26 $ 92,904.15
12/5/2026 245 $ 1,080.80 $ 577.57 $ 503.23 $ 264,796.00 $ 78,667.42 $ 186,128.58 $ 6,240.49 $ 92,326.58
1/5/2027 246 $ 1,080.80 $ 580.70 $ 500.10 $ 265,876.80 $ 79,248.12 $ 186,628.68 $ 500.10 $ 91,745.88
2/5/2027 247 $ 1,080.80 $ 583.84 $ 496.96 $ 266,957.60 $ 79,831.96 $ 187,125.64 $ 997.06 $ 91,162.04
3/5/2027 248 $ 1,080.80 $ 587.01 $ 493.79 $ 268,038.40 $ 80,418.97 $ 187,619.43 $ 1,490.85 $ 90,575.03
4/5/2027 249 $ 1,080.80 $ 590.19 $ 490.61 $ 269,119.20 $ 81,009.16 $ 188,110.04 $ 1,981.46 $ 89,984.84
5/5/2027 250 $ 1,080.80 $ 593.38 $ 487.42 $ 270,200.00 $ 81,602.54 $ 188,597.46 $ 2,468.88 $ 89,391.46
6/5/2027 251 $ 1,080.80 $ 596.60 $ 484.20 $ 271,280.80 $ 82,199.14 $ 189,081.66 $ 2,953.08 $ 88,794.86
7/5/2027 252 $ 1,080.80 $ 599.83 $ 480.97 $ 272,361.60 $ 82,798.97 $ 189,562.63 $ 3,434.05 $ 88,195.03
8/5/2027 253 $ 1,080.80 $ 603.08 $ 477.72 $ 273,442.40 $ 83,402.05 $ 190,040.35 $ 3,911.77 $ 87,591.95
9/5/2027 254 $ 1,080.80 $ 606.34 $ 474.46 $ 274,523.20 $ 84,008.39 $ 190,514.81 $ 4,386.23 $ 86,985.61
10/5/2027 255 $ 1,080.80 $ 609.63 $ 471.17 $ 275,604.00 $ 84,618.02 $ 190,985.98 $ 4,857.40 $ 86,375.98
11/5/2027 256 $ 1,080.80 $ 612.93 $ 467.87 $ 276,684.80 $ 85,230.95 $ 191,453.85 $ 5,325.27 $ 85,763.05
12/5/2027 257 $ 1,080.80 $ 616.25 $ 464.55 $ 277,765.60 $ 85,847.20 $ 191,918.40 $ 5,789.82 $ 85,146.80
1/5/2028 258 $ 1,080.80 $ 619.59 $ 461.21 $ 278,846.40 $ 86,466.79 $ 192,379.61 $ 461.21 $ 84,527.21
2/5/2028 259 $ 1,080.80 $ 622.94 $ 457.86 $ 279,927.20 $ 87,089.73 $ 192,837.47 $ 919.07 $ 83,904.27
3/5/2028 260 $ 1,080.80 $ 626.32 $ 454.48 $ 281,008.00 $ 87,716.05 $ 193,291.95 $ 1,373.55 $ 83,277.95
4/5/2028 261 $ 1,080.80 $ 629.71 $ 451.09 $ 282,088.80 $ 88,345.76 $ 193,743.04 $ 1,824.64 $ 82,648.24
5/5/2028 262 $ 1,080.80 $ 633.12 $ 447.68 $ 283,169.60 $ 88,978.88 $ 194,190.72 $ 2,272.32 $ 82,015.12
6/5/2028 263 $ 1,080.80 $ 636.55 $ 444.25 $ 284,250.40 $ 89,615.43 $ 194,634.97 $ 2,716.57 $ 81,378.57
7/5/2028 264 $ 1,080.80 $ 640.00 $ 440.80 $ 285,331.20 $ 90,255.43 $ 195,075.77 $ 3,157.37 $ 80,738.57
8/5/2028 265 $ 1,080.80 $ 643.47 $ 437.33 $ 286,412.00 $ 90,898.90 $ 195,513.10 $ 3,594.70 $ 80,095.10
9/5/2028 266 $ 1,080.80 $ 646.95 $ 433.85 $ 287,492.80 $ 91,545.85 $ 195,946.95 $ 4,028.55 $ 79,448.15
10/5/2028 267 $ 1,080.80 $ 650.46 $ 430.34 $ 288,573.60 $ 92,196.31 $ 196,377.29 $ 4,458.89 $ 78,797.69
11/5/2028 268 $ 1,080.80 $ 653.98 $ 426.82 $ 289,654.40 $ 92,850.29 $ 196,804.11 $ 4,885.71 $ 78,143.71
12/5/2028 269 $ 1,080.80 $ 657.52 $ 423.28 $ 290,735.20 $ 93,507.81 $ 197,227.39 $ 5,308.99 $ 77,486.19
1/5/2029 270 $ 1,080.80 $ 661.08 $ 419.72 $ 291,816.00 $ 94,168.89 $ 197,647.11 $ 419.72 $ 76,825.11
2/5/2029 271 $ 1,080.80 $ 664.66 $ 416.14 $ 292,896.80 $ 94,833.55 $ 198,063.25 $ 835.86 $ 76,160.45
3/5/2029 272 $ 1,080.80 $ 668.26 $ 412.54 $ 293,977.60 $ 95,501.81 $ 198,475.79 $ 1,248.40 $ 75,492.19
4/5/2029 273 $ 1,080.80 $ 671.88 $ 408.92 $ 295,058.40 $ 96,173.69 $ 198,884.71 $ 1,657.32 $ 74,820.31
5/5/2029 274 $ 1,080.80 $ 675.52 $ 405.28 $ 296,139.20 $ 96,849.21 $ 199,289.99 $ 2,062.60 $ 74,144.79
6/5/2029 275 $ 1,080.80 $ 679.18 $ 401.62 $ 297,220.00 $ 97,528.39 $ 199,691.61 $ 2,464.22 $ 73,465.61
7/5/2029 276 $ 1,080.80 $ 682.86 $ 397.94 $ 298,300.80 $ 98,211.25 $ 200,089.55 $ 2,862.16 $ 72,782.75
8/5/2029 277 $ 1,080.80 $ 686.56 $ 394.24 $ 299,381.60 $ 98,897.81 $ 200,483.79 $ 3,256.40 $ 72,096.19
9/5/2029 278 $ 1,080.80 $ 690.28 $ 390.52 $ 300,462.40 $ 99,588.09 $ 200,874.31 $ 3,646.92 $ 71,405.91
10/5/2029 279 $ 1,080.80 $ 694.02 $ 386.78 $ 301,543.20 $ 100,282.11 $ 201,261.09 $ 4,033.70 $ 70,711.89
11/5/2029 280 $ 1,080.80 $ 697.78 $ 383.02 $ 302,624.00 $ 100,979.89 $ 201,644.11 $ 4,416.72 $ 70,014.11
12/5/2029 281 $ 1,080.80 $ 701.56 $ 379.24 $ 303,704.80 $ 101,681.45 $ 202,023.35 $ 4,795.96 $ 69,312.55
1/5/2030 282 $ 1,080.80 $ 705.36 $ 375.44 $ 304,785.60 $ 102,386.81 $ 202,398.79 $ 375.44 $ 68,607.19
2/5/2030 283 $ 1,080.80 $ 709.18 $ 371.62 $ 305,866.40 $ 103,095.99 $ 202,770.41 $ 747.06 $ 67,898.01
3/5/2030 284 $ 1,080.80 $ 713.02 $ 367.78 $ 306,947.20 $ 103,809.01 $ 203,138.19 $ 1,114.84 $ 67,184.99
4/5/2030 285 $ 1,080.80 $ 716.88 $ 363.92 $ 308,028.00 $ 104,525.89 $ 203,502.11 $ 1,478.76 $ 66,468.11
5/5/2030 286 $ 1,080.80 $ 720.76 $ 360.04 $ 309,108.80 $ 105,246.65 $ 203,862.15 $ 1,838.80 $ 65,747.35
6/5/2030 287 $ 1,080.80 $ 724.67 $ 356.13 $ 310,189.60 $ 105,971.32 $ 204,218.28 $ 2,194.93 $ 65,022.68
7/5/2030 288 $ 1,080.80 $ 728.59 $ 352.21 $ 311,270.40 $ 106,699.91 $ 204,570.49 $ 2,547.14 $ 64,294.09
8/5/2030 289 $ 1,080.80 $ 732.54 $ 348.26 $ 312,351.20 $ 107,432.45 $ 204,918.75 $ 2,895.40 $ 63,561.55
9/5/2030 290 $ 1,080.80 $ 736.51 $ 344.29 $ 313,432.00 $ 108,168.96 $ 205,263.04 $ 3,239.69 $ 62,825.04
10/5/2030 291 $ 1,080.80 $ 740.50 $ 340.30 $ 314,512.80 $ 108,909.46 $ 205,603.34 $ 3,579.99 $ 62,084.54
11/5/2030 292 $ 1,080.80 $ 744.51 $ 336.29 $ 315,593.60 $ 109,653.97 $ 205,939.63 $ 3,916.28 $ 61,340.03
12/5/2030 293 $ 1,080.80 $ 748.54 $ 332.26 $ 316,674.40 $ 110,402.51 $ 206,271.89 $ 4,248.54 $ 60,591.49
1/5/2031 294 $ 1,080.80 $ 752.60 $ 328.20 $ 317,755.20 $ 111,155.11 $ 206,600.09 $ 328.20 $ 59,838.89
2/5/2031 295 $ 1,080.80 $ 756.67 $ 324.13 $ 318,836.00 $ 111,911.78 $ 206,924.22 $ 652.33 $ 59,082.22
3/5/2031 296 $ 1,080.80 $ 760.77 $ 320.03 $ 319,916.80 $ 112,672.55 $ 207,244.25 $ 972.36 $ 58,321.45
4/5/2031 297 $ 1,080.80 $ 764.89 $ 315.91 $ 320,997.60 $ 113,437.44 $ 207,560.16 $ 1,288.27 $ 57,556.56
5/5/2031 298 $ 1,080.80 $ 769.04 $ 311.76 $ 322,078.40 $ 114,206.48 $ 207,871.92 $ 1,600.03 $ 56,787.52
6/5/2031 299 $ 1,080.80 $ 773.20 $ 307.60 $ 323,159.20 $ 114,979.68 $ 208,179.52 $ 1,907.63 $ 56,014.32
7/5/2031 300 $ 1,080.80 $ 777.39 $ 303.41 $ 324,240.00 $ 115,757.07 $ 208,482.93 $ 2,211.04 $ 55,236.93
8/5/2031 301 $ 1,080.80 $ 781.60 $ 299.20 $ 325,320.80 $ 116,538.67 $ 208,782.13 $ 2,510.24 $ 54,455.33
9/5/2031 302 $ 1,080.80 $ 785.83 $ 294.97 $ 326,401.60 $ 117,324.50 $ 209,077.10 $ 2,805.21 $ 53,669.50
10/5/2031 303 $ 1,080.80 $ 790.09 $ 290.71 $ 327,482.40 $ 118,114.59 $ 209,367.81 $ 3,095.92 $ 52,879.41
11/5/2031 304 $ 1,080.80 $ 794.37 $ 286.43 $ 328,563.20 $ 118,908.96 $ 209,654.24 $ 3,382.35 $ 52,085.04
12/5/2031 305 $ 1,080.80 $ 798.67 $ 282.13 $ 329,644.00 $ 119,707.63 $ 209,936.37 $ 3,664.48 $ 51,286.37
1/5/2032 306 $ 1,080.80 $ 803.00 $ 277.80 $ 330,724.80 $ 120,510.63 $ 210,214.17 $ 277.80 $ 50,483.37
2/5/2032 307 $ 1,080.80 $ 807.35 $ 273.45 $ 331,805.60 $ 121,317.98 $ 210,487.62 $ 551.25 $ 49,676.02
3/5/2032 308 $ 1,080.80 $ 811.72 $ 269.08 $ 332,886.40 $ 122,129.70 $ 210,756.70 $ 820.33 $ 48,864.30
4/5/2032 309 $ 1,080.80 $ 816.12 $ 264.68 $ 333,967.20 $ 122,945.82 $ 211,021.38 $ 1,085.01 $ 48,048.18
5/5/2032 310 $ 1,080.80 $ 820.54 $ 260.26 $ 335,048.00 $ 123,766.36 $ 211,281.64 $ 1,345.27 $ 47,227.64
6/5/2032 311 $ 1,080.80 $ 824.98 $ 255.82 $ 336,128.80 $ 124,591.34 $ 211,537.46 $ 1,601.09 $ 46,402.66
7/5/2032 312 $ 1,080.80 $ 829.45 $ 251.35 $ 337,209.60 $ 125,420.79 $ 211,788.81 $ 1,852.44 $ 45,573.21
8/5/2032 313 $ 1,080.80 $ 833.95 $ 246.85 $ 338,290.40 $ 126,254.74 $ 212,035.66 $ 2,099.29 $ 44,739.26
9/5/2032 314 $ 1,080.80 $ 838.46 $ 242.34 $ 339,371.20 $ 127,093.20 $ 212,278.00 $ 2,341.63 $ 43,900.80
10/5/2032 315 $ 1,080.80 $ 843.00 $ 237.80 $ 340,452.00 $ 127,936.20 $ 212,515.80 $ 2,579.43 $ 43,057.80
11/5/2032 316 $ 1,080.80 $ 847.57 $ 233.23 $ 341,532.80 $ 128,783.77 $ 212,749.03 $ 2,812.66 $ 42,210.23
12/5/2032 317 $ 1,080.80 $ 852.16 $ 228.64 $ 342,613.60 $ 129,635.93 $ 212,977.67 $ 3,041.30 $ 41,358.07
1/5/2033 318 $ 1,080.80 $ 856.78 $ 224.02 $ 343,694.40 $ 130,492.71 $ 213,201.69 $ 224.02 $ 40,501.29
2/5/2033 319 $ 1,080.80 $ 861.42 $ 219.38 $ 344,775.20 $ 131,354.13 $ 213,421.07 $ 443.40 $ 39,639.87
3/5/2033 320 $ 1,080.80 $ 866.08 $ 214.72 $ 345,856.00 $ 132,220.21 $ 213,635.79 $ 658.12 $ 38,773.79
4/5/2033 321 $ 1,080.80 $ 870.78 $ 210.02 $ 346,936.80 $ 133,090.99 $ 213,845.81 $ 868.14 $ 37,903.01
5/5/2033 322 $ 1,080.80 $ 875.49 $ 205.31 $ 348,017.60 $ 133,966.48 $ 214,051.12 $ 1,073.45 $ 37,027.52
6/5/2033 323 $ 1,080.80 $ 880.23 $ 200.57 $ 349,098.40 $ 134,846.71 $ 214,251.69 $ 1,274.02 $ 36,147.29
7/5/2033 324 $ 1,080.80 $ 885.00 $ 195.80 $ 350,179.20 $ 135,731.71 $ 214,447.49 $ 1,469.82 $ 35,262.29
8/5/2033 325 $ 1,080.80 $ 889.80 $ 191.00 $ 351,260.00 $ 136,621.51 $ 214,638.49 $ 1,660.82 $ 34,372.49
9/5/2033 326 $ 1,080.80 $ 894.62 $ 186.18 $ 352,340.80 $ 137,516.13 $ 214,824.67 $ 1,847.00 $ 33,477.87
10/5/2033 327 $ 1,080.80 $ 899.46 $ 181.34 $ 353,421.60 $ 138,415.59 $ 215,006.01 $ 2,028.34 $ 32,578.41
11/5/2033 328 $ 1,080.80 $ 904.33 $ 176.47 $ 354,502.40 $ 139,319.92 $ 215,182.48 $ 2,204.81 $ 31,674.08
12/5/2033 329 $ 1,080.80 $ 909.23 $ 171.57 $ 355,583.20 $ 140,229.15 $ 215,354.05 $ 2,376.38 $ 30,764.85
1/5/2034 330 $ 1,080.80 $ 914.16 $ 166.64 $ 356,664.00 $ 141,143.31 $ 215,520.69 $ 166.64 $ 29,850.69
2/5/2034 331 $ 1,080.80 $ 919.11 $ 161.69 $ 357,744.80 $ 142,062.42 $ 215,682.38 $ 328.33 $ 28,931.58
3/5/2034 332 $ 1,080.80 $ 924.09 $ 156.71 $ 358,825.60 $ 142,986.51 $ 215,839.09 $ 485.04 $ 28,007.49
4/5/2034 333 $ 1,080.80 $ 929.09 $ 151.71 $ 359,906.40 $ 143,915.60 $ 215,990.80 $ 636.75 $ 27,078.40
5/5/2034 334 $ 1,080.80 $ 934.13 $ 146.67 $ 360,987.20 $ 144,849.73 $ 216,137.47 $ 783.42 $ 26,144.27
6/5/2034 335 $ 1,080.80 $ 939.19 $ 141.61 $ 362,068.00 $ 145,788.92 $ 216,279.08 $ 925.03 $ 25,205.08
7/5/2034 336 $ 1,080.80 $ 944.27 $ 136.53 $ 363,148.80 $ 146,733.19 $ 216,415.61 $ 1,061.56 $ 24,260.81
8/5/2034 337 $ 1,080.80 $ 949.39 $ 131.41 $ 364,229.60 $ 147,682.58 $ 216,547.02 $ 1,192.97 $ 23,311.42
9/5/2034 338 $ 1,080.80 $ 954.53 $ 126.27 $ 365,310.40 $ 148,637.11 $ 216,673.29 $ 1,319.24 $ 22,356.89
10/5/2034 339 $ 1,080.80 $ 959.70 $ 121.10 $ 366,391.20 $ 149,596.81 $ 216,794.39 $ 1,440.34 $ 21,397.19
11/5/2034 340 $ 1,080.80 $ 964.90 $ 115.90 $ 367,472.00 $ 150,561.71 $ 216,910.29 $ 1,556.24 $ 20,432.29
12/5/2034 341 $ 1,080.80 $ 970.13 $ 110.67 $ 368,552.80 $ 151,531.84 $ 217,020.96 $ 1,666.91 $ 19,462.16
1/5/2035 342 $ 1,080.80 $ 975.38 $ 105.42 $ 369,633.60 $ 152,507.22 $ 217,126.38 $ 105.42 $ 18,486.78
2/5/2035 343 $ 1,080.80 $ 980.66 $ 100.14 $ 370,714.40 $ 153,487.88 $ 217,226.52 $ 205.56 $ 17,506.12
3/5/2035 344 $ 1,080.80 $ 985.98 $ 94.82 $ 371,795.20 $ 154,473.86 $ 217,321.34 $ 300.38 $ 16,520.14
4/5/2035 345 $ 1,080.80 $ 991.32 $ 89.48 $ 372,876.00 $ 155,465.18 $ 217,410.82 $ 389.86 $ 15,528.82
5/5/2035 346 $ 1,080.80 $ 996.69 $ 84.11 $ 373,956.80 $ 156,461.87 $ 217,494.93 $ 473.97 $ 14,532.13
6/5/2035 347 $ 1,080.80 $ 1,002.08 $ 78.72 $ 375,037.60 $ 157,463.95 $ 217,573.65 $ 552.69 $ 13,530.05
7/5/2035 348 $ 1,080.80 $ 1,007.51 $ 73.29 $ 376,118.40 $ 158,471.46 $ 217,646.94 $ 625.98 $ 12,522.54
8/5/2035 349 $ 1,080.80 $ 1,012.97 $ 67.83 $ 377,199.20 $ 159,484.43 $ 217,714.77 $ 693.81 $ 11,509.57
9/5/2035 350 $ 1,080.80 $ 1,018.46 $ 62.34 $ 378,280.00 $ 160,502.89 $ 217,777.11 $ 756.15 $ 10,491.11
10/5/2035 351 $ 1,080.80 $ 1,023.97 $ 56.83 $ 379,360.80 $ 161,526.86 $ 217,833.94 $ 812.98 $ 9,467.14
11/5/2035 352 $ 1,080.80 $ 1,029.52 $ 51.28 $ 380,441.60 $ 162,556.38 $ 217,885.22 $ 864.26 $ 8,437.62
12/5/2035 353 $ 1,080.80 $ 1,035.10 $ 45.70 $ 381,522.40 $ 163,591.48 $ 217,930.92 $ 909.96 $ 7,402.52
1/5/2036 354 $ 1,080.80 $ 1,040.70 $ 40.10 $ 382,603.20 $ 164,632.18 $ 217,971.02 $ 40.10 $ 6,361.82
2/5/2036 355 $ 1,080.80 $ 1,046.34 $ 34.46 $ 383,684.00 $ 165,678.52 $ 218,005.48 $ 74.56 $ 5,315.48
3/5/2036 356 $ 1,080.80 $ 1,052.01 $ 28.79 $ 384,764.80 $ 166,730.53 $ 218,034.27 $ 103.35 $ 4,263.47
4/5/2036 357 $ 1,080.80 $ 1,057.71 $ 23.09 $ 385,845.60 $ 167,788.24 $ 218,057.36 $ 126.44 $ 3,205.76
5/5/2036 358 $ 1,080.80 $ 1,063.44 $ 17.36 $ 386,926.40 $ 168,851.68 $ 218,074.72 $ 143.80 $ 2,142.32
6/5/2036 359 $ 1,080.80 $ 1,069.20 $ 11.60 $ 388,007.20 $ 169,920.88 $ 218,086.32 $ 155.40 $ 1,073.12
7/5/2036 360 $ 1,078.93 $ 1,073.12 $ 5.81 $ 389,086.13 $ 170,994.00 $ 218,092.13 $ 161.21 $ -
2nd Loan (Mostly Implemented)
Notes
- Gray areas are to be filled out. Only adjust other areas when needed. Be very careful when changing formulas.
- Take careful note of Date calculation in Date column.
- Notice the Yearly Interest column is based on Month in the Date column.
- Monthly loan payment will be based on calculation if nothing is entered into Different Payment (D20).
- Notice Payment column will stop early when principal is paid off.
- Final payment includes the Balloon payment if used.
Starting Date 7/5/2006 Improvements Land Value Total Value (should match Purchase Price)
Purchase Price $ - $ - $ - $ -
Down Payment $ - 0% =% Down
Points % 3% $ - = Points
Fees $ - Closing Costs = Points + Fees???
Balloon Pmt $ - $ -
Interest Rate 8.50% 0.71% = Monthly Interest Rate
Term (years) 30 360 = Months
Different Payment $ - $ - = Payment Difference
Loan Amount $ - P&I Calculated Int Only
Loan Payment $ - $ - $ -
Total Interest Paid $ - $ - = underpayment due to decreased monthly payments (for 30y loan only).
Date Month Payment Principal Interest Total Total Total Yearly Ending
Paid Principal Interest Interest Balance
7/5/2006 0 $ - $ - $ - $ - $ - $ - $ -
8/5/2006 1 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2006 2 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2006 3 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2006 4 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2006 5 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2007 6 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2007 7 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2007 8 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2007 9 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2007 10 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2007 11 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2007 12 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2007 13 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2007 14 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2007 15 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2007 16 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2007 17 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2008 18 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2008 19 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2008 20 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2008 21 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2008 22 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2008 23 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2008 24 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2008 25 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2008 26 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2008 27 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2008 28 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2008 29 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2009 30 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2009 31 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2009 32 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2009 33 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2009 34 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2009 35 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2009 36 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2009 37 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2009 38 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2009 39 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2009 40 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2009 41 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2010 42 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2010 43 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2010 44 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2010 45 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2010 46 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2010 47 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2010 48 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2010 49 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2010 50 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2010 51 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2010 52 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2010 53 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2011 54 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2011 55 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2011 56 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2011 57 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2011 58 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2011 59 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2011 60 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2011 61 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2011 62 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2011 63 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2011 64 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2011 65 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2012 66 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2012 67 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2012 68 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2012 69 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2012 70 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2012 71 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2012 72 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2012 73 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2012 74 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2012 75 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2012 76 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2012 77 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2013 78 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2013 79 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2013 80 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2013 81 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2013 82 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2013 83 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2013 84 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2013 85 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2013 86 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2013 87 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2013 88 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2013 89 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2014 90 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2014 91 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2014 92 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2014 93 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2014 94 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2014 95 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2014 96 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2014 97 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2014 98 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2014 99 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2014 100 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2014 101 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2015 102 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2015 103 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2015 104 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2015 105 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2015 106 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2015 107 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2015 108 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2015 109 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2015 110 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2015 111 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2015 112 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2015 113 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2016 114 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2016 115 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2016 116 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2016 117 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2016 118 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2016 119 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2016 120 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2016 121 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2016 122 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2016 123 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2016 124 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2016 125 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2017 126 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2017 127 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2017 128 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2017 129 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2017 130 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2017 131 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2017 132 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2017 133 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2017 134 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2017 135 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2017 136 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2017 137 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2018 138 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2018 139 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2018 140 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2018 141 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2018 142 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2018 143 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2018 144 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2018 145 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2018 146 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2018 147 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2018 148 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2018 149 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2019 150 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2019 151 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2019 152 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2019 153 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2019 154 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2019 155 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2019 156 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2019 157 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2019 158 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2019 159 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2019 160 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2019 161 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2020 162 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2020 163 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2020 164 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2020 165 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2020 166 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2020 167 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2020 168 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2020 169 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2020 170 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2020 171 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2020 172 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2020 173 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2021 174 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2021 175 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2021 176 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2021 177 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2021 178 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2021 179 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2021 180 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2021 181 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2021 182 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2021 183 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2021 184 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2021 185 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2022 186 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2022 187 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2022 188 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2022 189 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2022 190 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2022 191 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2022 192 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2022 193 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2022 194 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2022 195 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2022 196 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2022 197 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2023 198 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2023 199 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2023 200 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2023 201 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2023 202 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2023 203 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2023 204 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2023 205 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2023 206 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2023 207 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2023 208 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2023 209 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2024 210 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2024 211 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2024 212 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2024 213 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2024 214 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2024 215 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2024 216 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2024 217 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2024 218 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2024 219 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2024 220 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2024 221 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2025 222 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2025 223 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2025 224 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2025 225 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2025 226 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2025 227 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2025 228 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2025 229 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2025 230 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2025 231 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2025 232 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2025 233 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2026 234 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2026 235 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2026 236 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2026 237 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2026 238 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2026 239 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2026 240 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2026 241 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2026 242 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2026 243 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2026 244 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2026 245 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2027 246 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2027 247 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2027 248 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2027 249 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2027 250 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2027 251 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2027 252 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2027 253 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2027 254 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2027 255 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2027 256 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2027 257 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2028 258 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2028 259 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2028 260 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2028 261 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2028 262 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2028 263 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2028 264 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2028 265 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2028 266 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2028 267 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2028 268 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2028 269 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2029 270 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2029 271 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2029 272 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2029 273 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2029 274 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2029 275 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2029 276 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2029 277 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2029 278 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2029 279 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2029 280 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2029 281 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2030 282 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2030 283 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2030 284 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2030 285 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2030 286 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2030 287 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2030 288 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2030 289 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2030 290 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2030 291 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2030 292 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2030 293 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2031 294 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2031 295 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2031 296 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2031 297 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2031 298 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2031 299 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2031 300 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2031 301 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2031 302 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2031 303 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2031 304 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2031 305 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2032 306 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2032 307 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2032 308 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2032 309 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2032 310 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2032 311 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2032 312 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2032 313 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2032 314 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2032 315 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2032 316 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2032 317 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2033 318 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2033 319 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2033 320 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2033 321 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2033 322 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2033 323 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2033 324 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2033 325 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2033 326 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2033 327 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2033 328 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2033 329 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2034 330 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2034 331 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2034 332 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2034 333 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2034 334 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2034 335 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2034 336 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2034 337 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2034 338 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2034 339 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2034 340 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2034 341 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2035 342 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2035 343 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2035 344 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2035 345 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2035 346 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2035 347 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2035 348 $ - $ - $ - $ - $ - $ - $ - $ -
8/5/2035 349 $ - $ - $ - $ - $ - $ - $ - $ -
9/5/2035 350 $ - $ - $ - $ - $ - $ - $ - $ -
10/5/2035 351 $ - $ - $ - $ - $ - $ - $ - $ -
11/5/2035 352 $ - $ - $ - $ - $ - $ - $ - $ -
12/5/2035 353 $ - $ - $ - $ - $ - $ - $ - $ -
1/5/2036 354 $ - $ - $ - $ - $ - $ - $ - $ -
2/5/2036 355 $ - $ - $ - $ - $ - $ - $ - $ -
3/5/2036 356 $ - $ - $ - $ - $ - $ - $ - $ -
4/5/2036 357 $ - $ - $ - $ - $ - $ - $ - $ -
5/5/2036 358 $ - $ - $ - $ - $ - $ - $ - $ -
6/5/2036 359 $ - $ - $ - $ - $ - $ - $ - $ -
7/5/2036 360 $ - $ - $ - $ - $ - $ - $ - $ -
Income
Monthly Monthly
Bedrooms # of Units Rent Income Sq. Ft. Market Rents $ per SF $/BR
Studio 0 $ 900 $ - 600 $ 1.50 $ 900
1 0 $ 1,000 $ - 750 $ 1.33 $ 1,000
2 0 $ 1,500 $ - 850 $ 1.76 $ 750
3 0 $ 1,050 $ - 1100 $ 0.95 $ 350
4 0 $ 2,500 $ - 1500 $ 1.67 $ 625
5 0 $ 3,000 $ - 2500 $ 1.20 $ 600
1 1 $ 1,050 $ 1,050 1000 (from Configuration Sheet) $ 1.05 $ 1,050
Laundry Room $ -
Vending Machines $ -
Totals 1 $ 1,050 $ 1,050 Monthly
Potential Income $ 12,600 Annually (Gross Operating Income = GOI)
Vacancy 4% $ (504) Annually
Effective Rental Income $ 12,096 Annually
Instructions:
For multiple unit property enter in the number of each type of unit and their average rent.
For single unit property enter 1 in any single row and the total rent in the adjacent column.
Expenses**
Type % Monthly Quarterly Annually
Association $ 110 $ - $ 1,320
Insurance $ 60 $ -
Earthquake $ - $ - $ -
Fire $ 40 $ - $ 480
Flood $ 10 $ - $ 120
Liability $ 10 $ - $ 120
Tornado $ - $ - $ -
Maintenance 3% $ 32 $ - $ 378
Management 5% $ 53 $ - $ 630
Property Taxes 1.15% $ 201 $ - $ 2,415
Utility: Cable TV (CATV) $ - $ - $ -
Utility: Electricity $ - $ - $ -
Utility: Gas $ - $ - $ -
Utility: Sewer $ - $ - $ -
Utility: Telephone $ - $ - $ -
Utility: Trash $ - $ - $ -
Utility: Water $ - $ - $ -
Accounting $ - $ - $ -
Advertising $ - $ - $ -
Gardening/Lawn $ - $ - $ -
Improvements $ - $ - $ -
Janitorial/Cleaning $ - $ - $ -
Legal Fees $ - $ - $ -
Licenses/Permits $ - $ - $ -
Office Expenses $ - $ - $ -
Pest Control $ - $ - $ -
Pool/Spa $ - $ - $ -
Reserves $ - $ - $ -
Resident Manager $ - $ - $ -
Security $ - $ - $ -
Snow Removal $ - $ - $ -
Supplies $ - $ - $ -
Tax Preparations $ - $ - $ -
Other/Miscellaneous $ - $ - $ -
Total Operating Expenses** $ 455 $ - $ 5,463 0
** Does not include loan payments
Reserves
Fix-up/Repair $ 2,000.00
Closing Costs $ 2,994.00 (1st + 2nd)
Down Payment(s) $ 42,000.00
6 Months Payments $ 6,484.80 (1st + 2nd)
Total Reserves $ 53,478.80
Annual Cash Flow
Gross Operating Income $ 12,600 (Potential Income From Income Sheet)
Vacancy Factor $ (504) 4.00%
Total Operating Expenses $ (5,463) (From Expenses Sheet)
Net Operating Income (NOI) $ 6,633 (Does not include Loan Payments)
Annual Loan Payments $ (12,970) = Loan Payment x 12 months
Cash Flow Before Taxes (CFBT) $ (6,337) = Reportable Income/(Loss)
Annual Depreciation** $ 5,056 #NAME?
Cash Flow After Depreciation (CFAD) $ (1,281) ??? (Ordinary Income Offset)
Monthly CFAD $ (107) (???)
Savings in Taxes $ 448
Cash Flow After Taxes (CFAT) $ (833)
Monthly CFAT $ (69)
** (See Configuration Worksheet)
$ 151,667 1st - Value of Improvements (Purchase Price - Land Value)
30 Depreciation Years
35% Tax Bracket
$ 1,080.80 Loan Payment (1st + 2nd)
$ 64,848.00 P&I Paid (1st 5 years)(1st + 2nd)
$ 53,923.05 Interest Paid (1st 5 years)(1st + 2nd)
$ 10,924.95 Principal Paid (1st 5 years)(1st + 2nd)
Return On Investment (ROI)
Purchase Price $ 210,000
Initial Investment $ 42,000 (down payments for 1st and 2nd loans)
Acquisition Costs $ 2,994 Loan Fees, Appraisal, Vacancy, Fix-up, etc.
Improvements $ 0
Rental Loss $ 19,216 (using CFAD)
Total Investment $ 64,210
Annual Return $ 448 (From Cash Flow - Savings in Taxes)
Percent of Return 0.70%
Annual Increase 7%
Elapsed Years 15 (as of 7/5/2021)
Future Value $ 579,397 (Estimated value as of above date assuming Annual Increase)
Appreciation $ 369,397 (Future Value - Purchase Price) or (Sales Price - Purchase Price)
Principal Reduction $ 46,923 (Value of the reduction in loan principal)
Sales Costs $ (23,176) 4% of Future Value
Recoup Depreciation $ (18,958) (Tax you must pay on the claimed depreciation tax write off)
Annual Returns $ 6,725
Net Profit $ 374,185
Total Percent 582.76%
Yearly Percent 38.85%
Taxes
Sales Price $ 700,000
Purchase Price $ 210,000
Improvements $ 100,000
Cost Basis $ 310,000
Year Sold 2010
Years Depreciated 4
Depreciation Taken $ 20,222
Buying Costs
Selling Costs
Capital Gain $ 390,000
Tax Rate 20%
Taxes Due $ 78,000
Capital Gain after Tax $ 312,000
Maintenance
Move-out Qty Cost per Item Total
Change Locks 4 $ 20.00 $ 80.00
Replace faucet washers 4 $ 10.00 $ 40.00
Replace washer hoses 2 $ 15.00 $ 30.00
Clean Drains 2 $ 25.00 $ 50.00
Shampoo Carpets 1000 $ 0.20 $ 200.00
Touchup paint 1000 $ 0.30 $ 300.00
Clean windows & coverings 6 $ 10.00 $ 60.00
$ -
$ -
$ -
$ -
$ -
$ -
$ -
Move-out Total $ 760.00
Annual Qty Cost per Item Total
Replace faucet washers 4 $ 10.00 $ 40.00
$ -
$ -
$ -
$ -
$ -
$ -
$ -
Annual Total $ 40.00
Version History
Versions Date Changes (in reverse order)
1.3d Version 1.3d frozen.
2006.10.05 Modified Instructions to clarify protection.
1.3c 2006.10.01 Version 1.3c frozen.
2006.06.26 Added Monthly Rent to Configuration sheet so almost everything can be done from one sheet.
2006.06.26 Changed CFAT to CFAD and added CFAT. Added, changed, and used more cell names.
2006.05.06 Added and used more cell names.
2006.05.06 Updated Loan Fees worksheet.
2006.05.06
Implemented Purchase Price and Down payment on Configuration worksheet. The 2nd Loan
worksheet will calculate a loan for any remaining monies not accounted for in the 1st Loan worksheet.
2006.04.13 Added calculated tax amounts (monthly and yearly) from Expenses to the Configuration sheet so one
could adjust the rate to agree with a know tax amount.
2006.04.13 Updated link on Instructions sheet.
2006.03.27 Added new sheet called Loan Fees (not incorporated into any other sheet).
2006.03.21 Summed insurances in Expenses sheet.
2005.11.23 Added Lot Size and Style to Property Information sheet.
Added Assessed Values in Configuration sheet to get % for depreciation.
Added Acquisition Costs in ROI sheet.
Added Laundry Room and Vending Machines in Income sheet.
Added extra Expense lines (Pest Control, Reserves, Supplies, Security).
Added Sq. Ft., $/sf, Market Rents to Income sheet.
2005.04.15 Named many cells and redid formulas with new names.
2004.07.31 Changed Loan worksheet to 1st Loan and added 2nd Loan worksheet
2004.07.19 Added Garage to Parking on Property sheet.
1.3b 2004.07.19 Expand Property work sheet and add more hints (Scott's updates incorporated).
1.3a 2004.07.12 Added Property/Building Materials section.
1.3 2004.07.11 Expand Property work sheet
Add V worksheet (this worksheet)
Change Page Setup on all worksheets to fit width of page and center.
1.2 2004.07.07 Incorporated Pat and Scott's Changes
Define header format and update all worksheets.
Create Instructions worksheet
Create Maintenance worksheet
1.1 2004.07.05 Incorporate Bob's work sheet and past work
1.0 2003.07.27 Create original Excel work sheets
To Dos
Date Changes (in reverse order)
2006.04.13 Add mouse over text if possible and where prudent.
2004.07.25 Add Home insurance of 0.5%.
2005.11.23 Add Deposit Refunds
Rents $/sf
$/Unit
$/sf
GRM
Cap Rate