Question

In: Finance

Finance question Given this ABC Co's. Balance Sheet at 31/12/2018 Assets Liabilities Cash 65000 Account payable...

Finance question

Given this ABC Co's. Balance Sheet at 31/12/2018

Assets

Liabilities

Cash

65000

Account payable

Mar/sec

30000

Notes payable

8000

Acc/rec

180000

Interest payable

4800

inventory

accurals

4200

Total C/A

Total C/L

Gross fixed assets

Long term debt

Less Acc/Dep

25000

common stock

115000

Net fixed assets

Retaine earning

125000

Total assets

Total liabilities and eq

Another data were provided about the company during 2018

Sales = $1,840,00.0 ; Gross profit margin = 30.0%; Inventory Turn-Over = 8.0 times; Current Ratio - 5.0; Total Asset Turn-Over = 2.0; Total Debt ratio = 73.91%; Purchases = 60.0% of sales;(Use 360 days/year).

hint: use the debt ratio in your calculations

Find

1- ABC. Inventories?

2 -ABC Net Fixed Assets?

3 - ABC APP average Payment Period)and COM (Average Age of Inventory) ?

4- ABC Total Current Liabilities and COM Total Current Assets?

Solutions

Expert Solution

1.Calculation of ABC. Inventories

Cost of goods sold=Sale-Gross profit

= $1,840,000-( $1,840,000*30%)

=$1840,000-$552,000

=$1288,000

Inventory Turnover=Cost og goods sold/Average inventory

Average inventory=Cost og goods sold/Inventory Turnover

=$1288000/8 times

=$161,000

we know that average inventory is;

=(Opening Inventory+closing Inventory)/2

In the given question nothing is given about opening inventory,hence it is assumed that average inventory is equal to closing inventory.

Accordingly,ABC. Inventories is $161000

2.ABC Net Fixed Assets

Total Assets turnover=Net Sales/Total assets

therefore,

Total Assets=Net Sales/Total Assets turnover

=$1840000/2

=$920,000

Total Assets=Fixed assets+Current asset

Fixed assets=Total Assets-Current asset

=$920,000-(65,000+30,000+180,000+161,000)

=$920,000-$436,000

=$484,000

Therefore,ABC Net Fixed Assets is $484,000

3.Calculation of ABC APP

For calculating APP,firstly we have to calculate the amount of Accounts Payable

Current ratio=Current Assets/current liablities

Thus,

current liablities=Current Assets/Current ratio

=$436,000/5

=$87,200

Now,

Accounts Payable=Total current liablities-Notes payable-interest payable-accurals

=$87,200-$8000-$4800-$4200

=$70200

APP=Accounts payable/(Total credit purchase/days in a period)

Nothing is given about the credit purchase,hence it is assumed that all purchases are mede in credit.

Total credit purchase=$1840,000*60%

=$1104,000

APP=$70200/($1104,000/360 days)

=$70200/3066.67

=22.89 days

Thus ABC APP is 22.89 days.

Average Age of Inventory=(Inventory/Cost of goods sold)*360 days

=($161000/$1288,000)*360 days

=45 days

Average Age of Inventory is 45 days

4.Total current Assets(already calculated in question 2)

=$436,000

Total current liablities(already calculated in question 3)

=$87,200


Related Solutions

