【财务预算管理❺】算算按揭贷款的钱home-equity-loan-calculator

HomeEquityLoanCalculator,,,,,,,,,,,,,UsingThisWorksheet

HELP,,,,,,,,,,,©2007-2015Vertex42LLC,,"Thisspreadsheetcreatesanamortizationscheduleforafixed-ratehomeequityloan,withoptionalextrapayments.Usethespreadsheettocomparedifferenttermlengths,rates,andloanamounts.Thisspreadsheetalsocalculatestheoutstandingbalanceattheendofaspecifiednumberofyearsandthetaxreturnediftheinterestpaidistaxdeductible."

,,,,,,,,,,,,,,

,Inputs,,,,BalanceDueatSpecifiedPeriod,,,,,,,,

,,LoanAmount,"$150,000",,,BalanceatYear…,30,,,,,,

,,AnnualInterestRate,6.00%,,,InterestPaid,"$112,966.26",,,,,,

,,TermLength(inYears),30,,,PrincipalPaid,"$150,000.00",,,,,,

,,FirstPaymentDate,2015/1/1,,,OutstandingBalance,$0.00,,,,,,

,,CompoundPeriod,Monthly,,,,,,,,,,

,,,.,,,,,,,,,,Editthewhitecells.Alltheothersarecalculated.

,,Payment,$899.33,,,,,,,,,,

,,,,,,,,,,,,,Thepaymentandtheinterestareroundedtothenearestcent.Thelastpaymentisadjustedtobringthebalancetozero.

,ExtraPayments(Prepayments),,,,,,,,,,,,

,,ExtraPayment,$75,,,,,,,,,,

,,EveryNMonths,1,,,,,,,,,,

,,ExtraAnnualPayment,"$1,000",,,,,,,,,,

,,,,,,,,,,,,,,

[42],LoanSummary,,,,,,,,,,,,

,,MonthlyInterestRate,0.500%,,,,,,,,,,

,,TotalPayments,"$262,966.26",,,,,,,TaxDeduction,,,

,,TotalInterest,"$112,966.26",,,,,,,,,,

,,NumberofPayments,250,(20.83years),,,TotalsAssumingNoExtraPayments,,,TaxBracket,25.00%,,

,,LastPaymentDate,2035/10/1,,,TotalPayments,"$323,754.82",,,EffectiveRate,4.500%,,

,,InterestSavings,"$60,789",,,TotalInterest,"$173,754.82",,,TotalReturned,"$28,242",,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

No.,"Payment

Date",Payment,"Extra

Payments",AdditionalPayment,Interest,Principal,Balance,,,TaxReturned,Cum.TaxReturned,,

,,,,,,,"$150,000.00",,,,,,

1,2015/1/1,899.33,75.00,,750.00,224.33,"149,775.67",,,187.50,187.50,,

2,2015/2/1,899.33,75.00,,748.88,225.45,"149,550.22",,,187.22,374.72,,

3,2015/3/1,899.33,75.00,,747.75,226.58,"149,323.64",,,186.94,561.66,,

4,2015/4/1,899.33,75.00,,746.62,227.71,"149,095.93",,,186.66,748.31,,

5,2015/5/1,899.33,75.00,,745.48,228.85,"148,867.08",,,186.37,934.68,,

6,2015/6/1,899.33,75.00,,744.34,229.99,"148,637.09",,,186.09,"1,120.77",,

7,2015/7/1,899.33,75.00,,743.19,231.14,"148,405.95",,,185.80,"1,306.57",,

8,2015/8/1,899.33,75.00,,742.03,232.30,"148,173.65",,,185.51,"1,492.07",,

9,2015/9/1,899.33,75.00,,740.87,233.46,"147,940.19",,,185.22,"1,677.29",,

10,2015/10/1,899.33,75.00,,739.70,234.63,"147,705.56",,,184.93,"1,862.22",,

11,2015/11/1,899.33,75.00,,738.53,235.80,"147,469.76",,,184.63,"2,046.85",,

12,2015/12/1,899.33,"1,075.00",,737.35,"1,236.98","146,232.78",,,184.34,"2,231.19",,

