Question

In: Finance

Given the following Financial Information Answer the following question: 2017 2018 Cash 2,000 189,100 Accounts Receivable...

  1. Given the following Financial Information Answer the following question:

    2017 2018
    Cash 2,000 189,100
    Accounts Receivable 2,000 2,020
    Inventory 8,000 8,080
    Prepaid Assets 3,000 3,030
    Other Assets 4,000 4,040
    Total Current Assets 19,000 206,270
    Net PPE 20,000 4,000
    Intangibles 10,000 10,000
    Total Assets 49,000 220,270
    Accounts Payable 8,000 8,080
    Salary Payable 6,000 6,060
    Notes Payable 3,000 3,000
    Total Current Liabilities 17,000 17,140
    Long-Term Debt 40,000 40,000
    Total Liabilities 57,000 57,140
    Common Stock 80,000 80,000
    Retained Earnings -88,000 83,130
    total equity 8,000 163,130
    2018
    Sales 1,733,000
    COGS 1,299,750
    Gross Profit 433,250
    SG&A 23,000
    Other Operating Expenses 14,000
    Depreciation 2,000
    Interest 3,676
    Taxes 142,560
    Net Income 248,014
    dividends 76,884

    Calculate the Change in Net Operating Working Capital (NOWC)

    a. $187,130.00

    b. $187,270.00

    c. $-187,270.00

    d. $-187,130.00

Solutions

Expert Solution

Net Operating Working Capital is the difference between Operating Current Assets and Operating Current Liabilities.

NOWC = Operating Current Assets - Operating Current Liabilities

Operating current assets are the current assets which directly support the operating cycle of a company.They do not include marketable securities and other financial short term assets. Similarly, operating current liabilities include only the liabilities which are directly related to the operating process.

NOWC of 2017 = Cash + AR + Inventory + Prepaid Assets + Other Assets - AP - Salary Payable

=> 2,000 + 2,000 + 8,000 + 3,000 + 4,000 - 8,000 - 6,000=> 5,000

NOWC of 2018 = Cash + AR + Inventory + Prepaid Assets + Other Assets - AP - Salary Payable

=> 189,100 + 2,020 + 8,080 + 3,030 + 4,040 - 8,080 - 6,060=> 192,130

Change in Net Operating Working Capital = NOWC of 2018 - NOWC of 2017

=> 192,130 - 15,000

=> 187,130 (Option A)

Note : Other current assets is treated as an operating current asset as there is no specific info. Notes Payable is a financial current asset and is not directly related to the operating cycle. So, it is not included in the NOWC.


Related Solutions

The following data is given: December 31, 2018 2017 Cash $66,500 $49,500 Accounts receivable (net) 90,000...
The following data is given: December 31, 2018 2017 Cash $66,500 $49,500 Accounts receivable (net) 90,000 59,000 Inventories 90,000 105,000 Plant assets (net) 382,500 324,000 Accounts payable 55,500 39,500 Salaries and wages payable 12,000 5,500 Bonds payable 68,500 72,000 8% Preferred stock, $40 par 100,000 100,000 Common stock, $10 par 120,000 90,000 Paid-in capital in excess of par 75,000 70,000 Retained earnings 198,000 160,500 Net credit sales 995,000 Cost of goods sold 740,000 Net income 82,000 Compute the following ratios:...
Below are the financial statements of ABC Company 2018 2017 cash 120,000 44,000 accounts receivable 100,000...
Below are the financial statements of ABC Company 2018 2017 cash 120,000 44,000 accounts receivable 100,000 90,000 inventory 220,000 242,000 equipment 220,000 120,000 a/d equipment 80,000 60,000 land 820,000 1,020,000 total assets 1,340,000 1,396,000 accts payable 220,000 180,000 common stock 220,000 200,000 r/e 900,000 1,016,000 Income statement sales 420,000 cogs 180,000 oper expenses 80,000 depreciation exp 40,000 loss on sale land 100,000 income   100,000 Further information a) ABC sold some stock during the year b) ABC only had 1 transaction...
The 2017 financial statements of Lowell Company report total revenues of $2,000 million, accounts receivable of...
The 2017 financial statements of Lowell Company report total revenues of $2,000 million, accounts receivable of $100 million for 2016 and $110 million for 2017. The company's accounts receivable turnover for the year is: A. 16 days B. 19 times C. 19 days D. 16 times E. None of the above
The following information was taken from the financial statements of Lefton corporation: Accounts receivable 2018: $25,000...
The following information was taken from the financial statements of Lefton corporation: Accounts receivable 2018: $25,000 2017: $18,500 Inventory 2018: $33,000 2017; $46000 Fixed assets (net) 2018: $120,000 2017: $100,000 Accounts payable 2018: $65000 2017: $70,000 Net sales: 2018: $375,000 2017: $425,000 Cost of goods sold 2018: $150,000 2017: $200,000 Net income 2018: $56,000 2017:$40000 # shares issued 2018: 80,000 2017: 80,000 # shares in treasury stock 2018:10,000 2017:20,000 Calculate the following ratios for 2018: Fixed asset turnover Inventory turnover...
You are given the following information. Calculate Total Liabilities. Cash and equivalents is $85 accounts receivable...
You are given the following information. Calculate Total Liabilities. Cash and equivalents is $85 accounts receivable are $87 inventory is $66 net fixed assets is $199 accounts payable is $92 accruals are $99 notes payable are $81 long term debt is $82
Calculate the net impact on cash given the following information: decrease in accounts receivable= $30; decrease...
Calculate the net impact on cash given the following information: decrease in accounts receivable= $30; decrease in inventory= $45; net fixed asset Disposals= $75; decrease in accounts payable= $27; increase in notes payable= $30; increase in long-term debt= $105; decrease in retained earnings= $18; decrease in common stock= $600. a. $470 net addition to cash b. $120 net deduction from cash c. $360 net addition to cash d. $120 net addition to cash e. $360 net deduction from cash
2017 2018 Accounts payable 800 740 Accounts receivable, net 1,850 2,150 Accruals 70 160 Cash ???...
2017 2018 Accounts payable 800 740 Accounts receivable, net 1,850 2,150 Accruals 70 160 Cash ??? ??? Capital surplus 1,250 1,360 Common stock 1,020 1,210 Cost of goods sold 7,340 7,580 Depreciation expense 1,610 1,720 Interest expense 220 190 Inventory (end of year) 5,360 5,240 Long-term debt 6,310 6,450 Net fixed assets 8,240 9,120 Net sales 12,850 13,950 Notes payable 840 750 Operating expenses (excluding depreciation) 2,240 2,430 Retained earnings 8,300 8,460 Taxes 340 450 This company’s operating profit margin...
Everest Climbers reported the following information for 2016 and 2017: 2016 2017    Accounts receivable $50...
Everest Climbers reported the following information for 2016 and 2017: 2016 2017    Accounts receivable $50 000 $75 000 Inventories 43 000 30 000 Accounts payable 29 000 49 000 Total comprehensive income 270 000 Depreciation expense 11 000    If Everest Climbers uses the indirect method to prepare the operating activities section of the statement of cash flows, what amount will be reported as net cash inflow from operating activities for 2017? Can you explain in using both Direct...
Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000...
Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000 A/R 24,000 25,000 Inventory 79,000 78,000 Prepaid Insurance 5,000 4,000 Preoperty plant, & Equipment 35,000 30,000 Accumlated Depreciation (7,000) (5,000) Total Assets 151,000 146,000 Account Payable 6,000 9,000 Bonds Payable (mature in yr 2022 45,000 60,000 Common Stock 70,000 60,000 Retaind Earnings 30,000 17,000 Total Liabilities & Equity 151,000 146,000 Sunny Company had the following comparative balance sheet information for 2018, 2017: Sunny reported...
Auditing Cash, Financial Instruments, Sale, and Receivable Accounts: A summary of specific financial information gleaned from...
Auditing Cash, Financial Instruments, Sale, and Receivable Accounts: A summary of specific financial information gleaned from the current Form 10-K used to perform an analysis of work program steps. For example, if the team noted significant swings in the Receivables balance year-over-year, identify these swings and how you address them in your work program (this is in essence an audit procedure - analytical review). Company is Walmart
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT