BUSN460 Senior Project
Individual Financial Analysis Project (CanGo)
Week 3
- At the beginning of 2009, CanGo purchased the online gaming company. This purchase was for cash, paid for through the proceeds of the IPO and results in goodwill.
- 90% of the online book sales comes from JIT, the other 10% through the inventory which CanGo possesses. 100% of the CD/DVD/MP3 come through CanGo inventory. The result is that 80% of ALL sales is JIT and 20% is inventory.
- There is one warehouse for shipping of books and one plant for manufacturing.
- There are three divisions: a CD/DVD/MP3 division, an online gaming division and a books division. All manufacturing takes place in the CD/DVD/MP3 division.
- The IPO took place at the beginning of 2009.
- The CD/DVDs were customized beginning in 2008. The MP3 players were built beginning in the start of 2009.
- The online gaming company was purchased for $30,000,000 and both Elizabeth and Andrew initiated the process.
- The company began in 2006, has a VC infusion in 2007 and 2008. It showed a profit in 2008 and 2009. Its only profitable division is the online book sales division.
- It has some type of international operations, hence the need for a “translation gain or loss” in owner’s equity.
- It has an extraordinary loss from fire and a sale of a segment of its business in 2009.
| ASSETS |
December 31, 2009 |
| Cash |
$20,900,000 |
| Marketable Securities |
$117,000,000 |
| Accounts Receivable |
$33,000,000 |
| Less: Allowance for Bad Debts |
$(880,000) |
| Net Accounts Receivable |
$32,120,000 |
| Inventory |
| Raw Materials |
$2,000,000 |
| Work-in-process |
$1,000,000 |
| Finished Goods |
$5,000,000 |
| Inventory Purchased for Resale |
$24,000,000 |
| Total Inventory |
$32,000,000 |
| Plant, Property and Equipment |
$6,700,000 |
| Less: Accumulated Depreciation |
$(320,000) |
| Net Plant, Property and Equipment |
$6,380,000 |
| Prepaid Expenses |
$200,000 |
| Goodwill and Other Purchased Intangibles |
$28,000,000 |
| Less: Amortization |
$(700,000) |
| Net Goodwill and Other Purchased Intangibles |
$27,300,000 |
| Total Assets |
$235,900,000 |
| LIABILITIES AND OWNERS’ EQUITY |
| Accounts Payable |
$22,000,000 |
| Accrued Advertising |
$11,800,000 |
| Other Liabilities and Accrued Expense |
$1,400,000 |
| Current Portion of Long-Term Debt |
$2,300,000 |
| Long Term Debt |
$57,400,000 |
| Preferred Stock, $100 par value per share, |
| 100,000 authorized, 0 shares issued and outstanding |
$0 |
| Common Stock, $1 par value per share, |
| 250,000,000 shares authorized, 13,000,000 shares |
| issued, 12,900,000 outstanding |
$13,000,000 |
| Additional Paid-in-Capital in excess of par value, Common Stock |
$117,000,000 |
| Treasury Stock |
$(1,000,000) |
|
| Retained Earnings (less Cash Dividends Paid) |
$12,000,000 |
$11,000,000 |
| Total Liabilities and Owner’s Equity |
$235,900,000 |
| December 31, 2009 |
December 31, 2008 |
| Sales Revenues |
$51,000,000 |
$10,300,000 |
| Less: Sales Returns |
$(1,000,000) |
$(300,000) |
| Net Sales Revenues |
$50,000,000 |
$10,000,000 |
| Less: Cost of Goods Sold |
$(9,000,000) |
$(4,000,000) |
| Gross Profit |
$41,000,000 |
$6,000,000 |
|
| Operating Expenses: |
| Advertising and Sales |
$(26,000,000) |
$(3,000,000) |
| Depreciation |
$(160,000) |
| Salaries and Wages |
$(1,700,000) |
$(1,400,000) |
| Product Development |
$(4,000,000) |
$(1,200,000) |
| Merger and Acquisition Related Costs, including |
| Amortization of Goodwill and Other Intangibles |
$(700,000) |
$0 |
| Total Operating Expenses |
$(32,560,000) |
|
| Income from Continuing Operations Before Income Taxes |
$8,440,000 |
| Less: Income Taxes at 35% |
$(2,954,000) |
| Income from Continuing Operations |
$5,486,000 |
|
| Discontinued Operations: |
| Income from Operations of Discontinued Division |
| (less applicable income taxes) |
$350,000 |
| Loss on Disposal of Discontinued Division |
| (less applicable income taxes) |
$(150,000) |
| Total Gain from Discontinued Operations |
$200,000 |
|
| Extraordinary Items: |
| Loss from fire (less applicable income taxes) |
$(200,000) |
|
| Net Income |
$5,486,000 |
|
| Divisional Revenues |
| Books |
$15,000,000 |
$7,000,000 |
| Online gaming |
$25,000,000 |
| Customized MP3/CD/DVD |
$10,000,000 |
$3,000,000 |
| Customized MP3/CD/DVD Inventory at end of 2009 |
$8,000,000 |