13,2016/1/1,899.33,75.00,,731.16,243.17,"145,989.61",,,182.79,"2,413.98",,

14,2016/2/1,899.33,75.00,,729.95,244.38,"145,745.23",,,182.49,"2,596.46",,

15,2016/3/1,899.33,75.00,,728.73,245.60,"145,499.63",,,182.18,"2,778.65",,

16,2016/4/1,899.33,75.00,,727.50,246.83,"145,252.80",,,181.88,"2,960.52",,

17,2016/5/1,899.33,75.00,,726.26,248.07,"145,004.73",,,181.57,"3,142.09",,

18,2016/6/1,899.33,75.00,,725.02,249.31,"144,755.42",,,181.26,"3,323.34",,

19,2016/7/1,899.33,75.00,,723.78,250.55,"144,504.87",,,180.95,"3,504.29",,

20,2016/8/1,899.33,75.00,,722.52,251.81,"144,253.06",,,180.63,"3,684.92",,

21,2016/9/1,899.33,75.00,,721.27,253.06,"144,000.00",,,180.32,"3,865.23",,

22,2016/10/1,899.33,75.00,,720.00,254.33,"143,745.67",,,180.00,"4,045.23",,

23,2016/11/1,899.33,75.00,,718.73,255.60,"143,490.07",,,179.68,"4,224.92",,

24,2016/12/1,899.33,"1,075.00",,717.45,"1,256.88","142,233.19",,,179.36,"4,404.28",,

25,2017/1/1,899.33,75.00,,711.17,263.16,"141,970.03",,,177.79,"4,582.07",,

26,2017/2/1,899.33,75.00,,709.85,264.48,"141,705.55",,,177.46,"4,759.53",,

27,2017/3/1,899.33,75.00,,708.53,265.80,"141,439.75",,,177.13,"4,936.67",,

28,2017/4/1,899.33,75.00,,707.20,267.13,"141,172.62",,,176.80,"5,113.47",,

29,2017/5/1,899.33,75.00,,705.86,268.47,"140,904.15",,,176.47,"5,289.93",,

30,2017/6/1,899.33,75.00,,704.52,269.81,"140,634.34",,,176.13,"5,466.06",,

31,2017/7/1,899.33,75.00,,703.17,271.16,"140,363.18",,,175.79,"5,641.85",,

32,2017/8/1,899.33,75.00,,701.82,272.51,"140,090.67",,,175.46,"5,817.31",,

33,2017/9/1,899.33,75.00,,700.45,273.88,"139,816.79",,,175.11,"5,992.42",,

34,2017/10/1,899.33,75.00,,699.08,275.25,"139,541.54",,,174.77,"6,167.19",,

35,2017/11/1,899.33,75.00,,697.71,276.62,"139,264.92",,,174.43,"6,341.62",,

36,2017/12/1,899.33,"1,075.00",,696.32,"1,278.01","137,986.91",,,174.08,"6,515.70",,

37,2018/1/1,899.33,75.00,,689.93,284.40,"137,702.51",,,172.48,"6,688.18",,

38,2018/2/1,899.33,75.00,,688.51,285.82,"137,416.69",,,172.13,"6,860.31",,

39,2018/3/1,899.33,75.00,,687.08,287.25,"137,129.44",,,171.77,"7,032.08",,

40,2018/4/1,899.33,75.00,,685.65,288.68,"136,840.76",,,171.41,"7,203.49",,

41,2018/5/1,899.33,75.00,,684.20,290.13,"136,550.63",,,171.05,"7,374.54",,

42,2018/6/1,899.33,75.00,,682.75,291.58,"136,259.05",,,170.69,"7,545.23",,

43,2018/7/1,899.33,75.00,,681.30,293.03,"135,966.02",,,170.33,"7,715.55",,

44,2018/8/1,899.33,75.00,,679.83,294.50,"135,671.52",,,169.96,"7,885.51",,

45,2018/9/1,899.33,75.00,,678.36,295.97,"135,375.55",,,169.59,"8,055.10",,

46,2018/10/1,899.33,75.00,,676.88,297.45,"135,078.10",,,169.22,"8,224.32",,

