{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Welcome","Macros","Update","Personal","Financial","Assets","Personal Assets","Business Assets","Liabilities","Personal Liabilities","Business Liabilities","Summary"],"not_rendered":{"charts":0,"images":58,"macros":1,"external_links":0,"defined_names":137,"comments":2,"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":"Welcome","index":0,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Welcome",null,null,null,null,null,"Yes","Yourself"]
[null,null,null,null,null,null,null,"No","Spouse"]
[null,"If an estate owner is to recieve sound advice from professional estate planners, a complete inventory must be taken. Such an inventory should include all pertinent data relative to the estate owner's assets, liabilities, future commitments and contingencies, family, responsibilities and personal objectives.\n",null,null,null,null,null,null,"Joint"]
[null,"As an aid in taking an estate planning inventory, the following information sheet was provided as a guide. All of the sections may not apply to everyone, and more pages may be needed in other sections. Modify or add to this inventory sheet as needed. Time invested by an estate owner in developing his estate inventory will generate many returns.\n"]
[null,"The inventory will arrange your personal affairs in an orderly manner. Your personal objectives will be formalized. Estate and retirement planners will be better able to assist you."]

{"sheet":"Macros","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,1,1,5],[3,1,8,5]]}
[]
[null,"Please enable macros!!!"]
[]
[null,"In order for this program to operate, macros must be enabled. If you chose not to enable the macros, please close the program and restart, enabling the macros."]
[]
[]
[]
[]
[]
[]
[]
[]
["2015-01-10T11:31:15"]

{"sheet":"Update","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Main Menu"]
[]
[]
[]
[null,null,null,"This is a detailed listing of family, their information, and information about your estate."]
[]
[null,null,null,"This will include personal incomes, benefits, and summaries of the last 5 years."]
[]
[null,null,null,"Assets will be listed seperately for personal and business."]
[]
[null,null,null,"Liabilities will be listed seperately for personal and business."]

{"sheet":"Personal","index":3,"n_rows":139,"n_cols":17,"rows_kept":139,"cut":false,"hidden":true,"merged":[[62,0,63,0],[27,0,27,1],[115,0,115,2],[129,1,129,2],[29,0,29,1],[55,1,55,2],[42,1,43,1],[46,1,47,1],[105,0,106,0],[108,0,110,0],[93,0,94,0],[121,0,122,0],[28,0,28,1]]}
[]
["Personal Information"]
["Yourself:"]
["First Name:"]
["Middle Name:"]
["Last Name:"]
["Date of Birth:"]
["SSN:"]
["Spouse:"]
["First Name:"]
["Middle Name:"]
["Last Name:"]
["Date of Birth:"]
["SSN:"]
[]
["Contact Information:"]
["Mailing Address:"]
["City:"]
["State:"]
["Zip Code:"]
["Home Phone:"]
["Business Phone:"]
["Mobile Phone:"]
["Mobile Phone:"]
["Primary Email:"]
[]
["Children:","(If married, give married name)"]
["Name:",null,"Age:","Phone:","Address:","City:","State:","Zip:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J29:P29)>=1,1,0)","v":0},{"$f":"IF(A29<>\"\",1,0)","v":0},{"$f":"IF(C29<>\"\",1,0)","v":0},{"$f":"IF(D29<>\"\",1,0)","v":0},{"$f":"IF(E29<>\"\",1,0)","v":0},{"$f":"IF(F29<>\"\",1,0)","v":0},{"$f":"IF(G29<>\"\",1,0)","v":0},{"$f":"IF(H29<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J30:P30)>=1,1,0)","v":0},{"$f":"IF(A30<>\"\",1,0)","v":0},{"$f":"IF(C30<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Other Dependents:",null,null,null,null,null,null,null,2]
["Name:","Relationship:","Age:","Phone:","Address:","City:","State:","Zip:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J34:P34)>=1,1,0)","v":0},{"$f":"IF(A34<>\"\",1,0)","v":0},{"$f":"IF(B34<>\"\",1,0)","v":0},{"$f":"IF(C34<>\"\",1,0)","v":0},{"$f":"IF(D34<>\"\",1,0)","v":0},{"$f":"IF(E34<>\"\",1,0)","v":0},{"$f":"IF(F34<>\"\",1,0)","v":0},{"$f":"IF(G34<>\"\",1,0)","v":0},{"$f":"IF(H34<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J35:P35)>=1,1,0)","v":0},{"$f":"IF(A35<>\"\",1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Special Family Information:",null,null,null,null,null,null,null,2]
["Have you been previously married?"]
["From:",null,"To:",null,"Date of Seperation:"]
["Do you have any known health problems?"]
["Please explain:"]
[]
["Other commitments:","(Please explain any other unusual financial arrangements)"]
[]
[]
[]
["What funeral arrangements have been made?","(Please include information regarding burial plots or funeral homes)"]
[]
[]
[]
["Do you have any prospective inheritances?"]
["Please explain:"]
[]
["The keys for lock boxes are kept:"]
[]
["Special Documents","(This information will help your professional estate planner)"]
["Have you prepared a will?"]
["Yourself:"]
["Spouse:"]
["Where are your important papers kept?","(Wills, trust, deeds, etc.)"]
[]
[]
["Do you have your income tax returns for the last 5 years available?"]
[]
[]
["Are you a trustee or guardian?"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J67:P67)>=1,1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J68:P68)>=1,1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Business Structure:",null,null,null,null,null,null,null,2]
["Your business is setup as a:"]
["Trust"]
["Partnership"]
["LLC"]
["Inc."]
["S-Corp"]
["C-Corp"]
[]
["Who is included in your business?","Name (First and Last)","City","State"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J80:P80)>=1,1,0)","v":0},{"$f":"IF(B80<>\"\",1,0)","v":0},{"$f":"IF(C80<>\"\",1,0)","v":0},{"$f":"IF(D80<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J81:P81)>=1,1,0)","v":0},{"$f":"IF(B81<>\"\",1,0)","v":0},{"$f":"IF(C81<>\"\",1,0)","v":0},{"$f":"IF(D81<>\"\",1,0)","v":0}]
["Where are the relevant documents kept?",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,2]
[]
["Who are the share holders?","Name (First and Last)","City","State","How many shares do they hold?"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J86:P86)>=1,1,0)","v":0},{"$f":"IF(B86<>\"\",1,0)","v":0},{"$f":"IF(C86<>\"\",1,0)","v":0},{"$f":"IF(D86<>\"\",1,0)","v":0},{"$f":"IF(E86<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J87:P87)>=1,1,0)","v":0},{"$f":"IF(B87<>\"\",1,0)","v":0},{"$f":"IF(C87<>\"\",1,0)","v":0},{"$f":"IF(D87<>\"\",1,0)","v":0},0]
[null,null,null,null,null,null,null,null,2]
["Personal Objectives:",null,null,null,null,null,null,null,2]
["To whom do you wish for your estate to pass to?","Name (First and Last)","City","State"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J91:P91)>=1,1,0)","v":0},{"$f":"IF(B91<>\"\",1,0)","v":0},{"$f":"IF(C91<>\"\",1,0)","v":0},{"$f":"IF(D91<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J92:P92)>=1,1,0)","v":0},{"$f":"IF(B92<>\"\",1,0)","v":0},{"$f":"IF(C92<>\"\",1,0)","v":0},{"$f":"IF(D92<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Do you wish to retain the maximum estate for the lives of both your spouse and yourself?",null,null,null,null,null,null,null,2]
[]
[]
["Are you planning on giving any gifts?"]
["To whom?","Describe the gift:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J99:P99)>=1,1,0)","v":0},{"$f":"IF(A99<>\"\",1,0)","v":0},{"$f":"IF(B99<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J100:P100)>=1,1,0)","v":0},{"$f":"IF(A100<>\"\",1,0)","v":0},{"$f":"IF(B100<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["When do you plan to retire?",null,null,null,null,null,null,null,2]
[]
["Where do you plan to retire to?"]
[]
["Do you plan to continue to manage your affairs after retirement?"]
[]
[]
["If you pre-decease your spouse, what suggestions or recommendations would you make concerning your estate?"]
[]
[]
[]
["Are there any special educational or medical needs?"]
["Please explain:"]
[]
["Should you or your spouse leave any minor children, please list the people who have agreed to serve as their guardian:"]
["Name (First and Last)","City","State","Phone Number"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J118:P118)>=1,1,0)","v":0},{"$f":"IF(A118<>\"\",1,0)","v":0},{"$f":"IF(B118<>\"\",1,0)","v":0},{"$f":"IF(C118<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J119:P119)>=1,1,0)","v":0},{"$f":"IF(A119<>\"\",1,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,2]
["Contacts Regarding the Estate:",null,null,null,null,null,null,null,2]
["Enter the primary contact for each title.\n Additional contacts can be added at the bottom."]
[null,"Name (First and Last)","Company Name","Phone Number","Address","City","State","Zip Code"]
["Accountant"]
["Attorney"]
["Insurance Agent"]
["Other:",null,null,null,null,null,null,null,{"$f":"IF(SUM(J127:P127)>=1,1,0)","v":0},{"$f":"IF(B127<>\"\",1,0)","v":0},{"$f":"IF(C127<>\"\",1,0)","v":0},{"$f":"IF(D127<>\"\",1,0)","v":0},{"$f":"IF(E127<>\"\",1,0)","v":0},{"$f":"IF(F127<>\"\",1,0)","v":0},{"$f":"IF(G127<>\"\",1,0)","v":0},{"$f":"IF(H127<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J128:P128)>=1,1,0)","v":0},{"$f":"IF(B128<>\"\",1,0)","v":0},{"$f":"IF(C128<>\"\",1,0)","v":0},{"$f":"IF(D128<>\"\",1,0)","v":0},{"$f":"IF(E128<>\"\",1,0)","v":0},{"$f":"IF(F128<>\"\",1,0)","v":0},{"$f":"IF(G128<>\"\",1,0)","v":0},{"$f":"IF(H128<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Gifts Previously Made to Others:","(Include all gifts of more than nominal value)",null,null,null,null,null,null,2]
["Date","Type of Property","Donor","Donee","Original Value","Current Value of Gift","Gift Tax Return Filed","Tax Paid"]
[null,null,null,null,null,null,null,0,{"$f":"IF(SUM(J132:P132)>=1,1,0)","v":0},{"$f":"IF(A132<>\"\",1,0)","v":0},{"$f":"IF(B132<>\"\",1,0)","v":0},{"$f":"IF(C132<>\"\",1,0)","v":0},{"$f":"IF(D132<>\"\",1,0)","v":0},{"$f":"IF(E132<>\"\",1,0)","v":0},{"$f":"IF(F132<>\"\",1,0)","v":0},{"$f":"IF(G132<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(SUM(J133:P133)>=1,1,0)","v":0},{"$f":"IF(A133<>\"\",1,0)","v":0},0,0,0,{"$f":"IF(E133<>\"\",1,0)","v":0},{"$f":"IF(F133<>\"\",1,0)","v":0},{"$f":"IF(G133<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Do you have a copy of all your gift tax returns?",null,null,"Totals:",{"$f":"SUM(E133:E134)","v":0},{"$f":"SUM(F133:F134)","v":0},null,{"$f":"SUM(H132:H134)","v":0},2]
[]
[]
[]
[null,null,null,null,null,null,null,null,"x"]

{"sheet":"Financial","index":4,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":true,"merged":[[31,3,31,4],[24,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[16,4,16,5],[21,4,21,5],[24,5,24,6],[16,1,16,3],[21,1,21,3],[18,1,18,3],[18,4,18,5],[22,1,22,3],[22,4,22,5],[20,1,20,3],[20,4,20,5],[17,1,17,3],[17,4,17,5],[24,1,24,2]]}
[]
["Income:"]
[null,"Yourself","Spouse","Total"]
["Wages:",null,null,{"$f":"SUM(B4:C4)","v":0}]
["Business Income:",null,null,{"$f":"SUM(B5:C5)","v":0}]
["Capital Gain:",null,null,0]
["Pensions & Annuities:",null,null,0]
["Rents, Royalties, Ect.:",null,null,0]
["Farm Income (Sched. F):",null,null,0]
["Social Security Benefits:",null,null,0]
["Other Income:",null,null,{"$f":"SUM(B11:C11)","v":0},null,null,null,null,{"$f":"IF(D11>0,1,0)","v":0}]
["Other Income:",null,null,0,null,null,null,null,{"$f":"IF(D12>0,1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Totals:",{"$f":"SUM(B4:B12)","v":0},{"$f":"SUM(C4:C12)","v":0},{"$f":"SUM(D4:D12)","v":0},null,null,null,null,2]
[]
["Benefits After Retirement:"]
["Yourself:","Employer's Name",null,null,"Employer's Address & ",null,"State"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J18:L18)>=1,1,0)","v":0},{"$f":"IF(B18<>\"\",1,0)","v":0},{"$f":"IF(E18<>\"\",1,0)","v":0},{"$f":"IF(G18<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J19:L19)>=1,1,0)","v":0},{"$f":"IF(B19<>\"\",1,0)","v":0},{"$f":"IF(E19<>\"\",1,0)","v":0},{"$f":"IF(G19<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Spouse:","Employer's Name",null,null,"Employer's Address & ",null,"State",null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J22:L22)>=1,1,0)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J23:L23)>=1,1,0)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,"Retirement Benefits (Annually)",null,"Amount Invested",null,"Death Benefits",null,null,2]
["Type:","Yourself","Spouse",null,null,"Yourself","Spouse"]
["Pensions:"]
["Profit Sharing:"]
["Self Employed:"]
["Pension Plan:"]
["Deferred Compensation:"]
["Social Security:"]
[]
["Annual Summaries:"]
["For last 5 years:",{"$f":"YEAR(TODAY())-1","v":2019},{"$f":"YEAR(TODAY())-2","v":2018},{"$f":"YEAR(TODAY())-3","v":2017},{"$f":"YEAR(TODAY())-4","v":2016},{"$f":"YEAR(TODAY())-5","v":2015}]
["Family Income:"]
["Taxes (Federal & State):"]
["Living Expenses:"]
["Insurance Premiums:"]
[]
[null,null,null,null,null,null,null,null,"x"]

{"sheet":"Assets","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,1,4,3]]}
[]
[null,"What assets would you like to view?"]

{"sheet":"Personal Assets","index":6,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":true,"merged":[[1,0,1,1],[30,1,30,2]]}
[]
["Personal Assets"]
["Personal Property:"]
[null,"Description:","Date Acquired:","Cost:","Tax Basis:","Ownership:","Market Value:"]
["Vehicles:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J6:Q6)>=1,1,0)","v":0},null,{"$f":"IF(B6<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J7:Q7)>=1,1,0)","v":0},null,{"$f":"IF(B7<>\"\",1,0)","v":0},{"$f":"IF(C7<>\"\",1,0)","v":0},{"$f":"IF(D7<>\"\",1,0)","v":0},{"$f":"IF(E7<>\"\",1,0)","v":0},{"$f":"IF(F7<>\"\",1,0)","v":0},{"$f":"IF(G7<>\"\",1,0)","v":0},{"$f":"IF(H7<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Home Furnishings:",null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J11:Q11)>=1,1,0)","v":0},null,{"$f":"IF(B11<>\"\",1,0)","v":0},{"$f":"IF(C11<>\"\",1,0)","v":0},{"$f":"IF(D11<>\"\",1,0)","v":0},{"$f":"IF(E11<>\"\",1,0)","v":0},{"$f":"IF(F11<>\"\",1,0)","v":0},{"$f":"IF(G11<>\"\",1,0)","v":0},{"$f":"IF(H11<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J12:Q12)>=1,1,0)","v":0},null,{"$f":"IF(B12<>\"\",1,0)","v":0},{"$f":"IF(C12<>\"\",1,0)","v":0},{"$f":"IF(D12<>\"\",1,0)","v":0},{"$f":"IF(E12<>\"\",1,0)","v":0},{"$f":"IF(F12<>\"\",1,0)","v":0},{"$f":"IF(G12<>\"\",1,0)","v":0},{"$f":"IF(H12<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
["Jewelry:",null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J16:Q16)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J17:Q17)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Collections:",null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J21:Q21)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J22:Q22)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Other property:",null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J26:Q26)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J27:Q27)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D6:D28)","v":0},{"$f":"SUM(E6:E28)","v":0},null,{"$f":"SUM(G6:G28)","v":0},null,2]
[]
["Real Estate:","(Include Oil, Gas, and other Mineral Interests)"]
["Legal Discription:","Personal Discription:","City:","State:","Date Acquired:","Ownership:","Market Value:","Basis:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J33:Q33)>=1,1,0)","v":0},{"$f":"IF(A33<>\"\",1,0)","v":0},{"$f":"IF(B33<>\"\",1,0)","v":0},{"$f":"IF(C33<>\"\",1,0)","v":0},{"$f":"IF(D33<>\"\",1,0)","v":0},{"$f":"IF(E33<>\"\",1,0)","v":0},{"$f":"IF(F33<>\"\",1,0)","v":0},{"$f":"IF(G33<>\"\",1,0)","v":0},{"$f":"IF(H33<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J34:Q34)>=1,1,0)","v":0},{"$f":"IF(A34<>\"\",1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,"Totals:",{"$f":"SUM(G33:G35)","v":0},{"$f":"SUM(H33:H35)","v":0},2]
[]
["Life Insurance:"]
["Company:","Policy Number:","Face Amount:","Double Indemnity:","Value:","Ownership:","Name of Insured:","Named Beneficiary:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J40:Q40)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J41:Q41)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,"Totals:",{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0},null,null,null,2]
[]
["Bank Accounts: (Cash)"]
[null,"Account Name:","Ownership:","Average Balance:"]
["Checking:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J48:Q48)>=1,1,0)","v":0},null,{"$f":"IF(B48<>\"\",1,0)","v":0},{"$f":"IF(C48<>\"\",1,0)","v":0},{"$f":"IF(D48<>\"\",1,0)","v":0},{"$f":"IF(E48<>\"\",1,0)","v":0},{"$f":"IF(F48<>\"\",1,0)","v":0},{"$f":"IF(G48<>\"\",1,0)","v":0},{"$f":"IF(H48<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J49:Q49)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Savings:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J52:Q52)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J53:Q53)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Cash:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J56:Q56)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J57:Q57)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D48:D58)","v":0},null,null,null,null,2]
[]
["Investments:"]
[]
["Are income statemetns and balance sheets available for the last 5 years?"]
[]
["Bonds:"]
["Description:","Year Purchased:","Number of Bonds:","Ownership:","Total Face Value:","Current Value:","Initial Investment:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J67:Q67)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J68:Q68)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,"Totals:",{"$f":"SUM(E67:E69)","v":0},{"$f":"SUM(F67:F69)","v":0},{"$f":"SUM(G67:G69)","v":0},null,2]
[]
["Stocks:"]
["Description:","Year Purchased:","Number of Stocks:","Ownership:","Current Value:","Initial Investment:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J74:Q74)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J75:Q75)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,"Totals:",{"$f":"SUM(E74:E76)","v":0},{"$f":"SUM(F74:F76)","v":0},null,null,2]
[]
["Mutual Funds:"]
["Description:","Year Purchased:","Ownership:","Initial Investment:","Current Value:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J81:Q81)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J82:Q82)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D81:D83)","v":0},{"$f":"SUM(E81:E83)","v":0},null,null,null,2]
[]
["Other Investments:"]
["Description:","Year Purchased:","Ownership:","Initial Investment:","Current Value:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J88:Q88)>=1,1,0)","v":0},{"$f":"IF(A88<>\"\",1,0)","v":0},{"$f":"IF(B88<>\"\",1,0)","v":0},{"$f":"IF(C88<>\"\",1,0)","v":0},{"$f":"IF(D88<>\"\",1,0)","v":0},{"$f":"IF(E88<>\"\",1,0)","v":0},{"$f":"IF(F88<>\"\",1,0)","v":0},{"$f":"IF(G88<>\"\",1,0)","v":0},{"$f":"IF(H88<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J89:Q89)>=1,1,0)","v":0},{"$f":"IF(A89<>\"\",1,0)","v":0},{"$f":"IF(B89<>\"\",1,0)","v":0},{"$f":"IF(C89<>\"\",1,0)","v":0},{"$f":"IF(D89<>\"\",1,0)","v":0},{"$f":"IF(E89<>\"\",1,0)","v":0},{"$f":"IF(F89<>\"\",1,0)","v":0},{"$f":"IF(G89<>\"\",1,0)","v":0},{"$f":"IF(H89<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D88:D90)","v":0},{"$f":"SUM(E88:E90)","v":0},null,null,null,2]
[]
["Notes, Mortgages & Receivables:"]
["Description:","Date Acquired:","Cost:","Current Value:","Original Owner:","Name of Debtor:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J95:Q95)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J96:Q96)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,"Totals:",{"$f":"SUM(C95:C97)","v":0},{"$f":"SUM(D95:D97)","v":0},null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,"x"]

{"sheet":"Business Assets","index":7,"n_rows":98,"n_cols":17,"rows_kept":98,"cut":false,"hidden":true,"merged":[[1,0,1,1],[30,1,30,3]]}
[]
["Business Assets"]
["Private Property:"]
[null,"Description:","Date Acquired:","Cost:","Tax Basis:","Fair Market Value:"]
["Company Vehicles"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J6:Q6)>=1,1,0)","v":0},null,{"$f":"IF(B6<>\"\",1,0)","v":0},{"$f":"IF(C6<>\"\",1,0)","v":0},{"$f":"IF(D6<>\"\",1,0)","v":0},{"$f":"IF(E6<>\"\",1,0)","v":0},{"$f":"IF(F6<>\"\",1,0)","v":0},{"$f":"IF(G6<>\"\",1,0)","v":0},{"$f":"IF(H6<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J7:Q7)>=1,1,0)","v":0},null,{"$f":"IF(B7<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Office Supplies:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J10:Q10)>=1,1,0)","v":0},null,{"$f":"IF(B10<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J11:Q11)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Crops:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J14:Q14)>=1,1,0)","v":0},null,{"$f":"IF(B14<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J15:Q15)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Livestock:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J18:Q18)>=1,1,0)","v":0},null,{"$f":"IF(B18<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J19:Q19)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Machinery:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J22:Q22)>=1,1,0)","v":0},null,{"$f":"IF(B22<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J23:Q23)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Other Property:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J26:Q26)>=1,1,0)","v":0},null,{"$f":"IF(B26<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J27:Q27)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D6:D28)","v":0},{"$f":"SUM(E6:E28)","v":0},{"$f":"SUM(F6:F28)","v":0},null,null,2]
[]
["Real Estate:","(Include Oil, Gas, and other Mineral Interests)"]
["Legal Discription:","Name/Discription:","City:","State:","Date Acquired:","Market Value:","Basis:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J33:Q33)>=1,1,0)","v":0},{"$f":"IF(A33<>\"\",1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J34:Q34)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Totals:",{"$f":"SUM(F33:F35)","v":0},{"$f":"SUM(G33:G35)","v":0},null,2]
[]
["Farm Insurance:"]
["Company:","Item Insured:","Policy Number:","Face Amount:","Value:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J40:Q40)>=1,1,0)","v":0},{"$f":"IF(A40<>\"\",1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J41:Q41)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D40:D42)","v":0},{"$f":"SUM(E40:E42)","v":0},null,null,null,2]
[]
["Bank Accounts: (Cash)"]
[null,"Account Name:","Average Balance:"]
["Checking:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J48:Q48)>=1,1,0)","v":0},null,{"$f":"IF(B48<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J49:Q49)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Savings:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J52:Q52)>=1,1,0)","v":0},null,{"$f":"IF(B52<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J53:Q53)>=1,1,0)","v":0},null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Cash:",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J56:Q56)>=1,1,0)","v":0},null,{"$f":"IF(B56<>\"\",1,0)","v":0},{"$f":"IF(C56<>\"\",1,0)","v":0},{"$f":"IF(D56<>\"\",1,0)","v":0},{"$f":"IF(E56<>\"\",1,0)","v":0},{"$f":"IF(F56<>\"\",1,0)","v":0},{"$f":"IF(G56<>\"\",1,0)","v":0},{"$f":"IF(H56<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J57:Q57)>=1,1,0)","v":0},null,{"$f":"IF(B57<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,"Totals:",{"$f":"SUM(C48:C58)","v":0},null,null,null,null,null,2]
[]
["Investments:"]
["Bonds:"]
["Description:","Year Purchased:","Number of Bonds:","Total Face Value:","Current Value:","Initial Investment:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J64:Q64)>=1,1,0)","v":0},{"$f":"IF(A64<>\"\",1,0)","v":0},{"$f":"IF(B64<>\"\",1,0)","v":0},{"$f":"IF(C64<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J65:Q65)>=1,1,0)","v":0},{"$f":"IF(A65<>\"\",1,0)","v":0},{"$f":"IF(B65<>\"\",1,0)","v":0},{"$f":"IF(C65<>\"\",1,0)","v":0},{"$f":"IF(C65<>\"\",1,0)","v":0},{"$f":"IF(D65<>\"\",1,0)","v":0},{"$f":"IF(E65<>\"\",1,0)","v":0},{"$f":"IF(F65<>\"\",1,0)","v":0},{"$f":"IF(H65<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D64:D66)","v":0},{"$f":"SUM(E64:E66)","v":0},0,null,null,2]
[]
["Stocks:"]
["Description:","Year Purchased:","Number of Stocks:","Current Value:","Initial Investment:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J71:Q71)>=1,1,0)","v":0},{"$f":"IF(A71<>\"\",1,0)","v":0},{"$f":"IF(B71<>\"\",1,0)","v":0},{"$f":"IF(C71<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J72:Q72)>=1,1,0)","v":0},{"$f":"IF(A72<>\"\",1,0)","v":0},{"$f":"IF(B72<>\"\",1,0)","v":0},{"$f":"IF(C72<>\"\",1,0)","v":0},{"$f":"IF(C72<>\"\",1,0)","v":0},{"$f":"IF(D72<>\"\",1,0)","v":0},{"$f":"IF(E72<>\"\",1,0)","v":0},{"$f":"IF(F72<>\"\",1,0)","v":0},{"$f":"IF(H72<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
[null,null,"Totals:",{"$f":"SUM(D71:D73)","v":0},{"$f":"SUM(E71:E73)","v":0},null,null,null,2]
[]
["Mutual Funds:"]
["Description:","Year Purchased:","Initial Investment:","Current Value:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J78:Q78)>=1,1,0)","v":0},{"$f":"IF(A78<>\"\",1,0)","v":0},{"$f":"IF(B78<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J79:Q79)>=1,1,0)","v":0},{"$f":"IF(A79<>\"\",1,0)","v":0},0,0,{"$f":"IF(C79<>\"\",1,0)","v":0},{"$f":"IF(D79<>\"\",1,0)","v":0},{"$f":"IF(E79<>\"\",1,0)","v":0},{"$f":"IF(F79<>\"\",1,0)","v":0},{"$f":"IF(H79<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
[null,"Totals:",{"$f":"SUM(C78:C80)","v":0},{"$f":"SUM(D78:D80)","v":0},null,null,null,null,2]
[]
["Other Investments:"]
["Description:","Year Purchased:","Initial Investment:","Current Value:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J85:Q85)>=1,1,0)","v":0},{"$f":"IF(A85<>\"\",1,0)","v":0},{"$f":"IF(B85<>\"\",1,0)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J86:Q86)>=1,1,0)","v":0},{"$f":"IF(A86<>\"\",1,0)","v":0},{"$f":"IF(B86<>\"\",1,0)","v":0},{"$f":"IF(B86<>\"\",1,0)","v":0},{"$f":"IF(C86<>\"\",1,0)","v":0},{"$f":"IF(D86<>\"\",1,0)","v":0},{"$f":"IF(E86<>\"\",1,0)","v":0},{"$f":"IF(F86<>\"\",1,0)","v":0},{"$f":"IF(H86<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
[null,"Totals:",{"$f":"SUM(C85:C87)","v":0},{"$f":"SUM(D85:D87)","v":0},null,null,null,null,2]
[]
["Notes, Mortgages & Recievables:"]
["Description:","Date Acquired:","Cost:","Current Value:","Original Owner:","Name of Debtor:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J92:Q92)>=1,1,0)","v":0},{"$f":"IF(A92<>\"\",1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J93:Q93)>=1,1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,"Totals:",{"$f":"SUM(C92:C94)","v":0},{"$f":"SUM(D92:D94)","v":0},null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,"x"]

{"sheet":"Liabilities","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,1,4,3]]}
[]
[null,"What liabilities would you like to view?"]

{"sheet":"Personal Liabilities","index":9,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":true,"merged":[[1,0,1,1],[9,0,9,2],[16,0,16,2]]}
[]
["Personal Liabilities:"]
["Mortgages:"]
["Discription:","Name of Creditor/Lendor:","Date Due:","Terms:","Ownership:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J5:O5)>=1,1,0)","v":0},{"$f":"IF(A5<>\"\",1,0)","v":0},{"$f":"IF(B5<>\"\",1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J6:O6)>=1,1,0)","v":0},{"$f":"IF(A6<>\"\",1,0)","v":0},{"$f":"IF(B6<>\"\",1,0)","v":0},{"$f":"IF(C6<>\"\",1,0)","v":0},{"$f":"IF(D6<>\"\",1,0)","v":0},{"$f":"IF(E6<>\"\",1,0)","v":0},{"$f":"IF(F6<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Totals:",{"$f":"SUM(F5:F7)","v":0},null,null,2]
[]
["Unsecured Notes, Installments, and Contracts:"]
["Discription:","Name of Creditor/Lendor:","Date Due:","Terms:","Ownership:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J12:O12)>=1,1,0)","v":0},{"$f":"IF(A12<>\"\",1,0)","v":0},{"$f":"IF(B12<>\"\",1,0)","v":0},{"$f":"IF(C12<>\"\",1,0)","v":0},{"$f":"IF(D12<>\"\",1,0)","v":0},{"$f":"IF(E12<>\"\",1,0)","v":0},{"$f":"IF(F12<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J13:O13)>=1,1,0)","v":0},{"$f":"IF(A13<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Totals:",{"$f":"SUM(F12:F14)","v":0},null,null,2]
[]
["Secured Notes, Installments, and Contracts:"]
["Discription:","Name of Creditor/Lendor:","Date Due:","Terms:","Ownership:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J19:O19)>=1,1,0)","v":0},{"$f":"IF(A19<>\"\",1,0)","v":0},{"$f":"IF(B19<>\"\",1,0)","v":0},{"$f":"IF(C19<>\"\",1,0)","v":0},{"$f":"IF(D19<>\"\",1,0)","v":0},{"$f":"IF(E19<>\"\",1,0)","v":0},{"$f":"IF(F19<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J20:O20)>=1,1,0)","v":0},{"$f":"IF(A20<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Totals:",{"$f":"SUM(F19:F21)","v":0},null,null,2]
[]
[]
[]
[null,null,null,null,null,null,null,null,"x"]

{"sheet":"Business Liabilities","index":10,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":true,"merged":[[1,0,1,1]]}
[]
["Business Liabilities:"]
["Land & Buildings:"]
["Description:","Legal Discription:","Name of Creditor/Lendor:","Date Due:","Terms:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J5:O5)>=1,1,0)","v":0},{"$f":"IF(A5<>\"\",1,0)","v":0},{"$f":"IF(B5<>\"\",1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J6:O6)>=1,1,0)","v":0},{"$f":"IF(A6<>\"\",1,0)","v":0},{"$f":"IF(B6<>\"\",1,0)","v":0},{"$f":"IF(C6<>\"\",1,0)","v":0},{"$f":"IF(D6<>\"\",1,0)","v":0},{"$f":"IF(E6<>\"\",1,0)","v":0},{"$f":"IF(F6<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Totals:",{"$f":"SUM(F5:F6)","v":0},null,null,2]
[]
["Machinery:"]
["Description:","Name of Creditor/Lendor:","Date Due:","Terms:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J12:O12)>=1,1,0)","v":0},{"$f":"IF(A12<>\"\",1,0)","v":0},{"$f":"IF(B12<>\"\",1,0)","v":0},{"$f":"IF(C12<>\"\",1,0)","v":0},{"$f":"IF(D12<>\"\",1,0)","v":0},{"$f":"IF(E12<>\"\",1,0)","v":0},{"$f":"IF(F12<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J13:O13)>=1,1,0)","v":0},{"$f":"IF(A13<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,"Totals:",{"$f":"SUM(E12:E13)","v":0},null,null,null,2]
[]
["Livestock:"]
["Description:","Name of Creditor/Lendor:","Date Due:","Terms:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J19:O19)>=1,1,0)","v":0},{"$f":"IF(A19<>\"\",1,0)","v":0},{"$f":"IF(B19<>\"\",1,0)","v":0},{"$f":"IF(C19<>\"\",1,0)","v":0},{"$f":"IF(D19<>\"\",1,0)","v":0},{"$f":"IF(E19<>\"\",1,0)","v":0},{"$f":"IF(F19<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J20:O20)>=1,1,0)","v":0},{"$f":"IF(A20<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,"Totals:",{"$f":"SUM(E19:E20)","v":0},null,null,null,2]
[]
["Crops:"]
["Description:","Name of Creditor/Lendor:","Date Due:","Terms:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J26:O26)>=1,1,0)","v":0},{"$f":"IF(A26<>\"\",1,0)","v":0},{"$f":"IF(B26<>\"\",1,0)","v":0},{"$f":"IF(C26<>\"\",1,0)","v":0},{"$f":"IF(D26<>\"\",1,0)","v":0},{"$f":"IF(E26<>\"\",1,0)","v":0},{"$f":"IF(F26<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J27:O27)>=1,1,0)","v":0},{"$f":"IF(A27<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,"Totals:",{"$f":"SUM(E26:E27)","v":0},null,null,null,2]
[]
["Unsecured Notes, Installments and Contracts:"]
["Discription:","Name of Creditor/Lendor:","Date Due:","Terms:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J33:O33)>=1,1,0)","v":0},{"$f":"IF(A33<>\"\",1,0)","v":0},{"$f":"IF(B33<>\"\",1,0)","v":0},{"$f":"IF(C33<>\"\",1,0)","v":0},{"$f":"IF(D33<>\"\",1,0)","v":0},{"$f":"IF(E33<>\"\",1,0)","v":0},{"$f":"IF(F33<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J34:O34)>=1,1,0)","v":0},{"$f":"IF(A34<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
[null,null,null,"Totals:",{"$f":"SUM(E33:E34)","v":0},null,null,null,2]
[]
["Accounts Payable:"]
["Discription:","Original Amount:","Date Due:","Terms:","Current Balance:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J40:O40)>=1,1,0)","v":0},{"$f":"IF(A40<>\"\",1,0)","v":0},{"$f":"IF(B40<>\"\",1,0)","v":0},{"$f":"IF(C40<>\"\",1,0)","v":0},{"$f":"IF(D40<>\"\",1,0)","v":0},{"$f":"IF(E40<>\"\",1,0)","v":0},{"$f":"IF(F40<>\"\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(J41:O41)>=1,1,0)","v":0},{"$f":"IF(A41<>\"\",1,0)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,2]
["Totals:",{"$f":"SUM(B40:B41)","v":0},null,null,{"$f":"SUM(E40:E41)","v":0},null,null,null,2]
[]
[null,null,null,null,null,null,null,null,"x"]

{"sheet":"Summary","index":11,"n_rows":186,"n_cols":3,"rows_kept":186,"cut":false,"hidden":false,"merged":[[4,0,4,1],[26,0,26,1],[38,0,38,1],[51,0,51,1],[52,0,52,1],[54,0,54,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[64,0,64,1],[63,0,63,1],[78,0,78,1],[88,0,88,1],[86,0,86,1],[157,0,157,1],[174,0,174,1],[106,0,106,1],[104,0,104,1],[125,0,125,1],[145,0,145,1],[147,0,147,1]]}
[]
["This document was last opened:",{"$f":"Macros!A13","v":"2015-01-10T11:31:15"}]
["& this page was last reviewed:","2015-01-10T11:33:21"]
[]
["Family Information"]
[]
["Name:",{"$f":"Personal!B4&\" \"&Personal!B5&\" \"&Personal!B6","v":"  "},{"$f":"IFERROR(IF(B7=\"  \",0,1),0)","v":0}]
["Date of Birth:",{"$f":"Personal!B7","v":0},{"$f":"IF(B8=0,0,1)","v":0}]
["Social Security Number:",{"$f":"Personal!B8","v":0},{"$f":"IF(B9=0,0,1)","v":0}]
["Spouse's Name:",{"$f":"Personal!B10&\" \"&Personal!B11&\" \"&Personal!B12","v":"  "},{"$f":"IF(B10=\"  \",0,1)","v":0}]
["Spouse's Date of Birth:",{"$f":"Personal!B13","v":0},{"$f":"IF(B11=0,0,1)","v":0}]
["Spouse's Social Security Number:",{"$f":"Personal!B14","v":0},{"$f":"IF(B12=0,0,1)","v":0}]
["Address:",{"$f":"IF(Personal!B17&CHAR(10)&Personal!B18&\", \"&Personal!B19&\" \"&Personal!B20=\"\n,  \",\"\",Personal!B17&CHAR(10)&Personal!B18&\", \"&Personal!B19&\" \"&Personal!B20)","v":""},{"$f":"IF(B13=\"\",0,1)","v":0}]
[]
["Home Phone:",{"$f":"Personal!B21","v":0},{"$f":"IF(B15=0,0,1)","v":0}]
["Business Phone:",{"$f":"Personal!B22","v":0},{"$f":"IF(B16=0,0,1)","v":0}]
["Mobile Phone:",{"$f":"Personal!B23","v":0},{"$f":"IF(B17=0,0,1)","v":0}]
["Mobile Phone:",{"$f":"Personal!B24","v":0},{"$f":"IF(B18=0,0,1)","v":0}]
["Primary Email:",{"$f":"Personal!B25","v":0},{"$f":"IF(B19=0,0,1)","v":0}]
[]
["Children:",null,{"$f":"IFERROR(IF(#REF!=2,1,0),0)","v":0}]
[]
["Other Dependents:",null,{"$f":"IFERROR($C$24,0)","v":0}]
[null,{"$f":"IF(Personal!A34>0,Personal!A34,\"\")&IF(Personal!C34>0,\"; Age: \"&Personal!C34,\"\")&IF(Personal!B34>0,CHAR(10)&Personal!B34,\"\")&IF(Personal!D34>0,CHAR(10)&\"Phone: \"&Personal!D34,\"\")&IF(Personal!E34>0,CHAR(10)&Personal!E34&CHAR(10),\"\")&IF(Personal!F34>0,\", \"&Personal!F34,\"\")&IF(Personal!G34>0,\", \"&Personal!G34,\"\")&IF(Personal!H34>0,\", \"&Personal!H34,\"\")","v":""},{"$f":"IFERROR(IF(B24=\"\",0,1),2)","v":0}]
[]
["Special Family Information:",null,{"$f":"SUM(C27:C33)","v":0}]
[{"$f":"IF(Married=\"Yes\",\"Yes, I was married from \"&OFFSET(Married,1,0)&\" through \"&OFFSET(Married,1,2)&\", seperating on \"&OFFSET(Married,1,4)&\".\",\"\")","v":""},null,{"$f":"IF(SpecFam=\"\",0,1)","v":0}]
[{"$f":"IF(Health=\"Yes\",\"There are known health problems.\",\"\")","v":""},{"$f":"IF(AND(Health=\"Yes\",OFFSET(Health,1,0)<>0),OFFSET(Health,1,0),OFFSET(Health,1,0))","v":0},{"$f":"IF(B28=0,0,1)","v":0}]
["Other financial arrangments are ",{"$f":"Personal!B45","v":0},{"$f":"IF(B29=0,0,1)","v":0}]
["Funeral arrangments are ",{"$f":"Personal!B49","v":0},{"$f":"IF(B30=0,0,1)","v":0}]
[{"$f":"IF(PropInher=\"Yes\",\"Prospective inheritances include:\",\"\")","v":""},{"$f":"IF(AND(PropInher=\"Yes\",OFFSET(PropInher,1,0)<>0),OFFSET(PropInher,1,0),OFFSET(PropInher,1,0))","v":0},{"$f":"IF(B31=0,0,1)","v":0}]
["The keys for lock boxes are kept ",{"$f":"Personal!B54","v":0},{"$f":"IF(B32=0,0,1)","v":0}]
[]
["Special Documents:",null,{"$f":"C35","v":0}]
["Wills: ",{"$f":"IF(Personal!B58=0,0,IF(Personal!B58=\"No\",\"I do not have a will.\",\"I have a will prepared for myself.\"))","v":0},{"$f":"IF(B35=0,0,1)","v":0}]
[null,{"$f":"IF(Personal!B59=0,0,IF(Personal!B59=\"No\",\"My spouse does not have a will.\",\"My spouse has a will prepared.\"))","v":0},{"$f":"IF(B36=0,0,1)","v":0}]
["Important papers are kept ",{"$f":"Personal!B61","v":0},{"$f":"IF(B37=0,0,1)","v":0}]
[]
[{"$f":"IF(Personal!B63=\"Yes\",\"Tax returns are available for the last 5 years.\",0)","v":0},null,{"$f":"IF(A39=0,0,1)","v":0}]
[{"$f":"IF(Guard=\"Yes\",\"I am a trustee or guardian for:\",0)","v":0},{"$f":"IF(Personal!B67<>\"\",Personal!B67,\"\")","v":""},{"$f":"IF(B40=\"\",0,1)","v":0}]
[]
["Business Structure:",null,{"$f":"C43","v":0}]
["Our business is set up as a ",{"$f":"IF(BusinessStructure=0,\"\",BusinessStructure)","v":""},{"$f":"IFERROR(IF(B43=\"\",0,1),2)","v":0}]
[null,null,{"$f":"C45","v":0}]
["The business includes:",{"$f":"IF(Personal!B80>0,Personal!B80,\"\")&IF(Personal!C80>0,\"; \"&Personal!C80,\"\")&IF(Personal!D80>0,\", \"&Personal!D80,\"\")","v":""},{"$f":"IFERROR(IF(B45=\"\",0,1),2)","v":0}]
[null,null,{"$f":"C47","v":0}]
["Relevent business documents are kept ",{"$f":"Personal!B82","v":0},{"$f":"IFERROR(IF(B47=0,0,1),2)","v":0}]
[null,null,{"$f":"C49","v":0}]
["Our share holders are:",{"$f":"IF(Personal!B86>0,Personal!B86,\"\")&IF(Personal!C86>0,\" of \"&Personal!C86,\"\")&IF(Personal!D86>0,\", \"&Personal!D86,\"\")&IF(Personal!E86>0,\" holds \"&Personal!E86&\" shares.\",\"\")","v":""},{"$f":"IFERROR(IF(B49=\"\",0,1),2)","v":0}]
[]
["Personal Objectives:",null,{"$f":"C53","v":0}]
["I wish for the estate to be passed to the following:",null,{"$f":"C53","v":0}]
[{"$f":"IF(Personal!B91>0,Personal!B91,\"\")&IF(Personal!C91>0,\", \"&Personal!C91,\"\")&IF(Personal!D91>0,\", \"&Personal!D91,\"\")","v":""},null,{"$f":"IFERROR(IF(A53=\"\",0,1),2)","v":0}]
[]
[{"$f":"IF(Personal!B94=\"Yes\",\"I (we) wish to retain the maximum estate for the entirety of my (our) lives.\",IF(Personal!B94=\"No\",\"I (we) do not wish to retain the maximum estate for the entirety of my (our) lives.\",0))","v":0},null,{"$f":"IF(A55=0,0,1)","v":0}]
["Giving of Gifts:",{"$f":"IF(Gifta=\"Yes\",\"We are planning on giving gifts.\",IF(Gifta=\"No\",\"We are not planning on giving any gifts.\",0))","v":0},{"$f":"IF(B56=0,0,1)","v":0}]
[null,{"$f":"IF(AND(Gifta=\"Yes\",Personal!A99<>\"\",Personal!B99<>\"\"),Personal!A99&\" should receive \"&Personal!B99,0)","v":0},{"$f":"IFERROR(IF(B57=0,0,1),2)","v":0}]
[]
[{"$f":"IF(Personal!B102<>\"\",\"I (we) plan on retiring \"&Personal!B102&\".\",0)","v":0},null,{"$f":"IF(A59=0,0,1)","v":0}]
[{"$f":"IF(Personal!B104<>\"\",\"I (we) would like to retire to \"&Personal!B104&\".\",0)","v":0},null,{"$f":"IF(A60=0,0,1)","v":0}]
[{"$f":"IF(Personal!B106=\"Yes\",\"I (we) plan on managing my (our) affairs after retirement.\",IF(Personal!B106=\"No\",\"I (we) do not plan on managing my(our) affairs after retirement.\",0))","v":0},null,0]
[{"$f":"IF(Personal!B110=\"\",0,\"Should I pass before my spouse, I would suggest or recommend \"&Personal!B110)","v":0},null,0]
[{"$f":"IF(Special=\"Yes\",\"My (our) special educational or medical needs are \",0)","v":0},{"$f":"IF(A63=0,0,Personal!B114)","v":0},{"$f":"IF(B63=0,0,1)","v":0}]
["Should there be any minor children, the following have offered to be a guardian for them:",null,{"$f":"C65","v":0}]
[{"$f":"IF(Personal!A118>0,Personal!A118,\"\")&IF(Personal!B118>0,\", \"&Personal!B118,\"\")&IF(Personal!C118>0,\", \"&Personal!C118,\"\")&IF(Personal!D118>0,\"; \"&Personal!D118,\"\")","v":""},null,{"$f":"IFERROR(IF(A65=\"\",0,1),2)","v":0}]
[]
["Important Contacts:",null,{"$f":"SUM(C68:C72)","v":0}]
[{"$f":"Personal!A124","v":"Accountant"},{"$f":"IF(AND(Personal!B124<>\"\",Personal!C124<>\"\",Personal!D124<>\"\",Personal!E124<>\"\",Personal!F124<>\"\",Personal!G124<>\"\",Personal!H124<>\"\"),Personal!B124&CHAR(10)&Personal!C124&CHAR(10)&Personal!D124&CHAR(10)&Personal!E124&\", \"&Personal!F124&\", \"&Personal!G124&\" \"&Personal!H124,0)","v":0},{"$f":"IF(B68=0,0,1)","v":0}]
[{"$f":"Personal!A125","v":"Attorney"},{"$f":"IF(AND(Personal!B125<>\"\",Personal!C125<>\"\",Personal!D125<>\"\",Personal!E125<>\"\",Personal!F125<>\"\",Personal!G125<>\"\",Personal!H125<>\"\"),Personal!B125&CHAR(10)&Personal!C125&CHAR(10)&Personal!D125&CHAR(10)&Personal!E125&\", \"&Personal!F125&\", \"&Personal!G125&\" \"&Personal!H125,0)","v":0},{"$f":"IF(B69=0,0,1)","v":0}]
[{"$f":"Personal!A126","v":"Insurance Agent"},{"$f":"IF(AND(Personal!B126<>\"\",Personal!C126<>\"\",Personal!D126<>\"\",Personal!E126<>\"\",Personal!F126<>\"\",Personal!G126<>\"\",Personal!H126<>\"\"),Personal!B126&CHAR(10)&Personal!C126&CHAR(10)&Personal!D126&CHAR(10)&Personal!E126&\", \"&Personal!F126&\", \"&Personal!G126&\" \"&Personal!H126,0)","v":0},{"$f":"IF(B70=0,0,1)","v":0}]
[{"$f":"Personal!A127","v":"Other:"},{"$f":"IF(Personal!B127>0,Personal!B127,\"\")&IF(Personal!C127>0,CHAR(10)&Personal!C127,\"\")&IF(Personal!D127>0,CHAR(10)&Personal!D127,\"\")&IF(Personal!E127>0,CHAR(10)&Personal!E127,\"\")&IF(Personal!F127>0,\", \"&Personal!F127,\"\")&IF(Personal!G127>0,\", \"&Personal!G127,\"\")&IF(Personal!H127>0,\" \"&Personal!H127,\"\")","v":""},{"$f":"IFERROR(IF(B71=\"\",0,1),2)","v":0}]
[]
["Previously Made Gifts:",{"$f":"IF(Personal!B135=\"Yes\",\"There are copies of tax returns for gifts.\",IF(Personal!B135=\"No\",\"There are no tax returns for gifts.\",\"\"))","v":""},{"$f":"IF(AND(B73=\"\",C74=0),0,1)","v":0}]
[{"$f":"IF(Personal!B132>0,Personal!B132&\" was given to \"&Personal!D132&\" by \"&Personal!C132&\" on \"&Personal!A132&\".\",\"\")","v":""},{"$f":"IF(A74=\"\",0,\"Original Value: \"&Personal!E132&CHAR(10)&\"Current Value of Gift: \"&Personal!F132&CHAR(10)&\"Gift Tax Return Filed: \"&Personal!G132&CHAR(10)&\"Tax Paid: \"&Personal!H132)","v":0},{"$f":"IFERROR(IF(B74=0,0,1),2)","v":0}]
[null,null,{"$f":"C76","v":0}]
["Totals for previously made gifts are:",{"$f":"\"Original Value: $\"&Personal!E135&CHAR(10)&\"Current Value of Gifts: $\"&Personal!F135&CHAR(10)&\"Taxes Paid: $\"&Personal!H135","v":"Original Value: $0\nCurrent Value of Gifts: $0\nTaxes Paid: $0"},{"$f":"IF(A74=\"\",0,1)","v":0}]
[]
[]
["Financial Information"]
[]
["Total Income for Myself:",{"$f":"Financial!B14","v":0},{"$f":"IF(B81=0,0,1)","v":0}]
["Total Income for my Spouse:",{"$f":"Financial!C14","v":0},{"$f":"IF(B82=0,0,1)","v":0}]
["Total Household Income:",{"$f":"SUM(B81:B82)","v":0},{"$f":"IF(B83=0,0,1)","v":0}]
[]
["Retirement Benefits:",null,{"$f":"IF(SUM(C86:C96)>0,1,0)","v":0}]
[]
[{"$f":"IF(Financial!B18=\"\",0,\"I receive retirement benefits from \"&Financial!B18&\", \"&Financial!E18&\", \"&Financial!G18 )","v":0},null,{"$f":"IFERROR(IF(A87=0,0,1),1)","v":0}]
[]
[{"$f":"IF(Financial!B22=\"\",0,\"My spouse receives retirement benefits from \"&Financial!B22&\", \"&Financial!E22&\", \"&Financial!G22 )","v":0},null,{"$f":"IFERROR(IF(A89=0,0,1),1)","v":0}]
[]
["I have the following for annual retirement benefits:",{"$f":"IF(Financial!B27>0,\"Pensions: $ \"&Financial!B27&CHAR(10),\"\")&IF(Financial!B28>0,\"Profit Sharing: $ \"&Financial!B28&CHAR(10),\"\")&IF(Financial!B29>0,\"Self-Employment: $ \"&Financial!B29&CHAR(10),\"\")&IF(Financial!B30>0,\"Pension Plan: $ \"&Financial!B30&CHAR(10),\"\")&IF(Financial!B31>0,\"Deferred Compensation: $ \"&Financial!B31&CHAR(10),\"\")&IF(Financial!B32>0,\"Social Security: $ \"&Financial!B32,\"\")","v":""},{"$f":"IF(SUM(Financial!B27:B32)>0,1,0)","v":0}]
["My spouse has the following for annual retirement benefits:",{"$f":"IF(Financial!C27>0,\"Pensions: $ \"&Financial!C27&CHAR(10),\"\")&IF(Financial!C28>0,\"Profit Sharing: $ \"&Financial!C28&CHAR(10),\"\")&IF(Financial!C29>0,\"Self-Employment: $ \"&Financial!BD7&CHAR(10),\"\")&IF(Financial!C30>0,\"Pension Plan: $ \"&Financial!C30&CHAR(10),\"\")&IF(Financial!C31>0,\"Deferred Compensation: $ \"&Financial!C31&CHAR(10),\"\")&IF(Financial!C32>0,\"Social Security: $ \"&Financial!C32,\"\")","v":""},{"$f":"IF(SUM(Financial!C27:C32)>0,1,0)","v":0}]
["There is ",{"$f":"(IF(Financial!D27>0,\"$\"&Financial!D27&\" invested in Pensions.\"&CHAR(10),\"\"))&(IF(Financial!D28>0,\"$\"&Financial!D28&\" invested in Profit Sharing.\"&CHAR(10),\"\"))&(IF(Financial!D29>0,\"$\"&Financial!D29&\" invested in Self-Employment.\"&CHAR(10),\"\"))&(IF(Financial!D30>0,\"$\"&Financial!D30&\" invested in Pension Plans.\"&CHAR(10),\"\"))&(IF(Financial!D31>0,\"$\"&Financial!D31&\" invested in Deferred Compensation.\"&CHAR(10),\"\"))&(IF(Financial!D32>0,CHAR(10)&\"$\"&Financial!D32&\" invested in Social Security.\",\"\"))","v":""},{"$f":"IF(B93=\"\",0,1)","v":0}]
["I have the following in death benefits from:",{"$f":"IF(Financial!F27>0,\"Pensions: $ \"&Financial!F27&CHAR(10),\"\")&IF(Financial!F28>0,\"Profit Sharing: $ \"&Financial!F28&CHAR(10),\"\")&IF(Financial!F29>0,\"Self-Employment: $ \"&Financial!F29&CHAR(10),\"\")&IF(Financial!F30>0,\"Pension Plan: $ \"&Financial!F30&CHAR(10),\"\")&IF(Financial!F31>0,\"Deferred Compensation: $ \"&Financial!F31&CHAR(10),\"\")&IF(Financial!F32>0,\"Social Security: $ \"&Financial!F32,\"\")","v":""},{"$f":"IF(B94=\"\",0,1)","v":0}]
["My spouse has the following in death benefits from:",{"$f":"IF(Financial!G27>0,\"Pensions: $ \"&Financial!G27&CHAR(10),\"\")&IF(Financial!G28>0,\"Profit Sharing: $ \"&Financial!G28&CHAR(10),\"\")&IF(Financial!G29>0,\"Self-Employment: $ \"&Financial!G29&CHAR(10),\"\")&IF(Financial!G30>0,\"Pension Plan: $ \"&Financial!G30&CHAR(10),\"\")&IF(Financial!G31>0,\"Deferred Compensation: $ \"&Financial!G31&CHAR(10),\"\")&IF(Financial!G32>0,\"Social Security: $ \"&Financial!G32,\"\")","v":""},{"$f":"IF(B95=\"\",0,1)","v":0}]
[]
["Annual Summaries:",null,{"$f":"IF(SUM(C98:C102)>0,1,0)","v":0}]
[{"$f":"Financial!B35","v":2019},{"$f":"IF(Financial!B36>0,\"Family Income: $ \"&Financial!B36&CHAR(10),\"\")&IF(Financial!B37>0,\"Taxes (Federal & State): $ \"&Financial!B37&CHAR(10),\"\")&IF(Financial!B38>0,\"Living Expenses: $ \"&Financial!B38&CHAR(10),\"\")&IF(Financial!B39>0,\"Insurance Premiums: $ \"&Financial!B39,\"\")","v":""},{"$f":"IF(B98=\"\",0,1)","v":0}]
[{"$f":"Financial!C35","v":2018},{"$f":"IF(Financial!C36>0,\"Family Income: $ \"&Financial!C36&CHAR(10),\"\")&IF(Financial!C37>0,\"Taxes (Federal & State): $ \"&Financial!C37&CHAR(10),\"\")&IF(Financial!C38>0,\"Living Expenses: $ \"&Financial!C38&CHAR(10),\"\")&IF(Financial!C39>0,\"Insurance Premiums: $ \"&Financial!C39,\"\")","v":""},0]
[{"$f":"Financial!D35","v":2017},{"$f":"IF(Financial!D36>0,\"Family Income: $ \"&Financial!D36&CHAR(10),\"\")&IF(Financial!D37>0,\"Taxes (Federal & State): $ \"&Financial!D37&CHAR(10),\"\")&IF(Financial!D38>0,\"Living Expenses: $ \"&Financial!D38&CHAR(10),\"\")&IF(Financial!D39>0,\"Insurance Premiums: $ \"&Financial!D39,\"\")","v":""},0]
[{"$f":"Financial!E35","v":2016},{"$f":"IF(Financial!E36>0,\"Family Income: $ \"&Financial!E36&CHAR(10),\"\")&IF(Financial!E37>0,\"Taxes (Federal & State): $ \"&Financial!E37&CHAR(10),\"\")&IF(Financial!E38>0,\"Living Expenses: $ \"&Financial!E38&CHAR(10),\"\")&IF(Financial!E39>0,\"Insurance Premiums: $ \"&Financial!E39,\"\")","v":""},0]
[{"$f":"Financial!F35","v":2015},{"$f":"IF(Financial!F36>0,\"Family Income: $ \"&Financial!F36&CHAR(10),\"\")&IF(Financial!F37>0,\"Taxes (Federal & State): $ \"&Financial!F37&CHAR(10),\"\")&IF(Financial!F38>0,\"Living Expenses: $ \"&Financial!F38&CHAR(10),\"\")&IF(Financial!F39>0,\"Insurance Premiums: $ \"&Financial!F39,\"\")","v":""},0]
[]
[]
["Assets:"]
[]
["Personal Assets:",null,{"$f":"IF(SUM(C108,C110,C112,C114,C116,C121)>0,1,0)","v":0}]
["Personal Property:",null,{"$f":"C109","v":0}]
["Total Market Value:",{"$f":"'Personal Assets'!G29","v":0},{"$f":"IF(B109=0,0,1)","v":0}]
["Real Estate:",null,{"$f":"C111","v":0}]
["Total Market Value:",{"$f":"'Personal Assets'!G36","v":0},{"$f":"IF(B111=0,0,1)","v":0}]
["Life Insurance:",null,{"$f":"C113","v":0}]
["Total Values:",{"$f":"'Personal Assets'!E43","v":0},0]
["Bank Accounts & Cash:",null,{"$f":"C115","v":0}]
["Total Amounts:",{"$f":"'Personal Assets'!D59","v":0},0]
["Investments (Total Current Values):",null,{"$f":"IF(SUM(C117:C120)>0,1,0)","v":0}]
["Bonds:",{"$f":"'Personal Assets'!F70","v":0},0]
["Stocks:",{"$f":"'Personal Assets'!E77","v":0},0]
["Mutual Funds:",{"$f":"'Personal Assets'!E84","v":0},0]
["Other Investments:",{"$f":"'Personal Assets'!E91","v":0},0]
["Accounts Revievable:",null,{"$f":"C122","v":0}]
["Total Current Values:",{"$f":"'Personal Assets'!D98","v":0},0]
[null,null,{"$f":"C124","v":0}]
["Total Personal Assets (Gross Estate):",{"$f":"SUM(B108:B123)","v":0},{"$f":"C107","v":0}]
[]
["Business Assets:",null,{"$f":"IF(SUM(C127,C129,C131,C133,C135,C140)>0,1,0)","v":0}]
["Private Property:",null,{"$f":"C128","v":0}]
["Total Market Value:",{"$f":"'Business Assets'!F26","v":0},{"$f":"IF(B128=0,0,1)","v":0}]
["Real Estate:",null,{"$f":"C130","v":0}]
["Total Market Value:",{"$f":"'Business Assets'!F36","v":0},{"$f":"IF(B130=0,0,1)","v":0}]
["Farm Insurance:",null,{"$f":"C132","v":0}]
["Total Values:",{"$f":"'Business Assets'!E43","v":0},0]
["Bank Accounts & Cash:",null,{"$f":"C134","v":0}]
["Total Amounts:",{"$f":"'Business Assets'!C59","v":0},0]
["Investments (Total Current Values):",null,{"$f":"IF(SUM(C136:C139)>0,1,0)","v":0}]
["Bonds:",{"$f":"'Business Assets'!E67","v":0},0]
["Stocks:",{"$f":"'Business Assets'!D74","v":0},0]
["Mutual Funds:",{"$f":"'Business Assets'!D81","v":0},0]
["Other Investments:",{"$f":"'Business Assets'!D88","v":0},0]
["Accounts Revievable:",null,{"$f":"C141","v":0}]
["Total Current Values:",{"$f":"'Business Assets'!D95","v":0},0]
[null,null,{"$f":"C143","v":0}]
["Total Business Assets (Gross Business Estate):",{"$f":"SUM(B127:B142)","v":0},{"$f":"C126","v":0}]
[]
[]
["Liabilities:"]
[]
["Personal Liabilities:",null,{"$f":"IF(SUM(C149,C151,C153)>0,1,0)","v":0}]
["Mortgages:",null,{"$f":"C150","v":0}]
["Total Current Balances:",{"$f":"'Personal Liabilities'!F8","v":0},{"$f":"IF(B150=0,0,1)","v":0}]
["Unsecured Notes, Installments, & Contracts:",null,{"$f":"C152","v":0}]
["Total Current Balances:",{"$f":"'Personal Liabilities'!F15","v":0},{"$f":"IF(B152=0,0,1)","v":0}]
["Secured Notes, Installments, & Contracts:",null,{"$f":"C154","v":0}]
["Total Current Balances:",{"$f":"'Personal Liabilities'!F22","v":0},{"$f":"IF(B154=0,0,1)","v":0}]
[null,null,{"$f":"C156","v":0}]
["Total Personal Liabilities:",{"$f":"SUM(B149:B155)","v":0},{"$f":"C148","v":0}]
[]
["Business Liabilities:",null,{"$f":"IF(SUM(C159,C161,C163,C165,C167,C169)>0,1,0)","v":0}]
["Land & Buildings:",null,{"$f":"C160","v":0}]
["Total Current Balance:",{"$f":"'Business Liabilities'!F8","v":0},{"$f":"IF(B160=0,0,1)","v":0}]
["Machinery:",null,{"$f":"C162","v":0}]
["Total Current Balance:",{"$f":"'Business Liabilities'!E15","v":0},{"$f":"IF(B162=0,0,1)","v":0}]
["Livestock:",null,{"$f":"C164","v":0}]
["Total Current Balance:",{"$f":"'Business Liabilities'!E22","v":0},{"$f":"IF(B164=0,0,1)","v":0}]
["Crops:",null,{"$f":"C166","v":0}]
["Total Current Balance:",{"$f":"'Business Liabilities'!E29","v":0},{"$f":"IF(B166=0,0,1)","v":0}]
["Unsecured Notes, Installments, & Contracts:",null,{"$f":"C168","v":0}]
["Total Current Balance:",{"$f":"'Business Liabilities'!E36","v":0},{"$f":"IF(B168=0,0,1)","v":0}]
["Accounts Payable:",null,{"$f":"C170","v":0}]
["Total Current Balance:",{"$f":"'Business Liabilities'!E43","v":0},{"$f":"IF(B170=0,0,1)","v":0}]
[null,null,{"$f":"C172","v":0}]
["Total Business Liabilities:",{"$f":"SUM(B159:B171)","v":0},{"$f":"C158","v":0}]
[]
[]
["Estate:"]
["Total Personal Assets (Gross Estate):",{"$f":"B124","v":0},{"$f":"IF(B176=0,0,1)","v":0}]
["- Total Personal Liabilities:",{"$f":"B156","v":0},{"$f":"IF(B177=0,0,1)","v":0}]
["Net Personal Estate:",{"$f":"B176-B177","v":0}]
[]
["Total Business Assets (Gross Business Estate):",{"$f":"B143","v":0},{"$f":"IF(B180=0,0,1)","v":0}]
["- Total Business Liabilities:",{"$f":"B172","v":0},0]
["Net Business Estate:",{"$f":"B180-B181","v":0}]
[]
[]
[]
[null,null,"x"]