This is the second part of the two-part restaurant project assignment. Your work for this phase...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 (or 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 jority 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. I 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? What is one recommendation that you have for this restaurant based on the financials? e hp 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 C39 4 5 6 10 11 12 13 *222** *********28 7 CURRENT ASSETS 4 3 20 21 23 15 TOTAL CURRENT ASSETS 24 Clipboard 17 PROPERTY, PLANT AND EQUIPMENT Equipment Land Building 26 A 25 TOTAL ASSETS Y 30 22 TOTAL PROPERTY, PLANT, AND EQUIPMENT 32 34 5 27 IABILITIES AND EQUITY X✓ fx 26 28 CURRENT LIABILITIES Cash Accounts Receivable Food Inventory Catering Deposits READY B ASSETS as TOTAL CURRENT LIABILITIES 40 Salary & Wages Accounts Payable Uneamed Revenue Taxes Collected Customer Deposits Font BS $ C L D E h Alignment G a H A 25 TOTAL ASSETS 26 27 LIABILITIES AND EQUITY 28 29 CURRENT LIABILITIES 30 31 32 33 34 35 36 37 38 39 TOTAL CURRENT LIABILITIES 40 41 LONG-TERM LIABILITIES 42 43 44 TOTAL LIABILITIES 45 46 EQUITY 47 45 49 50 51 52 53 TOTAL EQUITY 54 55 TOTAL LIABILITIES AND EQUITY 56 ST 159 50 61 READY Salary & Wages Accounts Payable Uneamed Revenue Taxes Collected Customer Deposits # B IS BS 15.3 D E D7 7 Revenue 00 A 15 16 17 8 Menu Order Service 9 Catering Services 10 Total revenue 11 Cost of goods sold 12 13 Operating expenses 14 Utility Expense Phone and Internet Expense Salary and Wages Expense 18 19 120 21 X✓ fx B READY Gross profit Equipment Expense Advertising Expense Repairs and Maintenance Expense Furniture Expense Kitchen Supplies Expense 22 23 Operating income 24 Non-operating income and (expense) 15 BS Total operating expenses e C O + Con E a F A Operating expenses Utility Expense 5 6 7 28 29 30 31 Phone and Internet Expense Salary and Wages Expense Equipment Expense Advertising Expense Repairs and Maintenance Expense Furniture Expense Kitchen Supplies Expense B READY Total operating expenses Non-operating income and (expense) Interest expense Operating income Total non-operating items Net income IS 65 + D m a LL F 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 (or 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 jority 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. I 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? What is one recommendation that you have for this restaurant based on the financials? e hp 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 C39 4 5 6 10 11 12 13 *222** *********28 7 CURRENT ASSETS 4 3 20 21 23 15 TOTAL CURRENT ASSETS 24 Clipboard 17 PROPERTY, PLANT AND EQUIPMENT Equipment Land Building 26 A 25 TOTAL ASSETS Y 30 22 TOTAL PROPERTY, PLANT, AND EQUIPMENT 32 34 5 27 IABILITIES AND EQUITY X✓ fx 26 28 CURRENT LIABILITIES Cash Accounts Receivable Food Inventory Catering Deposits READY B ASSETS as TOTAL CURRENT LIABILITIES 40 Salary & Wages Accounts Payable Uneamed Revenue Taxes Collected Customer Deposits Font BS $ C L D E h Alignment G a H A 25 TOTAL ASSETS 26 27 LIABILITIES AND EQUITY 28 29 CURRENT LIABILITIES 30 31 32 33 34 35 36 37 38 39 TOTAL CURRENT LIABILITIES 40 41 LONG-TERM LIABILITIES 42 43 44 TOTAL LIABILITIES 45 46 EQUITY 47 45 49 50 51 52 53 TOTAL EQUITY 54 55 TOTAL LIABILITIES AND EQUITY 56 ST 159 50 61 READY Salary & Wages Accounts Payable Uneamed Revenue Taxes Collected Customer Deposits # B IS BS 15.3 D E D7 7 Revenue 00 A 15 16 17 8 Menu Order Service 9 Catering Services 10 Total revenue 11 Cost of goods sold 12 13 Operating expenses 14 Utility Expense Phone and Internet Expense Salary and Wages Expense 18 19 120 21 X✓ fx B READY Gross profit Equipment Expense Advertising Expense Repairs and Maintenance Expense Furniture Expense Kitchen Supplies Expense 22 23 Operating income 24 Non-operating income and (expense) 15 BS Total operating expenses e C O + Con E a F A Operating expenses Utility Expense 5 6 7 28 29 30 31 Phone and Internet Expense Salary and Wages Expense Equipment Expense Advertising Expense Repairs and Maintenance Expense Furniture Expense Kitchen Supplies Expense B READY Total operating expenses Non-operating income and (expense) Interest expense Operating income Total non-operating items Net income IS 65 + D m a LL F
Expert Answer:
Answer rating: 100% (QA)
Current Asset Asset Total current Assets Property Plant and Eq... View the full answer
Related Book For
Concepts in Federal Taxation 2016
ISBN: 9781305585133
23rd edition
Authors: Kevin Murphy, Mark Higgins
Posted Date:
Students also viewed these accounting questions
-
This is the second part of a six part problem that will allow you to prepare the 2014 tax return for Laurie and Lynn Norris. As with the previous parts, this part of the problem will ask you to...
-
Investor A has an initial wealth of K550 and a utility function of the form: U(w) = log(w) Where w is her wealth at any time. Investment offers her a return of -18% or + 20% with equal probability....
-
This is the second year that your firm is auditing JJ Company, which is developing a new drug for a rare form of cancer. The company is controlled by Jack, who purchased the shares from the previous...
-
Which statement about sociology as a science is true? A) Most sociologists reject the use of the scientific method. B) Sociologists almost always use hypothesis testing in their research. C) Sociolo...
-
Consider again the demand and supply functions in Worked-Out Problem 2.2 (page 31). Suppose the government needs to buy 3.5 billion bushels of corn for a third-world famine relief program. What...
-
The babies born in singleton births in the United States have birth weights that are approximately normally distributed with mean 3.296 kg and standard deviation 0.560 kg (Martin et al. 2011). a....
-
More and more Japanese companies are moving in on what once was an exclusive U.S. preserve: making and selling the complex equipment that makes semiconductors. World sales are between \($3\) billion...
-
Oceanic Airways makes investments in available-for-sale securities. Selected income statement items for the years ended December 31, 2012 and 2013, plus selected items from comparative balance...
-
A bacteria culture starts with 340 bacteria and grows at a rate proportional to its size. After 2 hours there will be 680 bacteria. (a) Express the population P after t hours as a function of t. Be...
-
1. Fashion Trends, Inc., a regional fashion apparel retailer, wants to prepare a 2018 Pro Forma Income Statement and a 2018 Balance Sheet using the following 2017 and 2016 data: Fashion Trends, Inc....
-
Create a high-quality, 4-5 minute digital product that includes narration and demonstrates your ICT skills.
-
Regardless of Karl's contribution, Victoria wants to have enough money saved in 10 years that she alone could pay for the cabin. What are her equal monthly contributions she needs to make to her...
-
An extract from LIME's pre-closing trial balance for the year ended December 31, 2023, is shown below. The company's net income for the year was $16,250. What is included in the closing entries for...
-
How long is the continuous varve record from Lake Suigetsu in Japan ? who made this record please discuss
-
The purchase price is allocated among the transferred assets using a residual allocation method based on how many tiers?
-
Highland Inc. holds 70% of the common shares of Sissy Inc. On January 1, 20X5, Sissy sold equipment to Highland for $17,500. Sissy purchased this equipment from an independent non-associate for...
-
Success College Australia is a thriving College offering a range of courses in business, marketing and management. To collect evidence for this unit in a Project Portfolio, the steps need to be...
-
Problem 2. (0.6 points, 0.2 points for each question) (a) A company turns its inventory 2 times a month. Its months-of-supply = Its days-of-supply = Please show your analysis below: _months. days. (1...
-
Harry and Matilda are married and have the following tax return data for 2015: Do Harry and Matilda owe any income tax for 2015? Explain why they might owe tax in 2015, and discuss the items on their...
-
Neila sells 500 shares of Bolero Corporation stock for $10,500 and pays $500 in sales commissions on September 23 of the current year. She acquired the stock for $4,700 plus $300 in commissions five...
-
Determine the tax year(s) each of the following S corporations must use. Explain. a. Will, Dan, and Tom are equal owners of Rheen Corporation, and each has a different fiscal year. Will has a fiscal...
-
What is the payback period for the project described in Problem 4.21 if the maintenance increases by $\$ 500 /$ year (after the first year)? Data from in problem 4.21 What is the payback period for...
-
What is the payback period for the project described below? Machine investment $24,999 MARR 18% Annual benefit $5,000 Annual maintenance Life Salvage value $2,500 7 years $1,000
-
Describe the relationship between dynamic modeling, behavioral modeling, and structural modeling.
Study smarter with the SolutionInn App