{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Customer Information","Payment Schedule","Disclosure"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,1,5,11],[3,1,3,5]]}
["Expert Financial Services, Inc."]
["Residential Mortgage Kit"]
[]
[null,"Use this application to prepare a residential mortgage proposal for a potential borrower. Use the menu below to open the data entry form to enter and edit information about the borrower, the property, and the proposed loan."]
[]
[null,"Use the menu buttons below to complete a loan proposal. From this menu you can\nenter and edit the required information display the payment schedule, and display the Truth-in-Lending disclosure. "]
[]
[]
[null,null,"1. Enter Borrower, Property, and Loan Information"]
[]
[]
[]
[null,null,"2. Create and/or View the Loan Repayment Schedule"]
[]
[]
[]
[null,null,"3. Create and/or View the Truth-in-Lending Disclosure"]

{"sheet":"Customer Information","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Expert Financial Services, Inc."]
["Residential Mortgage Kit"]
[]
["Borrower Name:",null,null,null,"Investment Account?"]
["Borrower SSN:"]
[null,null,null,null,"Loan Principal:",150000]
["Current Address:"]
["City:",null,null,null,"Loan Rate:",5.7500000000000002E-2]
["State:"]
["Zip Code:",null,null,null,"Loan Term:",30]
["Home Telephone:"]
[]
["Property Address:"]
["City:"]
["State:"]
["Zip Code:"]
["Property Type:","Condo/Townhome"]

{"sheet":"Payment Schedule","index":2,"n_rows":369,"n_cols":7,"rows_kept":369,"cut":false,"hidden":false,"merged":[[3,5,3,6]]}
["Expert Financial Services, Inc."]
["Residential Mortgage Kit"]
[]
["Principal:",{"$f":"'Customer Information'!$F$6","v":150000},null,null,null,"Closing Costs"]
["Rate:",{"$f":"'Customer Information'!$F$8","v":5.7500000000000002E-2},null,null,null,"Origination Fee:",{"$f":"B4*0.02","v":3000}]
["Term:",{"$f":"'Customer Information'!$F$10","v":30},null,null,null,"Points:",{"$f":"IF('Customer Information'!F4=FALSE,B4*(B6*0.001),(B4*(B6*0.001)-(B4*0.01)))","v":4500}]
["Payment:",{"$f":"PMT(B5/12,B6*12,-B4)","v":875.35928466532948},null,null,null,"Total  Fees:",{"$f":"SUM(G5:G6)","v":7500}]
[]
["Payment\nNumber","Principal","Interest","Cumulative\nPrincipal","Cumulative\nInterest","Total Paid","Balance"]
[1,156.61000000000001,718.75,156.61000000000001,718.75,875.36,149843.39000000001]
[2,157.36000000000001,718,313.97000000000003,1436.75,1750.72,149686.03]
[3,158.11000000000001,717.25,472.08,2154,2626.08,149527.92000000001]
[4,158.87,716.49,630.95000000000005,2870.49,3501.44,149369.04999999999]
[5,159.63,715.73,790.58,3586.22,4376.8,149209.42000000001]
[6,160.4,714.96,950.98,4301.18,5252.16,149049.01999999999]
[7,161.16999999999999,714.19,1112.1500000000001,5015.37,6127.52,148887.85]
[8,161.94,713.42,1274.0899999999999,5728.79,7002.88,148725.91]
[9,162.71,712.65,1436.8,6441.44,7878.24,148563.20000000001]
[10,163.49,711.87,1600.29,7153.31,8753.6,148399.71]
[11,164.28,711.08,1764.57,7864.39,9628.9599999999991,148235.43]
[12,165.06,710.29,1929.63,8574.68,10504.31,148070.37]
[13,165.86,709.5,2095.4899999999998,9284.18,11379.67,147904.51]
[14,166.65,708.71,2262.14,9992.89,12255.03,147737.85999999999]
[15,167.45,707.91,2429.59,10700.8,13130.39,147570.41]
[16,168.25,707.11,2597.84,11407.91,14005.75,147402.16]
[17,169.06,706.3,2766.9,12114.21,14881.11,147233.1]
[18,169.87,705.49,2936.77,12819.7,15756.47,147063.23000000001]
[19,170.68,704.68,3107.45,13524.38,16631.830000000002,146892.54999999999]
[20,171.5,703.86,3278.95,14228.24,17507.189999999999,146721.04999999999]
[21,172.32,703.04,3451.27,14931.28,18382.55,146548.73000000001]
[22,173.15,702.21,3624.42,15633.49,19257.91,146375.57999999999]
[23,173.98,701.38,3798.4,16334.87,20133.27,146201.60000000001]
[24,174.81,700.55,3973.21,17035.419999999998,21008.63,146026.79]
[25,175.65,699.71,4148.8599999999997,17735.13,21883.99,145851.14000000001]
[26,176.49,698.87,4325.3500000000004,18434,22759.35,145674.65]
[27,177.33,698.02,4502.68,19132.02,23634.7,145497.32]
[28,178.18,697.17,4680.8599999999997,19829.189999999999,24510.05,145319.14000000001]
[29,179.04,696.32,4859.8999999999996,20525.509999999998,25385.41,145140.1]
[30,179.9,695.46,5039.8,21220.97,26260.77,144960.20000000001]
[31,180.76,694.6,5220.5600000000004,21915.57,27136.13,144779.44]
[32,181.62,693.73,5402.18,22609.3,28011.48,144597.82]
[33,182.49,692.86,5584.67,23302.16,28886.83,144415.32999999999]
[34,183.37,691.99,5768.04,23994.15,29762.19,144231.96]
[35,184.25,691.11,5952.29,24685.26,30637.55,144047.71]
[36,185.13,690.23,6137.42,25375.49,31512.91,143862.57999999999]
[37,186.02,689.34,6323.44,26064.83,32388.27,143676.56]
[38,186.91,688.45,6510.35,26753.279999999999,33263.629999999997,143489.65]
[39,187.8,687.55,6698.15,27440.83,34138.980000000003,143301.85]
[40,188.7,686.65,6886.85,28127.48,35014.33,143113.15]
[41,189.61,685.75,7076.46,28813.23,35889.69,142923.54]
[42,190.52,684.84,7266.98,29498.07,36765.050000000003,142733.01999999999]
[43,191.43,683.93,7458.41,30182,37640.410000000003,142541.59]
[44,192.35,683.01,7650.76,30865.01,38515.769999999997,142349.24]
[45,193.27,682.09,7844.03,31547.1,39391.129999999997,142155.97]
[46,194.2,681.16,8038.23,32228.26,40266.49,141961.76999999999]
[47,195.13,680.23,8233.36,32908.49,41141.85,141766.64000000001]
[48,196.06,679.3,8429.42,33587.79,42017.21,141570.57999999999]
[49,197,678.36,8626.42,34266.15,42892.57,141373.57999999999]
[50,197.94,677.42,8824.36,34943.57,43767.93,141175.64000000001]
[51,198.89,676.47,9023.25,35620.04,44643.29,140976.75]
[52,199.85,675.51,9223.1,36295.550000000003,45518.65,140776.9]
[53,200.8,674.56,9423.9,36970.11,46394.01,140576.1]
[54,201.77,673.59,9625.67,37643.699999999997,47269.37,140374.32999999999]
[55,202.73,672.63,9828.4,38316.33,48144.73,140171.6]
[56,203.7,671.66,10032.1,38987.99,49020.09,139967.9]
[57,204.68,670.68,10236.780000000001,39658.67,49895.45,139763.22]
[58,205.66,669.7,10442.44,40328.370000000003,50770.81,139557.56]
[59,206.65,668.71,10649.09,40997.08,51646.17,139350.91]
[60,207.64,667.72,10856.73,41664.800000000003,52521.53,139143.26999999999]
[61,208.63,666.73,11065.36,42331.53,53396.89,138934.64000000001]
[62,209.63,665.73,11274.99,42997.26,54272.25,138725.01]
[63,210.64,664.72,11485.63,43661.98,55147.61,138514.37]
[64,211.64,663.71,11697.27,44325.69,56022.96,138302.73000000001]
[65,212.66,662.7,11909.93,44988.39,56898.32,138090.07]
[66,213.68,661.68,12123.61,45650.07,57773.68,137876.39000000001]
[67,214.7,660.66,12338.31,46310.73,58649.04,137661.69]
[68,215.73,659.63,12554.04,46970.36,59524.4,137445.96]
[69,216.76,658.6,12770.8,47628.959999999999,60399.76,137229.20000000001]
[70,217.8,657.56,12988.6,48286.52,61275.12,137011.4]
[71,218.85,656.51,13207.45,48943.03,62150.48,136792.54999999999]
[72,219.89,655.46,13427.34,49598.49,63025.83,136572.66]
[73,220.95,654.41,13648.29,50252.9,63901.19,136351.71]
[74,222.01,653.35,13870.3,50906.25,64776.55,136129.70000000001]
[75,223.07,652.29,14093.37,51558.54,65651.91,135906.63]
[76,224.14,651.22,14317.51,52209.760000000002,66527.27,135682.49]
[77,225.21,650.15,14542.72,52859.91,67402.63,135457.28]
[78,226.29,649.07000000000005,14769.01,53508.98,68277.990000000005,135230.99]
[79,227.38,647.98,14996.39,54156.959999999999,69153.350000000006,135003.60999999999]
[80,228.47,646.89,15224.86,54803.85,70028.710000000006,134775.14000000001]
[81,229.56,645.79999999999995,15454.42,55449.65,70904.070000000007,134545.57999999999]
[82,230.66,644.70000000000005,15685.08,56094.35,71779.429999999993,134314.92000000001]
[83,231.77,643.59,15916.85,56737.94,72654.789999999994,134083.15]
[84,232.88,642.48,16149.73,57380.42,73530.149999999994,133850.26999999999]
[85,233.99,641.37,16383.72,58021.79,74405.509999999995,133616.28]
[86,235.11,640.24,16618.830000000002,58662.03,75280.86,133381.17000000001]
[87,236.24,639.12,16855.07,59301.15,76156.22,133144.93]
[88,237.37,637.99,17092.439999999999,59939.14,77031.58,132907.56]
[89,238.51,636.85,17330.95,60575.99,77906.94,132669.04999999999]
[90,239.65,635.71,17570.599999999999,61211.7,78782.3,132429.4]
[91,240.8,634.55999999999995,17811.400000000001,61846.26,79657.66,132188.6]
[92,241.96,633.4,18053.36,62479.66,80533.02,131946.64000000001]
[93,243.12,632.24,18296.48,63111.9,81408.38,131703.51999999999]
[94,244.28,631.08000000000004,18540.759999999998,63742.98,82283.740000000005,131459.24]
[95,245.45,629.91,18786.21,64372.89,83159.100000000006,131213.79]
[96,246.63,628.73,19032.84,65001.62,84034.46,130967.16]
[97,247.81,627.54999999999995,19280.650000000001,65629.17,84909.82,130719.35]
[98,249,626.36,19529.650000000001,66255.53,85785.18,130470.35]
[99,250.19,625.16999999999996,19779.84,66880.7,86660.54,130220.16]
[100,251.39,623.97,20031.23,67504.67,87535.9,129968.77]
[101,252.59,622.77,20283.82,68127.44,88411.26,129716.18]
[102,253.8,621.55999999999995,20537.62,68749,89286.62,129462.38]
[103,255.02,620.34,20792.64,69369.34,90161.98,129207.36]
[104,256.24,619.12,21048.880000000001,69988.460000000006,91037.34,128951.12]
[105,257.47000000000003,617.89,21306.35,70606.350000000006,91912.7,128693.65]
[106,258.7,616.66,21565.05,71223.009999999995,92788.06,128434.95]
[107,259.94,615.41999999999996,21824.99,71838.429999999993,93663.42,128175.01]
[108,261.19,614.16999999999996,22086.18,72452.600000000006,94538.78,127913.82]
[109,262.44,612.91999999999996,22348.62,73065.52,95414.14,127651.38]
[110,263.7,611.66,22612.32,73677.179999999993,96289.5,127387.68]
[111,264.95999999999998,610.4,22877.279999999999,74287.58,97164.86,127122.72]
[112,266.23,609.13,23143.51,74896.710000000006,98040.22,126856.49]
[113,267.51,607.85,23411.02,75504.56,98915.58,126588.98]
[114,268.79000000000002,606.57000000000005,23679.81,76111.13,99790.94,126320.19]
[115,270.07,605.28,23949.88,76716.41,100666.29,126050.12]
[116,271.37,603.99,24221.25,77320.399999999994,101541.65,125778.75]
[117,272.67,602.69000000000005,24493.919999999998,77923.09,102417.01,125506.08]
[118,273.98,601.38,24767.9,78524.47,103292.37,125232.1]
[119,275.29000000000002,600.07000000000005,25043.19,79124.539999999994,104167.73,124956.81]
[120,276.61,598.75,25319.8,79723.289999999994,105043.09,124680.2]
[121,277.93,597.42999999999995,25597.73,80320.72,105918.45,124402.27]
[122,279.27,596.09,25877,80916.81,106793.81,124123]
[123,280.60000000000002,594.76,26157.599999999999,81511.570000000007,107669.17,123842.4]
[124,281.95,593.41,26439.55,82104.98,108544.53,123560.45]
[125,283.3,592.05999999999995,26722.85,82697.039999999994,109419.89,123277.15]
[126,284.66000000000003,590.70000000000005,27007.51,83287.740000000005,110295.25,122992.49]
[127,286.02,589.34,27293.53,83877.08,111170.61,122706.47]
[128,287.39,587.97,27580.92,84465.05,112045.97,122419.08]
[129,288.77,586.59,27869.69,85051.64,112921.33,122130.31]
[130,290.14999999999998,585.21,28159.84,85636.85,113796.69,121840.16]
[131,291.54000000000002,583.82000000000005,28451.38,86220.67,114672.05,121548.62]
[132,292.94,582.41999999999996,28744.32,86803.09,115547.41,121255.67999999999]
[133,294.33999999999997,581.02,29038.66,87384.11,116422.77,120961.34]
[134,295.75,579.61,29334.41,87963.72,117298.13,120665.59]
[135,297.17,578.19000000000005,29631.58,88541.91,118173.49,120368.42]
[136,298.58999999999997,576.77,29930.17,89118.68,119048.85,120069.83]
[137,300.02,575.33000000000004,30230.19,89694.01,119924.2,119769.81]
[138,301.45999999999998,573.9,30531.65,90267.91,120799.56,119468.35]
[139,302.91000000000003,572.45000000000005,30834.560000000001,90840.36,121674.92,119165.44]
[140,304.36,571,31138.92,91411.36,122550.28,118861.08]
[141,305.82,569.54,31444.74,91980.9,123425.64,118555.26]
[142,307.27999999999997,568.08000000000004,31752.02,92548.98,124301,118247.98]
[143,308.75,566.61,32060.77,93115.59,125176.36,117939.23]
[144,310.23,565.13,32371,93680.72,126051.72,117629]
[145,311.72000000000003,563.64,32682.720000000001,94244.36,126927.08,117317.28]
[146,313.20999999999998,562.15,32995.93,94806.51,127802.44,117004.07]
[147,314.70999999999998,560.64,33310.639999999999,95367.15,128677.79,116689.36]
[148,316.22000000000003,559.14,33626.86,95926.29,129553.15,116373.14]
[149,317.74,557.62,33944.6,96483.91,130428.51,116055.4]
[150,319.26,556.1,34263.86,97040.01,131303.87,115736.14]
[151,320.79000000000002,554.57000000000005,34584.65,97594.58,132179.23000000001,115415.35]
[152,322.33,553.03,34906.980000000003,98147.61,133054.59,115093.02]
[153,323.87,551.49,35230.85,98699.1,133929.95000000001,114769.15]
[154,325.42,549.94000000000005,35556.269999999997,99249.04,134805.31,114443.73]
[155,326.98,548.38,35883.25,99797.42,135680.67000000001,114116.75]
[156,328.55,546.80999999999995,36211.800000000003,100344.23,136556.03,113788.2]
[157,330.12,545.24,36541.919999999998,100889.47,137431.39000000001,113458.08]
[158,331.71,543.65,36873.629999999997,101433.12,138306.75,113126.37]
[159,333.3,542.05999999999995,37206.93,101975.18,139182.10999999999,112793.07]
[160,334.89,540.47,37541.82,102515.65,140057.47,112458.18]
[161,336.5,538.86,37878.32,103054.51,140932.82999999999,112121.68]
[162,338.11,537.25,38216.43,103591.76,141808.19,111783.57]
[163,339.73,535.63,38556.160000000003,104127.39,142683.54999999999,111443.84]
[164,341.36,534,38897.519999999997,104661.39,143558.91,111102.48]
[165,342.99,532.37,39240.51,105193.76,144434.26999999999,110759.49]
[166,344.64,530.72,39585.15,105724.48,145309.63,110414.85]
[167,346.29,529.07000000000005,39931.440000000002,106253.55,146184.99,110068.56]
[168,347.95,527.41,40279.39,106780.96,147060.35,109720.61]
[169,349.61,525.74,40629,107306.7,147935.70000000001,109371]
[170,351.29,524.07000000000005,40980.29,107830.77,148811.06,109019.71]
[171,352.97,522.39,41333.26,108353.16,149686.42000000001,108666.74]
[172,354.66,520.69000000000005,41687.919999999998,108873.85,150561.76999999999,108312.08]
[173,356.36,519,42044.28,109392.85,151437.13,107955.72]
[174,358.07,517.29,42402.35,109910.14,152312.49,107597.65]
[175,359.79,515.57000000000005,42762.14,110425.71,153187.85,107237.86]
[176,361.51,513.85,43123.65,110939.56,154063.21,106876.35]
[177,363.24,512.12,43486.89,111451.68,154938.57,106513.11]
[178,364.98,510.38,43851.87,111962.06,155813.93,106148.13]
[179,366.73,508.63,44218.6,112470.69,156689.29,105781.4]
[180,368.49,506.87,44587.09,112977.56,157564.65,105412.91]
[181,370.26,505.1,44957.35,113482.66,158440.01,105042.65]
[182,372.03,503.33,45329.38,113985.99,159315.37,104670.62]
[183,373.81,501.55,45703.19,114487.54,160190.73000000001,104296.81]
[184,375.6,499.76,46078.79,114987.3,161066.09,103921.21]
[185,377.4,497.96,46456.19,115485.26,161941.45000000001,103543.81]
[186,379.21,496.15,46835.4,115981.41,162816.81,103164.6]
[187,381.03,494.33,47216.43,116475.74,163692.17000000001,102783.57]
[188,382.85,492.5,47599.28,116968.24,164567.51999999999,102400.72]
[189,384.69,490.67,47983.97,117458.91,165442.88,102016.03]
[190,386.53,488.83,48370.5,117947.74,166318.24,101629.5]
[191,388.38,486.97,48758.879999999997,118434.71,167193.59,101241.12]
[192,390.25,485.11,49149.13,118919.82,168068.95,100850.87]
[193,392.12,483.24,49541.25,119403.06,168944.31,100458.75]
[194,393.99,481.36,49935.24,119884.42,169819.66,100064.76]
[195,395.88,479.48,50331.12,120363.9,170695.02,99668.88]
[196,397.78,477.58,50728.9,120841.48,171570.38,99271.1]
[197,399.69,475.67,51128.59,121317.15,172445.74,98871.41]
[198,401.6,473.76,51530.19,121790.91,173321.1,98469.81]
[199,403.52,471.83,51933.71,122262.74,174196.45,98066.29]
[200,405.46,469.9,52339.17,122732.64,175071.81,97660.83]
[201,407.4,467.96,52746.57,123200.6,175947.17,97253.43]
[202,409.35,466.01,53155.92,123666.61,176822.53,96844.08]
[203,411.31,464.04,53567.23,124130.65,177697.88,96432.77]
[204,413.29,462.07,53980.52,124592.72,178573.24,96019.48]
[205,415.27,460.09,54395.79,125052.81,179448.6,95604.21]
[206,417.26,458.1,54813.05,125510.91,180323.96,95186.95]
[207,419.26,456.1,55232.31,125967.01,181199.32,94767.69]
[208,421.26,454.1,55653.57,126421.11,182074.68,94346.43]
[209,423.28,452.08,56076.85,126873.19,182950.04,93923.15]
[210,425.31,450.05,56502.16,127323.24,183825.4,93497.84]
[211,427.35,448.01,56929.51,127771.25,184700.76,93070.49]
[212,429.4,445.96,57358.91,128217.21,185576.12,92641.09]
[213,431.45,443.91,57790.36,128661.12,186451.48,92209.64]
[214,433.52,441.84,58223.88,129102.96,187326.84,91776.12]
[215,435.6,439.76,58659.48,129542.72,188202.2,91340.52]
[216,437.69,437.67,59097.17,129980.39,189077.56,90902.83]
[217,439.78,435.58,59536.95,130415.97,189952.92,90463.05]
[218,441.89,433.47,59978.84,130849.44,190828.28,90021.16]
[219,444.01,431.35,60422.85,131280.79,191703.64,89577.15]
[220,446.14,429.22,60868.99,131710.01,192579,89131.01]
[221,448.27,427.09,61317.26,132137.1,193454.36,88682.74]
[222,450.42,424.94,61767.68,132562.04,194329.72,88232.320000000007]
[223,452.58,422.78,62220.26,132984.82,195205.08,87779.74]
[224,454.75,420.61,62675.01,133405.43,196080.44,87324.99]
[225,456.93,418.43,63131.94,133823.85999999999,196955.8,86868.06]
[226,459.12,416.24,63591.06,134240.1,197831.16,86408.94]
[227,461.32,414.04,64052.38,134654.14000000001,198706.52,85947.62]
[228,463.53,411.83,64515.91,135065.97,199581.88,85484.09]
[229,465.75,409.61,64981.66,135475.57999999999,200457.24,85018.34]
[230,467.98,407.38,65449.64,135882.96,201332.6,84550.36]
[231,470.22,405.14,65919.86,136288.1,202207.96,84080.14]
[232,472.48,402.88,66392.34,136690.98000000001,203083.32,83607.66]
[233,474.74,400.62,66867.08,137091.6,203958.68,83132.92]
[234,477.01,398.35,67344.09,137489.95000000001,204834.04,82655.91]
[235,479.3,396.06,67823.39,137886.01,205709.4,82176.61]
[236,481.6,393.76,68304.990000000005,138279.76999999999,206584.76,81695.009999999995]
[237,483.9,391.46,68788.89,138671.23000000001,207460.12,81211.11]
[238,486.22,389.14,69275.11,139060.37,208335.48,80724.89]
[239,488.55,386.81,69763.66,139447.18,209210.84,80236.34]
[240,490.89,384.47,70254.55,139831.65,210086.2,79745.45]
[241,493.25,382.11,70747.8,140213.76000000001,210961.56,79252.2]
[242,495.61,379.75,71243.41,140593.51,211836.92,78756.59]
[243,497.98,377.38,71741.39,140970.89000000001,212712.28,78258.61]
[244,500.37,374.99,72241.759999999995,141345.88,213587.64,77758.240000000005]
[245,502.77,372.59,72744.53,141718.47,214463,77255.47]
[246,505.18,370.18,73249.710000000006,142088.65,215338.36,76750.289999999994]
[247,507.6,367.76,73757.31,142456.41,216213.72,76242.69]
[248,510.03,365.33,74267.34,142821.74,217089.08,75732.66]
[249,512.47,362.89,74779.81,143184.63,217964.44,75220.19]
[250,514.92999999999995,360.43,75294.740000000005,143545.06,218839.8,74705.259999999995]
[251,517.4,357.96,75812.14,143903.01999999999,219715.16,74187.86]
[252,519.88,355.48,76332.02,144258.5,220590.52,73667.98]
[253,522.37,352.99,76854.39,144611.49,221465.88,73145.61]
[254,524.87,350.49,77379.259999999995,144961.98000000001,222341.24,72620.740000000005]
[255,527.39,347.97,77906.649999999994,145309.95000000001,223216.6,72093.350000000006]
[256,529.91,345.45,78436.56,145655.4,224091.96,71563.44]
[257,532.45000000000005,342.91,78969.009999999995,145998.31,224967.32,71030.990000000005]
[258,535,340.36,79504.009999999995,146338.67000000001,225842.68,70495.990000000005]
[259,537.57000000000005,337.79,80041.58,146676.46,226718.04,69958.42]
[260,540.14,335.22,80581.72,147011.68,227593.4,69418.28]
[261,542.73,332.63,81124.45,147344.31,228468.76,68875.55]
[262,545.33000000000004,330.03,81669.78,147674.34,229344.12,68330.22]
[263,547.94000000000005,327.42,82217.72,148001.76,230219.48,67782.28]
[264,550.57000000000005,324.79000000000002,82768.289999999994,148326.54999999999,231094.84,67231.710000000006]
[265,553.21,322.14999999999998,83321.5,148648.70000000001,231970.2,66678.5]
[266,555.86,319.5,83877.36,148968.20000000001,232845.56,66122.64]
[267,558.52,316.83999999999997,84435.88,149285.04,233720.92,65564.12]
[268,561.20000000000005,314.16000000000003,84997.08,149599.20000000001,234596.28,65002.92]
[269,563.89,311.47000000000003,85560.97,149910.67000000001,235471.64,64439.03]
[270,566.59,308.77,86127.56,150219.44,236347,63872.44]
[271,569.29999999999995,306.06,86696.86,150525.5,237222.36,63303.14]
[272,572.03,303.33,87268.89,150828.82999999999,238097.72,62731.11]
[273,574.77,300.58999999999997,87843.66,151129.42000000001,238973.08,62156.34]
[274,577.53,297.83,88421.19,151427.25,239848.44,61578.81]
[275,580.29,295.07,89001.48,151722.32,240723.8,60998.52]
[276,583.07000000000005,292.27999999999997,89584.55,152014.6,241599.15,60415.45]
[277,585.87,289.49,90170.42,152304.09,242474.51,59829.58]
[278,588.67999999999995,286.68,90759.1,152590.76999999999,243349.87,59240.9]
[279,591.5,283.86,91350.6,152874.63,244225.23,58649.4]
[280,594.33000000000004,281.02999999999997,91944.93,153155.66,245100.59,58055.07]
[281,597.17999999999995,278.18,92542.11,153433.84,245975.95,57457.89]
[282,600.04,275.32,93142.15,153709.16,246851.31,56857.85]
[283,602.91999999999996,272.44,93745.07,153981.6,247726.67,56254.93]
[284,605.79999999999995,269.55,94350.87,154251.15,248602.02,55649.13]
[285,608.71,266.64999999999998,94959.58,154517.79999999999,249477.38,55040.42]
[286,611.62,263.74,95571.199999999997,154781.54,250352.74,54428.800000000003]
[287,614.54999999999995,260.8,96185.75,155042.34,251228.09,53814.25]
[288,617.5,257.86,96803.25,155300.20000000001,252103.45,53196.75]
[289,620.46,254.9,97423.71,155555.1,252978.81,52576.29]
[290,623.42999999999995,251.93,98047.14,155807.03,253854.17,51952.86]
[291,626.41999999999996,248.94,98673.56,156055.97,254729.53,51326.44]
[292,629.41999999999996,245.94,99302.98,156301.91,255604.89,50697.02]
[293,632.44000000000005,242.92,99935.42,156544.82999999999,256480.25,50064.58]
[294,635.47,239.89,100570.89,156784.72,257355.61,49429.11]
[295,638.51,236.85,101209.4,157021.57,258230.97,48790.6]
[296,641.57000000000005,233.79,101850.97,157255.35999999999,259106.33,48149.03]
[297,644.65,230.71,102495.62,157486.07,259981.69,47504.38]
[298,647.73,227.63,103143.35,157713.70000000001,260857.05,46856.65]
[299,650.84,224.52,103794.19,157938.22,261732.41,46205.81]
[300,653.96,221.4,104448.15,158159.62,262607.77,45551.85]
[301,657.09,218.27,105105.24,158377.89000000001,263483.13,44894.76]
[302,660.24,215.12,105765.48,158593.01,264358.49,44234.52]
[303,663.4,211.96,106428.88,158804.97,265233.84999999998,43571.12]
[304,666.58,208.78,107095.46,159013.75,266109.21000000002,42904.54]
[305,669.78,205.58,107765.24,159219.32999999999,266984.57,42234.76]
[306,672.98,202.37,108438.22,159421.70000000001,267859.92,41561.78]
[307,676.21,199.15,109114.43,159620.85,268735.28000000003,40885.57]
[308,679.45,195.91,109793.88,159816.76,269610.64,40206.120000000003]
[309,682.71,192.65,110476.59,160009.41,270486,39523.410000000003]
[310,685.98,189.38,111162.57,160198.79,271361.36,38837.43]
[311,689.26,186.1,111851.83,160384.89000000001,272236.71999999997,38148.17]
[312,692.57,182.79,112544.4,160567.67999999999,273112.08,37455.599999999999]
[313,695.88,179.47,113240.28,160747.15,273987.43,36759.72]
[314,699.22,176.14,113939.5,160923.29,274862.78999999998,36060.5]
[315,702.57,172.79,114642.07,161096.07999999999,275738.15000000002,35357.93]
[316,705.94,169.42,115348.01,161265.5,276613.51,34651.99]
[317,709.32,166.04,116057.33,161431.54,277488.87,33942.67]
[318,712.72,162.63999999999999,116770.05,161594.18,278364.23,33229.949999999997]
[319,716.13,159.22999999999999,117486.18,161753.41,279239.59000000003,32513.82]
[320,719.56,155.80000000000001,118205.74,161909.21,280114.95,31794.26]
[321,723.01,152.35,118928.75,162061.56,280990.31,31071.25]
[322,726.48,148.88,119655.23,162210.44,281865.67,30344.77]
[323,729.96,145.4,120385.19,162355.84,282741.03000000003,29614.81]
[324,733.45,141.9,121118.64,162497.74,283616.38,28881.360000000001]
[325,736.97,138.38999999999999,121855.61,162636.13,284491.74,28144.39]
[326,740.5,134.86000000000001,122596.11,162770.99,285367.09999999998,27403.89]
[327,744.05,131.31,123340.16,162902.29999999999,286242.46000000002,26659.84]
[328,747.61,127.75,124087.77,163030.04999999999,287117.82,25912.23]
[329,751.2,124.16,124838.97,163154.21,287993.18,25161.03]
[330,754.8,120.56,125593.77,163274.76999999999,288868.53999999998,24406.23]
[331,758.41,116.95,126352.18,163391.72,289743.90000000002,23647.82]
[332,762.05,113.31,127114.23,163505.03,290619.26,22885.77]
[333,765.7,109.66,127879.93,163614.69,291494.62,22120.07]
[334,769.37,105.99,128649.3,163720.68,292369.98,21350.7]
[335,773.05,102.31,129422.35,163822.99,293245.34000000003,20577.650000000001]
[336,776.76,98.6,130199.11,163921.59,294120.7,19800.89]
[337,780.48,94.88,130979.59,164016.47,294996.06,19020.41]
[338,784.22,91.14,131763.81,164107.60999999999,295871.42,18236.189999999999]
[339,787.98,87.38,132551.79,164194.99,296746.78000000003,17448.21]
[340,791.75,83.61,133343.54,164278.6,297622.14,16656.46]
[341,795.55,79.81,134139.09,164358.41,298497.5,15860.91]
[342,799.36,76,134938.45000000001,164434.41,299372.86,15061.55]
[343,803.19,72.17,135741.64000000001,164506.57999999999,300248.21999999997,14258.36]
[344,807.04,68.319999999999993,136548.68,164574.9,301123.58,13451.32]
[345,810.9,64.45,137359.57999999999,164639.35,301998.93,12640.42]
[346,814.79,60.57,138174.37,164699.92000000001,302874.28999999998,11825.63]
[347,818.69,56.66,138993.06,164756.57999999999,303749.64,11006.94]
[348,822.62,52.74,139815.67999999999,164809.32,304625,10184.32]
[349,826.56,48.8,140642.23999999999,164858.12,305500.36,9357.76]
[350,830.52,44.84,141472.76,164902.96,306375.71999999997,8527.24]
[351,834.5,40.86,142307.26,164943.82,307251.08,7692.74]
[352,838.5,36.86,143145.76,164980.68,308126.44,6854.24]
[353,842.52,32.840000000000003,143988.28,165013.51999999999,309001.8,6011.72]
[354,846.55,28.81,144834.82999999999,165042.32999999999,309877.15999999997,5165.17]
[355,850.61,24.75,145685.44,165067.07999999999,310752.52,4314.5600000000004]
[356,854.69,20.67,146540.13,165087.75,311627.88,3459.87]
[357,858.78,16.579999999999998,147398.91,165104.32999999999,312503.24,2601.09]
[358,862.9,12.46,148261.81,165116.79,313378.59999999998,1738.19]
[359,867.03,8.33,149128.84,165125.12,314253.96000000002,871.16]
[360,871.18,4.17,150000.01999999999,165129.29,315129.31,-0.02]

{"sheet":"Disclosure","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,2,13,3],[12,0,12,3],[14,0,15,0],[14,1,15,1]]}
["Expert Financial Services, Inc."]
["Residential Mortgage Kit"]
[]
["Date:",{"$f":"NOW()","v":"2011-03-05T19:37:32.150"}]
["Creditor:","Expert Financial Services, Inc."]
["Borrower:",{"$f":"'Customer Information'!$B$4","v":0}]
["Property Location:",{"$f":"'Customer Information'!$B$13","v":0}]
[]
[]
["Annual Percentage Rate\nThe cost of your credit as a yearly Rate","Finance Charge\nThe dollar amount the credit will cost you","Amount Financed\nThe amount of credit provided to you on your behalf","Total of Payments\nThe amount you will have paid after you have made all scheduled payments"]
[{"$f":"'Customer Information'!$F$8","v":5.7500000000000002E-2},{"$f":"-CUMIPMT(A11/12,A15,C11,1,A15,0)","v":165129.34247951859},{"$f":"'Customer Information'!F6","v":150000},{"$f":"B11+C11","v":315129.34247951861}]
[]
["Payment Schedule"]
["Number of Payments","Amount of Payments","When Payments are Due"]
[{"$f":"'Customer Information'!F10*12","v":360},{"$f":"PMT('Customer Information'!F8/12,'Customer Information'!F10*12,-'Customer Information'!F6)","v":875.35928466532948},"First:",{"$f":"B4+15","v":"2011-03-20T19:37:32.150"}]
[null,null,"Last:",{"$f":"DATE(YEAR(D15),MONTH(D15)+A15,DAY(D15))","v":"2041-03-20"}]