Analyzing Financial Reports

profilenbroomstqrq
Project3ChoiceHotelsWorkbook21882.xlsx

Instructions

Instructions Read and follow these instructions to complete the workbook. 1. To complete the Income Statement worksheet, Balance Sheet worksheet, and Cash Flow worksheet: a. Use the data you already collected in Project 2 to fill in the Choice Hotels table. b. Collect Marriott International's 10-K data from the Securities Exchange Commission website. c. Complete the percent change table on the right side of the workbook. (In the Balance sheet workbook, provide data only for the requested totals.) d. Answer the questions in the space given. 2. Given the supplied data in the Cost and Investing worksheet, answer the questions in the space provided. 3. To complete the Budgeting worksheet and Profitability worksheet:      a. Solve the ratios provided. b. Answer the questions in the space given.

Income Statement

CHH 2017 10-K Report CHH 2016 10-K Report MAR 2017 10-K Report MAR 2016 10-K Report
Choice Hotels 10-K Marriott International 10-K
2017 2016 (2017/2016)-1 2017 2016 (2017/2016)-1
Account Name 2017 10-K 2016 10-K2 Percent change from 2016 to 2017 Account Name 2017 10-K 2016 10-K2 Percent change from 2016 to 2017
REVENUES REVENUES
Royalty fees $ 345,302 $ 320,547 Base management fees $ 1,102 $ 806
Initial franchise and relicensing fees $ 26,262 $ 23,953 Franchise fees $ 1,618 $ 1,169
Procurement services $ 34,661 $ 31,226 Incentive management fees $ 607 $ 425
Marketing and reservation system $ 567,083 $ 525,716 Owned, leased, and other revenue $ 1,802 $ 1,126
Other $ 34,048 $ 23,199 Cost reimbursements $ 17,765 $ 13,546
Total revenues $ 1,007,356 $ 924,641 Total revenue $ 22,894 $ 17,072
OPERATING EXPENSES OPERATING COSTS AND EXPENSES
Selling, general and administrative $ 163,377 $ 148,728 Owned, leased, and other-direct $ 1,427 $ 900
Depreciation and amortization $ 12,431 $ 11,705 Reimbursed costs $ 17,765 $ 13,546
Marketing and reservation system $ 567,083 $ 525,716 Depreciation, amortization, and other $ 290 $ 168
Total operating expenses $ 742,891 $ 686,149 General, administrative, and other $ 894 $ 704
Gain (loss) on sale of assets, net $ (32) $ 403 Merger-related costs and charges $ 159 $ 386
Operating income $ 264,433 $ 238,895 Costs and Expenses, Total $ 20,535 $ 15,704
Operating income $ 2,359 $ 1,368
OTHER INCOME AND EXPENSES, NET Gains and other income, net $ 688 $ 5
Interest expense $ 45,039 $ 44,446 Interest expense $ (288) $ (234)
Interest income $ (5,920) $ (3,535) Interest income $ 38 $ 35
Other gains $ (3,229) $ (1,504) Equity in earnings $ 39 $ 10
Equity in net (income) loss of affiliates $ 4,546 $ (492)
Total other income and expenses, net $ 40,436 $ 38,915
Income before income taxes $ 223,997 $ 199,980 Income before income taxes $ 2,836 $ 1,184
Income taxes $ 109,104 $ 60,609 Provision for income taxes $ (1,464) $ (404)
Net income $ 114,893 $ 139,371 Net income $ 1,372 $ 780

Questions: 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?

Answer Questions 1 to 3 here.

https://www.sec.gov/Archives/edgar/data/1046311/000104631118000006/0001046311-18-000006-index.htm https://www.sec.gov/Archives/edgar/data/1046311/000104631117000006/0001046311-17-000006-index.htm https://www.sec.gov/Archives/edgar/data/1048286/000162828018001756/0001628280-18-001756-index.htm https://www.sec.gov/Archives/edgar/data/1048286/000162828017001506/0001628280-17-001506-index.htm

Balance Sheet

