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:
- Annual Report, Form 10 K filing for the fiscal year 2016 & 2017 for Choice Hotel
- 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.
jeff jeffy answered 2 years agoRelated 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
Latest Questions
- A neurologist needs to counsel a stroke victim and her husband about possible outcomes, treatment options,...
- Case Study: Personal Beliefs in the Workplace Don Shakow was a prominent professional who worked in...
- 1: Competency framework usage is the modern best practice in management. What is meant by competency...
- A 19.34 g mixture of sugar (C12H22O11) and table salt (NaCl) is dissolved in 231 g...
- Young and Company claims that its pressurized diving bell will, on average, maintain its integrity to...
- 1) Alternative compiled code sequence using instructions in classes A, B, C. What is the average...
- An asset is purchased on January 1 for $48,700. It is expected to have a useful...
ADVERTISEMENT