A COMPREHENSIVE ACCOUNTING CYCLE PROBLEM: Subject #3 Amber and Zack Wilson decide that they will create a new corporation, Canyon Canoe Company. Canyon Canoe Company is a service-based company that rents canoes for use on local lakes and rivers. The business began operations on December 1, 2018. The new business use the following accounts Cash Office Supplies Land Accumulated Depreciation - Building Utilities Payables Interest Payable Notes Payables Retained earning Income Summary Rent Expense Supplies Expense Depreciation Expense - Building Interest Expense Accounts Receivable Prepaid Insurance Building Accounts Payable Salaries Payables Unearned Revenue Common stock Dividends Service Revenue Salaries Expense Utilities Expense Telephone Payable The corporation performs adjusting entries monthly. Closing entries are performed annually on December 31. During December, the corporation entered into the following transactions Data for Adjusting Entries a. Office supplies on hand, $165 b. Rent of one month has been used. e. Determine the depreciation on the building using straight-line depreciation. Assume the useful life of the building is five years and the residual value is $5,000. d. $400 of unearned revenue has now been earned. e. The employee who has been working the rental booth has earned $1,250 in wages that will be paid January 15, 2019. f. Canyon Canoes has earned $1,850 of canoe rental revenue that has not been recorded or received g. Determine the depreciation on the canoes purchased on December 2 using straight-line depreciation. Assume the useful life of the canoes is 4 years and the residual value is $0. h. Interest expense accrued on the notes payable, $50. i. It is estimated that the company is subject to a combined federal and state income tax rate of 20 percent of income before income taxes (total revenue minus all expenses other than income taxes). These taxes will be payable in January. Instructions a. 2 Perform the following steps of the accounting cycle for the month of December: 1. Journalize the December transactions. Do not record adjusting entries at this point. Post the December transactions to the appropriate ledger accounts. 3. Prepare the unadjusted trial balance columns of a 10-column worksheet for the year ended December 31. 4. Prepare the necessary adjusting entries for December. 5. Post the December adjusting entries to the appropriate ledger accounts. 6. Complete the 10-column worksheet for the year ended December 31. b. Prepare an income statement and statement of retained earnings for the year ended December 31, and a balance sheet (in report form) as of December 31. c. Prepare required disclosures to accompany the December 31 financial statements. Your solution should include a separate note addressing each of the following areas: (1) depreciation policy, (2) maturity dates of major liabilities. d. Prepare closing entries and post to ledger accounts. e. Prepare an after-closing trial balance as of December 31 Calibri (Body) 11 X Cut Copy A- A- Paste O, A I B U Format 132 xfx D A 8 3 B 0 1 2 -3 land Note payable account payable unearned revenue Salaries payable interest payable Dividend payable Common stock Retained earning Dividend service revenue Utilities Expense Salaries expense Rent Expense Office supplies expense Depreciation expense furniture Depreciation expense building Depreciation expense Equipment interest expense Insurance expense Advertising Expense Income summary 5 26 27 29 30 31 32 33 34 35 36 37 38 39 40 w Insert Format Tools Data Window Help template excel project.xls (Compatibility Mode] Formulas Data Review Page Layout View General 11 dyl. Wrap Text A- A %) Merge & Center Conditions Format Formatting Table Call Style E D General Journal (daily transactions) DR CR Date Account and Explanation Wor COM P W 19 MacBook Air Excel File Edit View Insert Window Help Format Tools Data template excel project Formulas Data Review View Home Draw Page Layout Calibri (Body) - 11 Ger Wrap Text - AA Insert X Cut 3 Format Merge & Center Paste B U- 141 G A $ D General Journal (adjusting entries) Account and Explanation DR OR Date 0 1 12 16 17 18 19 20 -21 Journal general info Ludger out Instruction Account Adjusting Entries template excelets Compatibility Model Home Dw Page Layout Data Revit View Car Body - 11 AA w Custom Copy Format Marge Alter 9. Cel wat Pages 838 x N AN be G Dare 11 10 Dus C 12 20 2 A Det Datin Od T Account Journal Wo Laccounts Account com W 19 MacBook Air Calibr (Body wet Custom M Xon Copy Format B 2 Marge A. Condos para Palety Delta BB + Account 41 Credit Dab DO Gede C ACT 3 Ant 50 Date M Ordet De GR be Det Ort Date 5 A NE Date Gre C De Credit C AN DE D D Locos wo NEN 0 W 19 MacBook Air Csil (Body 11 A. A W Custom M Merge Care 65 . Condor Frate 27 3 X A me w O De De D Or Dabar A 30 alance G ute Dett D Credit De Route Duc * 25 C D D. Induction no Account Ledoute w RE 19 W O P MacBook Air Cory Custom Paste Parma Marge C. Conditions for Formatting Table 110 X G 1 . dance Credit Account Title Adjustments Debit Cred Adjunedance Debit Credit Income Det Credit Debit Credit 10 10 14 18 19 20 21 23 24 Instructions general info Accounts Jouma Adjusting Entries Lediger accounts Worksheet Income Statement NOV W O X 19 template excel Draw Page Layout Formulas Home Insert X Cut Data Review View Arial 10 - AA- Wrap Text Copy Paste B T U A. Format Merge & Center F6 ex A B D G H 6 7 10 12 13 14 15 16 17 18 20 23 23 24 25 26 Cut 10 Arial Wrap To A- A 9 Copy lill A - Merge & Cen Paste 00 I Format G11 X fx G H F B E D c 1 2 3 4 5 09 O 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Excel Fle Edit View Insert Format Tools Data Window Help template excel projects Compatty Mode Home Draw Page Layout Formulas Data Review View Insert X out Copy Calibrl (Body 11 Wrap Text General B 1 Format - Marge Center Condos Fort Formatting and H24 X f fx A D H 1 3 4 5 6 2 10 11 12 13 14 IS TE 19 20 23 22 20 35 23 11 Date Account and Explanation DR CR 7 8 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
