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...
-
Geneva Technology Company (GTC), a Swiss-based company founded in 1999, is considering the use of IFRS in preparing its annual report for the year ended December 31, 2013. You are the manager of...
-
Southern Distributors, Inc., supplies ice cream shops with various toppings for making sundaes. On November 17, 2024, a fire resulted in the loss of all of the toppings stored in one section of the...
-
Cantilever Ltd was awarded a contract to build an office block in London and work commenced at the site on 1 May 2005. During the period to 28 February 2006, the expenditure on the contract was as...
-
Consider the following network for conducting a two week (10 working days) computer training class: (a) Construct a schedule showing: ESs for all activities LSs for all activities Slacks for all...
-
of 6 nces Shadee Corporation expects to sell 540 sun shades in May and 390 in June. Each shade sells for $147. Shadee's beginning and ending finished goods inventories for May are 60 and 40 shades,...
-
On January 1, Ruiz Company issued bonds as follows: Face Amount $500,000 15 Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest semi-annually.) Required:...
-
Required information [The following information applies to the questions displayed below.] The following data is provided for Garcon Company and Pepper Company for the year ended December 31....
-
A company has two bonds outstanding. Both bonds have a face value of $1,000 and mature in 12 years. Bond A will be paying coupons semi-annually at the end of each period over the 12-year period....
-
While computing the cost of equity using the formula , rs=D1P0+grs=D1P0+g, we do not make any adjustment to express the cost of equity on an after-tax basis whereas while computing the cost of debt,...
-
On January 1, 2004, ChigaBiga Fund - an all-equity mutual fund - was established. At that time, funds collected were used to purchase the following securities: 01/01/2004 31/12/04 securities # Shares...
-
The Caesar cipher is a simple encryption method which works by swapping each letter with another one a certain offset away in the alphabet. For example, with an encryption offset of 1 , "abc" woudl...
-
As a financial planner is it wise to suggest to a client that those who work longer, then to live longer? Are there any research to support that theory or thought process? Cite source
-
Power Proper For these exercises, assume that all variable es Use the product property of logarithms to writ log(2xy) 2 answers
-
What are the key dimensions of critical thinking 2. Watch the NBC Learn video on Diet Scams. What types of claims are made in this video Are they valid Elaborate on your responses. Discuss this video...
-
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...
-
Cloud computing has just begun to take off in the business world. The biggest player in the cloud computing marketplace is one you might not expect: Amazon. Under its Web Services division (AWS),...
-
Look around. On the street, at restaurants, sports events, and stores, youll find many people using their smartphones. And many people are starting to use these devices on the job as well. According...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Perform a horizontal analysis of the balance sheets and income statements...
Study smarter with the SolutionInn App