47,2018/11/1,899.33,75.00,,675.39,298.94,"134,779.16",,,168.85,"8,393.17",,

48,2018/12/1,899.33,"1,075.00",,673.90,"1,300.43","133,478.73",,,168.48,"8,561.64",,

49,2019/1/1,899.33,75.00,,667.39,306.94,"133,171.79",,,166.85,"8,728.49",,

50,2019/2/1,899.33,75.00,,665.86,308.47,"132,863.32",,,166.47,"8,894.96",,

51,2019/3/1,899.33,75.00,,664.32,310.01,"132,553.31",,,166.08,"9,061.04",,

52,2019/4/1,899.33,75.00,,662.77,311.56,"132,241.75",,,165.69,"9,226.73",,

53,2019/5/1,899.33,75.00,,661.21,313.12,"131,928.63",,,165.30,"9,392.03",,

54,2019/6/1,899.33,75.00,,659.64,314.69,"131,613.94",,,164.91,"9,556.94",,

55,2019/7/1,899.33,75.00,,658.07,316.26,"131,297.68",,,164.52,"9,721.46",,

56,2019/8/1,899.33,75.00,,656.49,317.84,"130,979.84",,,164.12,"9,885.58",,

57,2019/9/1,899.33,75.00,,654.90,319.43,"130,660.41",,,163.73,"10,049.31",,

58,2019/10/1,899.33,75.00,,653.30,321.03,"130,339.38",,,163.33,"10,212.63",,

59,2019/11/1,899.33,75.00,,651.70,322.63,"130,016.75",,,162.93,"10,375.56",,

60,2019/12/1,899.33,"1,075.00",,650.08,"1,324.25","128,692.50",,,162.52,"10,538.08",,

61,2020/1/1,899.33,75.00,,643.46,330.87,"128,361.63",,,160.87,"10,698.94",,

62,2020/2/1,899.33,75.00,,641.81,332.52,"128,029.11",,,160.45,"10,859.39",,

63,2020/3/1,899.33,75.00,,640.15,334.18,"127,694.93",,,160.04,"11,019.43",,

64,2020/4/1,899.33,75.00,,638.47,335.86,"127,359.07",,,159.62,"11,179.05",,

65,2020/5/1,899.33,75.00,,636.80,337.53,"127,021.54",,,159.20,"11,338.25",,

66,2020/6/1,899.33,75.00,,635.11,339.22,"126,682.32",,,158.78,"11,497.03",,

67,2020/7/1,899.33,75.00,,633.41,340.92,"126,341.40",,,158.35,"11,655.38",,

68,2020/8/1,899.33,75.00,,631.71,342.62,"125,998.78",,,157.93,"11,813.31",,

69,2020/9/1,899.33,75.00,,629.99,344.34,"125,654.44",,,157.50,"11,970.80",,

70,2020/10/1,899.33,75.00,,628.27,346.06,"125,308.38",,,157.07,"12,127.87",,

71,2020/11/1,899.33,75.00,,626.54,347.79,"124,960.59",,,156.64,"12,284.51",,

72,2020/12/1,899.33,"1,075.00",,624.80,"1,349.53","123,611.06",,,156.20,"12,440.71",,

73,2021/1/1,899.33,75.00,,618.06,356.27,"123,254.79",,,154.52,"12,595.22",,

74,2021/2/1,899.33,75.00,,616.27,358.06,"122,896.73",,,154.07,"12,749.29",,

75,2021/3/1,899.33,75.00,,614.48,359.85,"122,536.88",,,153.62,"12,902.91",,

76,2021/4/1,899.33,75.00,,612.68,361.65,"122,175.23",,,153.17,"13,056.08",,

77,2021/5/1,899.33,75.00,,610.88,363.45,"121,811.78",,,152.72,"13,208.80",,

78,2021/6/1,899.33,75.00,,609.06,365.27,"121,446.51",,,152.27,"13,361.06",,

79,2021/7/1,899.33,75.00,,607.23,367.10,"121,079.41",,,151.81,"13,512.87",,

80,2021/8/1,899.33,75.00,,605.40,368.93,"120,710.48",,,151.35,"13,664.22",,

