Question

In: Accounting

Phillipe Corporation 2015 Income Statement In Millions of Dolars Sales 4053 Cost of Goods Sold 2780...

Phillipe Corporation 2015 Income Statement In Millions of Dolars Sales 4053 Cost of Goods Sold 2780 Depreciation 550 Earnings Before Interest and Taxes 723 Interest Paid 502 Taxable Income 221 Taxes (34%) 75 Net Income 146 Dividends 47 Addition to Retained Earnings 99 Philippe Corporation 2014 and 2015 Balance Sheets In Millions of Dollars 2014 2015 Assets Current Assets Cash 210 215 Accounts Receivable 355 310 Inventory 507 328 Total 1072 853 Fixed Assets Net Plant and Equipment 6085 6527 Total Assets 7157 7380 Liabilities and Owners Equity Current Liabilities Accounts Payable 207 298 Notes Payable 1715 1427 Total 1922 1725 Long Term Debt 1987 2308 Owners Equity Common Stock 1000 1000 Retained Earnings 2248 2347 Total 3248 3347 Total Liabilities and Owners Equity 7157 7380

1. Current and Quick Ratios  If a firm increases its quick ratio but the current ratio does not change, what has happened?  Has the liquidity of the company improved?

2. Ratios and Firm Health  Explain whether an increase in each of the following ratios means the firm is doing better or worse and why:  times interest earned, inventory turnover, days sales in receivables, total asset turnover, profit margin, return on assets.

Solutions

Expert Solution

2014 Calculation 2015 Calculation
Current Ratio(Current Assets / Current Liabilities) 0.56 1072/1922 0.49 853/1725
Quick Ratio[(Current Assets - Inventories)/Current laibilities] 0.29 (1072-507)/1922 0.30 (853-328)/1725
If the firm has increases its Quick ratio then it means that it has disposed/sold inventory in cash. As a result the Inventory has decreased resulting into a increase in the denominator
of the Quick ratio and thereby incraese in the Quick ratio. But the Current ratio remains same as the outflow of inventory and inflow of cash are both set off and net effect is zero.
1.Times Interest earned:- If this ratio incraeses then it means that it is able to meet its debt obligations by paying the interest and hence the firm is Better with its increase.
2.Inevntory Turnover:- A higher Inventory turnover means that there is adequate inventory in the firm and there is no overstocking or deficiency hence a higher inventory is Better.
3.Days sales in Receivable:- A higher days sales in receivables shows that the company is not efficient in collecting the receivables and hence a higher ratio is Worse for the company.
4.Asset Turnover:- A higher Asset turnover means that the company is generating higher revenue from its assets employed and hence the higher ratio the Better it is.
5.Profit Margin:- A higher profit margin signifies that the indirect expenses are less as compared to its revenues and henc the higher the ratio is Better.
6.Return on Assets:- It shows the Income generated by the company from the assets employed , hence the higher ROA the Better it is for the company.

Related Solutions

Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold...
Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,700 Cost of goods sold 7,340 Depreciation 405 Earnings before interest and taxes $ 955 Interest paid 82 Taxable income $ 873 Taxes 306 Net income $ 567    Windswept, Inc. 2016 and 2017 Balance Sheets ($ in millions) 2016 2017 2016 2017 Cash $ 150 $ 185 Accounts payable $ 1,180 $ 1,260 Accounts rec. 920 730 Long-term debt 1,000 1,265 Inventory 1,520 1,550 Common stock 3,210 2,900...
Nabors Inc. 2009 Income Statement ($ in millions) Bet Sales $9,610 Less: Cost of Goods Sold...
Nabors Inc. 2009 Income Statement ($ in millions) Bet Sales $9,610 Less: Cost of Goods Sold 6,310 Less Depreciation 1,370 Earnings before interest and taxes 1,930 Less: Interest paid 630 Taxable income $1,300 Less taxes 455 Net Income $   845 Nabors Inc. 2008 and 2009 Balance sheets ($ in millions) 2008 2009 2008 2009 Cash $310 $405 Accounts Pay $2720 $2570 Accounts Rec. 2640 3055 Notes Pay 100 0 Inventory 3275 3850 Total $2820 $2570 Total $6225 $7310 Long Term...
Kramerica Industries (KI) 2015 Income Statement Sales $422,045    Cost of goods sold 291,090    Depreciation 37,053 Earnings...
Kramerica Industries (KI) 2015 Income Statement Sales $422,045    Cost of goods sold 291,090    Depreciation 37,053 Earnings before interest and taxes $93,902    Interest expense 16,400 Earnings before taxes $77,502    Taxes 27,126 Net income $50,376    Dividends    Additions to retained earnings    Kramerica Industries (KI) 2014 and 2015 Balance Sheets 2014 2015 2014 2015 Cash $26,450 $29,106 Accounts payable $61,722 $69,426 Accounts receivable 13,693 18,282 Long-term debt 95,000 110,000 Inventory 27,931 32,586 Common stock 45,000 45,000 Net fixed assets 357,165 398,345 Retained earnings...
The 2018 income statement of Adrian Express reports sales of $15,015,000, cost of goods sold of...
The 2018 income statement of Adrian Express reports sales of $15,015,000, cost of goods sold of $8,863,500, and net income of $1,570,000. Balance sheet information is provided in the following table.      ADRIAN EXPRESS Balance Sheets December 31, 2018 and 2017   2018   2017 Assets   Current assets:        Cash $ 570,000 $ 730,000        Accounts receivable 1,340,000 970,000        Inventory 1,740,000 1,370,000   Long-term assets 4,770,000 4,210,000              Total assets $ 8,420,000 $ 7,280,000      Liabilities and Stockholders' Equity   Current liabilities $ 1,990,000 $ 1,630,000...
Prepare the companies statement of cash flows: Income statement: Sales $180,000 Cost of Goods Sold ($110,000)...
Prepare the companies statement of cash flows: Income statement: Sales $180,000 Cost of Goods Sold ($110,000) Depreciation Expense ($30,000) Operating Expense ($18,000) Loss on sale of land ($1,000) Gain on the sale of equipment $5,000 Net income $26,000 Balance Sheet- 2017/2016 Cash- $35,000 (2017)/ $53,000 (2016) AR- $25,000 / $32,000 Inventory- $40,000 / $32,000 Prepaid Expense- $5,000 / $4,000 Investments- $15,000 / $10,000 Land- $15,000 / $18,000 Build & Equip, net- $145,000 / $122,000 Total Assets- $280,000 / $271,000 Acct....
2016 2015 Sales $ 21,000,000 $ 19,500,000 Cost of goods sold 7,413,000 6,630,000 Net income 1,890,000...
2016 2015 Sales $ 21,000,000 $ 19,500,000 Cost of goods sold 7,413,000 6,630,000 Net income 1,890,000 1,560,000 Interest expenses 164,500 144,500 Income taxes 220,286 196,286 Current assets 2,250,000 2,115,000 Total assets 5,050,000 4,760,000 Total liabilities 760,000 750,000 Total stockholders' equity 4,290,000 4,010,000 Knowledge Check 01 The data provided here is of Stevenson Company. The tax rate is 30%. From this data, compute the gross margin percentage for the year 2016. 66.0% 64.7% 35.3% 34.0% Knowledge Check 02 The data provided...
Figures are in millions of dollars Net sales $ 2,473.8 Cost of goods sold (COGS) $...
Figures are in millions of dollars Net sales $ 2,473.8 Cost of goods sold (COGS) $ 1,316.2 Operating expenses (S&GA) $ 575.8 Inventory $ 250.1 Accounts receivable $ 36.7 Other current assets $ 68.9 Fixed assets $ 690.0 What's the net profit margin? $____ Show work. What's the net profit margin %? _____ Show work. What's the value of total assets? $____ Show work. What's the asset turnover ? $____ Show work. What's the return on assets (ROA)? $____ Show...
Schedules of Cost of Goods Manufactured and Cost of Goods Sold; Income Statement The following data...
Schedules of Cost of Goods Manufactured and Cost of Goods Sold; Income Statement The following data from the just completed year are taken from the accounting records of Mason Company: Sales .......................................... $524,000 Direct labor cost.................................. $70,000 Raw material purchases............................ $118,000 Selling expenses ................................. $140,000 Administrative expenses ........................... $63,000 Manufacturing overhead applied to work in process ...... $90,000 Actual manufacturing overhead costs ................. $80,000 Inventories Beginning of End of Year Year Raw materials.............. $7,000 $15,000 Work in process............ $10,000 $5,000...
2009 2010 Sales ($ millions) 1000 1112 Cost of Goods Sold ($ millions) 500 556 Other...
2009 2010 Sales ($ millions) 1000 1112 Cost of Goods Sold ($ millions) 500 556 Other Expenses ($ millions) 100 111 Depreciation ($ millions) 100 100 Interest Expense ($ millions) 50 55 Total Current Assets ($ millions) 600 700 Total Fixed Assets ($ millions) 2200 2500 Accumulated Depreciation ($ millions) 400 This can be determined from the information given Net Fixed Assets ($ millions) 1800 2000 Total Current Liabilities ($ millions) 450 550 Long-term Liabilities ($ millions) 900 975 Common...
Bayside, Inc. 2017 Income Statement ($ in thousands) Net sales $ 6,170 Cost of goods sold...
Bayside, Inc. 2017 Income Statement ($ in thousands) Net sales $ 6,170 Cost of goods sold 4,590 Depreciation 395 Earnings before interest and taxes $ 1,185 Interest paid 44 Taxable income $ 1,141 Taxes 399 Net income $ 742    Bayside, Inc. 2016 and 2017 Balance Sheets ($ in thousands) 2016 2017 2016 2017 Cash $ 145 $ 250 Accounts payable $ 1,710 $ 1,770 Accounts rec. 1,130 970 Long-term debt 880 680 Inventory 1,805 2,130 Common stock 3,380 3,350...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT