1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
a_sh-v [17]
3 years ago
10

Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentag

es for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016.
Computer Tycoon, Inc.
Income Statements
For the Year Ended December 31
Change in
2016 2015 Dollars Percentage
Sales Revenue $108,000 $132,000 %
Cost of Goods Sold 64,000 74,700 %
Gross Profit 44,000 57,300 %
Selling, General, and Administrative
Expenses 36,800 38,600 %
Interest Expense 580 515 %
Income before Income Tax Expense 6,620 18,185 %
Income Tax Expense 1,500 5,800 %
Net Income $5,120 $12,385 %
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.
Required:
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?
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.
Business
1 answer:
Iteru [2.4K]3 years ago
8 0

Answer:

Computer Tycoon, Inc.

1. Horizontal Analysis, calculating the year-over-year changes in each line:

Computer Tycoon, Inc. Income Statements  For the Year Ended December 31    

                                                      2016         2015            Dollars      %

Sales Revenue                             $108,000  $132,000  -$24,000  -18.2%

Cost of Goods Sold                         64,000      74,700   -$10,700  -14.3%

Gross Profit                                      44,000     57,300   -$13,300  -23.2%

Selling, General, & Administrative

                         Expenses               36,800     38,600   -$1,800      -4.7%

Interest Expense                                  580           515     $65         +12.6%

Income before Income Tax Exp.      6,620       18,185  -$11,565     -63.6%

Income Tax Expense                         1,500       5,800   -$4,300     -74.1%

Net Income                                      $5,120    $12,385   -$7,265    -58.7%

2-A. Vertical analysis by expressing each line as a percentage of total revenues:

Computer Tycoon, Inc. Income Statements  For the Year Ended December 31    

                                                      2016            %             2015             %

Sales Revenue                             $108,000     100        $132,000    100

Cost of Goods Sold                         64,000      59             74,700     56.6

Gross Profit                                      44,000       41             57,300     43.4

Selling, General, & Administrative

                         Expenses               36,800       34           38,600       29.2

Interest Expense                                  580       0.5                515      0.4

Income before Income Tax Exp.      6,620        6              18,185      13.8

Income Tax Expense                         1,500       1.4             5,800       4.4

Net Income                                      $5,120       4.7         $12,385      9.4

2-B No. It made less profit per dollar of sales in 2016 compared to 2015.

Explanation:

a) Horizontal analysis is the analysis of financial statements to show changes in the amounts of corresponding financial statement items over a period of time.  It is used to evaluate the trend situations, using financial statements for two or more periods.

b) Vertical analysis is another technique for analyzing financial statements with each line item being listed as a percentage of a base figure within the statement.  For income statement, the base figure is usually the Sales Revenue, while for balance sheet, the base figure is the total assets.

You might be interested in
Trout Lumber Yard has a current accounts receivable balance of $447,516. Credit sales for the year just ended were $8,105,305. a
musickatia [10]

Answer:

Trout Lumber Yard

a. The receivables turnover = Net Credit Sales/Average Receivables

= $8,105,305/$447,516

= 18 times per year

b. The Days' Sales in Receivables = Average Receivables/Credit Sales * 365

= $447,516/$8,105,305 * 365

= 20.15 days

c. On the average, it took 20.15 days (365/18.11) for credit customers to pay off their accounts during the past year.

Explanation:

a) Data and Calculations:

Accounts receivable balance = $447,516

Credit sales for the year just ended = $8,105,305

The receivables turnover = Net Credit Sales/Average Receivables

= $8,105,305/$447,516

= 18.11 times

The Days' Sales in Receivables = Average Receivables/Credit Sales * 365

= $447,516/$8,105,305 * 365

= 20.15 days

8 0
2 years ago
You find some public records about customer satisfaction in the company's archive. What type of data is this called?
Iteru [2.4K]

The  type of data is this called raw data when You find some public records about customer satisfaction in the company's archive.

Raw data collection is typically not ready for analysis, but when organized and cleaned, it becomes data. Processed data is the type of data that has been processed from raw data.

The term raw data is most commonly used to refer to information collected for research studies before the information is transformed or analyzed in any way. This term may apply to data that has been collected or cleaned once but has not been further transformed or analyzed.

A list of all purchases made at the store during the month, but without further structure or analysis. A video captured every second by a surveillance camera at night. The performance of all his students in the district for one quarter. List of all movies streamed by video streaming companies.

Learn more about  public records at

brainly.com/question/27583809

#SPJ4

8 0
1 year ago
TP2.
Karo-lina-s [1.5K]

Answer and explanation:

As their name describes, <em>nonprofit entities</em> are organizations whose main plan is not to have revenues out of their operations. They usually provide social services to different sectors of the population and can handle their operations mainly thanks to charity and donations. While making their budgets, these organizations cannot estimate their revenues since they cannot take donations for granted. Instead, they estimate their expenses since they will be incurred for sure.

8 0
2 years ago
X-Mart uses the perpetual inventory system to account for its merchandise. On May 1, it purchased $400 of merchandise on account
AlexFokin [52]

Answer:

The journal entries to record the whole purchase and payment process are:

May 1, purchase of merchandise on account

Dr Merchandise inventory 400

    Cr Accounts payable 400

May 3, defective merchandise returned

Dr Accounts payable 50

    Cr Purchase returns and allowances 50

Dr Purchase returns and allowances 50

    Cr Merchandise inventory 50

May 10? payment of merchandise account

Dr Accounts payable 350

    Cr Cash 343

    Cr Purchases discounts 7

6 0
3 years ago
Maxim County just completed construction of a new town hall to be used for its governmental offices. The employees have moved in
Svet_ta [14]

Answer:

The answers are:

B) Transfer the remaining funds to the debt service fund which will be handling the long-term debt incurred for the construction of the building.

C) Return the excess to the source of the restricted funding.

Explanation:

The fund balance of $12,000, means that the money left over was $12,000. When a government entity's project has a left over or excess, called surplus, it must first return it to the debt service fund.

At the end of the construction project if any money is left over, it must be returned to the source of the restricted funding.  

5 0
3 years ago
Other questions:
  • Xuechen graduated from culinary school at the top of her class, and signed an employment contract to work as a chef for one of C
    13·2 answers
  • Drew monthly net income is 800 what is the maximum he should use on debt payments
    10·1 answer
  • What motivates high school students to join professional organizations?
    11·1 answer
  • Holly took a prospective client to dinner, and after agreeing to a business deal, they went to the theater. Holly paid $290 for
    8·1 answer
  • The Lory Company had net earnings of $127,000 this past year. Dividends of $38,100 were paid. The company's equity was $1,587,50
    6·1 answer
  • Luis refuses to shop at big box stores, preferring to do his shopping locally. He reads in the paper that one of these stores wi
    13·1 answer
  • award a scholarship of $30,000 each year. The family wants the yearly awards to continue indefinitely. Assume that the fund will
    15·1 answer
  • What are some simlarities between saving and investing?
    14·1 answer
  • A1 Co. has a process costing system. All materials are added when the process is first begun. At the beginning of May, there wer
    8·1 answer
  • If the federal reserve overstimulates the economy by increasing money growth too much, then inflation will?
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!