Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Set up a worksheet similar to the one in Exhibit 3-6, page 92, and calculate all of the ratios for Sweet Dreams Corp. Verify the
- Set up a worksheet similar to the one in Exhibit 3-6, page 92, and calculate all of the ratios for Sweet Dreams Corp.
- Verify the change in 2017 Sophisticated Touch Corps ROE using the Du Pont method.
- Using the Altmans model for publicly held firms, calculate the Z-score for Sweet Dreams Corp. Assume that the market value of Sweet Dreams Corp. is 1,500,000; $1,250,000; $1,000,000; $850,000; and $700,000 for the years 2017, 2016, 2015, 2014, and 2013 respectively.
- Calculate Sweet Dreams Corp.s economic profit for these years and compare it to net income. Assume that the weighted average cost of capital is 12%.
- Using the following 2017 industry averages, evaluate Sweet Dreams Corp.s financial situation. Set up a ratio analysis system similar to the one in Exhibit 3-7, page 95.
- The staff at The Sophisticated Touch, Co. wants to perform a trend analysis with the data generated in the previous sections of this problem. Create a line chart showing each category of ratios from 2013 to 2017. Make sure to title the chart and label the axes. Also make a line chart of the Altmans model for private and public firms from 2013 to 2017. Put all of these small charts on one sheet. You can leave off Avg Collection Period. The charts should show data starting in 2013 and ending in 2017. Look for options "Select data" "Switch row/columns" and date axis to help with the formatting.
ues income statement and balance sheet answer questions 1,2,3,4,5,6
Free years. Sales Cost of Goods Sols Gross Profit Selling Expenses Gen. and Admin. Expenses Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Texes Taxes Net Income The Sophisticated Touch, Co. Income Statement For the Year Ended Dec. 31, 2017 2017 2016 5,775,000 5,658,000 4,875,000 4.793.000 900,000 865,000 330,300 329,000 194,000 174.600 100.000 100.000 27,000 23,000 248,700 238,400 80,000 163,700 158,400 65,480 63,360 98,220 95,040 2015 5,308,500 4,393.500 915,000 317,000 157,140 100.000 20.000 320,860 75.000 245,860 86,051 159,809 2014 4,906,000 4,056.000 850,000 313,000 141,426 100.000 17,000 278,574 75,000 203,574 61,072 142,502 2013 4,605,000 3.702,000 903,000 288,000 127,283 100,000 15,000 372,717 70,000 85,000 302,717 90.815 211,902 Notes: Tax Rate 40% 40% 35% 30% The Sophisticated Touch, Co. Balance Sheet As of Dec. 31, 2017 Assets 2017 2016 2015 2014 2013 2012 Cash and Equivalents 123,000 108,000 91,500 78,000 67,500 54,000 Accounts Receivable 350.000 330.000 320.000 300.000 270.000 250,000 Inventory 654,000 538,500 445,500 375,000 334,500 276,000 Total Current Assets 1,127,000 976,500 857,000 753,000 672,000 580,000 Land and buildings 770,250 672,000 589,500 485,250 430,500 380,250 Machinery and Equipment 593,125 462.000 379.750 290.625 224,250 190.625 Furniture and fixtures 154,050 134,400 117,900 97,050 86.100 76,050 Vehicles 123,240 107,520 94,320 77,640 68,880 60,840 Other Fixed Assets 107,835 94.080 82,530 67,935 60,270 53,235 Accumulated Depreciation 549,000 486.000 420.000 355.500 318.000 258,000 Net Fixed Assets 1,199,500 9 84.000 844,000 663,000 552,000 503,000 Total Assets 2,326,500 1,960,500 1,701,000 1,416,000 1,224,000 1,083,000 Liabilities and Owners' Equity Accounts Payable 262,500 234.000 204.000 183,000 153,000 135,000 Short-term Notes Payable 110,000 100,000 70,000 80,000 90,000 70,000 Other Current Liabilities 210,000 180,000 159,000 133,500 115,500 96,000 Total Current Liabilities 582,500 514,000 433,000 396,500 358,500 301.000 Long-term Debt 715,000 551,000 510,500 352,000 301,500 285,500 Total Liabilities 1,297,500 1,065,000 943,500 748,500 000,000 586,500 Common Stock 460,000 414,000 346,000 309,000 254,000 222,000 Pain-in capital 343,000 298.500 252.500 222.500 188.000 165,500 Retained Eamings 226,000 183.000 159.000 136.000 122.000 109,000 Total Shareholder's Equity 1,029,000 895,500 757,500 6 07,500 564,000 496,500 Total Liabilities and Owners' Equity 2,326,500 1,960,500 1,701,000 1,416,000 1,224,000 1,083,000 a) Set up a ratio worksheet similar to Exhibit 3-6, page 92, and calculate all of the ratios for The Sophisticated Touch, Co. b) Verify the change in 2017 Sophisticated Touch, Co.'s ROE using the Du Pont method. c) Using the Altman's model for privately held firms and public ones, calculate the Z-score for The Sophisticated Touch, Co. Assume that the market value of equity is $1,500,000: $1,250,000: $1,000,000; $850,000, and $700,000 for the years 2017, 2016, 2015, 2014, and 2013 respectively. d) Calculate the economic profit for these years and compare it to net income. Assume that the WACC is 12% each year. e) The staff at The Sophisticated Touch, Co. wants to perform a trend analysis with the data generated in the previous sections of this problem. Create a line chart showing each category of ratios from 2013 to 2017. Make sure to title the chart and label the axes. Also make a line chart of the Altman's model for private and public firms from 2013 to 2017. Free years. Sales Cost of Goods Sols Gross Profit Selling Expenses Gen. and Admin. Expenses Fixed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Texes Taxes Net Income The Sophisticated Touch, Co. Income Statement For the Year Ended Dec. 31, 2017 2017 2016 5,775,000 5,658,000 4,875,000 4.793.000 900,000 865,000 330,300 329,000 194,000 174.600 100.000 100.000 27,000 23,000 248,700 238,400 80,000 163,700 158,400 65,480 63,360 98,220 95,040 2015 5,308,500 4,393.500 915,000 317,000 157,140 100.000 20.000 320,860 75.000 245,860 86,051 159,809 2014 4,906,000 4,056.000 850,000 313,000 141,426 100.000 17,000 278,574 75,000 203,574 61,072 142,502 2013 4,605,000 3.702,000 903,000 288,000 127,283 100,000 15,000 372,717 70,000 85,000 302,717 90.815 211,902 Notes: Tax Rate 40% 40% 35% 30% The Sophisticated Touch, Co. Balance Sheet As of Dec. 31, 2017 Assets 2017 2016 2015 2014 2013 2012 Cash and Equivalents 123,000 108,000 91,500 78,000 67,500 54,000 Accounts Receivable 350.000 330.000 320.000 300.000 270.000 250,000 Inventory 654,000 538,500 445,500 375,000 334,500 276,000 Total Current Assets 1,127,000 976,500 857,000 753,000 672,000 580,000 Land and buildings 770,250 672,000 589,500 485,250 430,500 380,250 Machinery and Equipment 593,125 462.000 379.750 290.625 224,250 190.625 Furniture and fixtures 154,050 134,400 117,900 97,050 86.100 76,050 Vehicles 123,240 107,520 94,320 77,640 68,880 60,840 Other Fixed Assets 107,835 94.080 82,530 67,935 60,270 53,235 Accumulated Depreciation 549,000 486.000 420.000 355.500 318.000 258,000 Net Fixed Assets 1,199,500 9 84.000 844,000 663,000 552,000 503,000 Total Assets 2,326,500 1,960,500 1,701,000 1,416,000 1,224,000 1,083,000 Liabilities and Owners' Equity Accounts Payable 262,500 234.000 204.000 183,000 153,000 135,000 Short-term Notes Payable 110,000 100,000 70,000 80,000 90,000 70,000 Other Current Liabilities 210,000 180,000 159,000 133,500 115,500 96,000 Total Current Liabilities 582,500 514,000 433,000 396,500 358,500 301.000 Long-term Debt 715,000 551,000 510,500 352,000 301,500 285,500 Total Liabilities 1,297,500 1,065,000 943,500 748,500 000,000 586,500 Common Stock 460,000 414,000 346,000 309,000 254,000 222,000 Pain-in capital 343,000 298.500 252.500 222.500 188.000 165,500 Retained Eamings 226,000 183.000 159.000 136.000 122.000 109,000 Total Shareholder's Equity 1,029,000 895,500 757,500 6 07,500 564,000 496,500 Total Liabilities and Owners' Equity 2,326,500 1,960,500 1,701,000 1,416,000 1,224,000 1,083,000 a) Set up a ratio worksheet similar to Exhibit 3-6, page 92, and calculate all of the ratios for The Sophisticated Touch, Co. b) Verify the change in 2017 Sophisticated Touch, Co.'s ROE using the Du Pont method. c) Using the Altman's model for privately held firms and public ones, calculate the Z-score for The Sophisticated Touch, Co. Assume that the market value of equity is $1,500,000: $1,250,000: $1,000,000; $850,000, and $700,000 for the years 2017, 2016, 2015, 2014, and 2013 respectively. d) Calculate the economic profit for these years and compare it to net income. Assume that the WACC is 12% each year. e) The staff at The Sophisticated Touch, Co. wants to perform a trend analysis with the data generated in the previous sections of this problem. Create a line chart showing each category of ratios from 2013 to 2017. Make sure to title the chart and label the axes. Also make a line chart of the Altman's model for private and public firms from 2013 to 2017
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started