Radiation Shields 3 - Case - Radiation Shields 3 - Case.pdf

Template
    Radiation Shields, Inc.
    Pro-forma Financial Statements 2012
        Assumptions:
        Revenue Growth        20.00%
        Capex        5,000
    all numbers are in thousands
    Income Statement        2011    2012
     Sales Revenue        23,000
     Cost of Goods Sold        8,100
    Gross Margin        14,900
     Selling, General, and Administrative Expenses        10,450
     Depreciation        3,000
     R&D Expense        2,000
    Operating Income        (550)
     Interest Income        200
     Interest Expense        300
    Net Income        (650)
    Balance Sheet        12/31/11    12/31/12
    Cash        19,600
    Accounts Receivable        9,600
    Materials Inventory        900
    Prepaid Licensing Fee        250
    Total Cu
ent Assets        30,350
    Gross Value of Machinery        15,000
    less: Accumulated Depreciation        (3,000)
    Net Book Value        12,000
    Trademark        6,000
    Total Assets        48,350
    Accounts Payable        3,000
    Bank Loan        6,000
    Total Liabilities         9,000
    Common Stock        40,000
    Retained Earnings        (650)
     Total Stockholders' Equity        39,350
    Total Liabilities and Shareholders' Equity        48,350
    Cash Flow Statement        2011    2012
    Net Income        (650)
    Adjustments
     Depreciation        3,000
     Change in Accounts Receivable        (9,600)
     Change in Inventory        (900)
     Change in Prepaid Licensing Fee        (250)
     Change in Accounts Payable        3,000
    Cash provided (used) by operating activities        (5,400)
    Capital Expenditures        (15,000)
    Cash provided (used) by investing activities        (15,000)
    Proceeds from issuing common stock        34,000
    Bank Loan        6,000
    Cash Dividends        0
    Cash provided (used) by financing activities        40,000
    Total Cash Flow        19,600
    Beginning Balance Cash        0
    Ending Balance Cash        19,600
Low growth
    Radiation Shields, Inc.
    Pro-forma Financial Statements 2012
        Assumptions:
        Revenue Growth        20.00%
        Capex        5,000
    All numbers are in thousands
    Income Statement        2011    2012
     Sales Revenue        23,000    27,600
     Cost of Goods Sold        (8,100)    (9,720)
    Gross Margin        14,900    17,880
     Selling, General, and Administrative Expenses        (10,450)    (11,495)
     Depreciation        (3,000)    (4,000)
     R&D Expense        (2,000)    0
    Operating Income        (550)    2,385
     Interest Income        200    200
     ...