Calculate the missing numbers from the table below:
2011 |
2012 |
|
Opening Cash Balance |
? |
? |
Cash Flow from Operating Activity |
$500 |
$1,000 |
Cash Flow from Investing Activity |
(1,000) |
500 |
Cash Flow from Financing Activity |
(300) |
(600) |
Ending Cash Balance |
25,000 |
? |
Can someone help with this question, for the Financial Statement Analysis course?
Calculation of opening cash balance of 2011:
Ending cash balance= opening cash balance+ cash flow from operating activities+cash flow from investing activities+ cash flow from financing activities
25000= opening cash balance+500-1000-300
Opening cash balance for 2011= $25800
Calculation of opening cash balance for 2012:
Closing balance of 2011= opening balance for 2012
So opening cash balance for 2012= $25000
Calculation of closing cash balance for 2012:
Closing cash balance= opening cash balance+ cash flow from operating activities+ cash flow from investing activities+cash flow from financing activities
Closing cash balance= 25000+1000+500-600= 25900
Closing cash balance for 2012= $25900
Calculate the missing numbers from the table below: 2011 2012 Opening Cash Balance ? ? Cash...
Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2011 2012 Cash 300 400 Accounts receivable 1,000 1,400 Inventories 3,200 3,000 Current assets 4,500 4,800 Net fixed assets 3,800 4,300 Total assets 8,300 9,100 Notes payable 400 300 Accounts payable 700 500 Accruals 50 80 Current portion of long-term debt 70 80 Current liabilities 1,220 960...
Momber's Flooring Company 2011 2012 800 Cash 500 Accounts receivable 1,400 1,200 Inventory 3,900 4,400 Net fixed assets 8,200 8,200 Land 1,000 2,000 Total Assets 15,000 16,600 600 500 Notes payable 1,000 Accounts payable 3,000 2,000 Accruals 900 Long-term debt 3,600 5,400 Common Stock 2,500 2,200 Retained earnings 4,400 5,500 Total Liabilities and Equity 15,000 16,600 Given the Balance Sheets for Momber's Flooring Company above for the years ending December 31, 2011 and 2012, find Net Cash Flow from Financing...
Momber's Flooring Company 2011 2012 Cash 500 800 Accounts receivable 1,400 1,200 Inventory 3,900 4,400 Net fixed assets 8,200 8,200 Land 1,000 2,000 Total Assets 15,000 16,600 Notes payable 1,000 600 Accounts payable 3,000 2,000 Accruals 500 900 Long-term debt 3,600 5,400 Common Stock 2,500 2,200 Retained earnings 4,400 5,500 Total Liabilities and Equity ...
Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2011 2012 Cash 300 400 Accounts receivable 1,000 1,400 Inventories 3,200 3,000 Current assets 4,500 4,800 Net fixed assets 3,800 4,300 Total assets 8,300 9,100 Notes payable 400 300 Accounts payable 700 500 Accruals 50 80 Current portion of long-term debt 70 80 Current liabilities 1,220 960...
Thompson, Inc. Balance Sheets For the years ending December 31, 2011 and 2012) 2012 300 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets 2011 800 3,700 8,400 12,900 34,500 47,400 3,000 10,200 13,500 42,600 56,100 Notes payable Accounts payable Accruals Current liabilities Long-term debt Common stock Capital surplus Retained earnings Total liabilities and equity 1,000 600 1,600 10,700 6,000 18,900 10,200 47,400 1,600 800 700 3,100 10,000 8,000 24,100 10,900 56,100 In its 2011 income statement, Thompson...
Jeffersonson, Inc. Balance Sheets For the years ending December 31, 2011 and 2012) 2012 500 Cash Accounts receivable Inventory Current assets Net fixed assets Land Total assets 2011 500 2,800 9,300 12,600 48,200 11,600 72,400 2,400 9,900 12,800 61,400 12,900 87,100 1,000 1,700 Notes payable Accounts payable Accruals Current portion of LT Debt Current liabilities Long-term debt Common stock Additional paid in capital Retained earnings Total liabilities and equity 1,200 1,900 100 3,200 6,400 12,600 21,000 18,400 14,000 72,400 4,200...
Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2011 2012 Cash 300 400 Accounts receivable 1,000 1,400 Inventories 3,200 3,000 Current assets 4,500 4,800 Net fixed assets 3,800 4,300 Total assets 8,300 9,100 Notes payable 400 300 Accounts payable 700 500 Accruals 50 80 Current portion of long-term debt 70 80 Current liabilities 1,220 960...
Momber's Flooring Company 2011 2012 Cash 500 800 Accounts receivable 1,400 1,200 Inventory 3,900 4,400 Net fixed assets 8,200 8,200 Land 1,000 2,000 Total Assets 15,000 16,600 Notes payable 1,000 600 Accounts payable 3,000 2,000 Accruals 500 900 Long-term debt 3,600 5,400 Common Stock 2,500 2,200 Retained earnings 4,400 5,500 Total Liabilities and Equity ...
2011 2012 Cash 300 400 Accounts receivable 1,000 1,400 Inventories 3,200 3,000 Current assets 4,500 4,800 Net fixed assets 3,800 Total assets 4,300 9,100 8,300 Notes payable 300 Accounts payable 500 Accruals Current portion of long- term debt Current liabilities 1,220 Long-term debt 4,300 Common stock ($.20 par) 1,200 Additional paid-in capital 680 Retained earnings Total liabilities and equity 8,300 Het income as reported on the 2012 Income statement) - 528 960 4,900 1,300 740 1,200 900 9,100 Depreciation as...
Balance sheet at December 31 2011 2010 Cash Accounts receivable Merchandise inventory Property and equipment $84,000 $69,000 68,000 21,000 121,000 100,000 55,000 31,000 Less: Accumulated depreciation (60,000) (45,000) $231,000 $213,000 $15,000 $37,000 11,000 95,000 45,000 25,000 Accounts payable Wages payable Note payable, long-term Contributed capital Retained earnings 1,000 100,000 50,000 65,000 FROM FI $231,000 $213,000 There were no sales of equipment during 2011. Net income for 2011 was $55,000. There were dividends declared and paid during the year. There were...