{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Wealth Accumulation Analysis"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Wealth Accumulation Analysis","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[31,1,31,8]]}
[]
[]
[null,"Wealth Accumulation Analysis"]
[]
[null,{"$f":"NOW()","v":"2010-04-19T17:06:28.960"}]
[]
[null,"Annual Realized Income",null,null,"Net Worth Worksheet"]
[]
[null,"Monthly wages, salary",{"v":5000,"d":"$5,000"},null,"Property Assets",null,null,"Liabilities"]
[null,"Dividends and interest",{"v":100,"d":"100 "},null,"Residence",{"v":150000,"d":"$150,000"},null,"Home mortgage",{"v":70000,"d":"$70,000"}]
[null,"Other",{"v":10,"d":"10 "},null,"Vacation home",{"v":200000,"d":"200,000 "},null,"Other mortgage",{"v":30000,"d":"30,000 "}]
[null,"Total monthly Income",{"$f":"IF(SUM(C9:C11),SUM(C9:C11),\"\")","v":{"v":5110,"d":"$5,110"}},null,"Furnishings",{"v":50000,"d":"50,000 "},null,"Bank loans",{"v":1000,"d":"1,000 "}]
[null,"Other Income (Annual Amounts)",null,null,"Jewelry and art",{"v":10000,"d":"10,000 "},null,"Auto loans",{"v":20000,"d":"20,000 "}]
[null,"Business income",{"v":10000,"d":"$10,000"},null,"Automobiles",{"v":30000,"d":"30,000 "},null,"Credit cards",{"v":5000,"d":"5,000 "}]
[null,"Capital gains",{"v":2000,"d":"2,000 "},null,"Other",{"v":10000,"d":"10,000 "},null,"Personal loans",{"v":2000,"d":"2,000 "}]
[null,"Other",null,null,"Equity Assets",null,null,"Other",{"v":3000,"d":"3,000 "}]
[null,"Other",null,null,"Real estate",{"v":100000,"d":"$100,000"},null,"Total Liabilities",{"$f":"IF(SUM(I10:I16),SUM(I10:I16),\"\")","v":{"v":131000,"d":"$131,000"}}]
[null,"Other",null,null,"Stocks",{"v":50000,"d":"50,000 "}]
[null,"Other",null,null,"Bonds",{"v":56000,"d":"56,000 "}]
[null,"Total other income",{"$f":"IF(SUM(C14:C19),SUM(C14:C19),\"\")","v":{"v":12000,"d":"$12,000"}},null,"Mutual funds",{"v":15000,"d":"15,000 "}]
[{"$nulls":4},"Annuities",{"v":5000,"d":"5,000 "}]
[null,"Total annual realized income",{"$f":"IF(SUM(C12,C20),C12*12+C20,\"\")","v":{"v":73320,"d":"$73,320"}},null,"Business equity",{"v":15000,"d":"15,000 "}]
[{"$nulls":4},"Cash Reserve Assets",null,null,"Summary"]
[null,"Net Worth Analysis",null,null,"Checking account",{"v":10000,"d":"$10,000"},null,"Total Assets",{"$f":"IF(SUM(F29),F29,\"\")","v":{"v":714600,"d":"$714,600"}}]
[null,"Your Age",40,null,"Savings account",{"v":5000,"d":"5,000 "},null,"Total Liabilities",{"$f":"IF(SUM(I17),I17,\"\")","v":{"v":131000,"d":"$131,000"}}]
[null,"Actual Net Worth",{"$f":"IF(SUM(I29),I29,\"\")","v":{"v":583600,"d":"$583,600"}},null,"CDs",{"v":6000,"d":"6,000 "}]
[null,"What Your Net Worth Should Be",{"$f":"IF(SUM(C25),(C25*C22)/10,\"\")","v":{"v":293280,"d":"$293,280"}},null,"Money market",{"v":2000,"d":"2,000 "}]
[null,"Actual as a % of Projected",{"$f":"IF(SUM(C27),C26/C27,\"\")","v":{"v":1.9899072558647026,"d":"199%"}},null,"Other",{"v":600,"d":"600 "}]
[null,"Realized Income as % of NW",{"$f":"IF(SUM(I29),C22/I29,\"\")","v":{"v":0.12563399588759425,"d":"12.6%"}},null,"Total Assets",{"$f":"IF(SUM(F10:F15,F17:F22,F24:F28),SUM(F10:F15,F17:F22,F24:F28),\"\")","v":{"v":714600,"d":"$714,600"}},null,"Net Worth",{"$f":"IF(SUM(I24:I25),I24-I25,\"\")","v":{"v":583600,"d":"$583,600"}}]