Excel Spreadsheet

Investment ledger1

You must be logged in to download this document
Reviews
Shared by: Lindsay Martin
Stats
views:
487
rating:
not rated
reviews:
0
posted:
3/21/2008
language:
English
pages:
0
[Company Name] Investment Ledger [Date] Gray cells are calculated for you. You do not need to enter anything into them. Investment type Stocks Investment description 800 common shares-Fourth Coffee Purchase date 5/4/03 Number of units (shares) 1,800.00 Cost per unit (share) $67.00 Original cost (basis) $120,600.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $153,390.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $51,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Current Asset Value $197,500.00 Unrecognized Gain (Loss) $76,900.00 0.00 0.00 0.00 0.00 0.00 0.00 ($4,890.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ($1,000.00) 0.00 0.00 0.00 0.00 0.00 $50,000.00 0.00 0.00 0.00 0.00 0.00 $18,000.00 0.00 0.00 0.00 0.00 0.00 Bonds 10-year treasury (4.76% yield) 5/20/03 1,500.00 $102.26 $148,500.00 Mutual funds Woodgroove Bank equity fund 6/30/03 2,000.00 $25.50 $50,000.00 Minority interests Litware, Inc. (20% ownership) 1/15/99 $1,000.00 $500.00 $550,000.00 Other $18,000.00 Investment summary Classification Stocks Bonds Mutual funds Minority interests Other Total Total current value $197,500.00 148,500.00 50,000.00 550,000.00 18,000.00 $964,000.00 Total unrecognized gain/loss $76,900.00 (4,890.00) (1,000.00) 50,000.00 18,000.00 $139,010.00 Stocks Bonds Mutual funds Minority interests Other Other 2% Stocks 21% Minority interests 57% Bonds 15% Mutual funds 5% [Company Name] Investment Gain-Loss Analysis [Date] Gain-loss classification Long-term gain/loss Investment description Contoso, Ltd. common stock Date purchased 3/20/2004 Cost (basis) $50,000.00 Date sold 5/1/2004 Sale value $75,000.00 Recognized gain (loss) $25,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $25,000.00 ($1,500.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ($1,500.00) Total long-term gains/losses Short-term gain/loss Blue Yonder Airlines 10-yr. bonds (5.0% yield) 1/15/04 $30,000.00 4/30/04 $28,500.00 Total short-term gains/losses

Related docs
REGIONAL INVESTMENT
Views: 7  |  Downloads: 2
Service Investment
Views: 21  |  Downloads: 0
INVESTMENT APPRAISAL
Views: 78  |  Downloads: 2
Growth and investment
Views: 236  |  Downloads: 40
AN INVESTMENT PARTNERSHIP
Views: 1  |  Downloads: 0
Investment Portfolio
Views: 18  |  Downloads: 0
INVESTMENT COMMITTEE
Views: 6  |  Downloads: 0
Return on Investment
Views: 710  |  Downloads: 24
Investment_
Views: 3  |  Downloads: 0
Investment
Views: 0  |  Downloads: 0
Investment
Views: 4  |  Downloads: 1
premium docs
Other docs by Lindsay Martin
Budget summary report1[1]
Views: 414  |  Downloads: 57
Equity reconciliation report1[2]
Views: 393  |  Downloads: 20
Market analysis1
Views: 591  |  Downloads: 89
Capital asset depreciation schedule1[1]
Views: 858  |  Downloads: 99
Cash flow tracker1
Views: 688  |  Downloads: 99
Inventory-cost of goods sold analysis1
Views: 536  |  Downloads: 77
Product profitability analysis1[1]
Views: 494  |  Downloads: 53
Ratio analysis1[1]
Views: 530  |  Downloads: 101
Headcount and payroll planning1[1]
Views: 412  |  Downloads: 73
Quarterly revenue planning1[2]
Views: 192  |  Downloads: 11
Detailed revenue plan1[2]
Views: 183  |  Downloads: 18
Five year projection worksheet1[1]
Views: 234  |  Downloads: 18
Wedding budget1[1]
Views: 287  |  Downloads: 23
Finance charge1
Views: 297  |  Downloads: 7
4011
Views: 142  |  Downloads: 1