81,2021/9/1,899.33,75.00,,603.55,370.78,"120,339.70",,,150.89,"13,815.11",,

82,2021/10/1,899.33,75.00,,601.70,372.63,"119,967.07",,,150.43,"13,965.53",,

83,2021/11/1,899.33,75.00,,599.84,374.49,"119,592.58",,,149.96,"14,115.49",,

84,2021/12/1,899.33,"1,075.00",,597.96,"1,376.37","118,216.21",,,149.49,"14,264.98",,

85,2022/1/1,899.33,75.00,,591.08,383.25,"117,832.96",,,147.77,"14,412.75",,

86,2022/2/1,899.33,75.00,,589.16,385.17,"117,447.79",,,147.29,"14,560.04",,

87,2022/3/1,899.33,75.00,,587.24,387.09,"117,060.70",,,146.81,"14,706.85",,

88,2022/4/1,899.33,75.00,,585.30,389.03,"116,671.67",,,146.33,"14,853.18",,

89,2022/5/1,899.33,75.00,,583.36,390.97,"116,280.70",,,145.84,"14,999.02",,

90,2022/6/1,899.33,75.00,,581.40,392.93,"115,887.77",,,145.35,"15,144.37",,

91,2022/7/1,899.33,75.00,,579.44,394.89,"115,492.88",,,144.86,"15,289.23",,

92,2022/8/1,899.33,75.00,,577.46,396.87,"115,096.01",,,144.37,"15,433.59",,

93,2022/9/1,899.33,75.00,,575.48,398.85,"114,697.16",,,143.87,"15,577.46",,

94,2022/10/1,899.33,75.00,,573.49,400.84,"114,296.32",,,143.37,"15,720.84",,

95,2022/11/1,899.33,75.00,,571.48,402.85,"113,893.47",,,142.87,"15,863.71",,

96,2022/12/1,899.33,"1,075.00",,569.47,"1,404.86","112,488.61",,,142.37,"16,006.07",,

97,2023/1/1,899.33,75.00,,562.44,411.89,"112,076.72",,,140.61,"16,146.68",,

98,2023/2/1,899.33,75.00,,560.38,413.95,"111,662.77",,,140.10,"16,286.78",,

99,2023/3/1,899.33,75.00,,558.31,416.02,"111,246.75",,,139.58,"16,426.36",,

100,2023/4/1,899.33,75.00,,556.23,418.10,"110,828.65",,,139.06,"16,565.41",,

101,2023/5/1,899.33,75.00,,554.14,420.19,"110,408.46",,,138.54,"16,703.95",,

102,2023/6/1,899.33,75.00,,552.04,422.29,"109,986.17",,,138.01,"16,841.96",,

103,2023/7/1,899.33,75.00,,549.93,424.40,"109,561.77",,,137.48,"16,979.44",,

104,2023/8/1,899.33,75.00,,547.81,426.52,"109,135.25",,,136.95,"17,116.39",,

105,2023/9/1,899.33,75.00,,545.68,428.65,"108,706.60",,,136.42,"17,252.81",,

106,2023/10/1,899.33,75.00,,543.53,430.80,"108,275.80",,,135.88,"17,388.70",,

107,2023/11/1,899.33,75.00,,541.38,432.95,"107,842.85",,,135.35,"17,524.04",,

108,2023/12/1,899.33,"1,075.00",,539.21,"1,435.12","106,407.73",,,134.80,"17,658.84",,

109,2024/1/1,899.33,75.00,,532.04,442.29,"105,965.44",,,133.01,"17,791.85",,

110,2024/2/1,899.33,75.00,,529.83,444.50,"105,520.94",,,132.46,"17,924.31",,

111,2024/3/1,899.33,75.00,,527.60,446.73,"105,074.21",,,131.90,"18,056.21",,

112,2024/4/1,899.33,75.00,,525.37,448.96,"104,625.25",,,131.34,"18,187.55",,

113,2024/5/1,899.33,75.00,,523.13,451.20,"104,174.05",,,130.78,"18,318.34",,

114,2024/6/1,899.33,75.00,,520.87,453.46,"103,720.59",,,130.22,"18,448.55",,

