Using the 2020 and 2021 Income Statements, prepare both a Comparative Horizontal and Common Size Vertical...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the 2020 and 2021 Income Statements, prepare both a Comparative Horizontal and Common Size Vertical Analysis. Using a subset of the 2020 and 2021 Balance Sheets, prepare a Comparative Horizontal Analysis. Write a brief essay describing your understanding of the current business using these statements. Comment on any significant variances. Additionally, explain what you believe to be the strengths and weaknesses of the business based on this information. Use the worksheets in the back of this packet to complete the analysis and the space provided for your essay. Income Statement for Existing Restaurant Sales Revenue Food Revenue Beverage Revenue Total Sales Revenue Cost of Sales Food COS Beverage COS Total Cost of Sales Labor Expense Prime Cost Controllable Expenses Operating Supplies Expense Administrative and General Expense Advertising and Promotion Expense Repairs and Maintenance Utilities Total Controllable Expenses Controllable Income Non-Controllable Expenses Depreciation Occupancy Costs Interest Expense Total Non-Controllable Expenses Operating Income YE 2020 $995,000 $302,500 $1,297,500 $352,500 $95,000 $447,500 $382,560 $830,060 $20,100 $10,200 $4,200 $2,900 $14,100 $51,500 $415,940 $10,000 $152,000 $5,800 168,800 $248,140 YE 2021 $1,115,000 $351,600 $1,466,600 $345,200 $127,000 $472,200 $564,310 $1,036,510 $25,300 $11,405 $4,600 $1,650 $12,545 $55,500 $374,590 $10,000 $152,000 $5,200 167,200 $207,390 Current Assets Cash Credit Card Receivables Accounts Receivable Marketable Securities Prepaid Expenses Food Inventory Beverage Inventory Total Current Assets Current Liabilities Accounts Payable Accrued Expenses Payable Taxes Payable Current Mortgage Payable Total Current Liabilities YE 2020 $48,200 $2,740 $890 $1,200 $3,900 $6,900 $3,620 $67,450 $10,900 $3,250 $22,200 $13,200 $49,550 YE 2021 $31,600 $3,100 $1,475 $18,000 $5,400 $4,700 $2,960 $67,235 $9,400 $2,100 $24,300 $11,600 $47,400 Using the 2020 and 2021 Income Statements, prepare both a Comparative Horizontal and Common Size Vertical Analysis. Using a subset of the 2020 and 2021 Balance Sheets, prepare a Comparative Horizontal Analysis. Write a brief essay describing your understanding of the current business using these statements. Comment on any significant variances. Additionally, explain what you believe to be the strengths and weaknesses of the business based on this information. Use the worksheets in the back of this packet to complete the analysis and the space provided for your essay. Income Statement for Existing Restaurant Sales Revenue Food Revenue Beverage Revenue Total Sales Revenue Cost of Sales Food COS Beverage COS Total Cost of Sales Labor Expense Prime Cost Controllable Expenses Operating Supplies Expense Administrative and General Expense Advertising and Promotion Expense Repairs and Maintenance Utilities Total Controllable Expenses Controllable Income Non-Controllable Expenses Depreciation Occupancy Costs Interest Expense Total Non-Controllable Expenses Operating Income YE 2020 $995,000 $302,500 $1,297,500 $352,500 $95,000 $447,500 $382,560 $830,060 $20,100 $10,200 $4,200 $2,900 $14,100 $51,500 $415,940 $10,000 $152,000 $5,800 168,800 $248,140 YE 2021 $1,115,000 $351,600 $1,466,600 $345,200 $127,000 $472,200 $564,310 $1,036,510 $25,300 $11,405 $4,600 $1,650 $12,545 $55,500 $374,590 $10,000 $152,000 $5,200 167,200 $207,390 Current Assets Cash Credit Card Receivables Accounts Receivable Marketable Securities Prepaid Expenses Food Inventory Beverage Inventory Total Current Assets Current Liabilities Accounts Payable Accrued Expenses Payable Taxes Payable Current Mortgage Payable Total Current Liabilities YE 2020 $48,200 $2,740 $890 $1,200 $3,900 $6,900 $3,620 $67,450 $10,900 $3,250 $22,200 $13,200 $49,550 YE 2021 $31,600 $3,100 $1,475 $18,000 $5,400 $4,700 $2,960 $67,235 $9,400 $2,100 $24,300 $11,600 $47,400
Expert Answer:
Related Book For
Intermediate Accounting Volume 2
ISBN: 9781119497042
12th Canadian Edition
Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield, Irene M. Wiecek, Bruce J. McConomy
Posted Date:
Students also viewed these accounting questions
-
Thoroughly explain what you believe to be the three biggest future challenges facing professional sport and the three biggest future challenges facing collegiate sport.
-
Write a brief essay describing lobal societal problem minimum wage Address the following items in separate sections with new headings for each: Identify the global societal problem within the...
-
What do you believe to be the main challenges confronting the Caricom Single Market and Economy? How would you recommend that we as a people overcome these challenges?
-
Write a text-based transaction program for recording stock levels in a warehouse. A transaction is either an import, an export, or wastage (e.g., when stock falls off a shelf and breaks) of items,...
-
What were the dollar amount of change and the percentage of each change in Wilderness Lodges working capital during 2010 and 2009? Is this trend favorable orunfavorable? 201 2009 2008 Total current...
-
Parent Co. owns 75% of Sub Co. and uses the cost method to account for its investment. The following are summarized income statements for the year ended December 31, Year 7. Additional Information: ...
-
A derivative security of European style with expiration in 1 year has this payoff: \(\max (0, \min (3 K-S, S-K))\), where \(K=10\) is the strike price and \(S\) is the price of the underlying stock...
-
Paula Woodward is the head of the Information Systems Department at Mo Manufacturing Company. Roland Randolph, the companys controller, is meeting with her to discuss changes in data gathering that...
-
table. 2. Design an 8-to-1 mux, 4-to-1 mux and 3-to-8 decoder to implement the following truth ABC F 000 1 0 0 1 0 0101 0110 1000 10 1 1101 11
-
Using the adjusted trial provided below, prepare an income statement, statement of owner's equity, and balance sheet for Solomon Services Company. Note: Solomon Services Company had a capital balance...
-
4. Which design model transforms information domain model into data structures. a) Architectural design. b) Component-level design. c) Interface design. d) Data design. e) None of the above. ANSWER:...
-
Why is the external environment impossible to control?
-
Questionnaires are of little use and provide inaccurate information. Develop an evaluative discussion in response to this notion.
-
What are the main problems faced when dealing with the macro-environment?
-
Critically evaluate the importance of social media when considering reference groups.
-
What can be done to overcome interviewer bias?
-
Please provide suitable journal double entries for the following transactions: 1. I spend $500 of the companys cash and buy a desk for the reception. 2. The company pays a contractor to create an app...
-
The pendulum consists of two rods: AB is pin supported at A and swings only in the y-z plane, whereas a bearing at B allows the attached rod BD to spin about rod AB. At a given instant, the rods have...
-
Henry Limited had investments in securities on its SFP for the first time at the end of its fiscal year ended December 31, 2020. Henry reports under IFRS and its investments in securities are to be...
-
Rhonda is considering investing in the shares of either East Corporation or West Ltd. Both companies are publicly traded. How would an analysis of each company's EPS help Rhonda decide which company...
-
The Bank of Montreal and Royal Bank of Canada financial statements for their years ended October 31, 2017, can be found on SEDAR (www.sedar.com). Instructions a. What is the average carrying amount...
-
Which specific paperless tools are discussed by Shelby Walsh? Which are inferior to paper-based media, and which are superior? Is an entirely paperless office possible, or does paper still have...
-
Kaplan also notes how time- and labor-intensive it is to prepare proposals and sustain good relationships with funders and others. Which of Kaplans remarks underscore the importance of good business...
-
How does the research process that Health Scape Advisors uses reflect the elements in the chapter?
Study smarter with the SolutionInn App