Reference no: EM132215833

Assignment -

Step 1: Compare Business Performance Using Financial Statements

For this assignment, please complete the Project 3 Excel Workbook with information from the income statement, balance sheet, and statement of cash flow portions of Choice Hotels' and Marriott International's 10-K reports. The file contains instructions, an income statement template, balance sheet template, and a cash flow template.

Step 2: Analyze Cost and Investment Decisions

Using the same Project 3 Excel Workbook you used in Step 1, complete the Cost and Investing worksheet. The worksheet contains information that will aid in comparing the cost allocation methods for building guest rooms for Choice Hotels' franchise owners.

Step 3: Complete a Capital Budget and Profitability Analysis

Using the same Project 3 Excel Workbook you used in Steps 1 and 2, complete the Budgeting and Profitability worksheets, where you will calculate the quick ratio, acid test ratio, debt ratio, basic earnings power ratio, return on equity, and return on assets ratios and answer questions to determine if the equity firm should acquire Choice Hotels or Marriott International.

Step 4: Prepare a Report to Management

At the conclusion of your project, Frank requests a report based on your analysis and recommendations in the previous steps. He is planning on using this report to provide the client, Choice Hotels, with guidance on a potential acquisition. This report, along with citations for any sources you use, should be about three to five pages. The report should highlight your analysis and recommendations based on the work you completed in the workbook. Be creative and use charts, graphs, or any other tools you feel would be useful to convey your analysis and recommendations.

Attachment:- Assignment Files.rar