115,2024/7/1,899.33,75.00,,518.60,455.73,"103,264.86",,,129.65,"18,578.20",,

116,2024/8/1,899.33,75.00,,516.32,458.01,"102,806.85",,,129.08,"18,707.28",,

117,2024/9/1,899.33,75.00,,514.03,460.30,"102,346.55",,,128.51,"18,835.79",,

118,2024/10/1,899.33,75.00,,511.73,462.60,"101,883.95",,,127.93,"18,963.72",,

119,2024/11/1,899.33,75.00,,509.42,464.91,"101,419.04",,,127.36,"19,091.08",,

120,2024/12/1,899.33,"1,075.00",,507.10,"1,467.23","99,951.81",,,126.78,"19,217.85",,

121,2025/1/1,899.33,75.00,,499.76,474.57,"99,477.24",,,124.94,"19,342.79",,

122,2025/2/1,899.33,75.00,,497.39,476.94,"99,000.30",,,124.35,"19,467.14",,

123,2025/3/1,899.33,75.00,,495.00,479.33,"98,520.97",,,123.75,"19,590.89",,

124,2025/4/1,899.33,75.00,,492.60,481.73,"98,039.24",,,123.15,"19,714.04",,

125,2025/5/1,899.33,75.00,,490.20,484.13,"97,555.11",,,122.55,"19,836.59",,

126,2025/6/1,899.33,75.00,,487.78,486.55,"97,068.56",,,121.95,"19,958.54",,

127,2025/7/1,899.33,75.00,,485.34,488.99,"96,579.57",,,121.34,"20,079.87",,

128,2025/8/1,899.33,75.00,,482.90,491.43,"96,088.14",,,120.73,"20,200.60",,

129,2025/9/1,899.33,75.00,,480.44,493.89,"95,594.25",,,120.11,"20,320.71",,

130,2025/10/1,899.33,75.00,,477.97,496.36,"95,097.89",,,119.49,"20,440.20",,

131,2025/11/1,899.33,75.00,,475.49,498.84,"94,599.05",,,118.87,"20,559.07",,

132,2025/12/1,899.33,"1,075.00",,473.00,"1,501.33","93,097.72",,,118.25,"20,677.32",,

133,2026/1/1,899.33,75.00,,465.49,508.84,"92,588.88",,,116.37,"20,793.69",,

134,2026/2/1,899.33,75.00,,462.94,511.39,"92,077.49",,,115.74,"20,909.43",,

135,2026/3/1,899.33,75.00,,460.39,513.94,"91,563.55",,,115.10,"21,024.53",,

136,2026/4/1,899.33,75.00,,457.82,516.51,"91,047.04",,,114.46,"21,138.98",,

137,2026/5/1,899.33,75.00,,455.24,519.09,"90,527.95",,,113.81,"21,252.79",,

138,2026/6/1,899.33,75.00,,452.64,521.69,"90,006.26",,,113.16,"21,365.95",,

139,2026/7/1,899.33,75.00,,450.03,524.30,"89,481.96",,,112.51,"21,478.46",,

140,2026/8/1,899.33,75.00,,447.41,526.92,"88,955.04",,,111.85,"21,590.31",,

141,2026/9/1,899.33,75.00,,444.78,529.55,"88,425.49",,,111.20,"21,701.51",,

142,2026/10/1,899.33,75.00,,442.13,532.20,"87,893.29",,,110.53,"21,812.04",,

143,2026/11/1,899.33,75.00,,439.47,534.86,"87,358.43",,,109.87,"21,921.91",,

144,2026/12/1,899.33,"1,075.00",,436.79,"1,537.54","85,820.89",,,109.20,"22,031.10",,

145,2027/1/1,899.33,75.00,,429.10,545.23,"85,275.66",,,107.28,"22,138.38",,

146,2027/2/1,899.33,75.00,,426.38,547.95,"84,727.71",,,106.60,"22,244.97",,

147,2027/3/1,899.33,75.00,,423.64,550.69,"84,177.02",,,105.91,"22,350.88",,

148,2027/4/1,899.33,75.00,,420.89,553.44,"83,623.58",,,105.22,"22,456.11",,

