This is the second part of the two part restaurant project assignment. Your work for this phase of the project should build on your submission from part one plus any feedback received. For the second part of the assignment, the goal is to prepare financial statements for your selected restaurant Complete the following steps: 1 Refer to your Part 1 assignment. Review any feedback that you might have received and think about any additional accounts that might need to exist within the respective account categories. The minimum number of accounts for your restaurant should be as follows: Assets (6), Liabilities (4). Revenue (2), and Expenses (8). You can modify the number and name of the accounts in part 1 so that you do not have too many for too few) accounts. In some submissions of Part 1, some accounts need to be combined per my feedback. Also, refer to the "Business Highlights" section on page 2 of this document for detail on certain items that need to be present in Part 2 of the Restaurant Project. 2. Create an income statement for the year ended December 31, 2019 (10 points). You will need estimate numbers for total revenues and expenses related to the calendar year ended December 31, 2018. The majority of your revenue and expense accounts will be derived from your Part 1 assignment. For Part 2 this assignment, the goal is to assign/estimate numbers to each account. Be as realistic as possible in your number selection. One requirement is that your restaurant remain profitable for the year. 1 suggest that you try and put yourself in the mindset of the restaurant as to what the actual performance would/could be. 3. Create a classified balance sheet for the restaurant (10 points). Refer to page 4-20 and 4-21 for an example of classified balance sheet in the textbook. Be sure to classify assets into current and long-term and classify liabilities into current and long-term. In preparation of this statement, make sure that you reflect the restaurant owners taking 10% of current year net income as dividend. The retained earnings carried over from the previous year (2018) should be equal to $100,000. The last account that you populate will most likely involve a "plug to keep your balance sheet in balance. Remember, the balance sheet must balance. All numbers (on all statements) should be reviewed for believability. Below your balance sheet, show the calculation on how you get the ending balance of retained earnings based on the beginning retained earnings, net income and dividend. 4. Review the prepared financials and come up with an answer for each of the questions shown below (5 points). When uploading to Canvas include the answers to your questions in the submission window comment box What is one positive thing that you would want to highlight? b. What is one negative thing you would want to highlight? c. What is one recommendation that you have for this restaurant based on the financials? e a Business Highlights / Items A The business is a corporation. You can make any assumptions that you feel are necessary about par value, amount paid by investors to acquire stock of your restaurant, as well as the number of shares of stock authorized, issued, and/or outstanding. B. Although the business does the best it can to collect from catering customers, it is not always successful. Each year accounts are deemed uncollectable and written off. They use an allowance method for dealing with bad debts. C. The restaurant must own at least one type of long-term asset (e.g.property, plant, and equipment). Make sure you have included depreciation in your financials. D. Employees are paid on the 1st of every month for the work that they performed in the preceding month. E To provide certainty that business insurance will not expire the restaurant pays in advance insurance for the subsequent month of business. F. You may Ignore sales taxes and payroll taxes in this project. Submission: Upload the completed Excel file that contains the financials to Canvas. In addition, be sure to post your positive, negative, and recommendation for improvement based on the financials within the Canvas submission window as comment. Related to the Excel file, place each financial on its own tab within the workbook. Keep in mind that you are estimating the numbers for a one year period. As an example, if you think catering revenue for the year would be $100,000. Your income statement will show the $100,000. NOTE: This assignment should go pretty quick. I recommend using a template that you have previously created and adjusting it to fit your restaurant. Scoring: 25 Points Total Font Alignment Clipboard C39 : x X fx F D E H A B 5 ASSETS 6 7 CURRENT ASSETS 8 Cach Accounts Receivable 10 Food Inventory 11 Catering Deposits 12 13 14 15 TOTAL CURRENT ASSETS 16 1 PROPERTY, PLANT AND EQUIPMENT 18 Equipment Land 20 Building 21 22 TOTAL PROPERTY, PLANT, AND EQUIPMENT $ 988888888888 25 TOTAL ASSETS 26 27 TABILITIES AND EQUITY 28 29 CURRENT LIABILITIES Salary & Wage Accounts Payable Uneaed Revenue Taxes Collected Custom Deposits 35 ST 39 TOTAL CURRENT LIABILITIES 15 BS READY a B D E A 25 TOTAL ASSETS + 26 27 IABILITIES AND EQUITY 28 29 CURRENT LIABILITIES 30 Salary & Wages 31 Accounts Payable 32 Uneamed Revenue 33 Taxes Collected 34 Customer Deposits 35 36 37 38 39 TOTAL CURRENT LIABILITIES 40 41 LONG TERM LIABILITIES 42 43 44 TOTAL LIABILITIES 45 46 EQUITY 49 50 51 52 53 TOTAL EQUITY 56 55 TOTAL LIABILITIES AND EQUITY 56 57 58 59 50 IS BS READY D7 A B C E F 7 Revenue 15 8 Menu Order Service 9 Catering Services 10 Total revenue 11 Cost of goods sold 12. Gross profit 13 Operating expenses 14 Utility Expense Phone and Internet Expense Salary and Wages Expense 17 Equipment Expense Advertising Expense Repairs and Maintenance Expense 20 Furniture Expense 21 Kitchen Supplies Expense 22 Total operating expenses Operating income 24 Non-operating income and expense) 16 18 19 IS BS READY hop E F B Dperating expenses Utility Expense Phone and Internet Expense Salary and Wages Expense Equipment Expense Advertising Expense Repairs and Maintenance Expense Furniture Expense Kitchen Supplies Expense Total operating expenses Operating income Non-operating income and expense) 5 Interest expense Total non-operating items 27 Net income 6 28 29 30 31 ISBS READY hp a