accounting sheet

DD Restaurants, Inc. -- Preparing Financial Statements DD Restaurants, Inc. was incorporated in Florida in 1995 bur its parent company, GMRI begin in 1968 as Red Lobster Inne of America. Now DD Restaurant is the largest publicly held casual dining restaurant company in the world. In 2017, the company served over 350 million meals in 1.397 restaurants in the United States and Canada. The company operates the following restaurants: Red Lobster, Olive Garden, Bahama Breeze, Smokey Bones Barbeque & Grill and Seasons 52. (Source: Company Form 10-K) Learning Objectives Determine how economic events affect a company's financial statements Record economic events and prepare a simple set of financial statements. Understand how to adjust financial statements for accruals and reclassification In this case you will record basic transactions to recreate the May 27, 2017, balance sheet and income statement for DD Restaurants, Inc. The company's financial statement formats are included. You can use them to guide your work. Note: All dollar figures are in millions To complete this case you need to develop computerized spreadsheet. The structure of the spreadsheet follows after the case questions. Because of space constraints, the spreadsheet is reproduced on sequential pages here. However, you should create one worksheet with all the accounts across the top. Use the numbers from DD's Actual financial statements to enter the opening (i.e., May 28, 2016) and ending (ie, May 27, 2017) Balance Sheets and Statements of Earnings balances into the accounts on your spreadsheet. Create two separate accounts for "Land, building and equipment, one for the original cost of these assets (2016: $4,228.5 and 2017: $3.961.4) and a second account for the related accumulated depreciation (2016: 51.782.5 and 2017: $1.777). Show this second account as a negative amount (because it is a contra-asset account) so that the sum of the two accounts combined equals the "Land, building and equipment, net amount on the balance sheet (2016: 52.446.0 and 2017: $2,184.4). Some smaller balance sheet accounts have been combined in the spreadsheet. The Statement of Earnings accounts should have opening balances of so The row labeled "Unadjusted trial balance should be defined so that each cell equals the sum of the opening balance and the transactions in that column. The row labeled "Pre-closing balances should be defined so that cach cell equals the sum of the "Unadjusted trial balance and the adjustments and reclassifications in that column. The last row (i.c., May 27, 2017. Actual Balance Sheets and Statements of Earnings) serves as a check that your year-end balances are correct. You can define another row that calculates the difference between the actual year-end balances and your calculated balances. A necessary (but not sufficient) condition for a correct spreadsheet is that the value in each cell of the "difference" row is equal to zero. Some transactions will affect only the balance sheet (c.g. transaction #1), some will affect both the balance sheet and the income statement (e.g. transaction 12). Indicate increases in each account as positive numbers and decreases in each account as negative numbers. Use the "Retained Earnings" account only for the dividend entry (#23) and the closing entry. Record the transactions and adjustments that affect Statement of Earnings accounts directly to the appropriate revenue and expense accounts. You will close these temporary accounts to "Retained Earnings" in part g of the case. Concepts a. Prior to examining DD's balance sheet, think about what a restaurant chain does. What accounts do you expect to see on the balance sheet? Which are the major assets? Liabilities? Process b Record each of the following transactions for the year ended May 27, 2017, in the spreadsheet. All figures are in millions of dollars, 1. The company purchased $1,754.4 of food and beverage inventory on account. 2. The company had $5,816.5 in sales to customers. Or this, S149.3 was on account. 3. The cost of the food and beverage sold (H2 above) was $1,663.4. 4. The company paid cash for restaurant employees' wages and other labor expenses totaling $1.875.6. 5. The company paid cash for restaurant expenses totaling $888. 6. The company sold gift cards for which it collected $117.6 in cash. The cards expire in one year. The company does not recognize this as revenue until customers actually use (redeem) the cards 7. The company paid cash for selling general and administrative expenses totaling $473.8. 8. The company collected $140 of accounts receivable. 9. The company paid cash of $345.2 to purchase new equipment and cash of $2.2 to acquire other long-term assets. 10. DD Restaurants' management signed a new labor agreement with its employees. The two-year agreement takes effect on July 1, 2017, and calls for total wage and benefit Aun Dep. 49. increases of $120 per year. 11. DD Restaurants disposed of equipment that had a net book value of $61 for cash proceeds of $57.9. The difference is considered an operating loss on the statement of NU Equp. 61 carnings and is included in "Selling. general and administrative expense. The 519-54 equipment had an original cost of $110. 12. The company paid $1.752.5 to settle accounts payable. 13. During the year, the company paid bondholders 540.1 of interest. 14. Customers redeemed gift cards totaling $108.5. 15. On May 15, 2017, DD paid $33.5 for casualty and property insurance policies. Coverage on these one-year policies begins June 1, 2017 16. The company paid $59.5 to employees for wages and benefits relating to the prior-year. of this, $56 related to accrued payroll and $3.5 to accrued payroll taxes. 17. The company received $167.4 when it borrowed short-term debt. 18. The company repurchased its own stock for $371.2 cash. Hint: Treasury stock is a contra-equity account, which is why it is bracketed on the balance sheet. Purchasing more treasury stock makes the negative balance grow more negative (that is, larger in absolute terms). 19. The company granted stock options to certain key executives. These options had a fair value of $31.6 and DD recorded this as an expense ("Selling. general and administrative") and increased the common stock account by that amount. Cash was not affected. 20. During the year executives exercised previously-granted stock options. DD collected cash of $95.9 from the executives and received a tax refund from the government. These transactions affected a number of accounts. These transactions have already been entered into the spreadsheet in aggregate 21. The company repaid long-term debt amounting to $153. Hint: Part of this debt was classified as current portion of long-term debt on the May 28, 2016, balance sheet. 22. The company recorded income taxes expense of S153.7 which involved cash of $197.8 and other tax-related asset and liability accounts. This transaction has already been entered into the spreadsheet. 23. The company declared and paid $65.7 of dividends. 24. During the year, DD Restaurants closed one Red Lobster location and one Olive Garden location. No cash was involved in these closures but the company recorded an impairment charge of $2.4. These restaurant properties had an original cost of $9.2 and accumulated depreciation of 56.8 at the time DD closed them. c. Prepare and unadjusted trial balance from the spreadsheet. Hint: the unadjusted balance for Retained Earnings is $1,619. d. Based on the transactions you recorded in parts and c, list at least three adjustments or reclassifications that need to be made prior to preparing the final financial statements. c. Record in the spreadsheet, the following adjustments and reclassifications 25. By the middle of May 2017, DD Restaurants hnd decided to close certain under performing restaurants. Even though these restaurants have not yet been closed, DD must record the transactions in the current year. This necessitated three adjustments, as follows: a) DD must write down certain assets at the restaurants that will be closed such that the May 27, 2017, balance sheet reports the assets' (lower) fair value. To record this write- down, DD must reduce asset accounts by the following amounts: Land, buildings and equipment 396,0 Accumulated depreciation 145.8 Other assets (long-term) 3.9 In addition, DD must accrue anticipated payroll-related severance costs of S12.5, which will be paid next year. The combined asset write-down and payroll accrual result in a total charge of $266.6, which DD includes in an account labeled, "Loss from discontinued operations." b) During the year, the discontinued restaurants generate profit of $90.9. However, DD must reclassify this profit as discontinued for financial statement presentation purposes On the income statement, DD includes this profit in. "Loss from discontinued operations." Before any adjustments, the sales and expenses are recorded in the following accounts: Sales 44.6 Food and beverage expense 82.8 Restaurant labor expense 96.2 Restaurant expenses 53.5 Selling general and administrative expenses 34.5 c) For balance sheet presentation purposes, certain remaining assets and liabilities must be reclassified as discontinued assets and liabilities, respectively. DD labels these discontinued accounts as, Assets held for sale" and "Liabilities associated with assets held for sale". Before any adjustments, these assets and liabilities are included in the following accounts: Inventories 3579 Land, buildings and equipment 97.1 Other assets (long-term) 23 Accounts payable 37.1 Other liabilities (long-term) 5.2 26. The last payday for the company was May 22 2017. Restaurant employees had earned, but the company had not yet paid, $28.8 X hdditional wages through May 27, 2017.47k 42.1 DD Senior executives earned performance bonuses of $42.1, which the company will not pay until after 2020. DD included the executives' compensation in Selling general ther and administrative expense. 27. On May 15, 2016, DD paid the casualty and property insurance premium of $29.9 and recorded the amount as a prepaid expense (a current asset). Coverage on these one-year policies began June 1, 2016. Adjust for this expired insurance premium at May 27. 2017 by recording the insurance expense in "Selling, general and administrative expense. 28. Depreciation and amortization expense was $200.4 for the fiscal year. Or this, $196.1 restaurant labor-33 Accued.pylor nie sowie executive SG ** A Isabilities pertained to buildings and equipment and $4.3 related to amortization of certain intangible assets, which DD includes with "Other assets." 29. A review of the company's records revealed that $11.4 of previously deferred (uneared) rent had been damed during the year. DD includes rent revenue as a reduction to "Selling, general and administrative expense." 30. On May 27, 2017, DD Restaurant employees took a physical count of inventory. The cost of food and beverages at all continuing locations on that date was $209.6. 31. In May 2017, a consulting firm hired by DD Restaurants issued a report stating that the "Olive Garden brand name is worth $360. f. Construct a statement of earnings for the year ended May 27, 2017. Use the heading from your spreadsheet columns as the account titles. g. Close all the temporary accounts on the statement of earnings to retained carnings. h. Prepare the May 27, 2017, balance sheet. Use the headings from your spreadsheet columns as the account titles. i. For each of the transactions that involve cash, indicate whether the transaction would appear in the operating," "investing." of "financing" section of the statement of cash flows. belirtilmik OK~ Dithxx amount receiveable o feat. kitten restaurareader Dar2020 : ; A X 11 | | 3 Othe lishi11 199 eman mana F11 TFT :: THY ) : 114 | 14, 1 Salm f1 1 | |- | |- 11 14 || | , ||| 11 |||| 11 | | | THE MELI 19 | | , | 11, , ,, 11 114 | A| as Fi 1 ,1 | | TF 11 1 1 , 11 15 11, 11 11 | 11.1 19) 11 restaurareader Dar2020 : ; A X 11 | | | , 10 , ! ###11 ) |||| ,11,11 11 24 11 F1 , 1 1 , 11 HP , 14 (1) La | | 1999 ||| 1 blank - , , restaurareader Dar2020 : ; A X 11 | | - AA , F2A - PER,, 31 TTLE ely 11 19 Fre HEL FIT ||| | | ||| restaurareader Dar2020 : ; A X 11 | | - AA , , | | ||| , | 11 11 - JPT La LuLu | | || Las anage 1 1. L 11 1 1991 1959 19 111 | ||| T T | 19 | 11 10, | | , 1 | TWI ||||||||||| DD Restaurants, Inc. -- Preparing Financial Statements DD Restaurants, Inc. was incorporated in Florida in 1995 bur its parent company, GMRI begin in 1968 as Red Lobster Inne of America. Now DD Restaurant is the largest publicly held casual dining restaurant company in the world. In 2017, the company served over 350 million meals in 1.397 restaurants in the United States and Canada. The company operates the following restaurants: Red Lobster, Olive Garden, Bahama Breeze, Smokey Bones Barbeque & Grill and Seasons 52. (Source: Company Form 10-K) Learning Objectives Determine how economic events affect a company's financial statements Record economic events and prepare a simple set of financial statements. Understand how to adjust financial statements for accruals and reclassification In this case you will record basic transactions to recreate the May 27, 2017, balance sheet and income statement for DD Restaurants, Inc. The company's financial statement formats are included. You can use them to guide your work. Note: All dollar figures are in millions To complete this case you need to develop computerized spreadsheet. The structure of the spreadsheet follows after the case questions. Because of space constraints, the spreadsheet is reproduced on sequential pages here. However, you should create one worksheet with all the accounts across the top. Use the numbers from DD's Actual financial statements to enter the opening (i.e., May 28, 2016) and ending (ie, May 27, 2017) Balance Sheets and Statements of Earnings balances into the accounts on your spreadsheet. Create two separate accounts for "Land, building and equipment, one for the original cost of these assets (2016: $4,228.5 and 2017: $3.961.4) and a second account for the related accumulated depreciation (2016: 51.782.5 and 2017: $1.777). Show this second account as a negative amount (because it is a contra-asset account) so that the sum of the two accounts combined equals the "Land, building and equipment, net amount on the balance sheet (2016: 52.446.0 and 2017: $2,184.4). Some smaller balance sheet accounts have been combined in the spreadsheet. The Statement of Earnings accounts should have opening balances of so The row labeled "Unadjusted trial balance should be defined so that each cell equals the sum of the opening balance and the transactions in that column. The row labeled "Pre-closing balances should be defined so that cach cell equals the sum of the "Unadjusted trial balance and the adjustments and reclassifications in that column. The last row (i.c., May 27, 2017. Actual Balance Sheets and Statements of Earnings) serves as a check that your year-end balances are correct. You can define another row that calculates the difference between the actual year-end balances and your calculated balances. A necessary (but not sufficient) condition for a correct spreadsheet is that the value in each cell of the "difference" row is equal to zero. Some transactions will affect only the balance sheet (c.g. transaction #1), some will affect both the balance sheet and the income statement (e.g. transaction 12). Indicate increases in each account as positive numbers and decreases in each account as negative numbers. Use the "Retained Earnings" account only for the dividend entry (#23) and the closing entry. Record the transactions and adjustments that affect Statement of Earnings accounts directly to the appropriate revenue and expense accounts. You will close these temporary accounts to "Retained Earnings" in part g of the case. Concepts a. Prior to examining DD's balance sheet, think about what a restaurant chain does. What accounts do you expect to see on the balance sheet? Which are the major assets? Liabilities? Process b Record each of the following transactions for the year ended May 27, 2017, in the spreadsheet. All figures are in millions of dollars, 1. The company purchased $1,754.4 of food and beverage inventory on account. 2. The company had $5,816.5 in sales to customers. Or this, S149.3 was on account. 3. The cost of the food and beverage sold (H2 above) was $1,663.4. 4. The company paid cash for restaurant employees' wages and other labor expenses totaling $1.875.6. 5. The company paid cash for restaurant expenses totaling $888. 6. The company sold gift cards for which it collected $117.6 in cash. The cards expire in one year. The company does not recognize this as revenue until customers actually use (redeem) the cards 7. The company paid cash for selling general and administrative expenses totaling $473.8. 8. The company collected $140 of accounts receivable. 9. The company paid cash of $345.2 to purchase new equipment and cash of $2.2 to acquire other long-term assets. 10. DD Restaurants' management signed a new labor agreement with its employees. The two-year agreement takes effect on July 1, 2017, and calls for total wage and benefit Aun Dep. 49. increases of $120 per year. 11. DD Restaurants disposed of equipment that had a net book value of $61 for cash proceeds of $57.9. The difference is considered an operating loss on the statement of NU Equp. 61 carnings and is included in "Selling. general and administrative expense. The 519-54 equipment had an original cost of $110. 12. The company paid $1.752.5 to settle accounts payable. 13. During the year, the company paid bondholders 540.1 of interest. 14. Customers redeemed gift cards totaling $108.5. 15. On May 15, 2017, DD paid $33.5 for casualty and property insurance policies. Coverage on these one-year policies begins June 1, 2017 16. The company paid $59.5 to employees for wages and benefits relating to the prior-year. of this, $56 related to accrued payroll and $3.5 to accrued payroll taxes. 17. The company received $167.4 when it borrowed short-term debt. 18. The company repurchased its own stock for $371.2 cash. Hint: Treasury stock is a contra-equity account, which is why it is bracketed on the balance sheet. Purchasing more treasury stock makes the negative balance grow more negative (that is, larger in absolute terms). 19. The company granted stock options to certain key executives. These options had a fair value of $31.6 and DD recorded this as an expense ("Selling. general and administrative") and increased the common stock account by that amount. Cash was not affected. 20. During the year executives exercised previously-granted stock options. DD collected cash of $95.9 from the executives and received a tax refund from the government. These transactions affected a number of accounts. These transactions have already been entered into the spreadsheet in aggregate 21. The company repaid long-term debt amounting to $153. Hint: Part of this debt was classified as current portion of long-term debt on the May 28, 2016, balance sheet. 22. The company recorded income taxes expense of S153.7 which involved cash of $197.8 and other tax-related asset and liability accounts. This transaction has already been entered into the spreadsheet. 23. The company declared and paid $65.7 of dividends. 24. During the year, DD Restaurants closed one Red Lobster location and one Olive Garden location. No cash was involved in these closures but the company recorded an impairment charge of $2.4. These restaurant properties had an original cost of $9.2 and accumulated depreciation of 56.8 at the time DD closed them. c. Prepare and unadjusted trial balance from the spreadsheet. Hint: the unadjusted balance for Retained Earnings is $1,619. d. Based on the transactions you recorded in parts and c, list at least three adjustments or reclassifications that need to be made prior to preparing the final financial statements. c. Record in the spreadsheet, the following adjustments and reclassifications 25. By the middle of May 2017, DD Restaurants hnd decided to close certain under performing restaurants. Even though these restaurants have not yet been closed, DD must record the transactions in the current year. This necessitated three adjustments, as follows: a) DD must write down certain assets at the restaurants that will be closed such that the May 27, 2017, balance sheet reports the assets' (lower) fair value. To record this write- down, DD must reduce asset accounts by the following amounts: Land, buildings and equipment 396,0 Accumulated depreciation 145.8 Other assets (long-term) 3.9 In addition, DD must accrue anticipated payroll-related severance costs of S12.5, which will be paid next year. The combined asset write-down and payroll accrual result in a total charge of $266.6, which DD includes in an account labeled, "Loss from discontinued operations." b) During the year, the discontinued restaurants generate profit of $90.9. However, DD must reclassify this profit as discontinued for financial statement presentation purposes On the income statement, DD includes this profit in. "Loss from discontinued operations." Before any adjustments, the sales and expenses are recorded in the following accounts: Sales 44.6 Food and beverage expense 82.8 Restaurant labor expense 96.2 Restaurant expenses 53.5 Selling general and administrative expenses 34.5 c) For balance sheet presentation purposes, certain remaining assets and liabilities must be reclassified as discontinued assets and liabilities, respectively. DD labels these discontinued accounts as, Assets held for sale" and "Liabilities associated with assets held for sale". Before any adjustments, these assets and liabilities are included in the following accounts: Inventories 3579 Land, buildings and equipment 97.1 Other assets (long-term) 23 Accounts payable 37.1 Other liabilities (long-term) 5.2 26. The last payday for the company was May 22 2017. Restaurant employees had earned, but the company had not yet paid, $28.8 X hdditional wages through May 27, 2017.47k 42.1 DD Senior executives earned performance bonuses of $42.1, which the company will not pay until after 2020. DD included the executives' compensation in Selling general ther and administrative expense. 27. On May 15, 2016, DD paid the casualty and property insurance premium of $29.9 and recorded the amount as a prepaid expense (a current asset). Coverage on these one-year policies began June 1, 2016. Adjust for this expired insurance premium at May 27. 2017 by recording the insurance expense in "Selling, general and administrative expense. 28. Depreciation and amortization expense was $200.4 for the fiscal year. Or this, $196.1 restaurant labor-33 Accued.pylor nie sowie executive SG ** A Isabilities pertained to buildings and equipment and $4.3 related to amortization of certain intangible assets, which DD includes with "Other assets." 29. A review of the company's records revealed that $11.4 of previously deferred (uneared) rent had been damed during the year. DD includes rent revenue as a reduction to "Selling, general and administrative expense." 30. On May 27, 2017, DD Restaurant employees took a physical count of inventory. The cost of food and beverages at all continuing locations on that date was $209.6. 31. In May 2017, a consulting firm hired by DD Restaurants issued a report stating that the "Olive Garden brand name is worth $360. f. Construct a statement of earnings for the year ended May 27, 2017. Use the heading from your spreadsheet columns as the account titles. g. Close all the temporary accounts on the statement of earnings to retained carnings. h. Prepare the May 27, 2017, balance sheet. Use the headings from your spreadsheet columns as the account titles. i. For each of the transactions that involve cash, indicate whether the transaction would appear in the operating," "investing." of "financing" section of the statement of cash flows. belirtilmik OK~ Dithxx amount receiveable o feat. kitten restaurareader Dar2020 : ; A X 11 | | 3 Othe lishi11 199 eman mana F11 TFT :: THY ) : 114 | 14, 1 Salm f1 1 | |- | |- 11 14 || | , ||| 11 |||| 11 | | | THE MELI 19 | | , | 11, , ,, 11 114 | A| as Fi 1 ,1 | | TF 11 1 1 , 11 15 11, 11 11 | 11.1 19) 11 restaurareader Dar2020 : ; A X 11 | | | , 10 , ! ###11 ) |||| ,11,11 11 24 11 F1 , 1 1 , 11 HP , 14 (1) La | | 1999 ||| 1 blank - , , restaurareader Dar2020 : ; A X 11 | | - AA , F2A - PER,, 31 TTLE ely 11 19 Fre HEL FIT ||| | | ||| restaurareader Dar2020 : ; A X 11 | | - AA , , | | ||| , | 11 11 - JPT La LuLu | | || Las anage 1 1. L 11 1 1991 1959 19 111 | ||| T T | 19 | 11 10, | | , 1 | TWI |||||||||||