I have scanned the following assignment of P3-35A total of 1-4 excel spreadsheets for template

P4-27A- Has 6 excel spreadsheet templates for assignment

Chapter 3-4

The templates have tabs as listed above

Date a. Dec. 31 b. Dec. 31 c. Dec. 31 d. Dec. 31 e. Dec. 31 f. Dec. 31 g. Dec. 31 Accounts and Explanation Debit Credit Bal. Bal. Cash 7,700 Accounts Payable 3,600 Bal. Service Revenue 15,400 Bal. Bal. Bal. Accounts Receivable Bal. 19,200 Salaries Payable Salaries Expense Bal. 3,500 Bal. Bal. Bal. Bal. Bal. Bal. Bal. Bal. Bal. Prepaid Rent 2,400 Unearned Revenue 2,600 Bal. Bal. Office Supplies 1,300 Arlington, Capital 39,500 Equipment 19,900 Arlington, Withdrawals Bal. 9,500 Bal. Rent Expense Bal. Depreciation ExpenseEquipment Bal. Bal. Bal. Advertising Expense Bal. 1,900 Bal. Accumulated DepreciationEquipment 4,300 Bal. Supplies Expense Bal. Bal. ARLINGTON AIR PURIFICATION SYSTEM Account Title Adjusted Trial Balance December 31, 2014 Balance Debit Cash Accounts Receivable Prepaid Rent Office Supplies Equipment Accumulated DepreciationEquipment Accounts Payable Salaries Payable Unearned Revenue Arlington, Capital Arlington, Withdrawals Service Revenue Salaries Expense Rent Expense Depreciation ExpenseEquipment Advertising Expense Supplies Expense Total Credit $0 $0 How will Arlington Air Purification System use the adjusted trial balance? ELIAS REAL ESTATE APPRAISAL Income Statement Year Ended June 30, 2014 Revenues: Service Revenue Expenses: Salaries Expense Interest Expense Depreciation ExpenseBuilding Insurance Expense Utilities Expense Supplies Expense Total Expenses Net Loss - ELIAS REAL ESTATE APPRAISAL Statement of Owner's Equity Year Ended June 30, 2014 Elias, Capital, July 1, 2013 Owner contribution Net loss for the year Owner withdrawal Elias, Capital, June 30, 2014 $0 0 $0 0 0 hint: owner withdrawals reduce capital - think! Subtract or add the withdrawal amount $0 ELIAS REAL ESTATE APPRAISAL Balance Sheet June 30, 2014 Assets Current Assets: Cash Accounts Receivable Office Supplies Prepaid Insurance Total Current Assets Plant Assets: Building Less: Accumulated DepreciationBuilding Land Total Plant Assets Total Assets $0 0 0 0 $0 $0 0 Remember to subtract accumulated depreciation 0 0 0 $0 Liabilities Current Liabilities: Accounts Payable Interest Payable Salaries Payable Unearned Revenue Total Current Liabilities Long-term Liabilities: Notes Payable Total Liabilities $0 0 0 0 $0 0 $0 Owner's Equity Elias, Capital Total Liabilities and Owner's Equity 0 $0 Date Jun. 30 30 30 30 Accounts and Explanation Debit Credit Bal. Cash 4,900 Bal. Bal. Bal. Elias, Withdrawals 27,900 Bal. Accounts Receivable 5,300 Clos. Income Summary Clos. Bal. 0 Office Supplies 2,400 Service Revenue 48,200 Interest Payable 8,800 Bal. Bal. Bal. 0 Bal. Bal. Accounts Payable 19,500 Bal. Bal. 0 Prepaid Insurance 1,800 Bal. Bal. Bal. Building 74,400 Bal. Bal. Salaries Payable 2,200 Bal. Bal. Bal. Bal. Bal. Insurance Expense 4,500 Unearned Revenue 1,300 0 Salaries Expense 33,300 1,300 Clos. Bal. Bal. Accumulated DepreciationBuilding 26,700 Bal. Bal. Bal. Bal. Notes Payable 0 40,000 Supplies Expense 600 Bal. 40,000 Bal. 40,500 Bal. Clos. Elias, Capital Bal. Bal. Bal. Land 13,600 Bal. Bal. Bal. 0 Interest Expense 8,800 0 0 Bal. Clos. Clos. Bal. Clos. Bal. Clos. Depreciation ExpenseBuilding Bal. 7,500 Clos. Clos. Bal. Utilities Expense 2,200 Clos. Clos. Bal. Clos. 0 ELIAS REAL ESTATE APPRAISAL Post-Closing Trial Balance June 30, 2014 Account Title Cash Accounts Receivable Office Supplies Prepaid Insurance Building Accumulated DepreciationBuilding Land Accounts Payable Interest Payable Salaries Payable Unearned Revenue Notes Payable (long-term) Elias, Capital Total Balance Debit Credit $0 $0 The .,\\illusting Proc,.'.. 187 Requirements l. Journalize the acliusting entries needed on December 31 for Dillon Fishing Ci'rerters. Assume Dillon records adjusting enries only at the end of the year. 2. If i)ilion had not recorded the aci.lusting enuies, indicate which specific category of accounts on rhe financial statements would be misstated and if the misstaternent is overstated or understated. Use the following table as a guide. Adjusting Entry Specific Caieqory Specific Category of Accounts on the Balance Sheet Over / Understated the Stateinent of Accounts on lncome Over / Understated P3-35A Jonrnalizing and posting adiustments to the Tlaccounts and preparing an adusted trial balance The unadjusted trial balance of fulington Air Purificadon 2014, and thc data needed for the adjustrnenr follow. Sy,5sss, at Decembcr 31, Learning Objectives 3, 4 3. Adlusted trial balance, $70,500 total ARLINGTON AIR PURIFICATION SYSTEM Unadjusted Trial Balance December 31,2014 Balance Debit 5 7,700 Account Title Cash Credit 19,200 Accounts Receivable 2,400 Prepaid Rent 1.300 Office Supplies i 9,900 Equipment $ 4,300 Accumulated Deprecration-Equipment 3,600 Accounts Payable Salaries Payable 2,600 Unearned R...enue Arlington, Caprtal 39,500 Arlington, Wrthdrawals 9,500 15,400 Service Revenue 3,500 Salaries Expense Rent Expense Depreciation Expense-[q uipment 1,900 Advertising Expense Supplies Exoense $ 6s,400 Total r\\cljustment clatr at December 3l :$ 6s,400 fbllow: a. On Dcccrnbcr i 5, Arlingtor-r contractcd to per{brm scrvices fbr a client rccciving in advance. Arlington rccordcd this reccipt of cash as Urrcarned Rcvcnuc. $2,600 As of Deccrnber 31, Arlington has completed $1,,l00 of thc scrvices. b. Allington 1)atngren's prcpaicl nvo rxonths of rcnt on Decemlrcr Accountirl. The Financiai ChJpters, Tenth Copyright O 2014 !/ Pearson Educa:.n, lnc. 1. EC :,0n. by Tracie Nobles, Brenda Mattison, and Ella Mae Matsumura. Published by Prentice Hall. 188 chapter 3 c. Arlington used $500 of office supplies. d. Depreciation for the equipment is $900. e. Arlington received a bill for December's online adverti.sing, $900. Arlington will nor paF rhe bill unril Jarluary. (Use Accounts Payable.) f. Arlington pays its emplo)'ees on Monday for the previous weekly Its ernployees earn gI lWednesday this year. wages. ,500 for a ffve-day workweek. December 31 falis on g' o, c)ctober 1, Arlington agreed to provide a four-month air system check (beginning October l) for a cusromer for $3,200. Arlingron has completeil the system check every monrh, bur payment has not yer been received and no entries have been made. Requirements 1. Journalize the adjusting entries on l)ecember 31. 2. 3. 4. Learning Objectives 3, 4 3. Adjusted trial balance, $449,990 : ot.r l Usir:g the unadjusted trial balance, open rlle Ttaccounrs with the unacijusted balances. Post the adjusring enrries to the fiaccounts. Prepare the adjusted trial balance. How will Arlington Air Purification System use rhe adjusted trial balance? P3'36A Journalizing and posting adiustments to the four-column accognts 1nd preparing an adjusted trial balance The unadjusted trial balance of Lexington Inn company at l)ecember 31,2014, and the data needed for rhe adjustmenrs fdllow. @ LEXINGTON INN COMPANY Unad.iustecJ Trial Balance Decem::er 31, 2014 Balance Debit Account Title Casi: .; Credit 2, 100 1 Accounts Recervable 1 4,300 Prep"rrd lnsurance, 2, Otflce 5upplies 1,10C Building ,i 1 'l r00 ,000 AccLrmulaterl Depreciation Burlding $ 31 2,!00 Accounts Payable 1,9:,Ll Salaries Payable Unearned Revenue 2,.i00 Calvasina, Capital Cal,iasina, Withdraw;is "t 4,140 1 I 5,600 2,860 Senrice Re,venue Salaries Expense 2,1A{) insurance fxpense Depreciation Expense-Buildrnq Advertisinq Ixpense 810 Suppiles Ixpense Total 5 M7,190 5 447,190 Horngren's Accounting, The Financial chapters, Tenth Ediiion, by Tracie Nobles, Brenda Mattison, and Ella Mae Matsumura. pubtished by prentice Hail Copyright O 2014 by Pearson Education, lnc 254 cbapter 4 *r*ffi$) & Learning Objectives 1, 3, 4 Net Loss $(8,700) P4-27A Preparing ftnancial statements including a classifted balance sheet in report form, preparing and posting closing entries, and preparing a post-closing trid balance 'l'hc adjusted trial balancc o[Elias Real Estate Appraisal at June 30,2014, follows: ELIAS REAL ESTATE APPRAISAL Adjusted Trial Balance June 30. 2014 Balance Account Title Debit $ Cash credit 4,900 Accounts Receivable s,300 O{fice Supplies 2,400 Prepaid lnsurance 1,800 74,400 Building $ Accumulated Depreciation-Building 26,700 13,600 Land Accounts Payable 1 9,500 lnterest Payable 8,800 Salaries Payable 2,200 Unearned Revenue 1,300 Notes Payable (long-term) 40,000 40,500 Elias, Capital 2t,900 Elias, Withdrawals 48,200 Service Revenue 4.500 lnsurance Expense 33,300 Salaries Expense 600 5uoplies Expense lnterest Expense 8,80C Utilities Expense 2,200 /,5A0 Depreciation Expense-Building s 18?200 Total 5 187,200 Requirements l. Prcparc the conrpanl,'s incornc staterrcnl for rhe ycrr crrdcclJrrrrc at),2014. 2. Prepare ihe cornplrry'.s statemerlt of ou,ner'.s eqrriry fbr rhc year enderl irine -10, 2014. Assumc tl-rat thcrc rvcr.: no contributious rnadc br. tlrc orvncr rlui-ing thc vcar. l. Prcparc thc cornpanl,'.s classilied balancc shcct in rcport lbrrn arJrrnc 30,2014. 4. Jorirnalize thc closing 5. Opcn theT-lccounts entries. using thc balances fiorn thc acljustccl trial balancc :rnd post thc closing cntrics to thc T-accouuts. 6. Prepare thc cornparry'.s post-closing trial balancc Hornsren's Accountins. The Financial chapters, Tenth Edition, by Tracie Nobles, Brenda Mattison, ,"0 at]rrnc 30,2014. .,n*?"rilif8T[ft r;B"Xltffi:li