CHH 2017 10-K Report CHH 2016 10-K Report MAR 2017 10-K Report MAR 2016 10-K Report
Account name 2017 2016 (2017/2016)-1 Account name 2017 2016 (2017/2016)-1
ASSETS CHH 2017 10-K Report CHH 2016 10-K Report Percent change from 2016 to 2017 ASSETS MAR 2017 10-K Report MAR 2016 10-K Report Percent change from 2016 to 2017
Current assets Current assets
Cash and cash equivalents $ 235,336.00 $ 202,463.00 Cash and equivalents $ 383.00 $ 858.00
Receivables $ 125,452.00 $ 107,336.00 Accounts and notes receivable, net $ 1,991.00 $ 1,695.00
Income taxes receivable $ - 0 $ 316.00 Prepaid expenses and other $ 224.00 $ 230.00
Notes receivable, net of allowance $ 13,904.00 $ 7,873.00 Assets held for sale $ 149.00 $ 588.00
Other current assets $ 28,241.00 $ 26,885.00 Assets, current, total $ 2,747.00 $ 3,371.00
Total current assets $ 402,933.00 $ 344,873.00 Property and equipment, net $ 1,793.00 $ 2,335.00
Property and equipment, at cost, net $ 83,374.00 $ 84,061.00 Intangible assets
Goodwill $ 80,757.00 $ 78,905.00 Intangible assets $ 8,805.00 $ 9,270.00
Intangible assets, net $ 14,672.00 $ 15,738.00 Goodwill $ 9,207.00 $ 7,598.00
Notes receivable, net of allowances $ 147,993.00 $ 110,608.00 Goodwill and intangible assets, net, total $ 18,012.00 $ 16,868.00
Investments, employee benefit plans, at fair value $ 20,838.00 $ 16,975.00 Equity and cost method investments $ 740.00 $ 728.00
Investments in unconsolidated entities $ 134,226.00 $ 94,839.00 Notes receivable, net $ 142.00 $ 245.00
Deferred income taxes $ 13,335.00 $ 52,812.00 Deferred tax assets $ 93.00 $ 116.00
Other assets $ 29,479.00 $ 53,657.00 Other noncurrent assets $ 421.00 $ 477.00
Total assets $ 927,607.00 $ 852,468.00 Total assets $ 23,948.00 $ 24,140.00
LIABILITIES AND SHAREHOLDERS EQUITY CHH 2017 10-K Report CHH 2016 10-K Report Percent change from 2016 to 2017 LIABILITIES AND SHAREHOLDERS EQUITY MAR 2017 10-K Report MAR 2016 10-K Report Percent change from 2016 to 2017
Current liabilities Current liabilities
Accounts payable $ 63,540.00 $ 48,071.00 Current portion of long-term debt $ 398.00 $ 309.00
Accrued expenses and other current liabilities $ 85,838.00 $ 80,388.00 Accounts payable $ 780.00 $ 687.00
Deferred revenue $ 141,111.00 $ 133,218.00 Accrued payroll and benefits $ 1,227.00 $ 1,174.00
Current portion of long-term debt $ 1,232.00 $ 1,195.00 Liability for guest loyalty programs $ 2,064.00 $ 1,866.00
Income taxes payable $ 2,776.00 $ 796.00 Accrued expenses and other $ 1,541.00 $ 1,111.00
Total current liabilities $ 294,497.00 $ 263,668.00 Liabilities, current, total $ 6,010.00 $ 5,147.00
Long-term debt $ 725,292.00 $ 839,409.00 Long-term debt $ 7,840.00 $ 8,197.00
Deferred compensation and retirement plan obligations $ 25,566.00 $ 21,595.00 Liability for guest loyalty programs $ 2,876.00 $ 2,675.00
Income taxes payable $ 29,041.00 $ - 0 Deferred tax liabilities $ 604.00 $ 1,020.00
Deferred income taxes $ 39.00 $ 292.00 Other noncurrent liabilities $ 2,887.00 $ 1,744.00
Other liabilities $ 65,274.00 $ 38,853.00
Total liabilities $ 1,139,709.00 $ 1,163,817.00 Shareholders’ equity
Class A Common Stock $ 5.00 $ 5.00
Commitments and Contingencies Additional paid-in-capital $ 5,770.00 $ 5,808.00
Common stock $ 951.00 $ 951.00 Retained earnings $ 7,391.00 $ 6,501.00
Additional paid-in-capital $ 182,448.00 $ 159,045.00 Treasury stock, at cost $ (9,418.00) $ (6,460.00)
Accumulated other comprehensive loss $ (4,699.00) $ (8,522.00) Accumulated other comprehensive loss $ (17.00) $ (497.00)
Treasury stock $ (1,064,573.00) $ (1,070,383.00) Stockholders' deficit $ 3,731.00 $ 5,357.00
Retained earnings $ 673,771.00 $ 607,560.00 Liabilities and deficit, total $ 23,948.00 $ 24,140.00
Total shareholders equity $ (212,102.00) $ (311,349.00)
Total liabilities and shareholders equity $ 927,607.00 $ 852,468.00