ABC Corp. Balance Sheet As of December 31, 2018 Assets Liability Cash $6,000 Accounts Payable $3,000...
ABC Corp. Balance Sheet As of December 31, 2018 Assets Liability Cash $6,000 Accounts Payable $3,000 Accounts Receivable $4,000 Stockholders' Equity Common Stock $3,000 Retained Earnings $4,000 Total Liability and Stockholders' Equity Total Assets $10,000 $10,000 1. On January 1st, 2019, ABC Corp bought an equipment for $2,000. The equipment has a useful life of 5 years and has a salvage value of $500. The company uses double-declining depreciation method. 2. On March 1 st, 2019, ABC Corp received $2,400...
ABC Corp. Balance Sheet As of December 31, 2018 Assets Liability Cash $6,000 Accounts Payable $3,000...
ABC Corp. Balance Sheet As of December 31, 2018 Assets Liability Cash $6,000 Accounts Payable $3,000 Accounts Receivable $4,000 Stockholders' Equity Common Stock $3,000 Retained Earnings $4,000 Total Liability and Stockholders' Equity Total Assets $10,000 $10,000 On January 1st, 2019, ABC Corp bought an equipment for $2,000. The equipment has a useful life of 5 years and has a salvage value of $500. On May 1st, 2018, ABC Corp received $1,200 cash for services to be performed in the future....
CABOT CORPORATION Balance Sheet December 31 Assets Liabilities and Equity Cash $ 12,000 Accounts payable $...
CABOT CORPORATION Balance Sheet December 31 Assets Liabilities and Equity Cash $ 12,000 Accounts payable $ 16,500 Short-term investments 9,600 Accrued wages payable 3,800 Accounts receivable, net 32,800 Income taxes payable 3,900 Merchandise inventory 38,150 Long-term note payable, secured by mortgage on plant assets 70,400 Prepaid expenses 2,550 Common stock 89,000 Plant assets, net 150,300 Retained earnings 61,800 Total assets $ 245,400 Total liabilities and equity $ 245,400 Required: Compute the following: (1) current ratio, (2) acid-test ratio, (3) days'...
T. P. Jarmon Company Balance Sheet for 12/31/2017 and 12/31/2018 Assets 2017 2018 Cash $15,000 $14,000...
T. P. Jarmon Company Balance Sheet for 12/31/2017 and 12/31/2018 Assets 2017 2018 Cash $15,000 $14,000 Marketable securities 6,000 6,200 Accounts receivable 42,000 33,000 Inventory 51,000 84,000 Prepaid rent 1,200 1,100 Total current assets $115,200 $138,300 Net plant and equipment $286,000 $270,000 Total assets $401,200 $408,300 Liabilities and Equity 2017 2018 Accounts payable $48,000 $57,000 Accruals 6,000 5,000 Notes payable 15,000 13,000 Total current liabilities $69,000 $75,000 Long-term debt $160,000 $150,000 Common stockholders' equity $172,200 $183,300 Total liabilities and equity...
12/31/17 Balance Sheet Cash $17,000                                     Account
12/31/17 Balance Sheet Cash $17,000                                     Accounts Receivable                           $12,000                                     Prepaid Insurance                                $5,000                                     Inventory                                             $15,000 Total $49,000                                     Equipment                                           $100,000                                     Accumulated Depreciation                  $(20,000) Total $80,000                                     Total Assets                                        $129,000                                     Accounts Payable                                $9,000                                     Income Taxes Payable $3,000                                     Total Liabilities                                    $12,000                                     Common Stock                                   $100,000                                     Retained Earnings                               $17,000                                     Total Equity                                         $117,000                                     Total Liabilities & Equity                    $129,000 Additional Information: Sales for 2018 are expected to be $200,000. Accounts Receivable turnover is expected to be 12...
A firm has the following balance sheet: Assets Liabilities and Equity Cash $ 5,000 Accounts payable...
A firm has the following balance sheet: Assets Liabilities and Equity Cash $ 5,000 Accounts payable $ 5,000 Accounts receivable 153,000 Long-term debt 109,000 Inventory 89,000 Common stock ($8 par; 32,000 4,000 shares outstanding) Plant and equipment 190,000 Additional paid-in capital 148,000 Retained earnings 143,000 $437,000 $437,000 Construct a new balance sheet showing the impact of a four-for-one split. If the current market price of the stock is $55, what is the price after the split? Round the par value...
A firm has the following balance sheet: Assets Liabilities and Equity Cash $ 5,000 Accounts payable...
A firm has the following balance sheet: Assets Liabilities and Equity Cash $ 5,000 Accounts payable $ 5,000 Accounts receivable 158,000 Long-term debt 111,000 Inventory 72,500 Common stock ($9 par; 31,500 3,500 shares outstanding) Plant and equipment 210,000 Additional paid-in capital 150,000 Retained earnings 148,000 $445,500 $445,500 A. Construct a new balance sheet showing the impact of a three-for-one split. If the current market price of the stock is $56, what is the price after the split? Round the par...
A comparative balance sheet for Harrison Co. appear below: Assets 12/31/2019 12/31/2018 Cash $34,000 $11,000 Accounts...
A comparative balance sheet for Harrison Co. appear below: Assets 12/31/2019 12/31/2018 Cash $34,000 $11,000 Accounts receivable 18,000 13,000 Inventory 25,000 17,000 Prepaid expenses 6,000 9,000 Long-term investments -0- 17,000 Equipment 60,000 33,000 Accumulated depreciation-equipment (20,000) (15,000) Total assets $123,000 $85,000 Liabilities and Stockholders' Equity Accounts payable $17,000 $7,000 Bonds payable 36,000 45,000 Common stock 40,000 23,000 Retained earnings 30,000 10,000 Total liabilities and equity $123,000 $85,000 Additional information: Net income for the year ending December 31, 2019 was $35,000....
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $...
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $ 4,320 Receivables 6,480 Accruals 2,880 Inventories 9,000 Line of credit 0    Total current assets $16,560 Notes payable 2,100 Net fixed assets 12,600    Total current liabilities $ 9,300 Mortgage bonds 3,500 Common stock 3,500 Retained earnings 12,860    Total assets $29,160    Total liabilities and equity $29,160 Income Statement for January 1 - December 31, 2018 (Thousands of Dollars) Sales $36,000 Operating costs 32,440    Earnings before interest...
Balance Sheet (in $ millions) Assets Liabilities and Stockholders' Equity Cash  ......................................    $ 7 Accounts payable ............$20 Accounts...
Balance Sheet (in $ millions) Assets Liabilities and Stockholders' Equity Cash  ......................................    $ 7 Accounts payable ............$20 Accounts receivable ............    25 Accrued wages .................7 Inventory  ..............................         28 Accrued taxes .................. 13 Current assets ...................    $80 Current liabilities .......... $40 Fixed assets .........................       25 Notes payable ..................15 Common stock .................20   Retained earnings ............ 30 Total Assets ...........................$105 Total liabilities and stockholders’ equity .......$105 If the firm’s sales for last year were $100 million, and the balance sheet at year-end is similar in percentage of sales to that of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT