{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Budget","Balance Sheet","Notes","Projection"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"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","formulas":"cached_only"}

{"sheet":"Budget","index":0,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,1,5,4],[5,6,5,9],[5,11,5,14],[0,1,0,14],[2,1,2,14],[1,1,1,14]],"flags":["formulas_cached_only"]}
[null,"MONTHLY BUDGET"]
[null,"Dawn and Steve Jacobson"]
[null,"May 2008"]
[]
[]
[null,"Column #1",{"$nulls":4},"Column #2",{"$nulls":4},"Column #3"]
[null,"Housing:",{"$nulls":4},"Household / Personal:",{"$nulls":4},"Loan Payments / Savings:"]
[null,null,"Mortgage/Rent ($1,141.88)",null,1500,null,null,"Groceries",null,400,null,null,"Credit Card Payments",null,0]
[null,null,"Property Taxes",null,600,null,null,"Personal Care",null,50,null,null,"Other Loan Payments",null,0]
[null,null,"Home Maintenance",null,1300,null,null,"Clothing / Dry Cleaning",null,25,null,null,"Savings / Investing",null,500]
[null,null,"Homeowner's Insurance",null,12,null,null,"Domestic Help",null,85,null,null,"New Car Fund",null,500]
[null,null,"Utilities:","Electric / Gas",350,null,null,"Professional Dues",null,0]
[null,null,"     ","Water",60,null,null,"Dependent / Child Care",null,500,null,"Discretionary:"]
[null,null,null,"RoadRunner",42,null,null,"Education / School",null,0,null,null,"Dining Out",null,100]
[null,null,null,"Phone",120,null,null,"Cash / Allowances",null,0,null,null,"Recreation / Club Dues",null,200]
[{"$nulls":12},"Movies / Sporting Events",null,50]
[null,"Transportation:",{"$nulls":4},"Personal Insurance:",{"$nulls":5},"Hobbies",null,250]
[null,null,"Auto Payments",null,0,null,null,"Health Insurance *",null,0,null,null,"Vacation  / Travel",null,500]
[null,null,"Auto Insurance",null,100,null,null,"Life Insurance *",null,280.33666666666664,null,null,"Gifts / Contributions",null,250]
[null,null,"Gas",null,75,null,null,"Disability Insurance *",null,0,null,null,"Other: Braces",null,200]
[null,null,"Maintenance / License",null,300,null,null,"Long Term Care *",null,0,null,null,"Other:  ???",null,200]
[null,null,"Parking/Tolls/Bus/Train",null,70,null,null,"Medical/Dental/Drugs *",null,100]
[]
[null,"Total Column 1",null,null,4529,null,"Total Column 2",null,null,1440.3366666666666,null,"Total Column 3",null,null,2750]
[]
[]
[null,"Monthly Net Income *:",null,null,10500]
[null,"1/2 2007 Bonus (less 50% Tax)",null,null,1300]
[null,"   Less Expenses",null,null,8719.336666666666]
[null,"Total Surplus/(Deficit)",null,null,3080.663333333334]

{"sheet":"Balance Sheet","index":1,"n_rows":90,"n_cols":9,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7]],"flags":["formulas_cached_only"]}
["DAWN & STEVE JACOBOSON"]
["Balance Sheet"]
["December 31, 2009"]
[]
["ASSETS:"]
["Current Assets:"]
["  ECU - Checking Account - #08",{"$nulls":5},44937.94,"2009-12-31"]
["  ECU - Savings Account - #00",{"$nulls":5},13474.8,"2009-12-31"]
["  ECU - Money Market Account - #02",{"$nulls":5},49144.78,"2009-12-31"]
["  ECU - Special Savings Account - #03 (From Grandma Kralicek)",{"$nulls":5},47373.42,"2009-12-31"]
["  Webster Electric Credit Union (Danfoss/MCU)",{"$nulls":5},252.52,"2009-12-31"]
["  Northwestern Credit Union",{"$nulls":5},507.96,"2008-03-31"]
["  Johnson Bank - Savings Account",{"$nulls":5},3392.88,"2009-12-31"]
["Total Current Assets",{"$nulls":5},159084.3]
[]
["Long Term Assets:"]
["Cash Investments:"]
["  Aim Constellation Fund",{"$nulls":5},22385.77,"2009-12-31"]
["  Aim Global Growth",{"$nulls":5},6222.32,"2009-12-31"]
["  Aim Capital Development Fund",{"$nulls":5},33359.89,"2009-12-31"]
["  Putnam Growth & Income",{"$nulls":5},76165.51,"2009-12-31"]
["Total Cash Investments",{"$nulls":5},138133.49]
[]
["Other:"]
["  7140 Aspen Court",{"$nulls":5},156000,"Purchase Price (FMV $285,423)"]
["  Sunnyslope Condo",{"$nulls":5},165000,"Purchase Price (FMV $159,900 Assessment)"]
["  Prudential Life Insurance Policy - Dawn",{"$nulls":5},6803.16,"Death Benefit (June, 1999)"]
["  Prudential IRA - Dawn",{"$nulls":5},1053.25,"2009-12-31"]
["  NML Life Insurance - Term - Dawn",{"$nulls":5},150000,"NC"]
["  NML Life Insurance - Whole Life - Dawn",{"$nulls":5},150000,"NC (Total Investment Value - $953.50)"]
["  NML Life Insurance - Whole Life - Steve",{"$nulls":5},100000,"NC"]
["  SCJ Life Insurance - Dawn (5 x Pay)",{"$nulls":5},610000,"NC"]
["  SCJ Life Insurance - Steve",{"$nulls":5},50000,"NC"]
["  CNA - Life Insurance - Steve",{"$nulls":5},40000,"NC"]
["  Philadelphia Life Insurance - Steve",{"$nulls":5},25000,"NC"]
["  Valley Forge Life Insurance - Steve",{"$nulls":5},924.32,"May 10, 2008 (Death Benefit $10,000)"]
["  Valley Forge Life Insurance - Steve",{"$nulls":5},5123.27,"May 10, 2008 (Death Benefit $39,215)"]
["  M & I Bank - Steve's IRA",{"$nulls":5},271.7,"2009-12-31"]
["  NML - 401K Fund",{"$nulls":5},100756.38,"2008-12-31"]
["  SCJ Wax - 401K Fund (Deferred Profit Sharing and Savings Plan)",{"$nulls":5},345101.42,"2008-12-31","Check 2007 Statement value????"]
["  SCJ Wax - Cash Balance Pension Plan",{"$nulls":5},112689.4,"2009-01-01"]
["  SCJ Wax - Retirement Medical Savings Account",{"$nulls":5},56950.21,"2009-12-31"]
["  Johnson International - 401K Fund",{"$nulls":5},35264.48,"December 31,2009"]
["Total Other",{"$nulls":5},2110937.59]
[]
["Investments at Dad & Mom's:"]
["  Excelon (859.878 Shares @ $51.61)",{"$nulls":5},44378.30358,"2009-12-31"]
["  Growth Fund of America - American Funds (43.913 Shares @ $27.33)",{"$nulls":5},1200.1422899999998,"2009-12-31"]
["  Income Fund of America - American Funds (181.508 Shares @ $25.95)",{"$nulls":5},4710.1326,"2009-12-31"]
["Total Investments at Dad & Mom's",{"$nulls":5},50288.57846999999]
[]
["Total Long Term Assets",{"$nulls":5},2299359.65847]
[]
["Total Assets",{"$nulls":5},2458443.95847]
[]
["LIABILITIES & NET WORTH:"]
[]
["Mortgage:"]
[]
["Johnson Trust Loan ($160,288.23)",{"$nulls":5},86190.52,"2009-12-31"]
["Total Mortgage",{"$nulls":5},86190.52]
[{"$nulls":8},"NW Prior Year"]
["Total NET WORTH",{"$nulls":5},2261492.79,null,2261492.79]
["Total Liabilities & Net Worth",{"$nulls":5},2347683.31,null,"NW Change"]
[null,null,null,"Balance",null,null,110760.65,null,0]
[]
["Net Worth (excluding Life Insurance Policies)",{"$nulls":5},1234402.68847]
[]
["EMILY'S Information:"]
["  State Farm Insurance Policy - Emily",{"$nulls":5},15000,"NC"]
["  SCJ Life Insurance - Emily",{"$nulls":5},10000,"NC"]
["  Trivent Investment Large Cap Stock Fund",{"$nulls":5},5589.28,"2009-12-31"]
["  ECU CD - #40",null,"Matures on 4/22/10",null,null,null,1996.38,"2009-12-31"]
["  ECU Savings Account - #00",{"$nulls":5},11401.5,"2009-12-31"]
["Total Emily's Net Worth",{"$nulls":5},43987.16]
[]
["RYAN'S Information:"]
["  SCJ Life Insurance - Ryan",{"$nulls":5},10000,"NC"]
["  NML Life Insurance - Ryan",{"$nulls":5},25921,"Death Benefit, December 31, 2009"]
["  Trivent Investment Large Cap Stock Fund",{"$nulls":5},2652.37,"2009-12-31"]
["  The American Funds (Growth Fund of America - Class A)",{"$nulls":5},301.2,"2009-12-31"]
["  ECU Savings Account - #11",{"$nulls":5},2928.14,"2009-12-31"]
["  ECU Savings Account - #00",{"$nulls":5},5917.39,"2009-12-31"]
["Total Ryan's Net Worth",{"$nulls":5},47720.1]
[]
["MOM'S Information:"]
["  ECU Savings Account - #04",{"$nulls":5},4583.64,"2009-12-31"]
[]
["MISC NOTES:"]
["  Karen Schmidt - Cleaning",null,null,"9/6/06 gave raise from $50 for 4 hours ($12.50/hour) to $55 for 4 hours ($13.75/hour)"]

{"sheet":"Notes","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["NOTES:"]
[]
["Associated Mortgage"]
[null,"Phone Number:   1-800-242-2470"]
[null,"P.O. Box 12620"]
[null,"Green Bay, WI  54307-2620"]
[null,"Loan #88004"]
[]
[null,"Checking Account Number:   08000156158"]
[null,"ECU's Rounting ABA Number:    275981378"]

{"sheet":"Projection","index":3,"n_rows":27,"n_cols":42,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,0,18,3],[19,0,19,3],[7,0,7,3],[0,0,0,40],[1,0,1,40],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3],[8,0,8,3],[9,0,9,3]],"flags":["formulas_cached_only"]}
["DAWN & STEVE JACOBOSON"]
["December 31, 2009"]
[]
["Years until Retirement:",null,14]
["% annual earnings",null,0.06]
[]
[]
["Long Term Assets:",{"$nulls":4},"Current","Annual additional Investment","Investment Year 1","Investment Year 2","Investment Year 3","Investment Year 4","Investment Year 5","Investment Year 6","Investment Year 7","Investment Year 8","Investment Year 9","Investment Year 10","Investment Year 11","Investment Year 12","Investment Year 13","Investment Year 14","Retirement Year 1","Retirement Year 2","Retirement Year 3","Retirement Year 4","Retirement Year 5","Retirement Year 6","Retirement Year 7","Retirement Year 8","Retirement Year 9","Retirement Year 10","Retirement Year 11","Retirement Year 12","Retirement Year 13","Retirement Year 14","Retirement Year 15","Retirement Year 16","Retirement Year 17","Retirement Year 18","Retirement Year 19","Retirement Year 20"]
["  Aim Constellation Fund",null,null,null,"Emily",22385.77,6000,30088.916200000003,38254.25117200001,46909.506242320014,56084.076616859216,65809.12121387078,76117.66848670303,55244.72859590521,33119.41231165952,9666.577050359094,-15193.428326619362,-9745.034026216525,-3969.7360677895163,2152.0797681431127,8641.2045542317,9159.676827485602,9709.257437134738,10291.812883362823,10909.321656364593,11563.880955746468,12257.713813091257,12993.176641876733,13772.767240389338,14599.133274812699,15475.081271301462,16403.58614757955,17387.801316434325,-29268.93060457962,-31025.066440854396,-32886.57042730566,-34859.764652944,-36951.35053212065,-39168.43156404789,-41518.537457890765,-44009.649705364216]
["  Aim Global Growth",{"$nulls":4},6222.32,0,6595.6592,6991.398752,7410.88267712,7855.535637747201,8326.867776012034,8826.479842572757,9356.068633127123,9917.432751114751,10512.478716181637,11143.227439152535,11811.821085501688,12520.53035063179,13271.7621716697,14068.067901969882,14912.151976088075,15806.88109465336,16755.29396033256,17760.611597952517,18826.248293829667,19955.823191459447,21153.172582947016,22422.362937923837,23767.70471419927,25193.76699705123,26705.393016874303,28307.716597886763,30006.17959375997,31806.55036938557,33714.94339154871,35737.839995041635,37882.11039474414,40155.03701842879,42564.33923953452,45118.1995939066]
["  Aim Capital Development Fund",{"$nulls":4},33359.89,0,35361.483400000005,37483.172404000004,39732.16274824001,42116.09251313441,44643.05806392248,47321.64154775783,50160.940040623296,53170.5964430607,56360.832229644344,59742.48216342301,63327.0310932284,67126.6529588221,71154.25213635144,75423.50726453253,79948.91770040448,84745.85276242875,89830.60392817449,95220.44016386496,100933.66657369686,106989.68656811868,113409.0677622058,120213.61182793815,127426.42853761444,135072.0142498713,143176.3351048636,151766.91521115543,160872.93012382477,170525.30593125426,180756.82428712954,191602.2337443573,203098.36776901875,215284.26983515988,228201.3260252695,241893.40558678567]
["  Putnam Growth & Income",null,null,null,"Ryan",76165.51,0,80735.4406,85579.56703600001,90714.34105816002,96157.20152164962,101926.6336129486,108042.23162972552,114524.76552750905,121396.2514591596,128680.02654670918,136400.82813951175,144584.87782788248,153259.97049755542,162455.56872740874,140402.90285105328,117027.07702211649,92248.70164344348,65983.62374205008,69942.6411665731,74139.19963656749,78587.55161476154,83302.80471164724,88300.97299434608,93599.03137400685,99214.97325644727,105167.87165183411,111477.94395094416,118166.62058800082,125256.61782328087,132772.01489267775,140738.33578623843,149182.63593341273,83933.5940894175,88969.60973478256,94307.78631886952]
["  NML - 401K Fund",{"$nulls":4},100756.38,8715,116039.6628,132239.942568,149412.23912208,167614.87346940482,186909.66587756912,207362.14583022328,229041.7745800367,252022.1810548389,276381.41191812925,302202.19663321704,329572.2284312101,358584.4621370827,389337.4298653077,421935.5756572262,447251.7101966598,474086.8128084594,502532.021576967,532683.942871585,564644.9794438801,598523.678210513,634435.0989031438,672501.2048373325,712851.2771275725,755622.3537552268,800959.6949805404,849017.2766793729,899958.3132801353,953955.8120769435,1011193.1608015602,1071864.7504496537,1136176.635476633,1204347.233605231,1276608.067621545,1353204.5516788377]
["  SCJ Wax - 401K Fund (Deferred Profit Sharing and Savings Plan)",null,null,null,"Retirement Living",345101.42,23645.83,390872.085,439388.98990000004,490816.90909400006,545330.5034396402,603114.9134460186,664366.3880527797,729292.9511359464,798115.1080041032,871066.5942843494,948395.1697414103,1030363.459725895,1117249.8471094489,1209349.417736016,1306974.9626001772,1385393.4603561878,1362517.067977559,1338268.0920562127,1312564.1775795855,1285318.0282343607,1256437.1099284224,1225823.3365241277,1193372.7367155754,1158975.10091851,1122513.6069736206,1083864.4233920379,1042896.2887955601,999470.0661232938,953438.2700906915,904644.5662961331,852923.2402739011,798098.6346903353,739984.5527717554,678383.6259380607,613086.6434943443]
["  SCJ Wax - Cash Balance Pension Plan",{"$nulls":4},112689.4,0,119450.764,126617.80984,134214.87843040001,142267.77113622404,150803.8374043975,159852.06764866135,169443.19170758105,179609.7832100359,190386.37020263806,201809.55241479634,213918.12555968412,226753.2130932652,240358.40587886111,254779.9102315928,270066.70484548836,286270.7071362177,303446.94956439076,321653.7665382542,340952.99253054947,361410.1720823824,383094.7824073254,406080.46935176494,430445.29751287086,456272.0153636431,483648.33628546173,512667.23646258947,543427.2706503449,576032.9068893656,610594.8813027276,647230.5741808913,686064.4086317448,727228.2731496495,770861.9695386285,817113.6877109462]
["  SCJ Wax - Retirement Medical Savings Account",{"$nulls":4},56950.21,1400,61851.2226,67046.295956,72553.07371336,78390.2581361616,84577.6736243313,91136.33404179118,98088.51408429866,105457.82492935659,113269.29442511799,121549.45209062507,130326.41921606258,139630.00436902634,149491.80463116794,159945.312909038,169542.0316835803,179714.55358459512,190497.42679967085,201927.27240765112,214042.9087521102,226885.48327723684,240498.61227387105,254928.52901030332,270224.24075092154,286437.6951959768,303623.95690773544,321841.3943221996,341151.87798153155,361620.9906604235,383318.2501000489,406317.3451060518,430696.385812415,456538.1689611599,483930.4590988295,512966.2866447593]
["  Johnson International - 401K Fund",{"$nulls":4},35264.48,0,37380.34880000001,39623.16972800001,42000.55991168001,44520.593506380814,47191.82911676366,50023.33886376949,53024.73919559566,56206.22354733141,59578.59696017129,63153.312777781575,66942.51154444847,70959.06223711539,75216.60597134232,79729.60232962285,84513.37846940022,89584.18117756424,94959.2320482181,100656.78597111118,106696.19312937786,113097.96471714054,119883.84260016898,127076.87315617912,134701.48554554986,142783.57467828286,151350.58915897986,160431.62450851867,170057.52197902979,180260.9732977716,191076.6316956379,202541.22959737616,214693.70337321874,227575.32557561187,241229.8451101486,255703.63581675754]
["  Excelon (859.878 Shares @ $51.61)",{"$nulls":4},44378.30358,0,47041.0017948,49863.46190248801,52855.26961663729,56026.58579363553,59388.18094125367,62951.47179772889,66728.56010559262,70732.27371192818,74976.21013464387,79474.78274272251,84243.26970728587,89297.86588972303,94655.73784310643,100335.08211369281,106355.18704051439,112736.49826294526,119500.68815872198,126670.72944824531,134270.97321514005,142327.23160804846,150866.86550453136,159918.87743480326,169514.01008089146,179684.85068574495,190465.94172688967,201893.89823050305,214007.53212433326,226847.98405179326,240458.86309490088,254886.39488059495,270179.57857343066,286390.35328783654,303573.77448510675,321788.20095421316]
["  Growth Fund of America - American Funds (43.913 Shares @ $27.33)",{"$nulls":4},1200.1422899999998,0,1272.1508273999998,1348.4798770439997,1429.3886696666398,1515.1519898466383,1606.0611092374368,1702.424775791683,1804.5702623391842,1912.8444780795353,2027.6151467643076,2149.2720555701662,2278.2283789043763,2414.922081638639,2559.8174065369576,2713.406450929175,2876.210837984926,3048.783488264022,3231.710497559863,3425.613127413455,3631.1499150582626,3849.0189099617587,4079.960044559464,4324.757647233032,4584.243106067014,4859.297692431035,5150.855553976898,5459.906887215512,5787.5013004484435,6134.75137847535,6502.8364611838715,6893.006648854905,7306.587047786199,7744.982270653371,8209.681206892574,8702.262079306129]
["  Income Fund of America - American Funds (181.508 Shares @ $25.95)",{"$nulls":4},4710.1326,0,4992.740556,5292.30498936,5609.8432887216,5946.433886044897,6303.219919207591,6681.413114360047,7082.29790122165,7507.235775294949,7957.669921812647,8435.130117121405,8941.23792414869,9477.712199597612,10046.37493157347,10649.157427467879,11288.106873115952,11965.39328550291,12683.316882633086,13444.315895591071,14250.974849326536,15106.033340286129,16012.395340703297,16973.139061145495,17991.527404814227,19071.01904910308,20215.280192049267,21428.197003572226,22713.88882378656,24076.722153213756,25521.32548240658,27052.605011350977,28675.76131203204,30396.30699075396,32220.0854101992,34153.29053481115]
["Total Available Dollars (Investments less withdrawals)",{"$nulls":4},839183.95847,39760.83,931681.4757782002,1029728.844124892,1133659.0545723857,1243825.0776467293,1360601.0621055325,1484383.6056318649,1583793.1017697765,1689167.1676759634,1800863.6775365209,1919261.9779887123,2076564.1764680352,2243304.5068561174,2420049.2570674852,2575598.692291534,2698334.6138290265,2722434.6906587677,2747980.7720982945,2806859.6184241916,2869271.195529644,2935427.4672614224,3005553.115297108,3079886.3022149345,3158679.480347831,3242200.2491687,3330732.2641188223,3424576.1999659524,3476350.7719639093,3578931.818281744,3687667.727378649,3802927.7910213685,3925103.4584826506,3980409.66599161,4113234.245951107,4254028.300708173]
[]
["  With Drawals:",{"$nulls":40},"Total"]
["         Emily School and Wedding",{"$nulls":11},30000,30000,30000,30000,{"$nulls":16},45000,{"$nulls":8},165000]
["         Ryan School and Wedding",{"$nulls":18},30000,30000,30000,30000,{"$nulls":14},70000,null,null,null,190000]
["         Retirement Living",{"$nulls":20},100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,2000000]
["  Total Withdrawals",{"$nulls":6},0,0,0,0,0,30000,30000,30000,30000,0,0,0,30000,30000,130000,130000,100000,100000,100000,100000,100000,100000,100000,100000,100000,145000,100000,100000,100000,100000,170000,100000,100000,100000,2355000]