Questions: 1. Based on your horizontal analysis of Choice Hotels' and Marriott International's total assets, total liabilities, and total equity, which company is most attractive for an acquisition by the equity firm and why? 2. What advice would you give to the client, Choice Hotels, to reduce its total liabilities?

Answer Questions 1 to 3 here.

https://www.sec.gov/Archives/edgar/data/1046311/000104631118000006/0001046311-18-000006-index.htm https://www.sec.gov/Archives/edgar/data/1046311/000104631117000006/0001046311-17-000006-index.htm https://www.sec.gov/Archives/edgar/data/1048286/000162828018001756/0001628280-18-001756-index.htm https://www.sec.gov/Archives/edgar/data/1048286/000162828017001506/0001628280-17-001506-index.htm

Cash Flow

CHH 2017 10-K Report CHH 2016 10-K Report MAR 2017 10-K Report MAR 2016 10-K Report
10-K 10-K
Choice Hotels 2017 2016 (2017/2016)-1 Marriott International 2017 2016 (2017/2016)-1
CASH FLOWS FROM OPERATING ACTIVITIES 2017 10-K 2016 10-K Percent change from 2016 to 2017 CASH FLOWS FROM OPERATING ACTIVITIES 2017 10-K 2016 10-K Percent change from 2016 to 2017
Net income $ 114,893 $ 139,371 Net income $ 1,372 $ 780
Adjustments to reconcile net income to net cash provided by operating activities Adjustments to reconcile to cash provided by operating activities:
Depreciation and amortization $ 12,431 $ 11,705 Depreciation, amortization, and other $ 290 $ 168
Loss (gain) on disposal of assets $ 52 $ (346) Share-based compensation $ 181 $ 212
Provision for bad debts, net $ 3,440 $ 2,151 Income taxes $ 828 $ 76
Non-cash stock compensation and other charges $ 23,340 $ 15,458 Liability for guest loyalty program $ 378 $ 343
Non-cash interest and other (income) loss $ (772) $ 1,059 Merger-related charges $ (124) $ 113
Deferred income taxes $ 39,320 $ (10,542) Working capital changes $ 81 $ (77)
Equity in net losses from unconsolidated joint ventures, less distributions received $ 6,579 $ 1,025 (Gain) loss on asset dispositions $ (687) $ 1
Changes in assets and liabilities, net of acquisition Other $ 117 $ 66
Receivables $ (23,126) $ (21,919) Net cash provided by operating activities $ 2,436 $ 1,682
Advances to/from marketing and reservation system activities, net $ 51,722 $ (21,449)
Forgivable notes receivable, net $ (30,638) $ (17,410) INVESTING ACTIVITIES
Accounts payable $ 12,455 $ (13,689) Acquisition of a business, net of cash acquired $ - 0 $ (2,412)
Accrued expenses and other current liabilities $ 7,176 $ 5,225 Capital expenditures $ (240) $ (199)
Income taxes payable/receivable $ 31,383 $ 5,775 Dispositions $ 1,418 $ 218
Deferred revenue $ 7,797 $ 61,646 Loan advances $ (93) $ (32)
Other assets $ 1,521 $ (8,703) Loan collections $ 187 $ 67
Other liabilities $ (199) $ 2,678 Contract acquisition costs $ (189) $ (80)
Net cash provided by operating activities $ 257,374 $ 152,035 Redemption of debt security $ - 0 $ - 0
Other $ (63) $ 29
CASH FLOWS FROM INVESTING ACTIVITIES Net cash provided by (used in) investing activities $ 1,020 $ (2,409)
Investment in property and equipment $ (23,437) $ (25,191)
Investment in intangible assets $ (2,517) $ (2,580) FINANCING ACTIVITIES
Proceeds from sales of assets $ 1,000 $ 11,462 Commercial paper/Credit Facility, net $ 25 $ 1,365
Acquisitions of real estate $ - 0 $ (28,583) Issuance of long-term debt $ - 0 $ 1,482
Business acquisition, net of cash acquired $ - 0 $ (1,341) Repayment of long-term debt $ (310) $ (326)
Contributions to equity method investments $ (50,554) $ (34,661) Issuance of Class A Common Stock $ 6 $ 34
Distributions from equity method investments $ 4,569 $ 3,700 Dividends paid $ (482) $ (374)
Purchases of investments, employee benefit plans $ (2,447) $ (1,661) Purchase of treasury stock $ (3,013) $ (568)
Proceeds from sales of investments, employee benefit plans $ 2,245 $ 1,911 Share-based compensation withholding taxes $ (157) $ (100)
Issuance of mezzanine and other notes receivable $ (19,738) $ (32,604) Other $ - 0 $ (24)
Collections of mezzanine and other notes receivable $ 655 $ 11,070 Net cash (used in) provided by financing activities $ (3,931) $ 1,489
Other items, net $ 109 $ 11 (DECREASE) INCREASE IN CASH AND EQUIVALENTS $ (475) $ 762
Net cash used by investing activities $ (90,115) $ (98,467) CASH AND EQUIVALENTS, beginning of period $ 858 $ 96
CASH AND EQUIVALENTS, end of period $ 383 $ 858
CASH FLOWS FROM FINANCING ACTIVITIES
Proceeds from the issuance of long-term debt $ - 0 $ - 0
Net (repayments) borrowings pursuant to revolving credit facilities $ (115,003) $ 25,795
Principal payments on long-term debt $ (660) $ (988)
Proceeds from other debt agreements $ - 0 $ 550
Debt issuance costs $ - 0 $ (284)
Purchases of treasury stock $ (9,807) $ (35,926)
Dividends paid $ (48,651) $ (46,182)
Proceeds from transfer of interest in notes receivable $ 24,237 $ - 0
Proceeds from exercise of stock options $ 14,107 $ 12,951
Net cash used by financing activities $ (135,777) $ (44,084)
Net change in cash and cash equivalents $ 31,482 $ 9,484
Effect of foreign exchange rate changes on cash and cash equivalents $ 1,391 $ (462)
Cash and cash equivalents at beginning of period $ 202,463 $ 193,441
Cash and cash equivalents at end of period $ 235,336 $ 202,463

Questions: 1. Based on your horizontal analysis of Choice Hotels' and Marriott International's operating, investing, and financing activities, which company is most attractive for an acquisition by the equity firm and why? 2. What advice would you give to the client, Choice Hotels, to improve their investing and financing activities?

Answer Questions 1 to 3 here.

https://www.sec.gov/Archives/edgar/data/1046311/000104631118000006/0001046311-18-000006-index.htm https://www.sec.gov/Archives/edgar/data/1046311/000104631117000006/0001046311-17-000006-index.htm https://www.sec.gov/Archives/edgar/data/1048286/000162828018001756/0001628280-18-001756-index.htm https://www.sec.gov/Archives/edgar/data/1048286/000162828017001506/0001628280-17-001506-index.htm

Cost and Investing

Choice Hotels Sales, Production, and Cost Information Overhead Costs
Room Type Standard Guest Room Junior Suite Presidential Suite Type Cost
Volume 150 110 25 Depreciation $3,200,000
Price $140,000 $240,000 $1,050,000 Maintenance $1,800,000
Unit costs Purchasing $320,000
Direct materials $30,000 $92,000 $310,000 Inspection $850,000
Direct labor $54,000 $85,000 $640,000 Indirect materials $490,000
Manufacturing $30,000 $30,000 $30,000 Supervision $1,700,000
overhead Supplies $190,000
Total unit cost $114,000 $207,000 $980,000 Total manufacturing overhead cost $8,550,000
Unit gross profit $26,000 $33,000 $70,000 Note: Manufacturing overhead costs are fixed. They do not vary with the volume of manufacturing activity.
Direct labor hours 1,200 1,300 5,940
Rate per hour $45.00 $65.38 $107.74
Choice Hotels’ controller developed the following data for use in activity-based costing: Complete the calculations to help you answer the questions below
Manufacturing overhead Amount Cost driver Standard Guest Room Junior Suite Presidential Suite Total Square Feet Cost per square foot Standard Guest room Junior Suite Presidential Suite Check
Depreciation $3,200,000 Square feet 50,000 30,000 30,000 110,000 square feet $ 29.09 $ 1,454,545 $ 872,727 $ 872,727 $ 3,200,000
Maintenance $1,800,000 Direct labor hours 180,000 143,000 148,500
Purchasing $320,000 # of purchase orders 2,500 1,500 9,000
Inspection $850,000 # of inspections 1,000 850 3,500
Indirect $490,000 Units manufactured 150 110 25
materials
Supervision $1,700,000 # of inspections 1,000 850 3500
Supplies $190,000 Units manufactured 150 110 25
Total $8,550,000 234,800 176,420 194,550

