{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Investment Ledger","Investment Chart","Investment Gain-Loss Analysis"],"not_rendered":{"charts":1,"external_links":1,"defined_names":1},"unopened":[{"sheet":"Investment Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Investment Ledger","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"merged":[[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4]],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Investment Ledger"]
[null,"[Date]"]
[]
[null,"Gray cells are calculated for you. You do not need to enter anything into them. "]
[null,"Investment type","Investment description","Purchase date","Number of units (shares)","Cost per unit (share)","Original cost (basis)","Current Asset Value","Unrecognized Gain (Loss)"]
[null,"Stocks","800 common shares-Fourth Coffee","2003-05-04",{"v":1800,"d":"1,800.00"},{"v":67,"d":"$67.00"},{"v":120600,"d":"$120,600.00"},{"v":197500,"d":"$197,500.00"},{"v":76900,"d":"$76,900.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[null,"Bonds","10-year treasury (4.76% yield)","2003-05-20",{"v":1500,"d":"1,500.00"},{"v":102.26,"d":"$102.26"},{"v":153390,"d":"$153,390.00"},{"v":148500,"d":"$148,500.00"},{"v":-4890,"d":"($4,890.00)"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[null,"Mutual funds","Woodgroove Bank equity fund","2003-06-30",{"v":2000,"d":"2,000.00"},{"v":25.5,"d":"$25.50"},{"v":51000,"d":"$51,000.00"},{"v":50000,"d":"$50,000.00"},{"v":-1000,"d":"($1,000.00)"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[null,"Minority interests","Litware, Inc. (20% ownership)","1999-01-15",{"v":1000,"d":"$1,000.00"},{"v":500,"d":"$500.00"},{"v":500000,"d":"$500,000.00"},{"v":550000,"d":"$550,000.00"},{"v":50000,"d":"$50,000.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[null,"Other",{"$nulls":4},{"v":0,"d":"$0.00"},{"v":18000,"d":"$18,000.00"},{"v":18000,"d":"$18,000.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"v":0,"d":"$0.00"},null,{"v":0,"d":"0.00"}]
[]
[]
[null,"Investment summary"]
[null,"Classification","Total current value","Total unrecognized gain/loss"]
[null,"Stocks",{"v":197500,"d":"$197,500.00"},{"v":76900,"d":"$76,900.00"}]
[null,"Bonds",{"v":148500,"d":"148,500.00"},{"v":-4890,"d":"(4,890.00)"}]
[null,"Mutual funds",{"v":50000,"d":"50,000.00"},{"v":-1000,"d":"(1,000.00)"}]
[null,"Minority interests",{"v":550000,"d":"550,000.00"},{"v":50000,"d":"50,000.00"}]
[null,"Other",{"v":18000,"d":"18,000.00"},{"v":18000,"d":"18,000.00"}]
[null,"Total",{"v":964000,"d":"$964,000.00"},{"v":139010,"d":"$139,010.00"}]

{"sheet":"Investment Gain-Loss Analysis","index":2,"n_rows":35,"n_cols":8,"rows_kept":35,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Investment Gain-Loss Analysis"]
[null,"[Date]"]
[]
[null,"Gain-loss classification","Investment description","Date purchased","Cost \n(basis)","Date \nsold","Sale \nvalue","Recognized gain (loss)"]
[null,"Long-term gain/loss","Contoso, Ltd. common stock","2004-03-20",{"v":50000,"d":"$50,000.00"},"2004-05-01",{"v":75000,"d":"$75,000.00"},{"v":25000,"d":"$25,000.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Total long-term gains/losses",{"$nulls":5},{"v":25000,"d":"$25,000.00"}]
[]
[null,"Short-term gain/loss","Blue Yonder Airlines 10-yr. bonds (5.0% yield)","2004-01-15",{"v":30000,"d":"$30,000.00"},"2004-04-30",{"v":28500,"d":"$28,500.00"},{"v":-1500,"d":"($1,500.00)"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Total short-term gains/losses",{"$nulls":5},{"v":-1500,"d":"($1,500.00)"}]