Question

In: Accounting

Question 7 Use the following income statement and balance sheet information to put together a statement...

Question 7

Use the following income statement and balance sheet information to put together a statement of cash flows. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)

2017
Sales $1,242,000
Cost of goods sold $685,000
Gross profit $557,000
Gen'l & admin expense $156,000
Selling & mkt expense $135,000
Depreciation $24,000
Operating income $242,000
Interest $140,000
Income before taxes $102,000
Income taxes (27%) $27,540
Net income $74,460
Dividends paid $25,000
Assets 2017 2016
Cash $24,000 $10,840
Accounts receivable $123,000 $112,000
Inventory $201,000 $217,000
Total current assets $348,000 $339,840
Gross plant and equipment $700,000 $475,000
Less: accum. depreciation $313,000 $289,000
Net plant and equipment $387,000 $186,000
Total assets $735,000 $525,840
Liabilities
Accounts payable $118,000 $104,000
Notes payable $29,000 $29,000
Total current liabilities $147,000 $133,000
Long-term debt $248,000 $153,000
Total liabilities $395,000 $286,000
Common stock ($0.01 par) $4,500 $4,000
Paid-in capital $219,500 $169,300
Retained earnings $116,000 $66,540
Total stockholders' equity $340,000 $239,840
Total liabilities and equity $735,000 $525,840

Statement of Cash Flows
2017

Net Change in CashFinancing ActivitiesCash from FinancingOperating ActivitiesCash from OperationsInvesting ActivitiesCash from Investment

Increase in Accounts ReceivableDecrease in Accounts ReceivableIncrease in InventoriesNet Income/LossDecrease in InventoriesIncrease in Accounts PayableDecrease in Accounts PayablePurchase of Fixed AssetsDepreciationDividends PaidSale of Fixed AssetsIssuance of Common StockIssuance of Long-term debt

$

Decrease in InventoriesIncrease in InventoriesDividends PaidDecrease in Accounts PayableIssuance of Common StockSale of Fixed AssetsIssuance of Long-term debtNet Income/LossDepreciationPurchase of Fixed AssetsIncrease in Accounts ReceivableIncrease in Accounts PayableDecrease in Accounts Receivable

Purchase of Fixed AssetsIssuance of Long-term debtIncrease in InventoriesNet Income/LossSale of Fixed AssetsDepreciationDividends PaidIncrease in Accounts PayableDecrease in Accounts PayableIssuance of Common StockIncrease in Accounts ReceivableDecrease in Accounts ReceivableDecrease in Inventories

Decrease in Accounts PayableSale of Fixed AssetsDepreciationPurchase of Fixed AssetsDividends PaidIssuance of Common StockIssuance of Long-term debtNet Income/LossIncrease in Accounts ReceivableDecrease in Accounts ReceivableIncrease in InventoriesDecrease in InventoriesIncrease in Accounts Payable

Issuance of Common StockDecrease in Accounts ReceivableDepreciationDividends PaidIncrease in Accounts ReceivableNet Income/LossDecrease in Accounts PayableIncrease in Accounts PayableDecrease in InventoriesIncrease in InventoriesPurchase of Fixed AssetsSale of Fixed AssetsIssuance of Long-term debt

Cash from FinancingInvesting ActivitiesFinancing ActivitiesCash from InvestmentNet Change in CashOperating ActivitiesCash from Operations

Net Change in CashCash from FinancingFinancing ActivitiesOperating ActivitiesCash from OperationsInvesting ActivitiesCash from Investment

Increase in Accounts PayableDecrease in InventoriesIssuance of Long-term debtIncrease in InventoriesDecrease in Accounts PayableNet Income/LossDepreciationPurchase of Fixed AssetsDividends PaidSale of Fixed AssetsIncrease in Accounts ReceivableIssuance of Common StockDecrease in Accounts Receivable

Cash from OperationsInvesting ActivitiesCash from InvestmentFinancing ActivitiesNet Change in CashCash from FinancingOperating Activities

Investing ActivitiesCash from InvestmentCash from FinancingCash from OperationsFinancing ActivitiesNet Change in CashOperating Activities

Sale of Fixed AssetsDecrease in Accounts ReceivableNet Income/LossPurchase of Fixed AssetsDividends PaidIncrease in Accounts ReceivableDecrease in InventoriesIssuance of Common StockIncrease in InventoriesIncrease in Accounts PayableIssuance of Long-term debtDecrease in Accounts PayableDepreciation

Decrease in Accounts PayableIssuance of Long-term debtDecrease in Accounts ReceivableDecrease in InventoriesDepreciationDividends PaidPurchase of Fixed AssetsSale of Fixed AssetsIssuance of Common StockIncrease in InventoriesNet Income/LossIncrease in Accounts PayableIncrease in Accounts Receivable

Increase in Accounts ReceivableIncrease in InventoriesDividends PaidDecrease in InventoriesDecrease in Accounts ReceivableNet Income/LossIssuance of Common StockIssuance of Long-term debtDepreciationIncrease in Accounts PayableDecrease in Accounts PayablePurchase of Fixed AssetsSale of Fixed Assets

Financing ActivitiesCash from InvestmentCash from FinancingCash from OperationsOperating ActivitiesNet Change in CashInvesting Activities

Investing ActivitiesFinancing ActivitiesCash from FinancingOperating ActivitiesCash from InvestmentNet Change in CashCash from Operations

Solutions

Expert Solution


Related Solutions

Multistep income statement and balance sheet LO 7-1, 7-5 Use the following information to prepare a...
Multistep income statement and balance sheet LO 7-1, 7-5 Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 70,000 Operating Expenses $ 63,000 Common Stock 100,000 Cash Flow from Investing Activities 79,400 Notes...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE TAX RATE IS 40%. (COMMON EQUITY IS A PLUG IN NUMBER) ITEM 2010 2011 SALES 10,000 12,000 DEPRECIATION 3,000 3,000 COST OF GOODS SOLD 2,000 2,000 OTHER EXPENSES 3,000 4,000 INTEREST 1,000 1,000 CASH 1,000 1,000 ACCOUNTS RECEIVABLE 3,000 3,000 S.T. NOTES PAYABLE 1,000 1,000 L.T. DEBT 10,000 11,000 NET FIXED ASSETS 20,000 20,000 ACCOUNTS PAYABLE 2,000 2,000 INVENTORY 3,000 3,000 DIVIDENDS 600 600...
Required Use the following information to prepare a multistep income statement and a classified balance sheet...
Required Use the following information to prepare a multistep income statement and a classified balance sheet for Eller Equipment Co. for Year 1. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) Salaries expense $ 122,000 Beginning retained earnings $ 61,100 Common stock 110,000 Warranties payable (short term) 6,500 Notes receivable (short term) 32,500 Gain on sale of equipment 19,000 Allowance for doubtful accounts 19,000 Operating expenses 65,000 Accumulated depreciation 66,000...
Required Use the following information to prepare a multistep income statement and a classified balance sheet...
Required Use the following information to prepare a multistep income statement and a classified balance sheet for Eller Equipment Co. for Year 1. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) Salaries expense $ 103,000 Beginning retained earnings $ 42,100 Common stock 91,000 Warranties payable (short term) 4,600 Notes receivable (short term) 13,500 Gain on sale of equipment 8,000 Allowance for doubtful accounts 15,000 Operating expenses 46,000 Accumulated depreciation 47,000...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 84,000 Operating Expenses $ 77,000 Common Stock 100,000 Cash Flow from Investing Activities 93,400 Notes Receivable (short term) 39,000 Prepaid Rent 14,000 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 79,000 Operating Expenses $ 72,000 Common Stock 100,000 Cash Flow from Investing Activities 88,400 Notes Receivable (short term) 34,000 Prepaid Rent 13,500 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 75,000 Operating Expenses $ 68,000 Common Stock 100,000 Cash Flow from Investing Activities 84,400 Notes Receivable (short term) 30,000 Prepaid Rent 13,100 Allowance for...
QUESTION 5: A. Income statement and balance sheet From the following financial information of XYZ Ltd,...
QUESTION 5: A. Income statement and balance sheet From the following financial information of XYZ Ltd, for the year ended December 31, 2017. Prepare Income statement and Balance sheet. Particulars Amount $ Cash 31,000 Accounts Receivable 9,000 Equipment 90,000 Accumulated Depreciation 10,000 Accounts Payable 8,000 Bank Loan(Long term liability) 1,12,000 Sales 65,600 Cost of Goods sold 34,000 Advertising expense 10,000 Fuel expense 4,000 Interest expense 10,000 Income tax expense 2,400 Inventory 200,000 Share Capital 130,000 Short Term Liability 70,000 B....
Using the information below to answer question (a) to (e). The balance sheet and income statement...
Using the information below to answer question (a) to (e). The balance sheet and income statement shown below are for Rebel Inc. Note that the firm has no amortization charges and it does not lease any assets. Its tax rate is 35%. Balance Sheet (Millions of $) 2014 2013 Assets Cash and securities $2,500 $2,000 Accounts receivable 11,500 $11,000 Inventories 16,000 15,500 Total current assets $30,000 $28,500 Net plant and equipment $20,000 $19,500 Total assets $50,000 $48,000 Liabilities and Equity...
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 &...
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 & 2012. Also include a 40% tax rate expense on your pretax income. 2011 2012 Sales $4,203 $4,507 Cost of Goods Sold 2,422 2,633 Depreciation 785 952 Interest 180 196 Dividends 225 250 Current Assets 2,205 2,429 Net fixed Assets 7,344 7,650 Current Liabilities 1,003 1,255 Long-Term debt 3,106 2,085
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT