Pelican and Rotelli Restaurants (both rated two stars and are family owned) are putting up for sale. The asking price for Pelican Restaurant is $8.0 million while Rotelli is asking for $8.5 million. Assume that you are a financial analyst and was asked by your client, Mr. Robert J. Hayes to evaluate the two restaurants and to give a recommendation as to which one of the two restaurants to buy over. The true fact is that your client is already in the restaurant business and he is planning to acquire another one to expand his family business. Upon acquisition, your client is going to keep all existing employees that is, the restaurant will operate as usual except for the change in ownership This is to assure the employees that their jobs are secured but they must work hard and be professional in their job. You took a visit to both the restaurants and talked to the present management and found the following facts: Pelican Rotelli Years of operation........ 15 35 Total number of full-time staff.. 35 20 Average age of employees..... 28 35 Location......... outskirt downtown Parking area... plenty town parking with fees Design of building. contemporary conventional (classic colonial building) Patron......... mostly family working people & weekends tourists Business operation hours... 10 am - 11 p.m. 8 am - 9pm Mon - Sun Mon - Sun ** Note: Currently, both restaurants have internship program for the HOTEL, FOOD & CATERING major students from a local university. Over a year, an average of 20-30 interns may pass through both restaurants and the number varies from 3 to 5 interns per semester (6 months). Each intern works 40 hours a week and paid an hourly rate of $8 besides the 3-hr course credit earned. Upon completion of their internship program, the restaurant manager would write a report to their professor on their performance. The comparative balance sheets and income statements for the past three (3) years from 2018 to 2019 were provided by the management of each restaurant and are attached with this case. However, they cannot provide the statement of cashflows because they never have one done before. Required: Prepare a formal report to be submitted to the client as to your basis of selecting the restaurant you recommended. This is a comparison report; therefore, you are to present a report that contains all the facts to convince your client to acquire the respective restaurant. (You may already study this type of report presentation in your English class). Note: If you are not sure how the report should be written, search the INTERNET for guidance. For this coursework term project, you need to include a COVER PAGE with title of the assignment and your name (both) on your report. (Use Aerial font 11 single spacing) - see sample cover page that follows. Your formal report should consist of the following: Page # #-# #- # # # * # TABLE OF CONTENTS Executive Summary Introduction The Analysis Methods and Their Limitations Discussion/Body Business Valuation Analysis i) Book value approach ii) Market value approach ii) Payback period approach iv) Net present value approach Vertical Analysis: Common size balance sheet Vertical Analysis: Common size income statement Horizontal Analysis Statement of Cash Flow Ratio Analysis i) Liquidity ratio ii) Management activity ratio ii) Profitability ratio iv) Leverage ratio V) Investment ratio Non-quantitative factors analysis Conclusion and Recommendations Appendix Calculation of ratios, Vertical analysis table of balance sheet and income statements, horizontal analysis table of both companies. References URL of additional research and facts of restaurant business. # # ### Executive Summary - A very important document that summarizes the pertinent or main reasons of your team's decision or recommendation on which restaurant to buy. Half to a page of summary is the maximum. (Check out from the Internet what is an Executive Summary). Number your report and include a Table of Content, as above Minimum 1,000 to maximum 1,500 to 2,000 words, excluding Appendix. Font: Aerial: 11. Hint: a) b) c) d) Prepare and analyze the statement of cash flows with respect to Operating, Investing and Financing activities of both the restaurants for the year 2019 and 2020. How is the cash flow position now and the future, investment prospect and how the restaurants are being financed? Project your cashflows to the future and determine the feasibility of your client's investment in either restaurant by comparing with the current asking price. Prepare a vertical analysis of the balance sheet and income statements and a horizontal analysis of income statement of both restaurants. Compare and discussion on the restaurant's performance with respect to sales, cost, expenses and etc. Refer to Digital company for guidance. Work out the ratios (liquidity, asset management, debt leverage, profitability and investment ratio) for both restaurants and compare the findings. Discuss them in the report. Look at other non-quantitative factors such as location, patrons, students' internship program, average age of employees, building, parking, operating hours and others to support your analysis to making the final recommendations. Discuss these factors in the report Determine how to present the information to your client. How to organize and present the information on the report? Refer to Table of Content for guidance. (Remember: What is in the report is a reflection of you as a professional. Communication skills are highly required and ranked in today's working environment - irrespective of any professions) State the assumptions if your plan to use in your analysis such as the rate of investment return. The different valuation methods or analysis used and what are their limitations. e) f) g) 2020 2019 The Pelican Restaurant Comparative Balance Sheet December 31, 2021, 2020 and 2019 Assets 2021 Current assets: Cash $112.000 Accounts receivable (net) 120,000 Inventories 201,000 Prepaid expenses 21,000 Total current assets $454,000 Fixed assets: Property, plant and equipment 1.850,000 Accumulated depreciation 810,000 Net property, plant and equipment 1,040,000 Total assets $1,494,000 $152,000 98,000 192,600 23,400 $466,000 $115,000 65,000 169,600 18,200 $367,800 1,550,000 746,000 804,000 $1,270,000 1,470,000 680,000 790,000 $1,157,800 Liabilities Current liabilities: Accounts payable Current maturity of long-term debt Accrued payroll Income taxes payable Other accrued expenses Total current liabilities Long-term liabilities: Long-term debt Deferred income taxes Total liabilities $96,000 2,200 57,000 29,000 13,800 $198.000 $80,000 2,000 49,000 23,000 6,800 $160,800 $97,000 1,800 47,000 32,000 12,000 $189,800 43,000 18,800 $259,800 45,000 15,700 $221,500 47,000 26,000 $262,800 Shareholders' Equity Common stock, $1 par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $300,500 933,700 $1,234,200 $1,494,000 $300,500 748,000 $1,048,500 $1,270,000 $300,500 594,500 $895,000 $1,157,800 2020 2019 Rotelli Restaurant Comparative Balance Sheet December 31, 2021, 2020 and 2019 Assets 2021 Current assets: Cash $90,000 Short-term investments 200.000 Accounts receivable (net) 60.800 Inventories 104.000 Prepaid expenses 50,000 Total current assets $504,800 Fixed assets: Property, plant and equipment 2,750,000 Accumulated depreciation 325,000 Net property, plant and equipment 2.425,000 Intangible assets: Goodwill net 62,500 Total assets $2.992,300 $35,000 28,000 35,400 95,000 22,000 $215,400 $80,000 117000 25,000 75,000 25,000 $322,000 1,900,000 200.000 1,700,000 1,650,000 100,000 1,550,000 75,000 $1,990,400 87,500 $1,959,500 Liabilities Current liabilities: Accounts payable Current maturity of long-term debt Accrued payroll Income taxes payable Other accrued expenses Total current liabilities Long-term liabilities: Long-term debt Total liabilities $127,000 69,000 50,000 12.000 8.000 $266,000 $176,000 63,000 38,000 8,000 15,000 $300,000 $140,000 58,000 39,000 5,000 7,000 $249,000 1,326,000 $1,592,000 1,389,000 $1,689,000 1,447,000 $1,696,000 Shareholders' Equity Common stock, S1 par Additional paid-in capital in excess of par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity S101,000 1,250,000 49,300 $1,400,300 $2.992.300 $1,000 400,000 (99,600 5301,400 $1.990.400 $1,000 400,000 (137,500) S263,500 $1.959.500 Pelican and Rotelli Restaurants (both rated two stars and are family owned) are putting up for sale. The asking price for Pelican Restaurant is $8.0 million while Rotelli is asking for $8.5 million. Assume that you are a financial analyst and was asked by your client, Mr. Robert J. Hayes to evaluate the two restaurants and to give a recommendation as to which one of the two restaurants to buy over. The true fact is that your client is already in the restaurant business and he is planning to acquire another one to expand his family business. Upon acquisition, your client is going to keep all existing employees that is, the restaurant will operate as usual except for the change in ownership This is to assure the employees that their jobs are secured but they must work hard and be professional in their job. You took a visit to both the restaurants and talked to the present management and found the following facts: Pelican Rotelli Years of operation........ 15 35 Total number of full-time staff.. 35 20 Average age of employees..... 28 35 Location......... outskirt downtown Parking area... plenty town parking with fees Design of building. contemporary conventional (classic colonial building) Patron......... mostly family working people & weekends tourists Business operation hours... 10 am - 11 p.m. 8 am - 9pm Mon - Sun Mon - Sun ** Note: Currently, both restaurants have internship program for the HOTEL, FOOD & CATERING major students from a local university. Over a year, an average of 20-30 interns may pass through both restaurants and the number varies from 3 to 5 interns per semester (6 months). Each intern works 40 hours a week and paid an hourly rate of $8 besides the 3-hr course credit earned. Upon completion of their internship program, the restaurant manager would write a report to their professor on their performance. The comparative balance sheets and income statements for the past three (3) years from 2018 to 2019 were provided by the management of each restaurant and are attached with this case. However, they cannot provide the statement of cashflows because they never have one done before. Required: Prepare a formal report to be submitted to the client as to your basis of selecting the restaurant you recommended. This is a comparison report; therefore, you are to present a report that contains all the facts to convince your client to acquire the respective restaurant. (You may already study this type of report presentation in your English class). Note: If you are not sure how the report should be written, search the INTERNET for guidance. For this coursework term project, you need to include a COVER PAGE with title of the assignment and your name (both) on your report. (Use Aerial font 11 single spacing) - see sample cover page that follows. Your formal report should consist of the following: Page # #-# #- # # # * # TABLE OF CONTENTS Executive Summary Introduction The Analysis Methods and Their Limitations Discussion/Body Business Valuation Analysis i) Book value approach ii) Market value approach ii) Payback period approach iv) Net present value approach Vertical Analysis: Common size balance sheet Vertical Analysis: Common size income statement Horizontal Analysis Statement of Cash Flow Ratio Analysis i) Liquidity ratio ii) Management activity ratio ii) Profitability ratio iv) Leverage ratio V) Investment ratio Non-quantitative factors analysis Conclusion and Recommendations Appendix Calculation of ratios, Vertical analysis table of balance sheet and income statements, horizontal analysis table of both companies. References URL of additional research and facts of restaurant business. # # ### Executive Summary - A very important document that summarizes the pertinent or main reasons of your team's decision or recommendation on which restaurant to buy. Half to a page of summary is the maximum. (Check out from the Internet what is an Executive Summary). Number your report and include a Table of Content, as above Minimum 1,000 to maximum 1,500 to 2,000 words, excluding Appendix. Font: Aerial: 11. Hint: a) b) c) d) Prepare and analyze the statement of cash flows with respect to Operating, Investing and Financing activities of both the restaurants for the year 2019 and 2020. How is the cash flow position now and the future, investment prospect and how the restaurants are being financed? Project your cashflows to the future and determine the feasibility of your client's investment in either restaurant by comparing with the current asking price. Prepare a vertical analysis of the balance sheet and income statements and a horizontal analysis of income statement of both restaurants. Compare and discussion on the restaurant's performance with respect to sales, cost, expenses and etc. Refer to Digital company for guidance. Work out the ratios (liquidity, asset management, debt leverage, profitability and investment ratio) for both restaurants and compare the findings. Discuss them in the report. Look at other non-quantitative factors such as location, patrons, students' internship program, average age of employees, building, parking, operating hours and others to support your analysis to making the final recommendations. Discuss these factors in the report Determine how to present the information to your client. How to organize and present the information on the report? Refer to Table of Content for guidance. (Remember: What is in the report is a reflection of you as a professional. Communication skills are highly required and ranked in today's working environment - irrespective of any professions) State the assumptions if your plan to use in your analysis such as the rate of investment return. The different valuation methods or analysis used and what are their limitations. e) f) g) 2020 2019 The Pelican Restaurant Comparative Balance Sheet December 31, 2021, 2020 and 2019 Assets 2021 Current assets: Cash $112.000 Accounts receivable (net) 120,000 Inventories 201,000 Prepaid expenses 21,000 Total current assets $454,000 Fixed assets: Property, plant and equipment 1.850,000 Accumulated depreciation 810,000 Net property, plant and equipment 1,040,000 Total assets $1,494,000 $152,000 98,000 192,600 23,400 $466,000 $115,000 65,000 169,600 18,200 $367,800 1,550,000 746,000 804,000 $1,270,000 1,470,000 680,000 790,000 $1,157,800 Liabilities Current liabilities: Accounts payable Current maturity of long-term debt Accrued payroll Income taxes payable Other accrued expenses Total current liabilities Long-term liabilities: Long-term debt Deferred income taxes Total liabilities $96,000 2,200 57,000 29,000 13,800 $198.000 $80,000 2,000 49,000 23,000 6,800 $160,800 $97,000 1,800 47,000 32,000 12,000 $189,800 43,000 18,800 $259,800 45,000 15,700 $221,500 47,000 26,000 $262,800 Shareholders' Equity Common stock, $1 par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $300,500 933,700 $1,234,200 $1,494,000 $300,500 748,000 $1,048,500 $1,270,000 $300,500 594,500 $895,000 $1,157,800 2020 2019 Rotelli Restaurant Comparative Balance Sheet December 31, 2021, 2020 and 2019 Assets 2021 Current assets: Cash $90,000 Short-term investments 200.000 Accounts receivable (net) 60.800 Inventories 104.000 Prepaid expenses 50,000 Total current assets $504,800 Fixed assets: Property, plant and equipment 2,750,000 Accumulated depreciation 325,000 Net property, plant and equipment 2.425,000 Intangible assets: Goodwill net 62,500 Total assets $2.992,300 $35,000 28,000 35,400 95,000 22,000 $215,400 $80,000 117000 25,000 75,000 25,000 $322,000 1,900,000 200.000 1,700,000 1,650,000 100,000 1,550,000 75,000 $1,990,400 87,500 $1,959,500 Liabilities Current liabilities: Accounts payable Current maturity of long-term debt Accrued payroll Income taxes payable Other accrued expenses Total current liabilities Long-term liabilities: Long-term debt Total liabilities $127,000 69,000 50,000 12.000 8.000 $266,000 $176,000 63,000 38,000 8,000 15,000 $300,000 $140,000 58,000 39,000 5,000 7,000 $249,000 1,326,000 $1,592,000 1,389,000 $1,689,000 1,447,000 $1,696,000 Shareholders' Equity Common stock, S1 par Additional paid-in capital in excess of par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity S101,000 1,250,000 49,300 $1,400,300 $2.992.300 $1,000 400,000 (99,600 5301,400 $1.990.400 $1,000 400,000 (137,500) S263,500 $1.959.500