1. Conduct a vertical analysis (common-size analysis) for the income statements of Boatman Hotel for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Conduct a vertical analysis (common-size analysis) for the income statements of Boatman Hotel for the months ended March 31 and April 30, 2020. March March % April % Change in % Revenues: Rooms Food and Beverage Telecommunications Other Income Total Revenues Cost of Sales: Rooms Food and Beverages Telecommunications Other Income Total Cost of Sales Gross Profit: Rooms Food and Beverages Telecommunications Other Income Total Gross Profit Operating (Controllable) Expenses: Administration & General Marketing Franchise Fees Property Operations and Maintenance Utilities Total Operating Expenses Operating Income Other (Non-controllable) Expenses: Management Fee Property Taxes Reserve for Capital Improvements Insurance Interest Expense Total Non-controllable Expenses 375,236 186,253 4,213 46.879 130,256 142,516 3,453 35,648 311,873 244,980 43,737 760 11/231 11,605 41,219 21,005 37,456 32,156 143,441 April 425,105 176,523 6,901 75.004 131.984 5,326 49,654 154,987 135,216 4,123 41.213 335,539 270,118 41,307 1,203 8,441 18,256 44,362 24.032 38,612 36,459 161,721 0.69 7.65 100.00 50.91 39.99 7.14 0.12 1.83 1.89 6.73 3.43 6.11 5.25 23.42 6,145 6,425 1.00 25,613 25.613 4.18 18,321 20,153 2.99 6,852 1.13 78,450 12.24 137,493 21.55% Income Before Income Taxes (1) What was the Gross Profit Margin? Period 1: (2) Which Operating Expenses item had the highest %? (3) Which item had the highest change in % from Period 1 to Period 2? Period 2: 0.81 7.56 100.00 51.10 41.14 6.29 0.18 1.29 2.78 6.76 3.66 5.88 5.55 24.63 0.98 3.90 3.07 1.04 11.95 20.94% 0.12 -0.09 0.00 0.19 1.15 -0.85 0.06 -0.55 0.89 0.03 0.23 -0.23 0.30 1.21 -0.02 -0.28 0.08 -0.08 -0.30 -0.61% 2. Conduct a horizontal analysis (comparative analysis) for the balance sheets of Gian's Italian Cuisine as of November 30 and December 31, 2016. November December S change % change Current Assets: Cash Accounts Receivable Food Inventory Beverage Inventory Prepaid Rent Total Current Assets Fixed Assets: Furniture, Fixture & Equipment (FF&E) Accumulated Depreciation (FF&E) Building Long term Investments Long Term Assets Total Assets Current Liabilities: Accounts Payable Accrued Payroll Accrued Taxes Total Current Liabilities Long Term Debt Total Liabilities Owner's Equity Retained Earnings 9,000 10,000 4,000 6,000 18,000 7,500 (3.030) 20,000 5,000 29,470 7,000 5,400 5,500 10.000 27,900 39,000 9,570 14.000 11,500 3,538 3.950 20,000 9,870 (4,000) 20,000 8,580 34,450 6,790 6,540 3,500 12,000 28,830 40,620 17,988 1,500 -462 87,438 2,000 5,988 2,370 -970 0 -210 1,140 2,000 930 1,620 15.00 -11.55 10,968 11.11 12.74 31.60 32.01 0.00 -3.00 21.11 Total Owner's Equity Total Liabilities and Owner's Equity 76,470 (1) Name two positive trends from period I to period 2 by checking either $ change or % change: 20.00 3.33 4.15 14.34 (2) Name two negative trends from period 1 to period 2 by checking either S change or % change: 1. Conduct a vertical analysis (common-size analysis) for the income statements of Boatman Hotel for the months ended March 31 and April 30, 2020. March March % April % Change in % Revenues: Rooms Food and Beverage Telecommunications Other Income Total Revenues Cost of Sales: Rooms Food and Beverages Telecommunications Other Income Total Cost of Sales Gross Profit: Rooms Food and Beverages Telecommunications Other Income Total Gross Profit Operating (Controllable) Expenses: Administration & General Marketing Franchise Fees Property Operations and Maintenance Utilities Total Operating Expenses Operating Income Other (Non-controllable) Expenses: Management Fee Property Taxes Reserve for Capital Improvements Insurance Interest Expense Total Non-controllable Expenses 375,236 186,253 4,213 46.879 130,256 142,516 3,453 35,648 311,873 244,980 43,737 760 11/231 11,605 41,219 21,005 37,456 32,156 143,441 April 425,105 176,523 6,901 75.004 131.984 5,326 49,654 154,987 135,216 4,123 41.213 335,539 270,118 41,307 1,203 8,441 18,256 44,362 24.032 38,612 36,459 161,721 0.69 7.65 100.00 50.91 39.99 7.14 0.12 1.83 1.89 6.73 3.43 6.11 5.25 23.42 6,145 6,425 1.00 25,613 25.613 4.18 18,321 20,153 2.99 6,852 1.13 78,450 12.24 137,493 21.55% Income Before Income Taxes (1) What was the Gross Profit Margin? Period 1: (2) Which Operating Expenses item had the highest %? (3) Which item had the highest change in % from Period 1 to Period 2? Period 2: 0.81 7.56 100.00 51.10 41.14 6.29 0.18 1.29 2.78 6.76 3.66 5.88 5.55 24.63 0.98 3.90 3.07 1.04 11.95 20.94% 0.12 -0.09 0.00 0.19 1.15 -0.85 0.06 -0.55 0.89 0.03 0.23 -0.23 0.30 1.21 -0.02 -0.28 0.08 -0.08 -0.30 -0.61% 2. Conduct a horizontal analysis (comparative analysis) for the balance sheets of Gian's Italian Cuisine as of November 30 and December 31, 2016. November December S change % change Current Assets: Cash Accounts Receivable Food Inventory Beverage Inventory Prepaid Rent Total Current Assets Fixed Assets: Furniture, Fixture & Equipment (FF&E) Accumulated Depreciation (FF&E) Building Long term Investments Long Term Assets Total Assets Current Liabilities: Accounts Payable Accrued Payroll Accrued Taxes Total Current Liabilities Long Term Debt Total Liabilities Owner's Equity Retained Earnings 9,000 10,000 4,000 6,000 18,000 7,500 (3.030) 20,000 5,000 29,470 7,000 5,400 5,500 10.000 27,900 39,000 9,570 14.000 11,500 3,538 3.950 20,000 9,870 (4,000) 20,000 8,580 34,450 6,790 6,540 3,500 12,000 28,830 40,620 17,988 1,500 -462 87,438 2,000 5,988 2,370 -970 0 -210 1,140 2,000 930 1,620 15.00 -11.55 10,968 11.11 12.74 31.60 32.01 0.00 -3.00 21.11 Total Owner's Equity Total Liabilities and Owner's Equity 76,470 (1) Name two positive trends from period I to period 2 by checking either $ change or % change: 20.00 3.33 4.15 14.34 (2) Name two negative trends from period 1 to period 2 by checking either S change or % change:
Expert Answer:
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
The following are the income statements of two firms in the same industry. Required: a. Compute the contribution margin ratio, profit margin ratio, and sales per $ in fixed cost for the two firms. b....
-
The following data are from the income statements of Haskin Company. (a) Calculate for each year (1) the inventory turnover and (2) the days sales in inventory. (b) What conclusions concerning the...
-
The following data were taken from the income statements of Metronix Corporation. Compute the inventory-turnover ratio for each year. What conclusions concerning the management of the inventory can...
-
After the car reaches 1 0 0 km / hthe driver immediately steps on the brakes and comes to a stop in 2 . 5 5 s . The brakes are at a distance 1 5 . 9 cm from the center of the wheel and the force they...
-
Carboxylic acids (RCO 2 H; p K a 5) are approximately 10 11 times more acidic than alcohols (ROH; pK a 16). In other words, a carboxylate ion (RCO 2 ) is more stable than an alkoxide ion (RO )....
-
Prepare a bar chart comparing the tax rates in eight industrial countries: Canada, 33 percent; France, 45 percent; Germany, 41 percent; Japan, 28 percent; Netherlands, 38 percent; Sweden, 49 percent;...
-
A cost pool is a group of costs that is physically traced to the appropriate cost object. Do you agree? Explain.
-
The adjusted trial balance for Lloyd Construction as of December 31, 2020, follows: An analysis of other information reveals that Lloyd Construction is required to make a $41,500 payment on the...
-
A magazine subscription service is having a contest in which the prize is $40,000. If the company receives 2 million entries, what is the expectation of the contest? $
-
The shareholders equity section of the balance sheet of TNL Systems Inc. included the following accounts at December 31, 2020: Shareholders Equity ...............................................($ in...
-
An op-amp has CMRR = 100 dB, differential gain A D = 10 and common mode voltage applied to it is 2mV. Then find the value of common mode output voltage.
-
Sportsman Shoes has been a leader in the shoe industry for more than 30 years. Sportsman manufactures and sells athletic shoes for all types of sports. The company has pursued a low-cost strategy to...
-
Video Example Find f'(x) if f(x) = Solution Since In (18x1). f(x): = [In(8x) In(-8x) it follows that f'(x) = if x > 0 if x < 0 1 (8x) if x > 0 = dx d -(-8x) = = if x < 0 dx Thus, f'(x) = for all x 0.
-
Jane is on her 3rd placement. She must answer the engagement of the skate holders in the service/ 1.Engaging educators a) How do educators contribute to the QIP on a regular, ongoing basis? b)How are...
-
a bat sends 1 1 0 , 0 0 H z ultrasound signal out towards a n insenct 1 3 0 m away. i f the temperature i s 2 2 degrees celcius, how long will i t take t o hear the return signal? what i s the...
-
How does this cost of services sold statement differ from the cost of goods sold statement for a manufacturing firm?
-
1 Use the following returns for X and Y. 5.55 points eBook Returns Year X Y 12345 22.6% 28.8% - 17.6 4.6 10.6 30.8 21.2 -16.2 5.6 34.8 References a. Calculate the average returns for X and Y. (Do not...
-
For liquid water the isothermal compressibility is given by; where r and b are functions of temperature only. If 1 kg of water is compressed isothermally and reversibly from I to 500 bar at 60(C. how...
-
Repeat M7-16, except assume the 2015 ending inventory was over stated by $ 100,000. Refer M7-16 Assume the 2015 ending inventory of Sheas Shrimp Shack was understated by $ 10,000. Explain how this...
-
Refer to the data in ED- 2. Per Share 12/ 31/ 2015..$ 24 12/ 31/ 2016 31 Required: Assume that MetroMedia management purchased the Mitek stock as trading securities. Prepare the journal entries...
-
What is an adjusted trial balance? What is its purpose?
-
A You are required to calculate the overhead variances in the following cases: (a) Budgeted for \( 37,000\) fixed overhead. The actual fixed overhead turns out to be \( 36,420\). (b) Budgeted for...
-
You are required to calculate the overhead variances of Joseph Ltd. The budget is prepared as: (a) Total budgeted variable overhead \( 400,000\). (b) Total budgeted fixed overhead \( 160,000\). (c)...
-
A Corporec PLC manufactures a detergent in one of its plants. The information for the year to 30 September \(19 \mathrm{X} 2\) was as follows: The standard cost of manufacturing a litre was \( 2\)....
Study smarter with the SolutionInn App