Question

In: Finance

Income Statement Accounts 2014 2013 Net Sales $ 1,720,000 $ 1,450,000 Cost of Goods Sold 1,204,000...

Income Statement Accounts 2014 2013
Net Sales $ 1,720,000 $ 1,450,000
Cost of Goods Sold 1,204,000 1,015,000
Selling and Admin. Expense 220,000 185,385
Non operating revenue 9,192 8,860
Interest Expense 14,620 12,100
Earnings Before Income Tax 290,572 246,375
Provision for Income Taxes 116,473 113,616
Net Income $ 174,099 $ 132,759
Balance Sheet Accounts
Current Liabilities $ 190,400 $ 189,000
Long-term debts 120,000 112,000
Preferred Stocks (10%) 100,000 100,000
Common Stocks 850,000 850,000
Retained Earnings 348,198 265,518
Other Information
Total Assets Include the following:
Goodwill 12,000 12,000
Construction in Progress 340,000 250,000
Instructions:
a. Compute the following for 2013 and 2014:
Net Profit Margin
Total Assets Turn over
Operating Profit Margin
Operating Assets Turnover
Return on Investment
Return on Common Equity

b. Based on the previous computation, summarize the trend in profitability for this firm

Solutions

Expert Solution

a) Net Profit Margin:

2013:

Net Profit Margin= Net Income/Sales=132,759/1,450,000=9.16%

2014:

Net Profit Margin= Net Income/Sales= 174,099 / 1,720,000 =10.12%

Total Asset Turnover:

2013:

Total Asset Turnover Ratio= Sales /Assets=1,450,000/(12000+250000)=5.534

2014:

Total Asset Turnover Ratio= Sales /Assets=1,720,000/(12000+ 340,000 )=4.886

Operating Profit Margin:

2013:

Operating profit margin= ​(EBIT=Gross Income−(Operating expense + Depreciation) )/Sales

Operating profit margin=(1,450,000 - 1,015,000 - 185,385 + 8,860 )/1,450,000=258475/1450000=17.83%(This include non operating income also)

Without Operating Income: Operating profit margin=(1,450,000 - 1,015,000 - 185,385)/1,450,000=17.21%(This gives more exact picture of direct operating flows margins from core business)

2014

Operating profit margin=( 1,720,000 - 1,204,000 - 220,000 )/1,720,000=296000/1720000=17.21%(This does not include non operating income )

Operating Asset Turnover:

2013

Operating Asset Turnover=Sales/Operating Assets=1,450,000/250000=5.80(Only assets which contribute to revenue generration of business)

2014:

Operating Asset Turnover=Sales/Operating Assets= 1,720,000/340,000=5.058

Return on Investment:

2013:

ROI=Net Income/Total Investment(Shareholder's Equity + LT Debt)=132,759/( 100,000 + 850,000 + 265,518 + 250,000 )=9.06%

2014:

ROI=Net Income/Total Investment(Shareholder's Equity + LT Debt)=174099/( 100,000 + 850,000 + 348,198 +340000)=10.63%

Return on common Equity:

2013:

Retrun on common equity=Net income/Common equity=132,759/850,000=15.62%

2014:

Retrun on common equity=Net income/Common equity=174099/850,000=20.48%

b) As per above calculation, the ROI and Net profit margin along with sales are in increasing trend.

While the efficiency of operatiions have remained flat, as we can see thee is constand operating magin trend in 2 years and asset turnover ration has decreased, this is due to that fact they have substantial asset in work in progree so once thse asset are capitalized we will see improved margind as wwll as turnover ratio.

Overall the comapny is performing gooood, but more can be analysed ig we will know the buisness and industry in which it is operating in.

Hope this answers finds you well, please let me know if you have any doubts.

ANd if you like the answer please give a thumbs up to it , so that it encourages me to provide quality answers to students like you.


Related Solutions

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...
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...
Bayside Inc. 2005 Income Statement ($ in thousands) Net sales $5,680 Less: Cost of goods sold...
Bayside Inc. 2005 Income Statement ($ in thousands) Net sales $5,680 Less: Cost of goods sold 4,060 Less: Depreciation 420 Earnings before interest and taxes 1,200 Less: Interest paid 30 Taxable Income $1,170 Less: Taxes 410 Net income $ 760 Bayside, Inc. 2004 and 2005 Balance Sheets ($ in thousands) 2004 2005 2004 2005 Cash $ 70 $ 180 Accounts payable $1,350 $1,170 Accounts rec. 980 840 Long-term debt 720 500 Inventory 1,560 1,990 Common stock 3,200 3,500 Total $2,610...
Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $142,000 Fixed costs...
Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $142,000 Fixed costs $43,000 Selling, general, and administrative expenses $27,800 Depreciation $46,000 Partial Balance Sheet 12/31/2013 ASSETS LIABILITIES Cash $15,800 Notes payable $14,100 Accounts receivable $28,200 Accounts payable $19,200 Inventories $47,900 Long-term debt $189,800 Fixed assets $368,100 OWNERS' EQUITY Accumulated depreciation $140,200 Retained earnings Intangible assets $82,000 Common stock $131,800 Partial Balance Sheet 12/31/2014 ASSETS LIABILITIES Cash $25,900 Notes payable $12,200 Accounts receivable $19,100 Accounts payable $23,900...
Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $141,800 Fixed costs...
Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $141,800 Fixed costs $43,200 Selling, general, and administrative expenses $28,100 Depreciation $45,900 Partial Balance Sheet 12/31/2013 ASSETS LIABILITIES Cash $15,900 Notes payable $14,100 Accounts receivable $27,900 Accounts payable $18,900 Inventories $48,000 Long-term debt $190,100 Fixed assets $368,000 OWNERS' EQUITY Accumulated depreciation (-) $141,500 Retained earnings Intangible assets $82,000 Common stock $131,800 Partial Balance Sheet 12/31/2014 ASSETS LIABILITIES Cash $26,200 Notes payable $11,800 Accounts receivable $18,900 Accounts payable...
OPQ, Inc. 2018 statement of comprehensive income Net sales $8,953 Cost of goods sold $5,865 Depreciation...
OPQ, Inc. 2018 statement of comprehensive income Net sales $8,953 Cost of goods sold $5,865 Depreciation $? EBIT $? Interest paid $675 Earnings before taxes $675 Taxes $400 Net income $705 Dividends paid $? Addition to retained earnings $450 OPQ, Inc. Statement of financial positions as of December 31, 2017 and 2018 2017 2018 2017 2018 Cash $725 $1,135 Accounts payable $859 $1,031 Accounts rec. $2,330 $? Notes payable $? $4,020 Inventory $3,240 $5, 202 Current liabilities $? $? Current...
Major Manuscripts, Inc. 2012 Income Statement Net sales $ 8,600 Cost of goods sold 7,550 Depreciation...
Major Manuscripts, Inc. 2012 Income Statement Net sales $ 8,600 Cost of goods sold 7,550 Depreciation 310 Earnings before interest and taxes $ 740 Interest paid 40 Taxable Income $ 700 Taxes 280 Net income $ 420 Dividends $ 194 Major Manuscripts, Inc. 2012 Balance Sheet 2012 2012 Cash $ 2,420 Accounts payable $ 2,320 Accounts rec. 960 Long-term debt 280 Inventory 2,800 Common stock $ 2,400 Total $ 6,180 Retained earnings 4,580 Net fixed assets 3,400 Total assets $...
Kaler Company has sales of $1,450,000, cost of goods sold of $795,000, other operating expenses of...
Kaler Company has sales of $1,450,000, cost of goods sold of $795,000, other operating expenses of $208,000, average invested assets of $4,600,000, and a hurdle rate of 12 percent. Required: 1. Determine Kaler’s return on investment (ROI), investment turnover, profit margin, and residual income. 2. Several possible changes that Kaler could face in the upcoming year follow. Determine each scenario’s impact on Kaler’s ROI and residual income. (Note: Treat each scenario independently.) a. Company sales and cost of goods sold...
2013 2014 sales 2100 Cost of Goods Sold 1200 Depreciation Expense 225 Interest Expense 175 Current...
2013 2014 sales 2100 Cost of Goods Sold 1200 Depreciation Expense 225 Interest Expense 175 Current Assets 1000 1300 Total Fixed Assets 3500 4000 Accumulated Depreciation 1250 This can be determined from the information given Current Liabilities 900 975 Long-term Debt 1500 1350 Common Stock 400 This can be determined from the information given Question 1 part one) Use the information above to construct a 2014 income statement and balance sheets for both years. The average tax rate is 35%...
2013 2014 Sales $2100 Cost of Goods Sold $1200 Other operating expenses $200 Depreciation Expense $225...
2013 2014 Sales $2100 Cost of Goods Sold $1200 Other operating expenses $200 Depreciation Expense $225 Interest Expense $175 Current Assets $1000 $1300 Total Fixed Assets $3500 $4000 Accumulated Depreciation $1250 This can be determined from the information given Current Liabilities $900 $975 Long-term Debt $1500 $1350 Common Stock $400 This can be determined from the information given A company has the financial data above for years 2013 and 2014. The average tax rate is 35% and the dividend payout...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT