{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Initial Info","Initial Cost Disclosure","Final Info","Final Cost Disclosure","Price Schedule","(Funds to Closer)","(Funds to AH)","Pmt Ltr","Stmt","Reconciliation","Lease Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Initial Info","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[0,0,0,12],[6,0,6,4],[24,1,24,4],[25,0,25,4],[29,11,29,12],[15,0,15,4],[17,0,17,4],[18,0,18,4],[21,0,21,4],[22,1,22,4],[23,1,23,4],[24,9,24,10],[25,9,25,10],[26,0,26,4]]}
["Pre Qualification Information"]
[null,null,null,null,"Lease Number:"]
["Disclosure Date:",null,null,null,null,null,null,null,"Requires Data Entry"]
["Name of Correspondent:",null,null,null,null,null,null,null,"May Require Data Entry"]
["Program Participation Percentage:",null,null,null,null,null,null,null,"Should Not Change Data Values"]
["Applicant's Name:"]
["Co-Applicant Name:"]
[null,null,null,null,"Additional Applicant (if any):"]
[null,null,null,null,"Additional Applicant (if any):"]
[null,null,null,"Property Address:","Street:"]
[null,null,null,null,"City:"]
[null,null,null,null,"State:"]
[null,null,null,null,"Zip:"]
[null,null,null,null,"Email Address:"]
[null,null,null,null,"Phone #:"]
["Purchase Price:"]
[null,null,null,null,"Appraised Value:"]
["FHA Loan Interest Rate:"]
["Down Payment:",null,null,null,null,{"$f":"ROUNDUP(IF(F16>F17,ROUNDUP(F17*0.035,0)+F16-F17,F16*0.035),0)","v":0}]
[null,null,null,null,"UFMIP:",{"$f":"ROUND(IF(F16>F17,ROUNDDOWN(F17*0.965,0),F16-F19)*0.0175,2)","v":0}]
[null,null,null,null,"Gvt Entity FHA Insured Loan:",{"$f":"ROUNDDOWN(IF(F16>F17,F17*0.965,F16*0.965),0)+ROUNDDOWN(F20,0)","v":0}]
["Loan Terms:"]
[null,"1. Principle & Interest",null,null,null,{"$f":"PMT(F18/12,360,-F21)","v":0}]
[null,"2. Mo Mortgage Insurance",null,null,null,{"$f":"((F16-F19)*0.0055)/12","v":0}]
[null,"3. Annual Property Tax",null,null,null,null,null,"Monthly",null,{"$f":"F25/12","v":0}]
["4. Annual Hazard Insurance Premium",null,null,null,null,null,null,"Monthly",null,0]
["5. Estimated Cash to Close (from LE)"]
[null,null,null,null,"6. Seller Concessions"]
[]
["Is the Property Located in a Homeowner's Association?",null,null,null,null,null,"No",null,null,"If Yes, Premium:"]
["Leased Premesis utilities required to be in the name of the Owner?",null,null,null,null,null,"No",null,null,null,"per","Monthly"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L31=\"Monthly\",L30,IF(L31=\"Quarterly\",L30/3,IF(L31=\"Semi-Annually\",L30/6,IF(L31=\"Annually\",L30/12,0))))","v":0},"per Month"]
[]
[]
[]
["Assigned Customer Service Team Member:",null,null,null,null,"Needs Assignment"]

