Scribd Logo
Upload

Welcome to Scribd!

  • 77 views

    Proforma

    Uploaded by

    devanmade
    The document contains pro forma income statements and balance sheets for Red Queen Restaurants for 2012 and 2013. It shows increases in sales, costs of goods sold, operating expenses, taxes, dividends, and retained earnings from 2012 to 2013. The balance sheet shows increases in current assets, net fixed assets, and total assets, with current liabilities and total liabilities remaining steady and equity increasing. There is no need for external funds as the company has a surplus.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Proforma

    Uploaded by

    devanmade
    77 views4 pages
    The document contains pro forma income statements and balance sheets for Red Queen Restaurants for 2012 and 2013. It shows increases in sales, costs of goods sold, operating expenses, taxes, dividends, and retained earnings from 2012 to 2013. The balance sheet shows increases in current assets, net fixed assets, and total assets, with current liabilities and total liabilities remaining steady and equity increasing. There is no need for external funds as the company has a surplus.

    Original Description:

    excel investment

    Original Title

    proforma

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains pro forma income statements and balance sheets for Red Queen Restaurants for 2012 and 2013. It shows increases in sales, costs of goods sold, operating expenses, taxes, dividends, and retained earnings from 2012 to 2013. The balance sheet shows increases in current assets, net fixed assets, and total assets, with current liabilities and total liabilities remaining steady and equity increasing. There is no need for external funds as the company has a surplus.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    77 views4 pages

    Proforma

    Uploaded by

    devanmade
    The document contains pro forma income statements and balance sheets for Red Queen Restaurants for 2012 and 2013. It shows increases in sales, costs of goods sold, operating expenses, taxes, dividends, and retained earnings from 2012 to 2013. The balance sheet shows increases in current assets, net fixed assets, and total assets, with current liabilities and total liabilities remaining steady and equity increasing. There is no need for external funds as the company has a surplus.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    Pro Forma Income Statement

    Red Queen Restaurants


    FYE Dec 31, 2012 and 2013

    2012 Ratio 2013

    Sales 849,000 900,000


    Less: COGS 600,000 70.67% 636,042
    Gross Profits 249,000 263,958

    Less: Operating Expenses 100,000 11.78% 106,007


    Operating Profit 149,000 157,951

    Less: Taxes 59,600 40% tax rate 63,180


    Net Profit After Taxes 89,400 94,770

    Less: Cash Dividends 20,000 as stated in prob. 35,000


    To Retained Earnings 69,400 59,770

    Pro Forma Balance Sheet


    Red Queen Restaurants
    FYE Dec 31, 2012 and 2013

    2012 Ratio 2013

    Assets Liabilities and Stockholders' Eq

    Cash 32,000 30,000 Account Payable


    Marketable Securities 18,000 No Changes 18,000 Taxes Payable
    Account Receivable 150,000 18% of Annual Sales 162,000 Other Current Liabilities
    Inventories 100,000 11.78% 106,007
    Total Current Assets 300,000 316,007
    Long Term Debt
    Net Fixed Assets 350,000 375,000
    Total Assets 650,000 691,007
    Common Stock
    Retained Earnings

    External Funds Required

    Total Liabilities & Stockholders


    No, The company doesn't need external fund, because "negative external fund required" means that the company h
    The company generate more than enough money to finance its assets's growth
    The surplus fund can be used to reducing its liability, buyback their common stock or increasing their assets
    2012 Ratio 2013

    Liabilities and Stockholders' Equity

    Account Payable 100,000 11.78% 106,007


    Taxes Payable 20,000 25% of Tax 15,795
    Other Current Liabilities 5,000 No Changes 5,000
    Total Current Liabilities 125,000 126,802

    Long Term Debt 200,000 No Changes 200,000


    Total Liabilities 325,000 326,802

    Common Stock 150,000 No Changes 150,000


    Retained Earnings 175,000 234,770
    Total Equity 325,000 384,770

    External Funds Required (20,565)

    Total Liabilities & Stockholders' Equ 650,000 691,007


    ired" means that the company has surplus of fund.

    r increasing their assets

    You might also like