Questions: 1. What would be the cost per unit of producing Guest Room Set A using factory space as the allocation basis? What would be the cost per unit using labor as the allocation basis? 2. What would be the cost per unit of producing Guest Room Set A using activity-based costing? 3. Should Choice Hotels build Guest Room Set A or Guest Room Set B? Why? 4. Should Choice Hotels build or purchase the guest room furniture? Why?

Choice Hotels produces three models of guest rooms: the standard guest room, Junior Suite, and Presidential Suite. The Standard Guest Room comes with basic furniture, bathroom plan, and amenities. It sells for $140,000 to franchise hotels. The Junior Suite model is larger and includes an enhanced furniture selection, upgraded bathroom fixtures, more comfortable bedding. The guest room is considered an upgrade from the standard guestroom model. The Junior Suite sells for $240,000 to franchise hotels. The Presidential Suite model is a custom-made guest room with floors and walls constructed from specialty wood. The drapes are made from the traditional flax-based canvass. It has the look and feel of a room in the White House, with modern comforts and security. The Presidential Suite sells for $1,050,000 to franchise hotels. Workers who build the Presidential Suite are specialized craftsmen. They earn twice the hourly rate of those working on the Standard Guest Room and Junior Suite models. The labor rate is fully burdened to include benefits. Most of Choice Hotels’ guest room sales come from the Standard Guest Room and the Junior Suite, but sales of the Presidential Suite model have been growing. The company's sales, production, and cost information for last year is provided to the right:

Questions: 3. Use activity-based costing to allocate the costs of overhead per unit and in total to each guest room type. Show all supporting calculations in the space provided. 4. Calculate the cost of one Presidential Suite using activity-based costing.

Questions: 1. The cost-allocation system Choice Hotels has been using allocates over 90 percent of overhead costs to the Standard Guest Room and the Junior Suite, because over 90 percent of the models produced were one of these two models. How much overhead was allocated to each of the three models last year? Discuss why this might not be an accurate way to assign overhead costs to products. 2. Choice Hotels' production manager proposes allocating overhead by direct labor hours instead, since the different models require different amounts of labor. How much overhead would be allocated to each guest room (per unit and in total) using this method? Show all supporting calculations.

Questions: 5. At the current selling price, is the company covering its true cost of production of the Presidential Suite? Briefly discuss. 6. What should price should Choice Hotels charges for the Presidential Suite? 7. Assume that the Presidential Suite has the same profit margin as the Standard Guest Room. What should its selling price be? Show all calculations. 8. What should Choice Hotels do if the quantity of the Presidential Suite Guest Rooms sold at the new price falls to 10 per year? 9. What should Choice Hotels do if the price of the Presidential Suite cannot exceed $1,050,000? 10. At a selling price of $1,050,000 each, what is the breakeven unit volume for the Presidential Suite?

Answer Questions 1 to 2 here.

Answer Questions 3 to 4 here.

Answer Questions 5 to 10 here.

Budgeting

Choice Hotels Marriott International (2017/2016)-1 (2017/2016)-1
Ratios 2017 2016 2017 2016 Percent Change from 2016 to 2017 Percent Change from 2016 to 2017
Quick ratio = (cash + cash equivalence + receivables) / current liabilities
Acid test ratio = current assets / current liabilities
Debt ratio = total liabilities / total assets

Questions: 1. Quick ratios between 0.5 and 1 are considered satisfactory, as long as the collection of receivables is not expected to slow. Does the client, Choice Hotels, have enough current assets to meet the payment schedule of current liabilities with a margin of safety? 2. Which of the above ratios would you use to determine which company, Choice Hotels or Marriott International, is more attractive for an acquisition by the equity firm and why?

Answer Questions 1 to 3 here.

Profitability

Choice Hotels Marriott International (2017/2016)-1 (2017/2016)-1
Ratios 2017 2016 2017 2016 Percent Change from 2016 to 2017 Percent Change from 2016 to 2017
Return on equity (ROE) = net income / total equity
Return on assets (ROA) = net income / total assets

Questions: 1. The return on assets ratio tells us the profit generated by each dollar in assets. You will want to compare this ratio to Choice Hotels' historical performance and to Marriott International to understand if it is an acceptable ratio. Is the return on assets ratio acceptable? Why or why not? 2. Which of the above ratios would you use to determine which company, Choice Hotels or Marriott International, is more attractive for an acquisition? Why? 3. Based on the financial statement analysis, earnings per share analysis, budgeting ratios, and the above profitability ratios, which company would you invest in and why?

Answer Questions 1 to 3 here.