{"sheet":"Initial Cost Disclosure","index":1,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["CONSUMER COST DISCLOSURE: INITIAL ESTIMATE"]
[" THE EARNED EQUITY PROGRAM LONG-TERM PURCHASE AGREEMENT"]
[]
[null,"Disclosure Date:",{"$f":"'Initial Info'!F3","v":"00:00:00"}]
[]
[null,"Property Address:",{"$f":"'Initial Info'!F10","v":0},null,null,"Future Buyers:",{"$f":"'Initial Info'!F6","v":0}]
[null,null,{"$f":"'Initial Info'!F11&\", \"&'Initial Info'!F12&\" \"&'Initial Info'!F13","v":",  "},null,null,null,{"$f":"IF('Initial Info'!F7=\"\",\"\",'Initial Info'!F7)","v":""}]
[]
[null,"FHA Loan Interest Rate:",{"$f":"'Initial Info'!F18","v":0},null,null,"Efffective Program Rate",{"$f":"'Price Schedule'!E8","v":{"$error":"#NUM!"}}]
[]
[null,"Property Purchase Price (per Purchase Agreement):",null,null,null,null,null,{"$f":"'Initial Info'!F16","v":0}]
[null,"Initial Option Price* (after all costs are paid in full)",null,null,null,null,null,{"$f":"'Initial Info'!F21","v":0}]
[]
[null,"Monthly Payment"]
[]
[null,"Purchase Contract Term:\t",null,"10 Years with five-year guaranteed extension"]
[null,"Base Monthly Payment (Rent):",null,null,null,null,{"$f":"'Initial Info'!F23+ROUND('Initial Info'!F21*0.005/12,2)","v":0}]
[null,"Variable Portion: Mortgage Insurance, Property Tax, and Insurance\t",null,null,null,null,{"$f":"+'Initial Info'!F24+'Initial Info'!J25+'Initial Info'!J26","v":0}]
[null,"Expense:  HOA Dues (prorated to monthly amount-if necessary)",null,null,null,null,{"$f":"IF('Initial Info'!G30=\"No\",0,'Initial Info'!L32)","v":0}]
[]
[null,"This Is Your Initial Estimated Total Monthly Payment:",null,null,null,null,{"$f":"SUM(G17:G19)","v":0}]
[null,"Total Costs of this Transaction (Estimate)"]
[null,{"$f":"IF('Initial Info'!F5=\"\",\"\",\"Program Participation Fee:\")","v":""},null,null,null,null,{"$f":"IF('Initial Info'!F5=\"\",\"\",'Initial Info'!F21*'Initial Info'!F5)","v":""}]
[null,"Lease Security Deposit (Refundable):",null,null,null,null,100]
[null,"HOA Service Fee (if in HOA):",null,null,null,null,{"$f":"IF('Initial Info'!G30=\"Yes\",250,0)","v":0}]
[null,"Utility Management Setup Fee (if required):",null,null,null,null,{"$f":"IF('Initial Info'!G31=\"Yes\",50,0)","v":0}]
[null,"Notary Fee",null,null,null,null,150]
[null,"Program Underwriting / Processing Fee:",null,null,null,null,1250]
[null,"Long-Term Purchase Contract:  OPTION FEE",null,null,null,null,{"$f":"SUM(H30:H32)","v":0}]
[null,null,"Total FHA Loan Down Payment (Included in Opiton Fee):",null,null,null,"(+)",{"$f":"'Initial Info'!F19","v":0}]
[null,null,"Total FHA Loan Closing Costs (Included in Option Fee):",null,null,null,"(+)",{"$f":"'Initial Info'!F27-'Initial Info'!F19+'Initial Info'!F16*0.01","v":0}]
[null,null,"Program Management Fee (Included In Option Fee):",null,null,null,"(+)",{"$f":"IF('Initial Info'!F16<='Initial Info'!F17,0.005*'Initial Info'!F16,'Initial Info'!F17*0.005)","v":0}]
[null,"First Month Payment Collected Upfront",null,null,null,null,{"$f":"G21","v":0}]
[]
[null,"Total Estimated Required Funds to Close the Transaction:",null,null,null,null,{"$f":"SUM(G23:G29)+G33","v":1500}]
[null,"   *** Seller Concessions (reduces the above Required Funds to Close)",null,null,null,null,{"$f":"'Initial Info'!F28","v":0}]
[]
[null,"Credits not Applied in the Above Section"]
[]
[]
[null,"Updated Cash to Close with Applied Credits"]
[]
["I (We) understand that the fees described are an estimate of costs only.  All fees will be confirmed and I (We) will"]
["receive an updated and Final Cost Disclosure prior to signing the final Long-Term Purhase Agreement and Lease."]
[]
["My (Our) signature acknowledges receipt of this disclosure."]
[]
[]
[{"$f":"G6","v":0},null,null,null,null,null,"Date"]
[]
[]
[{"$f":"G7","v":""},null,null,null,null,null,"Date"]

{"sheet":"Final Info","index":2,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[26,7,26,9],[26,10,26,12],[27,10,27,12],[28,10,28,11],[33,12,33,13],[25,1,25,4],[39,3,39,6],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[26,1,26,4],[10,0,10,4],[17,0,17,4],[0,0,0,13],[19,0,19,4],[20,0,20,4],[23,0,23,4],[24,1,24,4]]}
["Confirmed Information"]
[null,null,null,null,"Lease Number:",null,{"$f":"'Initial Info'!F2:H2","v":0},0,0]
["Date of Disclosure:"]
["Closing Date:",null,null,null,null,null,null,null,null,"Requires Data Entry"]
["Name of Correspondent:",null,null,null,null,null,{"$f":"'Initial Info'!F4","v":0},null,null,"May Require Data Entry"]
["Program Participation Percentage:",null,null,null,null,null,{"$f":"'Initial Info'!F5","v":0},null,null,"Do Not Change Data Values"]
["Applicant's Name:",null,null,null,null,null,{"$f":"'Initial Info'!F6","v":0}]
["Co-Applicant Name:",null,null,null,null,null,{"$f":"IF('Initial Info'!F7=\"\",\"\",'Initial Info'!F7)","v":""}]
[null,null,null,null,"Additional Applicant (if any):",null,{"$f":"IF('Initial Info'!F8=\"\",\"\",'Initial Info'!F8)","v":""}]
[null,null,null,null,"Additional Applicant (if any):",null,{"$f":"IF('Initial Info'!F9=\"\",\"\",'Initial Info'!F9)","v":""}]
["Property Address (if available):",null,null,null,null,"Street:",{"$f":"'Initial Info'!F10","v":0}]
[null,null,null,null,null,"City:",{"$f":"'Initial Info'!F11","v":0}]
[null,null,null,null,null,"State:",{"$f":"'Initial Info'!F12","v":0}]
[null,null,null,null,null,"Zip:",{"$f":"'Initial Info'!F13","v":0}]
[null,null,null,null,null,"Tax Parcel ID:"]
[null,null,null,null,null,"Email Address:"]
[null,null,null,null,null,"Phone #:"]
["Purchase Price:",null,null,null,null,null,{"$f":"'Initial Info'!F16","v":0}]
[null,null,null,null,"Appraised Value:",null,{"$f":"'Initial Info'!F17","v":0}]
["FHA Loan Interest Rate:",null,null,null,null,null,{"$f":"'Initial Info'!F18","v":0}]
["Down Payment:",null,null,null,null,null,{"$f":"ROUNDUP(IF(G18>G19,G19*0.035+G18-G19,G18*0.035),0)","v":0}]
[null,null,null,null,"UFMIP:",null,{"$f":"ROUND(IF(G18>G19,ROUNDDOWN(G19*0.965,0),G18-G21)*0.0175,2)","v":0}]
[null,null,null,null,"Gvt Entity FHA Insured Loan:",null,{"$f":"ROUNDDOWN(IF(G18>G19,ROUNDDOWN(G19*0.965,0),(G18-G21))*1.0175,0)","v":0}]
["Loan Terms:"]
[null,"1. Principal & Interest",null,null,null,null,{"$f":"PMT(G20/12,360,-G23)","v":0}]
[null,"2. Mo Mortgage Insurance",null,null,null,null,{"$f":"ROUND(((G18-G21)*0.0055)/12,2)","v":0}]
[null,"3. Taxes & Insurance",null,null,null,null,{"$f":"ROUND(K27/12,2)+ROUND(K28/12,2)","v":0},"Annual Property Taxes",null,null,{"$f":"'Initial Info'!F25","v":0}]
[null,null,null,null,"4. HOA Dues",null,{"$f":"M36","v":0},null,null,"Annual Haz Insurance",{"$f":"'Initial Info'!F26","v":0}]
[null,null,null,null,"Total Monthly Mortgage Payment",null,{"$f":"SUM(G25:G28)","v":0}]
[null,null,null,null,"Total Lease Payment",null,{"$f":"G29+ROUND(G23*0.005/12,2)","v":0}]
[null,null,null,null,"5. Cash to Close",null,{"$f":"'Initial Info'!F27","v":0}]
[null,null,null,null,"6. Seller Concessions",null,{"$f":"'Initial Info'!F28","v":0}]
[]
["Is the Property Located in a Homeowner's Association?",null,null,null,null,null,null,{"$f":"'Initial Info'!G30","v":"No"},null,null,"If Yes, Premium:",null,{"$f":"'Initial Info'!L30","v":0}]
["Leased Premises utilities required to be in the name of the Owner?",null,null,null,null,null,null,"No",null,null,null,"per",{"$f":"'Initial Info'!L31","v":"Monthly"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M35=\"Monthly\",M34,IF(M35=\"Quarterly\",ROUNDUP(M34/3,2),IF(M35=\"Semi-Annually\",ROUNDUP(M34/6,2),IF(M35=\"Annually\",ROUNDUP(M34/12,2),0))))","v":0},"per Month"]
["Will the Hazard Insurance be provided by TRFA's Master Insurance Carrier?",null,null,null,null,null,null,"Yes"]
[]
[null,null,null,null,null,"Assigned Closer:","Needs Assignment"]
["Property County:"]
[]
["Property Legal Description:"]

{"sheet":"Final Cost Disclosure","index":3,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,7],[43,0,43,3],[45,0,45,3],[1,0,1,6],[4,0,4,1],[5,5,5,6],[6,5,6,6]]}
["CONSUMER COST DISCLOSURE:  FINAL"]
[" THE EARNED EQUITY PROGRAM LONG-TERM PURCHASE AGREEMENT"]
[]
[null,"Disclosure Date:",{"$f":"'Final Info'!G3","v":"00:00:00"},null,"Home Purchase Date:",{"$f":"'Final Info'!G4","v":"00:00:00"}]
[]
[null,"Property Address:",{"$f":"'Final Info'!G11","v":0},null,"Future Buyers:",{"$f":"'Final Info'!G7","v":0}]
[null,null,{"$f":"'Final Info'!G12&\",\"&'Final Info'!G13&\" \"&'Final Info'!G14","v":"0,0 0"},null,null,{"$f":"IF('Final Info'!G8=\"\",\"\",'Final Info'!G8)","v":""}]
[]
[null,null,"Property Purchase Price (per Purchase Agreement):",null,null,{"$f":"'Final Info'!G18","v":0}]
[null,null,"Day 1 Option Price* (after all costs are paid in full)",null,null,{"$f":"'Final Info'!G23","v":0}]
["FHA Loan Interest Rate",null,{"$f":"'Final Info'!G20","v":0},null,null,"Effective Program Interest Rate:",{"$f":"'Price Schedule'!E8","v":{"$error":"#NUM!"}}]
[]
["Initial Monthly Payment"]
[null,null,"Purchase Contract Term:\t","10 Years with five-year guaranteed extension"]
[null,"Base Monthly Payment",null,null,null,null,{"$f":"'Final Info'!G25+ROUND(('Final Info'!G23*0.005/12),2)","v":0}]
[null,"Expense: Mortgage Insurance, Property Tax ,& Hazaard Insurance Escrow",null,null,null,null,{"$f":"'Final Info'!G26+'Final Info'!G27","v":0}]
[null,"Expense: HOA Dues (prorated to monthly amount-if necessary)",null,null,null,null,{"$f":"'Final Info'!M36","v":0}]
[]
[null,"This is Your Initial Total Monthly Payment:",null,null,null,null,{"$f":"SUM(G15:G17)","v":0}]
[]
["Funds Due To Close Transaction"]
[null,{"$f":"IF('Final Info'!G6=0,\"\",\"Program Participation Fee:\")","v":""},null,null,null,{"$f":"IF('Final Info'!G6=0,\"\",ROUND('Final Info'!G23*0.0075,2))","v":""}]
[null,"Lease Security Deposit (Refundable):",null,null,null,100]
[null,"HOA Service Fee (if in HOA)",null,null,null,{"$f":"IF('Final Info'!H34=\"Yes\",250,0)","v":0}]
[null,"Utility Management Setup Fee (if required)",null,null,null,{"$f":"IF('Final Info'!H35=\"Yes\",50,0)","v":0}]
[null,"Notary Fee",null,null,null,150]
[null,"Program Underwriting / Processing Fee",null,null,null,1250]
[null,"Long-Term Purchase Contract:  OPTION FEE",null,null,null,{"$f":"SUM(G29:G31)","v":0}]
[null,null,"Total FHA Loan Down Payment (Included in Opiton Fee):",null,null,"(+)",{"$f":"'Final Info'!G21","v":0}]
[null,null,"Total FHA Loan Closing Costs (Included in Option Fee):",null,null,"(+)",{"$f":"'Final Info'!G31-'Final Cost Disclosure'!G29+'Final Cost Disclosure'!F9*0.01","v":0}]
[null,null,"Program Management Fee (Included In Option Fee):",null,null,"(+)",{"$f":"ROUND(F10*0.005,2)","v":0}]
[null,"First Month's Payment (Collected at Closing):",null,null,null,{"$f":"G19","v":0}]
[]
["Total FundsDue From Program Participant(s)",null,null,null,null,{"$f":"SUM(F22:F28)+F32","v":1500}]
[null,"***Seller Concessions (Included in the above Funds to Close calculation)",null,null,null,{"$f":"'Final Info'!G32","v":0}]
[]
["I (We) understand that the fees described must be paid before TRHEEA will purchase the selected property. Any delay in"]
["payment of these fees will delay TRHEEA's ability to complete the property purchase.  If the purchase is not completed by"]
["the contractually required date, I (we) may lose the opportunity to purchase the property, any earnest money deposit, and"]
["any other fees I (we) have paid. I (We) also understand that if the fees charged to TRHEEA for the home purchase change"]
["then these fees will change and I will receive a new disclosure and will be required to pay the difference."]
[]
[]
[{"$f":"F6","v":0}]
[null,null,null,null,null,null,"Date"]
[{"$f":"F7","v":""}]
[null,null,null,null,null,null,"Date"]

{"sheet":"Price Schedule","index":4,"n_rows":164,"n_cols":13,"rows_kept":164,"cut":false,"hidden":false,"merged":[[0,0,0,6],[8,8,8,11],[135,1,135,4],[138,1,138,4],[1,1,1,5],[5,1,5,2],[5,4,5,5],[6,4,6,5],[7,1,7,2]]}
["SCHEDULE A"]
[null,"Purchase Option Price Disclosure"]
[null,{"$f":"'Final Cost Disclosure'!C6","v":0},null,null,{"$f":"'Final Cost Disclosure'!F6","v":0}]
[null,{"$f":"'Final Cost Disclosure'!C7","v":"0,0 0"},null,null,{"$f":"'Final Cost Disclosure'!F7","v":""}]
[]
[null,"Purchase Price",null,null,{"$f":"'Final Cost Disclosure'!F9","v":0}]
[null,"Day 1 Option Price",null,null,{"$f":"'Final Info'!G23","v":0}]
[null,"Lease Interest Rate",null,null,{"$f":"RATE(480,-('Final Info'!G25+'Final Info'!G26+'Final Info'!G23*0.005/12),E7,0,0,9.75%)*12","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,"FHA Insured Mortgage"]
[null,"Month","Lease Payment","Total Tenant Credit","Monthly Tenant Credit","Option Price",null,"Interest","P&I","Interest","Principal","FHA Balance","Difference"]
[null,1,{"$f":"'Final Cost Disclosure'!G19","v":0},{"$f":"E11","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H11","v":{"$error":"#NUM!"}},{"$f":"E7-E11","v":{"$error":"#NUM!"}},null,{"$f":"E7*E8/12","v":{"$error":"#NUM!"}},null,null,null,{"$f":"'Final Cost Disclosure'!F10","v":0},{"$f":"F11-L11","v":{"$error":"#NUM!"}}]
[null,2,{"$f":"C11","v":0},{"$f":"D11+E12","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H12","v":{"$error":"#NUM!"}},{"$f":"F11-E12","v":{"$error":"#NUM!"}},null,{"$f":"$E$8*F11/12","v":{"$error":"#NUM!"}},{"$f":"'Final Info'!G25","v":0},{"$f":"'Final Info'!G23*'Final Info'!G20/12","v":0},{"$f":"I12-J12","v":0},{"$f":"'Final Info'!G23-K12","v":0},{"$error":"#NUM!"}]
[null,3,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H13","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$f":"I12","v":0},{"$f":"L12*'Final Info'!$G$20/12","v":0},0,{"$f":"L12-K13","v":0},{"$error":"#NUM!"}]
[null,4,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H14","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L13*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,5,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H15","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L14*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,6,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H16","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L15*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,7,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H17","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L16*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,8,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H18","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L17*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,9,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H19","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L18*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,10,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H20","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L19*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,11,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H21","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L20*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,12,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H22","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L21*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,13,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H23","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L22*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,14,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H24","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L23*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,15,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H25","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L24*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,16,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H26","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L25*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,17,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H27","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L26*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,18,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H28","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L27*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,19,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H29","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L28*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,20,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H30","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L29*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,21,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L30*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,22,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H32","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L31*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,23,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H33","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L32*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,24,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H34","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L33*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,25,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H35","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L34*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,26,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H36","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L35*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,27,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H37","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L36*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,28,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H38","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L37*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,29,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H39","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L38*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,30,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H40","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L39*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,31,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H41","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L40*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,32,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H42","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L41*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,33,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H43","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L42*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,34,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H44","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L43*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,35,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H45","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L44*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,36,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H46","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L45*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,37,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H47","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L46*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,38,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H48","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L47*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,39,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H49","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L48*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,40,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H50","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L49*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,41,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H51","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L50*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,42,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H52","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},"Sch A Page 1",{"$error":"#NUM!"},0,{"$f":"L51*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,"Month","Monthly Lease Payment","Total Tenant Credit","Monthly Tenant Credit","Option Price"]
[null,43,{"$f":"C52","v":0},{"$f":"D52+E54","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H54","v":{"$error":"#NUM!"}},{"$f":"F52-E54","v":{"$error":"#NUM!"}},null,{"$f":"$E$8*F52/12","v":{"$error":"#NUM!"}},{"$f":"I52","v":0},{"$f":"L52*'Final Info'!$G$20/12","v":0},0,{"$f":"L52-K54","v":0},{"$f":"F54-L54","v":{"$error":"#NUM!"}}]
[null,44,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H55","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L54*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,45,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H56","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L55*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,46,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H57","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L56*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,47,{"$f":"C57","v":0},{"$f":"D57+E58","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H58","v":{"$error":"#NUM!"}},{"$f":"F57-E58","v":{"$error":"#NUM!"}},null,{"$f":"$E$8*F57/12","v":{"$error":"#NUM!"}},{"$f":"I57","v":0},{"$f":"L57*'Final Info'!$G$20/12","v":0},{"$f":"I58-J58","v":0},{"$f":"L57-K58","v":0},{"$error":"#NUM!"}]
[null,48,{"$f":"C58","v":0},{"$f":"D58+E59","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H59","v":{"$error":"#NUM!"}},{"$f":"F58-E59","v":{"$error":"#NUM!"}},null,{"$f":"$E$8*F58/12","v":{"$error":"#NUM!"}},{"$f":"I58","v":0},{"$f":"L58*'Final Info'!$G$20/12","v":0},0,{"$f":"L58-K59","v":0},{"$error":"#NUM!"}]
[null,49,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H60","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L59*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,50,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H61","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L60*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,51,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H62","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L61*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,52,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H63","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L62*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,53,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H64","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L63*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,54,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H65","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L64*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,55,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H66","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L65*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,56,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H67","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L66*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,57,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H68","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L67*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,58,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H69","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L68*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,59,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H70","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L69*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,60,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H71","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L70*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,61,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H72","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L71*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,62,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H73","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L72*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,63,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H74","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L73*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,64,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H75","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L74*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,65,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H76","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L75*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,66,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H77","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L76*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,67,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H78","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L77*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,68,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H79","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L78*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,69,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H80","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L79*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,70,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H81","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L80*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,71,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H82","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L81*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,72,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H83","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L82*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,73,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H84","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L83*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,74,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H85","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L84*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,75,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H86","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L85*'Final Info'!$G$20/12","v":0},0,0,{"$f":"F86-L86","v":{"$error":"#NUM!"}}]
[null,76,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H87","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L86*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,77,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H88","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L87*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,78,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H89","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L88*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,79,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H90","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L89*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,80,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H91","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L90*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,81,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H92","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L91*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,82,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H93","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L92*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,83,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H94","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L93*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,84,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H95","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L94*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,85,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H96","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L95*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,86,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H97","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L96*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,87,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H98","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L97*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,88,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H99","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L98*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,89,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H100","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L99*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,90,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H101","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L100*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,91,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H102","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L101*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,92,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H103","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L102*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,93,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H104","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L103*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,94,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H105","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L104*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,95,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H106","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L105*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,96,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H107","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L106*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,97,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H108","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},"Sch A Page 2",{"$error":"#NUM!"},0,{"$f":"L107*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,"Month","Monthly Lease Payment","Total Tenant Credit","Monthly Tenant Credit","Option Price",null,null,{"$f":"I108","v":0},{"$f":"L108*'Final Info'!$G$20/12","v":0},0,{"$f":"L108-K109","v":0},{"$f":"F110-L109","v":{"$error":"#NUM!"}}]
[null,98,{"$f":"C108","v":0},{"$f":"D108+E110","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H110","v":{"$error":"#NUM!"}},{"$f":"F108-E110","v":{"$error":"#NUM!"}},null,{"$f":"$E$8*F108/12","v":{"$error":"#NUM!"}},0,{"$f":"L109*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,99,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H111","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L110*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,100,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H112","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L111*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,101,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H113","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L112*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,102,{"$f":"C113","v":0},{"$f":"D113+E114","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H114","v":{"$error":"#NUM!"}},{"$f":"F113-E114","v":{"$error":"#NUM!"}},null,{"$f":"$E$8*F113/12","v":{"$error":"#NUM!"}},0,{"$f":"L113*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,103,{"$f":"C114","v":0},{"$f":"D114+E115","v":{"$error":"#NUM!"}},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H115","v":{"$error":"#NUM!"}},{"$f":"F114-E115","v":{"$error":"#NUM!"}},null,{"$f":"$E$8*F114/12","v":{"$error":"#NUM!"}},0,{"$f":"L114*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,104,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H116","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L115*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,105,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H117","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L116*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,106,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H118","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L117*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,107,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H119","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L118*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,108,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H120","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L119*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,109,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H121","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L120*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,110,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H122","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L121*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,111,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H123","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L122*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,112,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H124","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L123*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,113,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H125","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L124*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,114,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H126","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L125*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,115,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H127","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L126*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,116,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H128","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L127*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,117,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H129","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L128*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,118,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H130","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L129*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,119,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H131","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},0,{"$f":"L130*'Final Info'!$G$20/12","v":0},0,0,{"$error":"#NUM!"}]
[null,120,0,{"$error":"#NUM!"},{"$f":"('Final Info'!$G$25+'Final Info'!$G$26+'Final Info'!$G$23*0.005/12)-H132","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"}]
[]
[]
[]
[null,{"$f":"'Final Cost Disclosure'!F6","v":0},null,null,null,"Date"]
[]
[]
[null,{"$f":"IF('Final Cost Disclosure'!F7=\"\",\"\",'Final Cost Disclosure'!F7)","v":""},null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Sch A Page 3"]

{"sheet":"(Funds to Closer)","index":5,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,9],[2,0,2,9],[65,4,65,9],[6,7,6,9],[60,0,60,9]]}
["Instructions for Signing and Closing the Lease with Long-Term Purchase Agreement"]
[]
["THIS TRANSACTION IS A FUNDING REQUIREMENT FOR THE FHA LOAN"]
["  ON THE PROPERTY LOCATED AT:",null,null,null,null,null,null,{"$f":"'Final Info'!G11","v":0}]
[null,null,null,null,null,null,null,{"$f":"'Final Info'!G12&\", \"&'Final Info'!G13&\" \"&'Final Info'!G14","v":"0, 0 0"}]
[]
[null,null,null,null,null,null,"Program Participant(s):",{"$f":"'Final Info'!G7","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF('Final Cost Disclosure'!F7=\"\",\"\",'Final Cost Disclosure'!F7)","v":""}]
[]
["These instructions are designed to assist you to close the lease and long-term purchase agreement"]
["in conjunction with the FHA insured loan issued to Tule River Homebuyer Earned Equity Agency (TRHEEA)."]
["You have received, in conjunction with these lease documents, a FHA loan closing package and second"]
["mortgage loan documents for TRHEEA.  The loan documents will allow TRHEEA to acquire the"]
["home being leased to the Program Participant(s). The documents received with these instructions are a"]
["requirement of closing the Fha loan to TRHEEA and allow the Consumer to occupy the property under a Long-"]
["Term Purchase Agreement and Lease."]
[]
["As part of the program documentation, you should have received the following:"]
[null,"Consumer Lease Certification and Authorization-please have consumer sign and return to AH"]
[null,"Lease (with three exhibits)-please have consumer sign and please notarize, then return to AH"]
[null,"Long-Term Purchase Agreement-Please have consumer sign, then return to AH"]
[null,"Memorandum of Long-Term Purchase Agreement-please have consumer sign, please notarize, then"]
[null,null,"please record after recording the government entity's FHA insured first mortgage and second"]
[null,null,"mortgage."]
[null,"Consumer Cost Disclosure: Final-please have consumer sign, then return to AH"]
[null,"Purchase Option Price Disclosure-please have consumer initial each page, then return to AH"]
["You may also have received:"]
[null,"Purchase Contract Assignment Addendum (if included)-please have consumer sign and return to AH"]
[null,"Home Inspection Cure Agreement (if included)-please have consumer sign and return to AH"]
[]
["Returning documents to AH: Please provide a scanned copy of the signed lease package to "]
[null,"eep@arrivehome.org",null,null,"and ship the original signed copies to the Arrive Home address below."]
[]
["The Memorandum of Long-Term Purchase Agreement should be recorded after the FHA first and DPA second."]
["All other signed documentation should be forwarded to:"]
[null,"Arrive Home"]
[null,"8821 S Redwood Rd, Suite B"]
[null,"West Jordan, UT 84088"]
[]
["TOTAL FUNDS TO COLLECT FROM PROGRAM PARTICIPANT",null,null,null,null,null,null,null,null,{"$f":"'Final Cost Disclosure'!F34","v":1500}]
[{"$f":"IF('Final Info'!H37=\"Yes\",\"Hazard Insurance Premium\",\"\")","v":"Hazard Insurance Premium"},null,null,null,null,null,null,null,null,{"$f":"IF('Final Info'!H37=\"Yes\",'Final Info'!K28,\"\")","v":0}]
[]
["HOW TO DISTRIBUTE FUNDS"]
[]
["Total Funds Required to Close the FHA Loan to TRHEEA per CD",null,null,null,null,null,null,null,null,{"$f":"'Final Info'!G31","v":0}]
[]
["Total Funds to Send to TRHEEA",null,null,null,null,null,null,null,null,{"$f":"J40-J45","v":1500}]
[{"$f":"IF('Final Info'!H37=\"Yes\",\"Hazard Insurance Premium to Arrive Home (not included in amount above)\",\"\")","v":"Hazard Insurance Premium to Arrive Home (not included in amount above)"},null,null,null,null,null,null,null,null,{"$f":"IF('Final Info'!H37=\"Yes\",'Final Info'!K28,\"\")","v":0}]
[null,{"$f":"IF('Final Info'!H37=\"Yes\",\"(Hazard Insurance Premium may be included in the wire to TRHEEA or mailed separately.)\",\"\")","v":"(Hazard Insurance Premium may be included in the wire to TRHEEA or mailed separately.)"}]
[]
["Please send all AH funds either via wire or trackable carrier.  Shipped funds may be included with the lease"]
[null,"documents and sent to the West Jordan address above."]
[]
["Wire Instructions for Arrive Home:"]
["Beneficiary and/or Receipient name is Tule River Homebuyer Earned Equity Agency."]
[null,"Mountain America Credit Union"]
[null,"706 S Main St",null,null,null,null,"ABA:  324079555"]
[null,"Logan, UT 84321",null,null,null,null,"Acct #: 501013459117"]
[null,"(DO NOT MAIL DOCUMENTS TO THIS ADDRESS)"]
[]
["*Please reference the property address and Program Participant name on memo line.*"]
[]
["Please send wire confirmation to: accounting@arrivehome.org and reference the PROPERTY ADDRESS."]
[]
["Questions may be directed to:"]
[null,"File Processing:",null,null,{"$f":"'Final Info'!G39","v":"Needs Assignment"}]

{"sheet":"(Funds to AH)","index":6,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7],[40,0,40,7]]}
["Program Participant Wire Request and Reconciliation"]
[]
["RECEIPT OF THESE FUNDS IS A REQUIREMENT FOR THE PURCHASE"]
["  OF THE PROPERTY LOCATED AT:",null,null,null,{"$f":"'Final Info'!G11","v":0}]
[null,null,null,null,{"$f":"'Final Info'!G12&\", \"&'Final Info'!G13&\" \"&'Final Info'!G14","v":"0, 0 0"}]
[]
[null,null,null,"Program Participant(s):",{"$f":"'Final Info'!G7","v":0}]
[null,null,null,null,{"$f":"IF('Final Cost Disclosure'!F7:G7=\"\",\"\",'Final Cost Disclosure'!F7:G7)","v":""},""]
[]
["The wired funds must be received by the Tule River Homebuyer Earned Equity Agency in order to"]
["complete the purchase of the property identified above. Delay in sending funds will delay the loan "]
["closing and may result in the loss of earnest money provided towards the purchase contract."]
[]
["As part of the program documentation, you will be signing the following documents: "]
[null,"Consumer Lease Certification and Authorization"]
[null,"Lease (with three exhibits)"]
[null,"Long-Term Purchase Agreement"]
[null,"Memorandum of Long-Term Purchase Agreement"]
[null,"Consumer Cost Disclosure"]
[null,"Purchase Option Price Disclosure"]
[]
["Total Funds to Collect from the Program Participant",null,null,null,null,null,null,{"$f":"'Final Cost Disclosure'!F34","v":1500}]
[]
["How to Disburse Funds:"]
[]
["Total to Wire to Closing Entity to Close the FHA loan",null,null,null,null,null,null,{"$f":"'Final Info'!G31","v":0}]
[]
["Amount to Retain for Program Fees",null,null,null,null,null,null,{"$f":"H22-H26","v":1500}]
[]
["Amount AH to Receive After Closing (if applicable):"]
[{"$f":"IF('Final Info'!H37=\"Yes\",\"Closing Entity to Send Hazard Insurance Premium to AH\",\"None\")","v":"Closing Entity to Send Hazard Insurance Premium to AH"},null,null,null,null,null,null,{"$f":"IF('Final Info'!H37=\"Yes\",'Final Info'!K28,\"\")","v":0}]
[]
[]
["HOW TO SEND FUNDS TO TULE RIVER HOMEBUYER EARNED EQUITY AGENCY"]
[]
["Beneficiary  and/or Receiptient nameis Tule River Homebuyer Earned Equity Agency."]
[null,"Mountain America Credit Union"]
[null,"706 S Main St",null,null,"Routing #:  324079555"]
[null,"Logan, UT 84321",null,null,"Account #: 501013459117"]
[]
["*Please reference the property address and Program Participant name on memo line.*"]
[]
["Please email wire confirmation/receipt to: accounting@arrivehome.org and reference the PROPERTY"]
[" ADDRESS."]
["Questions may be directed to:"]
[null,"File Processing:",null,{"$f":"'Final Info'!G39","v":"Needs Assignment"}]

{"sheet":"Pmt Ltr","index":7,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,3],[38,0,38,3]]}
["PAYMENT LETTER"]
[]
[]
["Program Number:"]
[]
["Property Address:",{"$f":"'Final Info'!G11","v":0}]
[null,{"$f":"'Final Info'!G12&\", \"&'Final Info'!G13&\" \"&'Final Info'!G14","v":"0, 0 0"}]
[]
["Participant Name(s):",{"$f":"'Final Info'!G7","v":0}]
[null,{"$f":"'Final Info'!G8","v":""}]
[]
["Payment Amount:",{"$f":"'Final Info'!G30","v":0}]
["Due Date",{"$f":"EOMONTH(EOMONTH('Final Info'!G4,0)+1,0)+1","v":60}]
[]
["Please Send Your Monthly Payment to:"]
[]
[null,"Tule River Homebuyer Earned Equity Agency"]
[null,"5954 South Augustine Ave"]
[null,"Boise, ID 83709"]
["  "]
["  Make Checks Payable to:  Tule River Homebuyer Earned Equity Agency"]
[]
["You may also make your payments by bank draw by contacting TRHEEA by phone."]
[]
["          After applying your first payment, your Option Price will be reduced to:",null,null,{"$f":"'Price Schedule'!F11","v":{"$error":"#NUM!"}}]
["          After making this payment your Option Price will be reduced to:",null,null,{"$f":"'Price Schedule'!F12","v":{"$error":"#NUM!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["--------------------------------------------------------Detach Here--------------------------------------------------------"]
["Program Number:",{"$f":"IF('Final Info'!G2=\"\",\"TBD\",'Final Info'!G2)","v":0}]
["Property Address:",{"$f":"'Final Info'!G11","v":0}]
[null,{"$f":"'Final Info'!G12&\", \"&'Final Info'!G13&\" \"&'Final Info'!G14","v":"0, 0 0"}]
["Participant Name:",{"$f":"'Final Info'!G7","v":0}]
["Payment Due Date:",{"$f":"B13","v":60}]
["Payment Amount Due:",{"$f":"B12","v":0},"Amount Enclosed:"]

{"sheet":"Stmt","index":8,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,10],[44,3,44,4],[14,2,14,3],[15,2,15,3],[15,7,15,8],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[37,0,37,8],[38,2,38,3],[41,3,41,5],[42,3,42,5],[14,7,14,8]]}
["Program Statement"]
[null,null,null,null,null,null,null,"Statement Date",{"$f":"NOW()","v":"2024-05-20T09:27:34.520"}]
[]
[]
[]
[null,null,null,null,null,"Account Number",null,null,{"$f":"'Final Info'!G2","v":0}]
[null,null,null,null,null,"Payment Due Date",{"$f":"EOMONTH(I2,0)+1","v":"2024-06-01"},"Amount Due",{"$f":"'Final Cost Disclosure'!G19","v":0}]
[null,null,null,null,null,"if payment is received after",{"$f":"EOMONTH(G7,-1)+8","v":"2024-06-08"},"a late fee  will be charged"]
[null,{"$f":"'Final Info'!G7","v":0},null,null,null,null,null,"in the amount of",{"$f":"ROUND(I7*0.05,2)","v":0}]
[null,{"$f":"'Final Info'!G8","v":""}]
[null,{"$f":"'Final Info'!G11","v":0}]
[null,{"$f":"'Final Info'!G12&\", \"&'Final Info'!G13&\" \"&'Final Info'!G14","v":"0, 0 0"}]
[]
[{"$f":"EOMONTH(I2,-2)+1","v":"2024-04-01"},"Payment Breakdown",null,null,null,"Account Information"]
["Total Mo. Payment",null,{"$f":"I7","v":0},null,null,"Initial Option Price",null,{"$f":"'Price Schedule'!E7","v":0}]
["  Fixed Portion",null,{"$f":"'Final Cost Disclosure'!G15","v":0},null,null,"New Option Price",null,{"$f":"'Price Schedule'!F11","v":{"$error":"#NUM!"}}]
["    Interest Paid",null,{"$f":"'Price Schedule'!H11","v":{"$error":"#NUM!"}},null,null,"Interest Rate on FHA Loan",null,null,{"$f":"'Final Info'!G20","v":0}]
["    Credit to Opt Price",null,{"$f":"'Price Schedule'!E11","v":{"$error":"#NUM!"}}]
["Variable Portion",null,{"$f":"'Final Cost Disclosure'!G16","v":0}]
["    Property Taxes",null,{"$f":"'Final Info'!G27-'Final Info'!K28","v":0}]
["    Hazard Insurance",null,{"$f":"'Final Info'!K28","v":0}]
[]
["Please Mail Payments to:",null,null,"Tule River Homebuyer Earned Equity Agency"]
[null,null,null,"5954 S Augustine Way"]
[null,null,null,"Boise, ID 83709"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["--------------------------------------------------------Detach Here--------------------------------------------------------"]
["Account Number:",null,{"$f":"I6","v":0}]
["Property Address:",null,null,null,null,{"$f":"B11","v":0}]
[null,null,null,null,null,"0, 0 0"]
["Participant Name(s):",null,null,{"$f":"B9","v":0}]
[null,null,null,{"$f":"IF(B10=\"\",\"\",B10)","v":""}]
["Payment Due Date:",null,null,{"$f":"EOMONTH(I2,0)+1","v":"2024-06-01"}]
["Payment Amount Due:",null,null,{"$f":"I7","v":0}]
["Late Fee (if applicable)",null,null,{"$f":"ROUND(D45*0.05,2)","v":0}]
[]
[null,null,null,null,null,"Amount Enclosed:"]

{"sheet":"Reconciliation","index":9,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["CASH RECONCILIATION"]
[]
["When Borrower Sends Cash to Investor"]
[]
["CASH REQUIRED"]
["Down Payment:",{"$f":"'Final Cost Disclosure'!G29","v":0}]
["Net Closing Costs:",{"$f":"'Final Info'!G31-B6+0.01*'Final Cost Disclosure'!F9","v":0}]
["Lease Fees:",{"$f":"SUM('Final Cost Disclosure'!F22:F27)+'Final Cost Disclosure'!G31","v":1500}]
["1st Pmt:",{"$f":"'Final Cost Disclosure'!F32","v":0}]
[null,{"$f":"SUM(B6:B9)","v":1500}]
[]
["TOTAL CASH TO COLLECT FROM CONSUMER:",null,null,{"$f":"'Final Cost Disclosure'!F34","v":1500}]
[]
["CASH TO SEND TO CLOSING ENTITY:",null,null,{"$f":"'(Funds to AH)'!H26","v":0}]
[]
["CASH RETAINED BY TRFA:",null,null,{"$f":"D12-D14","v":1500}]
[]
["     AFTER CLOSING REIMBURSE DPA:",null,null,{"$f":"0.01*'Final Cost Disclosure'!F9","v":0}]
[]
[{"$f":"IF('Final Info'!H37=\"Yes\",\"     CLOSING ENTITY TO SEND HOI TO AH:\",\"\")","v":"     CLOSING ENTITY TO SEND HOI TO AH:"},null,null,{"$f":"IF('Final Info'!H37=\"Yes\",'Final Info'!K28,\"\")","v":0}]

{"sheet":"Lease Data","index":10,"n_rows":2,"n_cols":24,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Tenant 1","Tenant 2","Tenant 3","Tenant 4","Street","City","State","Zip","E-Mail","Phone #","Closing Date","Expiration Date","Legal Description","1st Amount","2nd Amount","Rate","Rent","Expenses","Option Fee","And 2","And 3","And 4","Tax Parcel ID","State 2"]
[{"$f":"'Final Info'!G7","v":0},{"$f":"'Final Info'!G8","v":""},{"$f":"'Final Info'!G9","v":""},{"$f":"'Final Info'!G10","v":""},{"$f":"'Final Info'!G11","v":0},{"$f":"'Final Info'!G12","v":0},{"$f":"'Final Info'!G13","v":0},{"$f":"'Final Info'!G14","v":0},{"$f":"'Final Info'!G16","v":0},{"$f":"IF('Final Info'!G17=\"\",\"\",'Final Info'!G17)","v":""},{"$f":"'Final Info'!G4","v":"00:00:00"},{"$f":"EDATE(EOMONTH(K2,0)-30,119)","v":"1909-12-01"},{"$f":"'Final Info'!E42","v":0},{"$f":"'Final Info'!G23","v":0},{"$f":"ROUNDDOWN(IF('Final Info'!G18>='Final Info'!G19,'Final Info'!G18*0.01,'Final Info'!G19*0.01),0)","v":0},{"$f":"'Final Info'!G20","v":0},{"$f":"'Final Cost Disclosure'!G15","v":0},{"$f":"'Final Cost Disclosure'!G16+'Final Cost Disclosure'!G17","v":0},{"$f":"'Final Cost Disclosure'!F28","v":0},{"$f":"IF(B2=\"\",\"\",\"and\")","v":""},{"$f":"IF(C2=\"\",\"\",\"and\")","v":""},{"$f":"IF(D2=\"\",\"\",\"and\")","v":""},{"$f":"'Final Info'!G15","v":0}]