{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Wealth Accumulation Analysis - "],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Wealth Accumulation Analysis - ","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,33,8],[25,1,25,2],[8,4,8,8],[8,1,8,2],[6,1,6,8],[4,1,4,8]]}
[]
[]
[]
[]
[null,"CashFlow Accumulation Analysis"]
[]
[null,{"$f":"NOW()","v":"2017-03-15T10:17:38"}]
[]
[null,"Annual Realized Income",null,null,"Net Worth Worksheet"]
[]
[null,"Monthly wages, salary",5000,null,"Property Assets",null,null,"Liabilities"]
[null,"Dividends and interest",100,null,"Residence",150000,null,"Home mortgage",70000]
[null,"Other",10,null,"Vacation home",0,null,"Other mortgage",30000]
[null,"Total monthly Income",{"$f":"IF(SUM(C11:C13),SUM(C11:C13),\"\")","v":5110},null,"Furnishings",50000,null,"Bank loans",1000]
[null,"Other Income (Annual Amounts)",null,null,"Jewelry and art",10000,null,"Auto loans",20000]
[null,"Business income",10000,null,"Automobiles",30000,null,"Credit cards",5000]
[null,"Capital gains",2000,null,"Other",10000,null,"Personal loans",2000]
[null,"Other",null,null,"Equity Assets",null,null,"Other",3000]
[null,"Other",null,null,"Real estate",100000,null,"Total Liabilities",{"$f":"IF(SUM(I12:I18),SUM(I12:I18),\"\")","v":131000}]
[null,"Other",null,null,"Stocks",50000]
[null,"Other",null,null,"Bonds",56000]
[null,"Total other income",{"$f":"IF(SUM(C16:C21),SUM(C16:C21),\"\")","v":12000},null,"Mutual funds",15000]
[{"$nulls":4},"Annuities",5000]
[null,"Total annual realized income",{"$f":"IF(SUM(C14,C22),C14*12+C22,\"\")","v":73320},null,"Business equity",15000]
[{"$nulls":4},"Cash Reserve Assets",null,null,"Summary"]
[null,"Net Worth Analysis",null,null,"Checking account",10000,null,"Total Assets",{"$f":"IF(SUM(F31),F31,\"\")","v":514600}]
[null,"Your Age",40,null,"Savings account",5000,null,"Total Liabilities",{"$f":"IF(SUM(I19),I19,\"\")","v":131000}]
[null,"Actual Net Worth",{"$f":"IF(SUM(I31),I31,\"\")","v":383600},null,"CDs",6000]
[null,"What Your Net Worth Should Be",{"$f":"IF(SUM(C27),(C27*C24)/10,\"\")","v":293280},null,"Money market",2000]
[null,"Actual as a % of Projected",{"$f":"IF(SUM(C29),C28/C29,\"\")","v":1.307965084560829},null,"Other",600]
[null,"Realized Income as % of NW",{"$f":"IF(SUM(I31),C24/I31,\"\")","v":0.1911366006256517},null,"Total Assets",{"$f":"IF(SUM(F12:F17,F19:F24,F26:F30),SUM(F12:F17,F19:F24,F26:F30),\"\")","v":514600},null,"Net Worth",{"$f":"IF(SUM(I26:I27),I26-I27,\"\")","v":383600}]
[]
[]
[null,"www.CUAtlanta.org"]