Scribd Logo
Upload

Welcome to Scribd!

  • 42 views

    Aamir Ali Bba Viii A

    Uploaded by

    aamir ali
    The document shows a pro forma cash budget and income statement for a company from June to October 2013, which projects the company's beginning and ending cash balances, expected cash inflows and outflows, sales, expenses, income, and dividends over that time period. It also includes a pro forma balance sheet projecting the company's assets, liabilities, and equity from June to September 2013. The documents provide projected financial information to evaluate the company's expected cash flows, profits, and financial position over the next few months.

    Copyright:

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

    Aamir Ali Bba Viii A

    Uploaded by

    aamir ali
    42 views9 pages
    The document shows a pro forma cash budget and income statement for a company from June to October 2013, which projects the company's beginning and ending cash balances, expected cash inflows and outflows, sales, expenses, income, and dividends over that time period. It also includes a pro forma balance sheet projecting the company's assets, liabilities, and equity from June to September 2013. The documents provide projected financial information to evaluate the company's expected cash flows, profits, and financial position over the next few months.

    Original Description:

    solution excell

    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 shows a pro forma cash budget and income statement for a company from June to October 2013, which projects the company's beginning and ending cash balances, expected cash inflows and outflows, sales, expenses, income, and dividends over that time period. It also includes a pro forma balance sheet projecting the company's assets, liabilities, and equity from June to September 2013. The documents provide projected financial information to evaluate the company's expected cash flows, profits, and financial position over the next few months.

    Copyright:

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

    Aamir Ali Bba Viii A

    Uploaded by

    aamir ali
    The document shows a pro forma cash budget and income statement for a company from June to October 2013, which projects the company's beginning and ending cash balances, expected cash inflows and outflows, sales, expenses, income, and dividends over that time period. It also includes a pro forma balance sheet projecting the company's assets, liabilities, and equity from June to September 2013. The documents provide projected financial information to evaluate the company's expected cash flows, profits, and financial position over the next few months.

    Copyright:

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

    Exhibit TN-2 Pro Forma Cash Budget, June to October 2013 (thousands of dollars)

    Beginning Cash Balance

    Cash Receipts
    Collections of accounts receivable
    Interest income
    Bank loan
    Total cash inflow

    Cash Disbursements
    Payments of accounts payable
    Operating expenses
    Capital expenditure
    Tax payments
    Interest payments
    Principal payments
    Dividend payments
    Total cash outflow

    Net cash inflow (outflow)


    Ending Cash Balance
    June July August September October october sales
    4,994 1,312 5,852 5,305 (2,332)

    3,744 10,779 5,678 7,201


    10 12 13 14
    - 2,400 - -
    3,754 13,191 5,691 7,215 0

    5,969 5,200 5,200 5,200


    750 750 750 750
    - 2,400 - -
    680 264 250 265
    37 37 37 37
    - - - 7,400
    - - - 1,200
    7,436 8,651 6,237 14,852 0

    (3,682) 4,540 (546) (7,637) 0


    1,312 5,852 5,305 (2,332) (2,332)
    7,764
    Column1 Column2 Column3 Column4 Column5 Column6
    orma Income Statements, June to October 2013 (thousands of dollars)

    Four Months
    June July August September
    Total
    Net sales 12,681 7,374 7,201 7,394 34,650
    COGS a
    9,764 5,678 5,545 5,693 26,681
    Gross profit 2,917 1,696 1,656 1,701 7,970

    Operating expenses 750 750 750 750 3,000


    Depreciation and amortization 120 120 120 120 480
    Interest expenseb 37 37 37 37 148
    Interest income c
    10 12 13 14 49
    Profit (loss) before tax 2,000 777 736 780 4,293
    Income taxesd 680 264 250 265 1,459
    Net income 1,320 513 486 515 2,833
    Dividends
    interest expense
    loan 5000000 25000
    2400000 12000
    37000
    Column1 Column2 Column3 Column4 Column5
    orma Balance Sheets, June to October 2013 (thousands of dollars)

    June July August September


    Cash 4,994 10,779 5,648 (199)
    Accounts receivable a
    10,779 5,678 7,201 7,394
    Inventory 7,123 5,080 5,110 5,120
    Current assets 22,896 21,537 17,959 12,315

    Gross PP&E 45,500 47,900 47,900 47,900


    Accumulated depreciation b
    31,568 31,688 31,808 31,928
    Net PP&E 13,932 16,212 16,092 15,972
    Prepaid expenses 54 54 54 54
    Total assets 36,882 37,803 34,105 28,341

    Accounts payablec 5,200 5,200 5,200 5,200


    Notes payable, bank 5,000 5,000 5,000 5,000
    Accrued taxesd 341 427 533 667
    Other accrued expenses 1,142 1,142 1,142 1,142
    Customer advance payments 900
    Current liabilities 12,583 11,769 11,875 12,009

    Shareholders' equity 24,299 26,034 22,230 16,332


    Total liabilities and equity 36,882 37,803 34,105 28,341
    Column6

    Notes
    cash balance of May 31 2013
    80 percent of sales. Becouse 30 percent has paid advance
    WIP has decreased from 5040

    purchased other equipement of 2.4 million

    Unchanged

    273 of May acrued tax is increases with 25 percent each month


    Unchanged
    Column1 Column2 Column3 Column4 Column5 Column6
    and Uses of Funds, August 31, 2012 to May 31, 2013 (thousands of dollars)

    Sources of Funds
    Increase in bank debt
    Decrease in cash
    Decrease in accounts receivable
    Increase in retained earnings
    Decrease in net fixed assets
    Increase in customer advances
    Increase in accounts payable
    Decrease in prepaid expenses
    Increase in taxes payable
    Total Sources of Funds 0

    Uses of Funds
    Stock repurchase
    Inventories
    Decrease in accruals
    Total Uses of Funds 0
    Column7 Column8

    You might also like