Question

In: Finance

_______________________________________________________________________ JETER CORPORATION Income Statement For the Year Ended December 31, 2019 Sales.......................................................................................... $ 3,300,000 Co

_______________________________________________________________________

JETER CORPORATION

Income Statement

For the Year Ended December 31, 2019

Sales.......................................................................................... $ 3,300,000

Cost of goods sold....................................................................    1,950,000

Gross profits.......................................................................      1,350,000

Selling and administrative expense..........................................         650,000

Depreciation expense................................................................        230,000

Operating income................................................................         470,000

Interest expense........................................................................          80,000

Earnings before taxes.........................................................         390,000

Taxes.........................................................................................        140,000

Earnings after taxes............................................................         250,000

Preferred stock dividends............................................................       10,000

Net Income Available to Common Shareholders.....................    $   240,000

Shares outstanding..................................................................         150,000

Current Stock Price................................................................... $         16.00

_______________________________________________________________________

_______________________________________________________________________

Statement of Retained Earnings

For the Year Ended December 31, 2019

Retained earnings, balance, January 1, 2014............................       $800,000

Add: Earnings available to common stockholders, 2014......         240,000

Deduct: Cash dividends declared and paid in 2014..............         140,000

Retained earnings, balance, December 31, 2014......................       $900,000

_______________________________________________________________________

_______________________________________________________________________

Comparative Balance Sheets

For 2018 and 2019

                                                                                                                Year-End    Year-End

Assets                                                                                                 2018              2019

Current assets:

Cash....................................................................................      $ 100,000      $120,000

Accounts receivable (net)...................................................         500,000        510,000

Inventory............................................................................         610,000        640,000

Prepaid expenses.................................................................           60,000        30,000

Total current assets.......................................................      1,270,000     1,300,000

Investments (long-term securities)......................................           90,000          80,000

Plant and equipment...........................................................      2,000,000     2,600,000

Less: Accumulated depreciation...................................    1,000,000   1,230,000

Net plant and equipment.....................................................    1,000,000   1,370,000

Total assets...............................................................................    $2,360,000   $2,750,000

                                                                                                                Year-End     Year-End

Liabilities and Stockholders’ Equity                                               2018            2019

Current liabilities:

Accounts payable................................................................      $ 300,000     $ 550,000

Notes payable......................................................................         500,000        500,000

Accrued expenses...............................................................           70,000          50,000

Total current liabilities.....................................................         870,000     1,100,000

Long-term liabilities:

Bonds payable, 2030..........................................................        100,000        160,000

Total liabilities.................................................................         970,000     1,260,000

Stockholders’ equity:

Preferred stock, $100 par value..........................................           90,000          90,000

Common stock, $1 par value..............................................         150,000        150,000

Capital paid in excess of par...............................................         350,000        350,000

Retained earnings................................................................         800,000        900,000

Total stockholders’ equity...............................................    1,390,000   1,490,000

Total liabilities and stockholders’ equity.................................    $2,360,000   $2,750,000

_______________________________________________________________________

Calculate the 2019 Ratios using Jeter Corp.’s financial statements, assume stock price is $16.00/share. Also, Complete the Common Size Income Statement and Balance sheet for 2018 and 2019.

Profit Margin                                                                                 Total Asset Turnover

Operating Profit Margin                                                                EPS (Earnings per share)

Price/Earnings Ratio

Return on Assets                                                                                                                                               

Return on Equity                                                                           Liabilities to total assets ratio

A/R Average Collection Period

Inventory Day’s Sales on hand

Inventory Turnover

Current Ratio

Quick Ratio

Times Interest Earned

Fixed Asset Turnover

Gross Profit Margin

Solutions

Expert Solution

Calculate the 2019 Ratios using Jeter Corp.’s financial statements

1. Profit Margin    = profit / sales

Profit = 250,000  sales = 3,300,000

Profit Margin    = 250000 / 3300000 = 0.07575 = 7.57%

2. Total Asset Turnover = sales / Average asset

Average asset = (Beginning + ending ) / 2

=( 2,360,000  + $2,750,000) / 2 = 2555000

Total Asset Turnover = 3300000 / 2555000 = 1.29 times

             

3. Operating Profit Margin     =     Operating Profit / sales

     Operating Profit = 470,000

          Operating Profit Margin     = 470,000 / 3300000 = 0.1424 = 14.24%

4. EPS (Earnings per share)  = IAC (Net Income Available to Common                        Shareholders) / share outstanding

           IAC = 240,000

            share outstanding = 150,000

      EPS (Earnings per share) = 240000 / 150000 = 1.6

5. Price/Earnings Ratio = Current Stock Price / EPS (Earnings per share)

             Current Stock Price  = 16 / share

      Price/Earnings Ratio =  16 / 1.6 = 10

6. Return on Assets        = Net income / Average assets

Net Income = 250,000

Average assets= 2555000

Return on Assets        = 250,000 / 2555000 = 0.0978 = 9.78%

               

7. Return on Equity       = Net income / Average equity

         Average equity = (beginning + ending) / 2

    Here we only use common stock equity, so deduct preferred equity from total stock holders equity

                       = ((1,390,000 - 90000) + (1,490,000 - 90000) ) / 2

                        = 1350000

     Return on Equity       = 250000 / 1350000 = 0.1852 = 18.52%

8. Liabilities to total assets ratio = Total liability / Total asset

                Total liability = 1,260,000

                 Total asset = 2,750,000

Liabilities to total assets ratio = 1,260,000 / 2,750,000 = 0.4582 = 45.825

9. A/R Average Collection Period  = Average A/R / Sales per day

           Average A/R = (opening + ending) / 2

                        = ( 500,000   +     510,000) / 2 = 505000

Sales per day = Sales / 365

            = 3,300,000 / 365 = 9041.1

        A/R Average Collection Period  = 505000 / 9041.1 = 56 days

10. Inventory Day’s Sales on hand = Average inventory / Cost of good per day

           Average inventory = (opening + ending) / 2

                        = ( 610,000    +    640,000) / 2 = 625000

Cost of goods sold per day = Cost of goods sold / 365

            = 1,950,000 / 365 = 5342.466

        A/R Average Collection Period  = 625000 / 5342.466 = 117 days

11. Inventory Turnover = Cost of goods sold / Average inventory

              = 1,950,000 / 625000 = 3.12

12. Current Ratio = current assets / Current liabilities

           current assets = 1,300,000

           Current liabilities = 1,100,000

Current Ratio = 1,300,000 / 1,100,000 = 1.18 times

13. Quick Ratio = Quick Asset / Current liabilities

            Quick Asset = current assets - ( inventory + prepaid expenses)

                        = 1,300,000 - (640,000 + 30,000 ) = 630000

         Quick Ratio = 630000 / 1,100,000 = 0.57 times

14. Times Interest Earned = Earning Before Interest and Tax / Interest Expenses

               Earning Before Interest and Tax =470,000

                Interest Expenses = 80,000

      Times Interest Earned = 470,000 / 80,000 = 5.875 times

15. Fixed Asset Turnover  = Sales / Average Fixed Asset

                Average Fixed Asset = (opening + ending) / 2

      ( 2,360,000 -1,270,000) + ( $2,750,000 - 1,300,000 ) = 1270000

         Fixed Asset Turnover  = 3300000 / 1270000 = 2.60 times

16. Gross Profit Margin = Gross profit / Sales

             Gross profit = 1,350,000

Gross Profit Margin = 1350000 / 3300000 = 0.4090 = 40.90%

Complete the Common Size Income Statement and Balance sheet for 2018 and 2019.

Common Size Income Statement ( vertical )

Common Size Income Statement

For the Year Ended December 31, 2019

Sales

100%

Cost of goods sold.

59.09%

Gross profits

40.90%

Selling and administrative expense

19.70%

Depreciation expense

6.97%

Operating income

14.24%

Interest expense

2.42%

Earnings before taxes

11.82%

Taxes

4.24%

Earnings after taxes

7.57%

Preferred stock dividends

0.30%

Net Income Available to Common Shareholders.

7.27%

Common Size Balance sheet for 2018 and 2019.

Here we prepare Horizontal common size balance sheet for 2018 and 2019.

We assume 2018 as base year

Horizontal common size Comparative Balance Sheets

For 2018 and 2019

(2019 figure as percentage of base year)

Vertical common size Comparative Balance Sheets

For 2018 and 2019

(As percentage of Total asset)

Year end 2018 (base year)

Year end 2019

2019

Assets

Current assets:

Cash..

100%

120%

4.23%

4.36%

Accounts receivable (net)..

100%

102%

21.18%

18.55%

Inventory

100%

105%

25.84%

23.27%

Prepaid expenses.

100%

50%

2.54%

1.09%

Total current assets.

100%

102.36%

53.81%

47.27%

Investments (long-term securities).

100%

88.89%

3.81%

2.90%

Plant and equipment

100%

130%

84.74%

94.545%

Less: Accumulated depreciation

100%

123%

42.37%

44.73%

Net plant and equipment..

100%

137%

42.37%

49.82%

Total assets.

100%

116.52%

100%

100%

           

Liabilities and Stockholders’ Equity            

Current liabilities:

Accounts payable

100%

183.33%

12.71%

20%

Notes payable.

100%

100%

21.18%

18.18%

Accrued expense

100%

71.43%

2.96%

1.82%

Total current liabilities.

100%

126.44%

36.86%

40%

Long-term liabilities:

Bonds payable, 2030.

100%

160%

4.24%

5.82%

Total liabilities

100%

129.90%

41.10%

45.82%

Stockholders’ equity:

Preferred stock, $100 par value

100%

100%

3.81%

3.27%

Common stock, $1 par value

100%

100%

6.35%

5.45%

Capital paid in excess of par..

100%

100%

14.83%

12.73%

Retained earnings.

100%

1125.5%

33.89%

32.72%

Total stockholders’ equity

100%

107.19%

58.90%

54.18%

Total liabilities and stockholders’ equity

100%

116.52%

100%

100%

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

The following is the income statement for Nikov and Co. for the year ended 31 December...
The following is the income statement for Nikov and Co. for the year ended 31 December 2014, along with information relating to the preceding year. Income statement for the year ended 31 December 2014 £000 2013 £000 Sales revenue 420.2 382.5 Cost of sales (126.1) (114.8) Gross profit 294.1 267.7 Salaries and wages (92.6) (86.4) Selling and distribution costs (98.9) (75.4) Rent and rates (22.0) (22.0) Bad debts written off (19.7) (4.0) Telephone and postage (4.8) (4.4) Insurance (2.9) (2.8)...
Income Statement Covid Company for the year ended December 31, 2019 shows sales revenue $6,000,000 and...
Income Statement Covid Company for the year ended December 31, 2019 shows sales revenue $6,000,000 and COGS $3,800,000 . Accounts receivable increased $250,000 during the year, and inventory decreased $300,000. Accounts payable to suppliers of merchandise decreased $450,000 during the year. Accrued expenses payable decreased $90,000 during the year. Operating expenses include depreciation expense of $1,600,000. Depreciation expense was $100,000. Prepare Statement of Cash Flow Operating Activities Section for Covid Company.
Income Statement For the Year Ended December 31, 2018 Sales                                &nb
Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these types of sales....
Income Statement For the Year Ended December 31, 2018 Sales                                &nb
Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these types of sales....
Complete a Balance Sheet ABC Corporation Income Statement For the Year Ended December 31, 2014 Sales...
Complete a Balance Sheet ABC Corporation Income Statement For the Year Ended December 31, 2014 Sales Revenue    792,845 Less: Operating Expenses Wages Expense         80,350 Office Expense         21,700 Utilities Expense         31,000 Advertising Expense $       8,400 Insurance Expense         82,000 Employee Compensation Expense         10,000 Bad Debt Expense         25,000 Pension Expense         40,000 Depreciation Expense         33,759 Total Operating Expenses    332,209 Income from Operations    460,636 Other Revenue/Expenses Rent Revenue         12,000 Interest Income         19,561...
Complete a Balance Sheet ABC Corporation Income Statement For the Year Ended December 31, 2014 Sales...
Complete a Balance Sheet ABC Corporation Income Statement For the Year Ended December 31, 2014 Sales Revenue    792,845 Less: Operating Expenses Wages Expense         80,350 Office Expense         21,700 Utilities Expense         31,000 Advertising Expense $       8,400 Insurance Expense         82,000 Employee Compensation Expense         10,000 Bad Debt Expense         25,000 Pension Expense         40,000 Depreciation Expense         33,759 Total Operating Expenses    332,209 Income from Operations    460,636 Other Revenue/Expenses Rent Revenue         12,000 Interest Income         19,561...
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings for the year ended December 31, 20XX
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings for the year ended December 31, 20XX and Comparative Balance Sheets for 20XW and 20XX of Maris Corporation: Maris CorporationIncome StatementYear Ended December 31, 20XX  Sales$3,800,000  Cost of goods sold2,250,000        Gross profits1,550,000  Selling and administrative expense540,000  Amortization expense200,000        Operating income810,000  Interest expense43,000        Earnings before taxes767,000  Taxes440,000        Earnings after taxes327,000    Preferred stock dividends30,000     Earnings available to common shareholders$297,000    Shares outstanding198,000  Earnings per share$1.50   Statement of...
the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                            &n
the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these...
the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                            &n
the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 1.Restate the income statement in a contribution margin format. 2.Compute the break-even point in sales...
Brick & Stone Income Statement for the year ended 31 December 2010 Notes $ $ Sales...
Brick & Stone Income Statement for the year ended 31 December 2010 Notes $ $ Sales 2,500,000 Cost of Sales 1 1,100,000 Gross Profit 1,400,000 Expenses Salaries & Wages 2 760,000 Employer Social Security Contribution 2,400 Rent and Rates 3 240,000 Insurance 50,000 Maintenance 120,000 Depreciation 4 55,000 Los on Disposal of Vehicle 5 10,000 Telephone 6 35,000 Electricity 7 54,000 Utilities 70,000 Entertainment 8 100,000 Donations 9 85,000 Provision for Bad Debts 10 80,000 Fines and Penalties 11 15,000...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT