need help on closing entries please!

N M D M E G H F Diner 64, Inc. This case study must be completed in Excel program using the formats provided in this workbook. Objectives: 1. Practice the steps involved in the Accounting Cycle 2. Practice electronic spreadsheet skills a Formulas b. Linking worksheets 3 Instructions 1 21. Using the Chart of Accounts provided record the transactions for month of June in the General Journal. Do not add new accounts. 4 2. Post the General Journal entries to the General Ledger 5 6.3. Prepare the Unadjusted Trial Balance in the Trial Balance tab. 7 8 4. Journalize any adjusting entries in the General Journal and post to the General Ledger Show your calculations for the adjustments in the Adjustments tab 20 21 5. Prepare the Adjusted Trial Balance in the Trial Balances tab, 23 6. Prepare the closing journal entries in the General Journal and post to the General Ledger 24 25 7. Prepare the Post-Closing Trial Balance in the Trial Balances tab Also the Income Statement 26 and Balance Sheet columns on the Trial Balance tab Closing Gener 19 22 8. Prepare classified statements for the income Statement, Statement of Retained Earnings, Statement of Stockholders' Equity, and Balance Sheet Statement for the period of July 1, 2020 - June 30 2021 in the appropriate tabs Ignore the effects of income tax 10. Note the following additional information 1 The business began on July 1, 2020 2. The period under consideration is July 1, 2020 June 30, 2021 3. For the purposes of this assignment, ignore the effects of cost of goods sold income tax property tax sales tax, and payroll tax 4. Straight-line depreciation method is used 5. The supplies on hand June 30, 2021 were $750, 4 5 8 7 8 9 0 -1 -2 13 34 5 46 47 48 49 50 51 52 53 6. Physical count of food inventory on hand June 30, 2021 was $1,500 7. The telephone bill for June 30, 2021 for $135 was received July 2021 8 The utility bill for June 30, 2021 for $285 was received July 2021 9. For the purposes of this assignment consider the note payable for delivery van purchase to be a current liability 10. The following transactions occurred in the first month of operations and are reflected in the geceral ledger account balances D G N P B c E H M 10. The following transactions occurred in the first month of operations and are reflected in the general ledger account balances July 1, 2020 Liz Burnes and her brother James each invested $15,000 in a corporation they formed to run Diner 64. Inc. Each were issued 1,500 shares of $10 par value common stock July 1, 2020 The corporation took a $30,000 small business loan from a local bank. The loan is an interest only loan for three years at a fixed rate of 12% per year A baloon payment of the principal will be due in 3 years. The monthly interest payment is due by the 10th of the following month July 1, 2020 Because this was a new business, the landlord required the business to prepay $6,000 for the rent for the first six month, plus a $1,500 security deposit for a total cash outlay of $7,500 July 1, 2020 The business purchased equipment and fixtures for $20,000 in cash, The assets have a useful life of 10 years July 1, 2020 The company purchased a delivery van value at $40,000 with a $15,000 down payment and a 3-year, $25,000 note payable with an annual intereste rate of 6%. The truck has a 10-year useful life. The monthly payment including principal and interest is $76055. July 8, 2020 Preston Hill, a local Bed & Breakfast (B&B). arranges with Diner 64 to provide breakfast for their guests at $10 per person per day Diner 64 will bill the B & B at the end of each month for the meals provided. Payment is Tequired by the 10th of the next month Joly 15, 2020 Paid $4.800 for two year fire and liability insurance with coverage beginning September 1 2020 Accounting Transactions for the Month of June 2021 Description Paid June rent in the amount of $1,000. Paid $750 for six- months auto insurance policy beginning June 1. Food purchases in the amount of $1,200 paid in cash. The business purchased $2,500 for supplies on account from Jones Supplies Co. Payment received from Preston Hill B & B for May 2021. Food purchases in the amount of $600 paid in cash. Cash receipts were deposited in the amount of $3,800. 3 19 20 21 22 Paid $1,200 to employees for wages earned during the first two weeks of June. Paid amount due to Jones Supplies Co. Cash receipts were deposited in the amount of $4,500. Paid utilities bill in the amount of $355. Paid telephone bill in the amount of $170.00 Cash receipts were deposited in the amount of $3,000. Paid for cleaning and maintenance expense for the month, $1,150. Truck payment remitted - Total $760.55 (Principal = $664.73, Interest = $95.82) 4 5 36 B7 38 39 Cash receipts were deposited, $6,500 Sent and recorded invoice to Preston Hill B & B for month of June in the amount of $600. 40 41 42 Paid $3,850 to the company credit card for the following charges Advertising $1,850 Advertising: $1,850 Uniforms: $300 Repairs: $250 Printing: $800 Gasoline: $650 Paid $1,000 to employees for wages earned during the last two weeks of June. Sold $250 in gift certificates to customers in cash. Dividends paid to shareholders in the amount of $500. X Arial 11 A A = ab Paste BIU A v Clipboard 2 5 Font L2 Alignment A4 X fix B C A B 1 Diner 64, Inc. D E m F G 2 N 3 Closing entries 4 5 6 7 8 OD 9 0 10 11 12 13 14 15 16 17 18 19 20 21 A Soon NNN 25 N M D M E G H F Diner 64, Inc. This case study must be completed in Excel program using the formats provided in this workbook. Objectives: 1. Practice the steps involved in the Accounting Cycle 2. Practice electronic spreadsheet skills a Formulas b. Linking worksheets 3 Instructions 1 21. Using the Chart of Accounts provided record the transactions for month of June in the General Journal. Do not add new accounts. 4 2. Post the General Journal entries to the General Ledger 5 6.3. Prepare the Unadjusted Trial Balance in the Trial Balance tab. 7 8 4. Journalize any adjusting entries in the General Journal and post to the General Ledger Show your calculations for the adjustments in the Adjustments tab 20 21 5. Prepare the Adjusted Trial Balance in the Trial Balances tab, 23 6. Prepare the closing journal entries in the General Journal and post to the General Ledger 24 25 7. Prepare the Post-Closing Trial Balance in the Trial Balances tab Also the Income Statement 26 and Balance Sheet columns on the Trial Balance tab Closing Gener 19 22 8. Prepare classified statements for the income Statement, Statement of Retained Earnings, Statement of Stockholders' Equity, and Balance Sheet Statement for the period of July 1, 2020 - June 30 2021 in the appropriate tabs Ignore the effects of income tax 10. Note the following additional information 1 The business began on July 1, 2020 2. The period under consideration is July 1, 2020 June 30, 2021 3. For the purposes of this assignment, ignore the effects of cost of goods sold income tax property tax sales tax, and payroll tax 4. Straight-line depreciation method is used 5. The supplies on hand June 30, 2021 were $750, 4 5 8 7 8 9 0 -1 -2 13 34 5 46 47 48 49 50 51 52 53 6. Physical count of food inventory on hand June 30, 2021 was $1,500 7. The telephone bill for June 30, 2021 for $135 was received July 2021 8 The utility bill for June 30, 2021 for $285 was received July 2021 9. For the purposes of this assignment consider the note payable for delivery van purchase to be a current liability 10. The following transactions occurred in the first month of operations and are reflected in the geceral ledger account balances D G N P B c E H M 10. The following transactions occurred in the first month of operations and are reflected in the general ledger account balances July 1, 2020 Liz Burnes and her brother James each invested $15,000 in a corporation they formed to run Diner 64. Inc. Each were issued 1,500 shares of $10 par value common stock July 1, 2020 The corporation took a $30,000 small business loan from a local bank. The loan is an interest only loan for three years at a fixed rate of 12% per year A baloon payment of the principal will be due in 3 years. The monthly interest payment is due by the 10th of the following month July 1, 2020 Because this was a new business, the landlord required the business to prepay $6,000 for the rent for the first six month, plus a $1,500 security deposit for a total cash outlay of $7,500 July 1, 2020 The business purchased equipment and fixtures for $20,000 in cash, The assets have a useful life of 10 years July 1, 2020 The company purchased a delivery van value at $40,000 with a $15,000 down payment and a 3-year, $25,000 note payable with an annual intereste rate of 6%. The truck has a 10-year useful life. The monthly payment including principal and interest is $76055. July 8, 2020 Preston Hill, a local Bed & Breakfast (B&B). arranges with Diner 64 to provide breakfast for their guests at $10 per person per day Diner 64 will bill the B & B at the end of each month for the meals provided. Payment is Tequired by the 10th of the next month Joly 15, 2020 Paid $4.800 for two year fire and liability insurance with coverage beginning September 1 2020 Accounting Transactions for the Month of June 2021 Description Paid June rent in the amount of $1,000. Paid $750 for six- months auto insurance policy beginning June 1. Food purchases in the amount of $1,200 paid in cash. The business purchased $2,500 for supplies on account from Jones Supplies Co. Payment received from Preston Hill B & B for May 2021. Food purchases in the amount of $600 paid in cash. Cash receipts were deposited in the amount of $3,800. 3 19 20 21 22 Paid $1,200 to employees for wages earned during the first two weeks of June. Paid amount due to Jones Supplies Co. Cash receipts were deposited in the amount of $4,500. Paid utilities bill in the amount of $355. Paid telephone bill in the amount of $170.00 Cash receipts were deposited in the amount of $3,000. Paid for cleaning and maintenance expense for the month, $1,150. Truck payment remitted - Total $760.55 (Principal = $664.73, Interest = $95.82) 4 5 36 B7 38 39 Cash receipts were deposited, $6,500 Sent and recorded invoice to Preston Hill B & B for month of June in the amount of $600. 40 41 42 Paid $3,850 to the company credit card for the following charges Advertising $1,850 Advertising: $1,850 Uniforms: $300 Repairs: $250 Printing: $800 Gasoline: $650 Paid $1,000 to employees for wages earned during the last two weeks of June. Sold $250 in gift certificates to customers in cash. Dividends paid to shareholders in the amount of $500. X Arial 11 A A = ab Paste BIU A v Clipboard 2 5 Font L2 Alignment A4 X fix B C A B 1 Diner 64, Inc. D E m F G 2 N 3 Closing entries 4 5 6 7 8 OD 9 0 10 11 12 13 14 15 16 17 18 19 20 21 A Soon NNN 25