149,2027/5/1,899.33,75.00,,418.12,556.21,"83,067.37",,,104.53,"22,560.64",,

150,2027/6/1,899.33,75.00,,415.34,558.99,"82,508.38",,,103.84,"22,664.47",,

151,2027/7/1,899.33,75.00,,412.54,561.79,"81,946.59",,,103.14,"22,767.61",,

152,2027/8/1,899.33,75.00,,409.73,564.60,"81,381.99",,,102.43,"22,870.04",,

153,2027/9/1,899.33,75.00,,406.91,567.42,"80,814.57",,,101.73,"22,971.77",,

154,2027/10/1,899.33,75.00,,404.07,570.26,"80,244.31",,,101.02,"23,072.78",,

155,2027/11/1,899.33,75.00,,401.22,573.11,"79,671.20",,,100.31,"23,173.09",,

156,2027/12/1,899.33,"1,075.00",,398.36,"1,575.97","78,095.23",,,99.59,"23,272.68",,

157,2028/1/1,899.33,75.00,,390.48,583.85,"77,511.38",,,97.62,"23,370.30",,

158,2028/2/1,899.33,75.00,,387.56,586.77,"76,924.61",,,96.89,"23,467.19",,

159,2028/3/1,899.33,75.00,,384.62,589.71,"76,334.90",,,96.16,"23,563.34",,

160,2028/4/1,899.33,75.00,,381.67,592.66,"75,742.24",,,95.42,"23,658.76",,

161,2028/5/1,899.33,75.00,,378.71,595.62,"75,146.62",,,94.68,"23,753.44",,

162,2028/6/1,899.33,75.00,,375.73,598.60,"74,548.02",,,93.93,"23,847.37",,

163,2028/7/1,899.33,75.00,,372.74,601.59,"73,946.43",,,93.19,"23,940.56",,

164,2028/8/1,899.33,75.00,,369.73,604.60,"73,341.83",,,92.43,"24,032.99",,

165,2028/9/1,899.33,75.00,,366.71,607.62,"72,734.21",,,91.68,"24,124.67",,

166,2028/10/1,899.33,75.00,,363.67,610.66,"72,123.55",,,90.92,"24,215.58",,

167,2028/11/1,899.33,75.00,,360.62,613.71,"71,509.84",,,90.16,"24,305.74",,

168,2028/12/1,899.33,"1,075.00",,357.55,"1,616.78","69,893.06",,,89.39,"24,395.13",,

169,2029/1/1,899.33,75.00,,349.47,624.86,"69,268.20",,,87.37,"24,482.49",,

170,2029/2/1,899.33,75.00,,346.34,627.99,"68,640.21",,,86.59,"24,569.08",,

171,2029/3/1,899.33,75.00,,343.20,631.13,"68,009.08",,,85.80,"24,654.88",,

172,2029/4/1,899.33,75.00,,340.05,634.28,"67,374.80",,,85.01,"24,739.89",,

173,2029/5/1,899.33,75.00,,336.87,637.46,"66,737.34",,,84.22,"24,824.11",,

174,2029/6/1,899.33,75.00,,333.69,640.64,"66,096.70",,,83.42,"24,907.53",,

175,2029/7/1,899.33,75.00,,330.48,643.85,"65,452.85",,,82.62,"24,990.15",,

176,2029/8/1,899.33,75.00,,327.26,647.07,"64,805.78",,,81.82,"25,071.97",,

177,2029/9/1,899.33,75.00,,324.03,650.30,"64,155.48",,,81.01,"25,152.97",,

178,2029/10/1,899.33,75.00,,320.78,653.55,"63,501.93",,,80.20,"25,233.17",,

179,2029/11/1,899.33,75.00,,317.51,656.82,"62,845.11",,,79.38,"25,312.55",,

180,2029/12/1,899.33,"1,075.00",,314.23,"1,660.10","61,185.01",,,78.56,"25,391.10",,

181,2030/1/1,899.33,75.00,,305.93,668.40,"60,516.61",,,76.48,"25,467.59",,

182,2030/2/1,899.33,75.00,,302.58,671.75,"59,844.86",,,75.65,"25,543.23",,

