Question

In: Finance

Based on your horizontal analysis of Choice Hotels' and Marriott International's total revenue, total expenses, and net income


1. Based on your horizontal analysis of Choice Hotels' and Marriott International's total revenue, total expenses, and net income, which company would be a more attractive target for an acquisition by the equity firm and why?

2. Given the changes in total revenue, operating income, and net income from 2016 to 2017, did Choice Hotels or Marriott International experience more change? Which area (total revenue, operating income, or net income) changed most?

Solutions

Expert Solution

Source of data for the table below:

  1. Annual Report, Form 10 K filing for the fiscal year 2016 & 2017 for Choice Hotel
  2. Annual Report, Form 10 K filing for the fiscal year 2016 & 2017 for Marriott International

Please see the tables below for Horizontal analysis

In the data below, total revenues and net income are directly observation in the Income Statement. Total expenses are not directly available and the same have been back calculated as Total Revenues - Net Income

Change has been calculated as = 2017 figure / 2016 figure - 1

Choice Hotel
Parameter 2017 2016 Change
Total Revenue                1,007,356        924,641 8.95%
Total Expenses                   892,463        785,270 13.65%
Net Income                   114,893        139,371 -17.56%
Marriott International
Parameter 2017 2016 Change
Total Revenue                     22,894           17,072 34.10%
Total Expenses                     21,522           16,292 32.10%
Net Income                       1,372                780 75.90%

1. Based on your horizontal analysis of Choice Hotels' and Marriott International's total revenue, total expenses, and net income, which company would be a more attractive target for an acquisition by the equity firm and why?

  • Marriott International is showing a healthy increase across total revenues and net income
  • Choice Hotels has less than 10% growth rate in revenues while its net income has slipped

Under these situations and basis our analysis, Marriott International would be a more attractive target for an acquisition by the equity firm.

2. Given the changes in total revenue, operating income, and net income from 2016 to 2017, did Choice Hotels or Marriott International experience more change? Which area (total revenue, operating income, or net income) changed most?

Marriott International experienced a higher change.

And the highest change was seen in case of net income, It has gone up by 75.90% in one year.


Related Solutions

Determine the effect of the following errors on a company's total revenue, total expenses, and net...
Determine the effect of the following errors on a company's total revenue, total expenses, and net income. Indicate the effect by selecting Overstated (too much), Understated (too little),or Not Affected. Transactions Total Revenue Total Expenses Net Income Example: A check for $325 was written to pay on account. The accountant debited Rent Expense for $325 and credited Cash for $325. Not Affected Overstated Understated a. $615 was received on account from customers. The accountant debited Cash for $615 and credited...
1) Net income: A) is calculated by subtracting total expenses and total dividends from total revenues....
1) Net income: A) is calculated by subtracting total expenses and total dividends from total revenues. B) occurs when total revenues are less than total expenses. C) is often referred to as the "bottom line" on an income statement. D) decreases total stockholders' equity. 2) On January 1, 2017, total assets for Wininger Technologies were $140,000; on December 31, 2017, total assets were $155,000. On January 1, 2017, total liabilities were $111,000; on December 31, 2017, total liabilities were $118,000....
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $693,095 $579,000 Cost of goods sold 518,000 370,000 Gross profit $175,095 $209,000 Selling expenses $73,500 $49,000 Administrative expenses 42,160 31,000 Total operating expenses $115,660 $80,000 Income from operations $59,435...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $815,178 $741,000 Cost of goods sold 573,400 470,000 Gross profit $241,778 $271,000 Selling expenses $79,050 $62,000 Administrative expenses 46,720 39,000 Total operating expenses $125,770 $101,000 Income from operations $116,008...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $505,848 $446,000 Cost of goods sold 358,400 280,000 Gross profit $147,448 $166,000 Selling expenses $51,300 $38,000 Administrative expenses 30,050 24,000 Total operating expenses $81,350 $62,000 Income from operations $66,098...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $501,094 $418,000 Cost of goods sold 364,000 260,000 Gross profit $137,094 $158,000 Selling expenses $52,500 $35,000 Administrative expenses 29,920 22,000 Total operating expenses $82,420 $57,000 Income from operations $54,674...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $526,224 $456,000 Cost of goods sold 382,800 290,000 Gross profit $143,424 $166,000 Selling expenses $53,200 $38,000 Administrative expenses 30,910 24,000 Total operating expenses $84,110 $62,000 Income from operations $59,314...
Horizontal Analysis of Income Statement For 20Y2, Macklin Inc. reported a significant decrease in net income....
Horizontal Analysis of Income Statement For 20Y2, Macklin Inc. reported a significant decrease in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $867,160 $731,000 Cost of goods sold (634,800) (460,000) Gross profit $232,360 $271,000 Selling expenses $(91,450) $(62,000) Administrative expenses (52,340) (39,000) Total operating expenses $(143,790) $(101,000) Operating income $88,570...
Based on the following transactions, calculate the revenues, expenses, and net income that would be reported...
Based on the following transactions, calculate the revenues, expenses, and net income that would be reported on (a) the cash basis and (b) the accrual basis: i. Inventory costing $70,000 was purchased on account. ii. Inventory costing $60,000 was sold for $100,000. Eighty percent of the sales were for cash. iii. Cash collected from credit customers (those who bought on account) totalled $20,000. iv. A lease was signed at the beginning of the year, requiring monthly payments of $1,000. The...
1. Based on the following transactions, calculate the revenues, expenses, and net income that would be...
1. Based on the following transactions, calculate the revenues, expenses, and net income that would be reported on (a) the cash basis and (b) the accrual basis: i. Inventory costing $70,000 was purchased on account. ii. Inventory costing $60,000 was sold for $100,000. Eighty percent of the sales were for cash. iii. Cash collected from credit customers (those who bought on account) totalled $20,000. iv. A lease was signed at the beginning of the year, requiring monthly payments of $1,000....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT