Question

In: Finance

Create a mock balance sheet. Include numbers for each component (e.g. Current assets are 2,030, etc.)....

Create a mock balance sheet. Include numbers for each component (e.g. Current assets are 2,030, etc.). What areas within the balance sheet are involved networking capital? What is the formula for net working capital and the answer in your example?

Solutions

Expert Solution

XYZ Company

Balance Sheet as at December 31, 2018

Assets

Current assets

Cash

700,000.00

Marketable securities

1,300,000.00

Accounts receivable (net)

950,000.00

Inventories

850,000.00

Prepaid expenses

250,000.00

Total current assets

4,050,000.00

Long-term investments

2,000,000.00

Property, plant, and equipment (net)

4,680,000.00

Total assets

10,730,000.00

Liabilities

Current liabilities

Accounts Payables

1,000,000.00

Salaries Payable

2,000,000.00

Long-term liabilities

Mortgage note payable

500,000.00

Bonds payable

1,330,000.00

Total long-term liabilities

1,830,000.00

Total liabilities

4,830,000.00

Stockholders' Equity

Preferred Stock

750,000.00

Common stock,

850,000.00

Retained earnings

4,300,000.00

Total stockholders' equity

5,900,000.00

Total liabilities and stockholders' equity

10,730,000.00

Net Working Capital = Total Current Assets – Total Current Liabilities

= $4,050,000.00 – [ $10,00,000.00 + 20,00,000.00 ]

= $4,050,000.00 - $30,50,000.00

= $10,50,000.00

“ Net Working Capital = $10,50,000.00 “


Related Solutions

Create a mock balance sheet. Include numbers for each component (e.g. Current assets are 2,030, etc.)....
Create a mock balance sheet. Include numbers for each component (e.g. Current assets are 2,030, etc.). What areas within the balance sheet are involved networking capital? What is the formula for net working capital and the answer in your example?
Complete the following Balance Sheet           ASSETS           Current Assets           Cash    
Complete the following Balance Sheet           ASSETS           Current Assets           Cash                                                                                                   $   250,000           Accounts Receivable           ($_________ less allowance for Doubtful Accounts)                        $1,320,000           Inventory                                                                                             $1,410,000                       Total Current Assets                                                               $_________           Land                                                                                                    $_________           Plant & Equipment ($2,800,000 less                       Accumulated Depreciation ________)                                   $2,110,000           TOTAL ASSETS                                                                               $5,390,000 LIABILITIES AND STOCKHOLDERS EQUITY           Current Liabilities           Accounts Payable                                                                              $   620,000           Notes Payable to banks                                                                      $   130,000           Accrued Wages                                                                                 $________                            Total...
Please create a vertical and horizontal analysis of the following balance sheet. 2009 2010 Assets Current...
Please create a vertical and horizontal analysis of the following balance sheet. 2009 2010 Assets Current Asset Cash 3278 1844 Accounts Receivable 6954 11807 Inventory 17417 9628 Fixed Asset Plant & Equipment 144500 158700 Total Assets 172149 181979 Liabilities Current Liabilities Accounts Payables 9250 13446 Wages Payable 1110 650 Property & Tax Payables 3650 4124 Non-Current Liabilities Long-Term Debt 75800 92800 Owners' Equity 82339 70959 Total Liabilities 172149 181979
What are current assets? How are they shown on the balance sheet? What are non-current assets?...
What are current assets? How are they shown on the balance sheet? What are non-current assets? How are they shown on the balance sheet?
Balance the budget sheet: Current Assets: Total Current Assets: Property and equipment: Other assets: Total Assets:...
Balance the budget sheet: Current Assets: Total Current Assets: Property and equipment: Other assets: Total Assets: Current liabilities: Total Current Liabilities: Total Liabilities: Share holders equity Total Liabilities & Share holders Equity: Instructions: Please place the following items and amounts in their correct locations on the balance sheet Accounts payable $30,000 Accounts receivable $20,000 Investments $10,000 Common stock $10,000 Additional paid-in capital $20,000 Prepaid expense $4,000 Cash and cash equivalents $100,000 Deferred revenue $2,000 Notes payable $10,000 Inventory $15,000 Retained...
Typical balance sheet classifications are as follows.      Current Assets                          &nbsp
Typical balance sheet classifications are as follows.      Current Assets                                                                              g.     Long-Term Liabilities      Investments and Funds                                                              h.     Capital Stock      Property, Plant and Equipment                                                 i.      Additional Paid-In Capital      Intangible Assets                                                                         j.      Retained Earnings      Other Assets                                                                                 k.     Notes to Financial Statements      Current Liabilities                                                                        l.      Not Reported on Balance Sheet Indicate by use of the above letters how each of the following items would be classified on a balance sheet prepared at December 31, 2014. If a contra...
Following is the current balance sheet for a local partnership of doctors:Cash and current assets $...
Following is the current balance sheet for a local partnership of doctors:Cash and current assets $ 78,000 Liabilities $ 82,000 Land 242,000 A, capital 62,000 Building and equipment (net) 200,000 B, capital 82,000 C, capital 132,000 D, capital 162,000 Totals $ 520,000 Totals $ 520,000 The following questions represent independent situations: E is going to invest enough money in this partnership to receive a 25 percent interest. No goodwill or bonus is to be recorded. How much should E invest?...
The balance sheet for Bostick Corporation? follows: Ending balance Beginning balance ?Assets: Current? assets: Cash and...
The balance sheet for Bostick Corporation? follows: Ending balance Beginning balance ?Assets: Current? assets: Cash and cash equivalents $52,600 ?$44,600 Accounts receivable $18,300 ?$22,300 Inventory $48,500 ?$53,000 Total current assets $119,400 ?$119,900 ?Property, plant, and equipment ?$287,800 ?$275,300 Less accumulated depreciation $109,000 ?$101,550 Net? property, plant, and equipment $178,800 ?$173,750 Total assets $298,200 ?$293,650 Liabilities and? stockholders' equity: Current? liabilities: Accounts payable ?$26,030 ?$29,580 Wages payable ?$41,600 ?$47,100 Other accounts payable $42,200 ?$35,400 Notes payable ?$24,200 ?$25,200 Total current liabilities...
Following is the current balance sheet for a local partnership of doctors: Cash and current assets...
Following is the current balance sheet for a local partnership of doctors: Cash and current assets $ 78,000 Liabilities $ 70,000 Land 212,000 A, capital 50,000 Building and equipment (net) 170,000 B, capital 70,000 C, capital 120,000 D, capital 150,000 Totals $ 460,000 Totals $ 460,000 The following questions represent independent situations: E is going to invest enough money in this partnership to receive a 25 percent interest. No goodwill or bonus is to be recorded. How much should E...
Following is the current balance sheet for a local partnership of doctors: Cash and current assets...
Following is the current balance sheet for a local partnership of doctors: Cash and current assets $ 81,000 Liabilities $ 78,000 Land 236,000 A, capital 58,000 Building and equipment (net) 183,000 B, capital 78,000 C, capital 128,000 D, capital 158,000 Totals $ 500,000 Totals $ 500,000 The following questions represent independent situations: E is going to invest enough money in this partnership to receive a 20 percent interest. No goodwill or bonus is to be recorded. How much should E...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT