Calculate working capital for the data below Income Statement 40209 Revenues

Calculate working capital for the data below income

This preview shows page 110 - 125 out of 163 pages.

Calculate working capital for the data below. Income Statement $40,209 Revenues Sales $10,000 Less Cost of Goods Sold Beginning Inventory $0 Purchases $2,000 Ending inventory $1,500 $500 Gross profit $9,500 Operating Expenses Salaries $3,500 Office Lease $900 Telephone $96 Office supplies $167 Depreciation, Computer $54 Net income $4,783 12 Income Statement 1/31/2011 Revenues Sales $90,000 Beginning inventory $1,500 Purchases $25,000 An analysis of cash flow can help determine how a company uses its cash assets. Is it use The starting point of a cash flow analysis is a review of the income statement and balance
Image of page 110
Ending inventory $2,000 Less Cost of Goods Sold $24,500 Gross profit $65,500 Operating Expenses Salaries $42,000 Office Lease $10,800 Telephone $1,151 Office supplies $2,000 Depreciation, Computers $1,037 Gain on sale of office $5,000 Net income $13,512 13 Considering the above income statement and balance sheet: What was the value of the materials in inventory at the beginning of the period? 14 How much additional inventory was purchased during the year? 15 How mych inventory was used during the year? 16 Calculate the working capital for both month end periods. 17 What was the cash on hand at the end of Jan 2011?
Image of page 111
e Statement and the Balance Sheet?
Image of page 112
.
Image of page 113
below by calculating the daily balance from the beginn Credit Balance $ 29,344 $ 6,864 $ 3,194 $ 6,023 $ 8,474 $ 1,835 $ 6,440 $ 2,950 $ 2,761 $ 4,377 $ 3,116 data below by calculating the daily balance from the b Credit Balance $ 18,827 g., month) plus debits to the account less credits to
Image of page 114
$ 17,951 r the data below. Credit $ 1,144 =L179-M180 e allocated over 12 months and the Personal Compute $10,000 $10,000 $3,500 $900 $96 $166.67 $54.17
Image of page 115
$8,446 $4,717 $1,554 $5,283 Changes to Balance Sheet, 1/1 - 1/31 Assets $40,179 $40,209 Cash $9,000 $2,554 Accounts Receivable $8,000 Inventory $1,500 Office Supplies $1,833 Computer $1,950 Accumulated depreciation -$54 $9,000 $15,783 Liabilities and Owner's Equity Notes payable $2,000 Jean Marble, equity $9,000 $13,783 $9,000 $15,783 Working capital $9,000 $11,887 Changes to Balance Sheet, 1/31/10 - 1/31/11 Assets 1/31/2010 1/31/2011 Cash $2,554 $17,783 Accounts Receivable $8,000 $5,500 Inventory $1,500 $2,000 ed to acquire assets, meet liabilities, retire debt etc. e sheet.
Image of page 116
Office Supplies $1,833 $1,833 Computer $1,950 $1,950 Computer $2,320 Accumulated depreciation -$54 -$1,091 $15,783 $30,295 Liabilities and Owner's Equity Notes payable $2,000 $3,000 Jean Martin, equity $13,783 $27,295 $15,783 $492,315 Working capital $11,887 $24,116
Image of page 117
Image of page 118
Image of page 119
ning to the end of the month. beginning to the end of the month.
Image of page 120
er were depreciated (expense) over 3 years?
Image of page 121
Image of page 122
Image of page 123
1 What is statement analysis? 2 3 The following is a balace sheet displaying two year's data on a company. Common-size the report. P Calculate the Dollar Change and the Percent Change from 2012 to 2013. Place results in the Dollar C Common-sized 2013 2012 2013 2012 ASSETS Non-current assets 260,000 240,000 Goodwill 60,000 60,000 Intangible assets 120,000 100,000 440,000 400,000 Current assets Inventories 24,000 20,000 Trade receivables 50,000 60,000 16,000 20,000 90,000 100,000 TOTAL ASSETS 530,000 500,000 EQUITY AND LIABILITIES Equity Share capital 200,000 200,000 Retained earnings 100,000 80,000 Revaluation reserve 30,000 20,000 Total equity 330,000 300,000 Non-current liabilities What does it mean to common-size a report?
Image of page 124
Image of page 125

You've reached the end of your free preview.

Want to read all 163 pages?

  • Fall '15
  • Threesome

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes