Question

In: Accounting

Use the following financial data for Greta’s Gadgets, Inc. Greta’s Gadgets, Inc. Income Statement For the...

Use the following financial data for Greta’s Gadgets, Inc.

Greta’s Gadgets, Inc.

Income Statement
For the Year Ended December 31, 2014

Sales

$4,000,000

– Costs and expenses @ 90%

3,600,000

Earnings before interest & taxes

$   400,000

– Interest (.10*$1,000,000)

     100,000

Earnings before taxes

$   300,000

Taxes @ 40%

     120,000

Net income

$   180,000

Greta’s Gadgets, Inc.

Balance Sheet

As of December 31, 2014

                       Assets

Liabilities and Stockholders’ Equity

Current assets

$              0

Current liabilities

$             0

Fixed assets

2,000,000

Long-term debt @ 10%

1,000,000

Total assets

$2,000,000

Total liabilities

$1,000,000

Common stock equity

1,000,000

Total liabilities and stockholders’

    equity

$2,000,000

1. Calculate the current (2014) net profit margin, total asset turnover, assets-to-equity ratio, return on total assets, and return on common equity for Greta’s. Show your calculations!

2. Show mathematically the tax disadvantage to organizing a U.S. business today as a corporation versus a partnership, given the following assumptions. All earnings will be paid out as dividends, and operating income before taxes will be $1,500,000. The effective corporate tax rate is 35%, and the tax rate on corporate dividends is 15%. The average personal tax rate for partners in the business is 35%.

Tax Table

Taxable income over

Not over

Tax Rate

$                0

$       50,000

15%

         50,000

         75,000

25%

         75,000

       100,000

34%

       100,000

       335,000

39%

       335,000

  10,000,000

34%

  10,000,000

  15,000,000

35%

  15,000,000

  18,333,333

38%

  18,333,333

...............

35%

3. Refer to the Tax Table. First Watch, Inc. has a pretax income of $3,755,250. What is the company’s average tax rate, marginal tax rate and tax liability?

4. The Park Corp. had earnings before interest and taxes of $500,000 and had a depreciation expense of $200,000 this last year. If the firm was subject to an average tax rate of 30%, what was Park’s operating cash flow for the year? If you need to, assume that Park’s interest expense was zero for the year.

5. List and briefly describe the three general areas of responsibility for a financial manager.

6. Give some examples of ways in which manager's goals can differ from those of shareholders.

Galaxy Interiors

2011 Income Statement ($ in Millions)

Net Sales: $21415

Cost of goods sold: 16408

Depreciation: 1611

Earnings before Interest and taxes: 3396

Interest Paid: 1282

Taxable Income: 2114

Less Taxes: 740

Net Income: 1374  

Galaxy Interiors  

2010 and 2011 Balance Sheet ($ in millions)

cash: $668(2010) $297(2011)

Accounts Rec: 1611(2010) 1527(2011)

Inventory:3848(2010) 2947(2011)

Total: $6127(2010) $4771(2011)

Net fixed assets: 17489(2010) 17107(2011)

Total assets: $23616(2010) $21878(2011)

Accounts payable: $1694 (2010) $1532 (2011)  

Notes payable: 2500 (2010) 0 (2011)

Total: $4194 (2010) $1532 (2011)  

Long term debt: 9800 (2010) 10650 (2011)  

Common stock: 7500 (2010) 7000 (2011)

Retained Earnings: 2122 (2010) 2696 (2011)

Total liab. & Equity: $23616 (2010) $21878 (2011)  

7. What is the cash flow from assets for 2011? What is the cash flow to creditors for 2011? What is the cash flow to stockholders for 2011? Show your calculations!

8. Discuss the difference between book values and market values and explain which one is more important to the financial manager and why.

9. It is commonly recommended that the managers of a firm compare the performance of their firm to that of its peers. Increasingly, this is becoming a more difficult task. Explain some of the reasons why comparisons of this type can frequently be either difficult to perform or produce misleading results.

Solutions

Expert Solution

Note: All given questions are separate & independent. So as per rule I am answering first question including all its parts.

Net profit margin;

Net profit margin = (Net income * 100 / Sales)

Net income = $180000

Sales = $4000000

Now let’s put the values in the above given formula;

Net profit margin ($180000 * 100 / $4000000) = 4.5%

Total asset turnover;

Total asset turnover = (Sales / Total assets)

Total assets = $2000000

Sales = $4000000

Now let’s put the values in the above given formula;

Total asset turnover ($4000000 / $2000000) = 2 times

Asset to equity ratio;

Asset to equity ratio = (Total assets / Equity)

Total assets = $2000000

Equity = $1000000

Now let’s put the values in the above given formula;

Asset to equity ratio ($2000000 / $1000000) = 2 times

Return on total assets;

Return on total assets = (Net income * 100 / Total assets)

Total assets = $2000000

Net income = $180000

Now let’s put the values in the above given formula;

Return on total assets ($180000 * 100 / $2000000) = 9%

Return on common equity;

Return on common equity = (Net income * 100 / Common stock equity)

Common stock equity = $1000000

Net income = $180000

Now let’s put the values in the above given formula;

Return on common equity ($180000 * 100 / $1000000) = 18%


Related Solutions

A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $...
A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2016. Show that ROE = PM × AT × FL. (in thousands) 2016 2015 Net sales $5,456,650 $5,702,613 Operating income 619,233 640,922 Interest expense 95,118 85,270 Net income 318,022 369,416 Total assets 6,493,794 6,535,143 Total liabilities 4,086,012 3,901,889
Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands)...
Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2013. Show that ROE = PM × AT × FL. (in thousands) 2013 2012 Net sales $6,484,892 $6,420,881 Operating income 1,168,103 1,021,015 Interest expense 5,555 6,841 Net income 903,944 776,464 Total assets 6,439,626 6,526,785 Total liabilities 3,188,067 3,459,741
Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income Statement Years...
Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income Statement Years Ended December 31, 2016 and 2015 2016 2015 Net sales $687,000 $595,000 Cost of goods sold 375,000 276,000 Gross profit 312,000 319,000 Operating expenses 129,000 142,000 Income from operations 183,000 177,000 Interest expense 37,000 45,000 Income before income tax 146,000 132,000 Income tax expense 36,000 51,000 Net income $110,000 $81,000 Lannister Inc. Comparative Balance Sheet December 31, 2016 and 2015 2016 2015 2014 Current...
Income statement Crowley Inc., submits the following data for September
 Income statement Crowley Inc., submits the following data for September Direct labor cost, $30,000 Cost of goods sold, $111,000 Factory overhead is applied at the rate of 150% of direct labor cost Inventory accounts showed these beginning and ending balances: September 1 September 30 Finished goods……………….... $15,000 $17,500 Work in process……………….. 9,600 13,000 Materials…………………………. 7,000 7,400 Other data: Marketing expenses………………………………………………………………………… $ 14,100General and administrative expenses……………………………………………… 22,000 Sales for the month………………………………………………………………………… 182,000 Required:An income statement with schedule showing cost of goods...
Question 4 Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income...
Question 4 Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income Statement Years Ended December 31, 2016 and 2015 2016 2015 Net sales $687,000 $595,000 Cost of goods sold 375,000 276,000 Gross profit 312,000 319,000 Operating expenses 129,000 142,000 Income from operations 183,000 177,000 Interest expense 37,000 45,000 Income before income tax 146,000 132,000 Income tax expense 36,000 51,000 Net income $110,000 $81,000 Lannister Inc. Comparative Balance Sheet December 31, 2016 and 2015 2016 2015...
The following data were extracted from the income statement of Keever Inc.:
Inventory AnalysisThe following data were extracted from the income statement of Keever Inc.:Current YearPrevious YearSales$1,270,200$1,327,100Beginning inventories70,73870,964Cost of goods sold635,100737,300Ending inventories63,93870,738a. Determine for each year (1) the inventory turnover and (2) the number of days' sales in inventory. Round interim calculations to the nearest dollar and the final answers to one decimal place. Assume 365 days a year.Current YearPrevious Year1. Inventory turnover2. Number of days' sales in inventorydaysdaysb. The inventory position of the business has deteriorated . The inventory turnover has...
Income Statement, Retained Earnings Statement, and Balance Sheet The following financial data were adapted from a...
Income Statement, Retained Earnings Statement, and Balance Sheet The following financial data were adapted from a recent annual report of Target Corporation for the year ending January 31. In millions Accounts payable $ 7,759 Cash 2,210 Common stock 53 Cost of goods sold 51,278 Debt and other borrowings 12,705 Income tax expense 1,204 Interest expense 882 Inventories 8,790 Other assets 4,446 Other expenses 6,214 Other liabilities 6,943 Property, plant, and equipment 25,958 Sales 72,618 Selling, general, and administrative expenses 14,676...
. Using the financial statement and data below answer the following questions: Financial Statement Data and...
. Using the financial statement and data below answer the following questions: Financial Statement Data and Stock Price Data for Flextronics (All data as of fiscal year end; $ in millions) Income Statement 2012 2013 2014 2015 2016 Revenue 404.3 363.8 424.6 510.7 604.1 Cost of Goods Sold -188.3 -173.8 -206.2 -246.8 -293.4 Gross profit 216 190 218.4 263.9 310.7 Sales and Marketing -66.7 -66.4 -82.8 -102.1 -120.8 Administration -60.6 -59.1 -59.4 -66.4 -78.5 Depreciation & Amortization -27.3 -27 -34.3...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a Recent Year Total sales and revenues ...................................................................................... $55,184,000 Less: Cost of products sold ................................................................................... $40,391,000 Gross profit .......................................................................................,.................... $ 14,793,000 Less: Operating costs : Selling, general, and administrative expenses ................................................ $ 5,697,000 Research and development expenses ............................................................ $2,135,000 Other operating expenses ............................................................................... $1,633,000 Total operating costs ............................................................................................. $ 9,465,000 Operating profit ..................................................................................................... $ 5,328,000 Less: Other expenses ............................................................................................ 245,000 Consolidated profit before taxes .............................................................................
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a Recent Year Total sales and revenues ...................................................................................... $55,184,000 Less: Cost of products sold ................................................................................... $40,391,000 Gross profit .......................................................................................,.................... $ 14,793,000 Less: Operating costs : Selling, general, and administrative expenses ................................................ $ 5,697,000 Research and development expenses ............................................................ $2,135,000 Other operating expenses ............................................................................... $1,633,000 Total operating costs ............................................................................................. $ 9,465,000 Operating profit ..................................................................................................... $ 5,328,000 Less: Other expenses ............................................................................................ 245,000 Consolidated profit before taxes .............................................................................
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT