According to the producer price index database maintained by the Bureau of Labor Statistics, the averagecost of computer equipment fell 3.8 percent between January and December 2016.Required:ts1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed indollars and in percentages for the income statement of Computer Tycoon Inc. for the year endedDecember 31, 2016.2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues.2-b. Excluding income tax, interest, and operating expenses, did Computer Tycoon earn more profit perdollar of sales in 2016 compared to 2015?еВookHintPrintComplete this question by entering your answers in the tabs below.eferencesReq 1Reg 2AReg 2BConduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and inpercentages for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. (Decreases should beindicated by a minus sign. Round percentage values to 1 decimal place.)COMPUTER TYCOON, INC.Income StatementsFor the Year Ended December 31Change in20162015DollarsPercentageSales Revenue$114,000 $141.000%Cost of Goods Sold67,00077,100Gross Profit47,00063,900%Selling, General, and Administrative Expenses37,40039,800Interest Expense640545%Income before Income Tax Expense8,96023,555Income Tax Expense2,0006,400Net Income$6,960$17,155% According to the producer price index database maintained by the Bureau of Labor Statistics, the averagecost of computer equipment fell 3.8 percent between January and December 2016.Required:1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed indollars and in percentages for the income statement of Computer Tycoon Inc. for the year endedDecember 31, 2016.2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues.2-b. Excluding income tax, interest, and operating expenses, did Computer Tycoon earn more profit perdollar of sales in 2016 compared to 2015?Complete this question by entering your answers in the tabs below.Req 1Req 2AReq 2BConduct a vertical analysis by expressing each line as a percentage of total revenues. (Round percentage values to 1 decimalplace.)COMPUTER TYCOON, INC.Income StatementsFor the Year Ended December 3120162015Sales Revenue$114,000%141,000%%%%%%%Cost of Goods Sold67,000%77,100Gross Profit47,000%63,900Selling, General, and Administrative Expenses37,400%39,800Interest Expense640%545Income before Income Tax Expense8,960%23,555Income Tax ExpenseNet Income2,000%6,400$6,960%$17,155%< Req 1Req 2B >

Solution: Introduction: Horizontal Analysis which is also known as the trend analysis. It provides a…

1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax, interest, and operating expenses, did Computer Tycoon earn more profit per dollar of sales in 2016 compared to 2015?

1. Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2-a. Conduct a vertical analysis by expressing each line as a percentage of total revenues. 2-b. Excluding income tax, interest, and operating expenses, did Computer Tycoon earn more profit per dollar of sales in 2016 compared to 2015?

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter9: Responsibility Accounting And Decentralization

Section: Chapter Questions

Problem 8PB: The following revenue data were taken from the December 31, 2017, General Electric annual report...

See similar textbooks

Similar questions

According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018 relative to 2017? Required 2 2018 $ 105,000 62,500 42,500 36,500 3. Gonzalez reported average net fixed assets of $54,700 in 2018 and $45,600 in…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required 2 2018 $ 117,000 68,500 48,500 37,700 Year 670 10, 130 2,500 $ 7,630 2017 2018 2017 $ 145,500 Required: 1. Compute the times interest earned ratios for 2018 and 2017. 2. Does Gonzalez generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing? 78,300 67,200 40,400 Complete this question by entering your answers in the tabs below. 560 26,240 6,700 $ 19,540 Compute the times interest earned ratios for 2018 and 2017. (Round your answers to 1…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required 2 Required 3 2018 $ 105,000 62,500 42,500 36,500 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018 relative to 2017? 550 5,450 1,500 $ 3,950 3. Gonzalez reported average net fixed assets…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Gonzalez Industries for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required 1 Required 2 Required 3 2018 $ 105,000 62,500 Required: 1. Compute the gross profit percentage for each year. Assuming the change from 2017 to 2018 is the beginning of a sustained trend, is Gonzalez likely to earn more or less gross profit from each dollar of sales in 2019? 2. Compute the net profit margin for each year. Did Gonzalez do a better or worse job of controlling operating expenses in 2018 relative to 2017? 3. Gonzalez reported average net fixed assets of $54,700 in 2018 and $45,600 in…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Wizard Computers for the year ended December 31, 2018. Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income Required: 2018 $ 114,000 67,000 2017 $ 141,000 77,100 47,000 63,900 37,400 39,800 640 545 8,960 2,000 23,555 6,400 $ 6,960 $ 17,155 1. Compute the times interest earned ratios for 2018 and 2017. 2. Does Wizard generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the times interest earned ratios for 2018 and 2017. (Round your answers to 1 decimal place.) Times…
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Let’s see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2016 2015 Sales Revenue $ 120,000 $ 150,000 Cost of Goods Sold 70,000 79,500 Gross Profit 50,000 70,500 Selling, General, and Administrative Expenses 38,000 41,000 Interest Expense 700 575 Income before Income Tax Expense 11,300 28,925 Income Tax Expense 2,500 7,000 Net Income $ 8,800 $ 21,925 Required: Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each dollar of sales in 2017? Compute the net profit margin…
7 According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Let's see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2016 2015 Sales Revenue $113,000 66,500 46,500 $139,500 76,700 62,800 Cost of Goods Sold Gross Profit Вook Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense 37,300 39,600 630 540 Hint 8,570 2,000 $ 6,570 22,660 6,300 $ 16,360 Print Net Income erences Required: 1. Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each dollar of sales in 2017? 2. Compute the net profit margin for each year. Given your calculations here and in requirement 1, explain whether Computer…
7
A condensed income statement for Weber Associates and a partially completed vertical analysis follow. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). 2. Does Cost of Goods Sold, as a percentage of Net Revenues, represent better or worse performance in 2019 as compared to 2018? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). (Decreases should be indicated by a minus sign. Round your answers to the nearest whole percent.) Net Revenues Cost of Goods Sold Research and Development Expense Sales and Marketing Expense General and Administrative Expense Income from Operations Other…
Calculate gross profit, cost of goods sold, and selling price MBI, Inc., had sales of $600 million for fiscal 2016. The company’s gross profit ratio for that year was 31.2%.Required:a. Calculate the gross profit and cost of goods sold for MBI, Inc., for fiscal 2016.b. Assume that a new product is developed and that it will cost $1,634 to manufacture. Calculate the selling price that must be set for this new product if its gross profit ratio is to be the same as the average achieved for all products for fiscal 2016.c. From a management viewpoint, what would you do with this information?
On January 1 2020, South by Southwest Company used least squares regression analysis to estimate the total monthly payroll department cost of the company in 2020. The followings are the output from the regression analysis based on the observation of the payroll department cost( dependent variable) and the labor hours worked ( independent variable) for the last 20 months: Constant $18,000 r2 0.8924 X coefficient(s) $ 2.55 Required: BASED ON THE OUTPUT FROM THE REGRESSION ANALYSIS a. What is the total estimated fixed payroll department cost? b. What is the variable payroll department cost per labor hour? c. What is the estimate cost function of the payroll department cost? d. What is the coefficient of determination? Comment on the goodness of fit of the cost function? Plzz give all the ans
Use the following selected data from Success Systems' income statement for the three months ended March 31, 2014, and from its March 31, 2014, balance sheet to complete the requirements below: Computer services revenue $29,221 Net sales (of goods) $18,480 Total sales and revenue $47,701 Cost of goods sold $15,344 Net income $19,179 Quick assets $88,668 Current assets $96,904 Total assets $123,448 Current liabilities $970 Total liabilities $970 $122,478 Total equity Required: Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio. (Round your answers to 1 decimal place.)