BUSN460 Individual Financial Analysis Project complete solutions correct answers key

BUSN460 Individual Financial Analysis Project complete solutions correct answers key

Assumptions:

1. 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.
    
2. 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.
    
3. There is one warehouse for shipping of books and one plant for manufacturing.
    
4. 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.
    
5. The IPO took place at the beginning of 2009.
    
6. The CD/DVDs were customized beginning in 2008. The MP3 players were built beginning in the start of 2009.
    
7. The online gaming company was purchased for $30,000,000 and both Elizabeth and Andrew initiated the process.
    
8. 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.
    
9. It has some type of international operations, hence the need for a "translation gain or loss" in owner's equity.
    
10. It has an extraordinary loss from fire and a sale of a segment of its business in 2009.

Balance Sheet

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

Income Statement

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