183,2030/3/1,899.33,75.00,,299.22,675.11,"59,169.75",,,74.81,"25,618.04",,

184,2030/4/1,899.33,75.00,,295.85,678.48,"58,491.27",,,73.96,"25,692.00",,

185,2030/5/1,899.33,75.00,,292.46,681.87,"57,809.40",,,73.12,"25,765.11",,

186,2030/6/1,899.33,75.00,,289.05,685.28,"57,124.12",,,72.26,"25,837.38",,

187,2030/7/1,899.33,75.00,,285.62,688.71,"56,435.41",,,71.41,"25,908.78",,

188,2030/8/1,899.33,75.00,,282.18,692.15,"55,743.26",,,70.55,"25,979.33",,

189,2030/9/1,899.33,75.00,,278.72,695.61,"55,047.65",,,69.68,"26,049.01",,

190,2030/10/1,899.33,75.00,,275.24,699.09,"54,348.56",,,68.81,"26,117.82",,

191,2030/11/1,899.33,75.00,,271.74,702.59,"53,645.97",,,67.94,"26,185.75",,

192,2030/12/1,899.33,"1,075.00",,268.23,"1,706.10","51,939.87",,,67.06,"26,252.81",,

193,2031/1/1,899.33,75.00,,259.70,714.63,"51,225.24",,,64.93,"26,317.73",,

194,2031/2/1,899.33,75.00,,256.13,718.20,"50,507.04",,,64.03,"26,381.77",,

195,2031/3/1,899.33,75.00,,252.54,721.79,"49,785.25",,,63.14,"26,444.90",,

196,2031/4/1,899.33,75.00,,248.93,725.40,"49,059.85",,,62.23,"26,507.13",,

197,2031/5/1,899.33,75.00,,245.30,729.03,"48,330.82",,,61.33,"26,568.46",,

198,2031/6/1,899.33,75.00,,241.65,732.68,"47,598.14",,,60.41,"26,628.87",,

199,2031/7/1,899.33,75.00,,237.99,736.34,"46,861.80",,,59.50,"26,688.37",,

200,2031/8/1,899.33,75.00,,234.31,740.02,"46,121.78",,,58.58,"26,746.95",,

201,2031/9/1,899.33,75.00,,230.61,743.72,"45,378.06",,,57.65,"26,804.60",,

202,2031/10/1,899.33,75.00,,226.89,747.44,"44,630.62",,,56.72,"26,861.32",,

203,2031/11/1,899.33,75.00,,223.15,751.18,"43,879.44",,,55.79,"26,917.11",,

204,2031/12/1,899.33,"1,075.00",,219.40,"1,754.93","42,124.51",,,54.85,"26,971.96",,

205,2032/1/1,899.33,75.00,,210.62,763.71,"41,360.80",,,52.66,"27,024.61",,

206,2032/2/1,899.33,75.00,,206.80,767.53,"40,593.27",,,51.70,"27,076.31",,

207,2032/3/1,899.33,75.00,,202.97,771.36,"39,821.91",,,50.74,"27,127.06",,

208,2032/4/1,899.33,75.00,,199.11,775.22,"39,046.69",,,49.78,"27,176.83",,

209,2032/5/1,899.33,75.00,,195.23,779.10,"38,267.59",,,48.81,"27,225.64",,

210,2032/6/1,899.33,75.00,,191.34,782.99,"37,484.60",,,47.84,"27,273.48",,

211,2032/7/1,899.33,75.00,,187.42,786.91,"36,697.69",,,46.86,"27,320.33",,

212,2032/8/1,899.33,75.00,,183.49,790.84,"35,906.85",,,45.87,"27,366.20",,

213,2032/9/1,899.33,75.00,,179.53,794.80,"35,112.05",,,44.88,"27,411.09",,

214,2032/10/1,899.33,75.00,,175.56,798.77,"34,313.28",,,43.89,"27,454.98",,

215,2032/11/1,899.33,75.00,,171.57,802.76,"33,510.52",,,42.89,"27,497.87",,

216,2032/12/1,899.33,"1,075.00",,167.55,"1,806.78","31,703.74",,,41.89,"27,539.76",,

217,2033/1/1,899.33,75.00,,158.52,815.81,"30,887.93",,,39.63,"27,579.39",,

218,2033/2/1,899.33,75.00,,154.44,819.89,"30,068.04",,,38.61,"27,618.00",,

219,2033/3/1,899.33,75.00,,150.34,823.99,"29,244.05",,,37.59,"27,655.58",,

220,2033/4/1,899.33,75.00,,146.22,828.11,"28,415.94",,,36.56,"27,692.14",,

221,2033/5/1,899.33,75.00,,142.08,832.25,"27,583.69",,,35.52,"27,727.66",,

222,2033/6/1,899.33,75.00,,137.92,836.41,"26,747.28",,,34.48,"27,762.14",,

223,2033/7/1,899.33,75.00,,133.74,840.59,"25,906.69",,,33.44,"27,795.57",,

224,2033/8/1,899.33,75.00,,129.53,844.80,"25,061.89",,,32.38,"27,827.95",,

225,2033/9/1,899.33,75.00,,125.31,849.02,"24,212.87",,,31.33,"27,859.28",,

226,2033/10/1,899.33,75.00,,121.06,853.27,"23,359.60",,,30.27,"27,889.55",,

227,2033/11/1,899.33,75.00,,116.80,857.53,"22,502.07",,,29.20,"27,918.75",,

228,2033/12/1,899.33,"1,075.00",,112.51,"1,861.82","20,640.25",,,28.13,"27,946.87",,

229,2034/1/1,899.33,75.00,,103.20,871.13,"19,769.12",,,25.80,"27,972.67",,

230,2034/2/1,899.33,75.00,,98.85,875.48,"18,893.64",,,24.71,"27,997.39",,

231,2034/3/1,899.33,75.00,,94.47,879.86,"18,013.78",,,23.62,"28,021.00",,

232,2034/4/1,899.33,75.00,,90.07,884.26,"17,129.52",,,22.52,"28,043.52",,

233,2034/5/1,899.33,75.00,,85.65,888.68,"16,240.84",,,21.41,"28,064.93",,

234,2034/6/1,899.33,75.00,,81.20,893.13,"15,347.71",,,20.30,"28,085.23",,

235,2034/7/1,899.33,75.00,,76.74,897.59,"14,450.12",,,19.19,"28,104.42",,

236,2034/8/1,899.33,75.00,,72.25,902.08,"13,548.04",,,18.06,"28,122.48",,

237,2034/9/1,899.33,75.00,,67.74,906.59,"12,641.45",,,16.94,"28,139.42",,

238,2034/10/1,899.33,75.00,,63.21,911.12,"11,730.33",,,15.80,"28,155.22",,

239,2034/11/1,899.33,75.00,,58.65,915.68,"10,814.65",,,14.66,"28,169.88",,

240,2034/12/1,899.33,"1,075.00",,54.07,"1,920.26","8,894.39",,,13.52,"28,183.40",,

241,2035/1/1,899.33,75.00,,44.47,929.86,"7,964.53",,,11.12,"28,194.52",,

242,2035/2/1,899.33,75.00,,39.82,934.51,"7,030.02",,,9.96,"28,204.47",,

243,2035/3/1,899.33,75.00,,35.15,939.18,"6,090.84",,,8.79,"28,213.26",,

244,2035/4/1,899.33,75.00,,30.45,943.88,"5,146.96",,,7.61,"28,220.87",,

245,2035/5/1,899.33,75.00,,25.73,948.60,"4,198.36",,,6.43,"28,227.30",,

246,2035/6/1,899.33,75.00,,20.99,953.34,"3,245.02",,,5.25,"28,232.55",,

247,2035/7/1,899.33,75.00,,16.23,958.10,"2,286.92",,,4.06,"28,236.61",,

248,2035/8/1,899.33,75.00,,11.43,962.90,"1,324.02",,,2.86,"28,239.47",,

249,2035/9/1,899.33,75.00,,6.62,967.71,356.31,,,1.66,"28,241.12",,

250,2035/10/1,358.09,0.00,,1.78,356.31,0.00,,,0.45,"28,241.57",,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,