QUESTION 1 stin : : Terrplale xtixe: Use the following accounts as appropriate. 1. Doe Istio common stock iti exchange for canh of $0,000 1.Dec Paud the promatn in diduance on a one year msarance pobicy, 1400 1.DeC Purchanad Eoueprient for $3,600cesh. 5. Doc Prechirsed office supplies tram X YZZ Campary on accounc, 5400. 15- Doe Provided servaces to customers for $5,400 cash. 16 Dec Aprovded services to castomer ABC inc on account, $7.500. 17. Dec. Rocowod 8800 cash in advance from a custamer for servoes to be pronded an January 22.Dec: Paid $220 to XYZ company for the Doc 5 purchase on account. 23-Doc Recotved $1,300 cash trom customer, ABC inc, on acoourt 25-D0c. Paid the rere for the current month, $500. 2a-Dec Paid salaries to employees for work performod from Docember 1 through December 28,$4,200. 29-Dec Doclared and pad dovidends to stockhobders $700. 30-Dec Purchased lend by signing 3 yeor note payablo for $5,000 taver 4 )ien 1 31. Doc Ook moneis insurance has eppeced 140 31 thee The ostermect dechecishon an equaryen is kiol. contries haine beien forking check point t: Aefrinted that todivis todal detitiedar - 20,700 Mrovide the following amounts from the Adfusted Trial flaiance: fle nure to enter all numbers as posibve and no answer should be iett blank.) answer should tre leth blank.) Provide the follewing ambumt frem the theoest Statemest tos sure to enter all monbers as posive and ao answer shivid. twe left blank.) 15. thereion i4eyonder. If Desociobontiperes: Provide the fesiowing ameunt from the Income statement; ( Ee sure to enter all numbers as positive and no antwer ahoutd be lett blank. Provide the following accoumt balances from the Balance Sheet cBe sure fo enter all mambers as positive and no answer should be left blanki Prowide the following account balance trem the Statantent of stockholders" Equity: (Be sure to enter all numbers as pasithe and no answer shoutd be left blank) 218 Dividerich Provide the tollowing account belance from the Statement of steckhobdern' Equity. ine sure to enter all numbers as positive and na answer should be leit blank.) 20 Dwiseredn fiver beon persind beomposinet Check Point 2 : Totad Assets 1 t 14,500 JESTON? (of Reriened Fieneres on the Bialincel thent? Propare joumal entres to record the Docomber transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template x lsx". Uso the following accounts as aporopniate Post all of the Docomber transactions from the "General Journal tab to the T-accounts under the "T-Accounts" tatb in the oxcel template file "Acoounting Cycle Exool Tomplato x isx". Assume there are no beginining belances in any of the accounts. Compule the balance for each T-account after a all of the entrias have been posted Propare the unadjusled trial byance on the "Uradiusied Trual Balance" tab. 1 Provide the total of the crodit column from the Unadiusted Irial Balance Record the Docerabor adfusting entries on the "Genoral Jouenal" tab. 31-Doc Ono month's insurance has expired $40. 31. Dec: The tomaining a riventory of umased offeo sunclios is 390 31 Doc tho estirnated dopreciation on equeperont is 560. 31. Deo Sakanos incurrod from Docomber 20 to Docember 31 but not yot poid or rocorded fotal $450 Step 6: Pose all of the adgrsting entnes to the Traccounts on the "T.Accounte" tab. Computo the balance for each T-account after all of the adisting critios hawe boon postod. Slep 7. Pregare the adjusted trial balance on the 'Aldusted Trial Balanoe' tab Check point 1: Adjusted trial balance total debicicredt = 20,390 Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no artswer should be left blank.) Provide the following amount from the income Statement: (Be sure to enter all numbers as positive and no answer should be left blank.) Provide the following account balances from the Balance sheet: (De sure to enter all numbers as positive and no answer should be left blank.) Provide the following account balance from the statement of stockholders' Equity: Be sure to enter all numbers as pesitive and no answer should be left blank.) Dividends Provide the following account balance from the statement of stockholders' Equity: (Ble sure to enter all numbers as positive and no answer should be left blank.) 28 Dimbonds: Step 9. Rocord the elosing entres on the "General wournal" tob hamo beon posted Step 11- Prepare the post closing tral bolance tor tlvi month ended Decentor 31, 200 con the Poat Closina. Trial Balance tob. 29 Provise the total of the dobit coturn from thw Post Closing Inal flalance been poslend Check Point 2 Totat Assets is 14.570 QUESTION2 31. Doess the ending talarke of the Retarned Rarnings tuccount agree with tho balanco af Retained Earnings on the Bdance Sheet? Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answer should be left blank.) Prepare the ficcorio Statement, Staternent of Stockholder's Equity and Classified Balance Sheot on the "Fuancial Statements" tab for the Fionth ended Decrember 31,20x Provide the following amount from the lncome statement: (Be sure to enter all numbers as positive and no answer should be left blank.) 15 Service Perenue 16 Deprecation Expense QUESTION 1 stin : : Terrplale xtixe: Use the following accounts as appropriate. 1. Doe Istio common stock iti exchange for canh of $0,000 1.Dec Paud the promatn in diduance on a one year msarance pobicy, 1400 1.DeC Purchanad Eoueprient for $3,600cesh. 5. Doc Prechirsed office supplies tram X YZZ Campary on accounc, 5400. 15- Doe Provided servaces to customers for $5,400 cash. 16 Dec Aprovded services to castomer ABC inc on account, $7.500. 17. Dec. Rocowod 8800 cash in advance from a custamer for servoes to be pronded an January 22.Dec: Paid $220 to XYZ company for the Doc 5 purchase on account. 23-Doc Recotved $1,300 cash trom customer, ABC inc, on acoourt 25-D0c. Paid the rere for the current month, $500. 2a-Dec Paid salaries to employees for work performod from Docember 1 through December 28,$4,200. 29-Dec Doclared and pad dovidends to stockhobders $700. 30-Dec Purchased lend by signing 3 yeor note payablo for $5,000 taver 4 )ien 1 31. Doc Ook moneis insurance has eppeced 140 31 thee The ostermect dechecishon an equaryen is kiol. contries haine beien forking check point t: Aefrinted that todivis todal detitiedar - 20,700 Mrovide the following amounts from the Adfusted Trial flaiance: fle nure to enter all numbers as posibve and no answer should be iett blank.) answer should tre leth blank.) Provide the follewing ambumt frem the theoest Statemest tos sure to enter all monbers as posive and ao answer shivid. twe left blank.) 15. thereion i4eyonder. If Desociobontiperes: Provide the fesiowing ameunt from the Income statement; ( Ee sure to enter all numbers as positive and no antwer ahoutd be lett blank. Provide the following accoumt balances from the Balance Sheet cBe sure fo enter all mambers as positive and no answer should be left blanki Prowide the following account balance trem the Statantent of stockholders" Equity: (Be sure to enter all numbers as pasithe and no answer shoutd be left blank) 218 Dividerich Provide the tollowing account belance from the Statement of steckhobdern' Equity. ine sure to enter all numbers as positive and na answer should be leit blank.) 20 Dwiseredn fiver beon persind beomposinet Check Point 2 : Totad Assets 1 t 14,500 JESTON? (of Reriened Fieneres on the Bialincel thent? Propare joumal entres to record the Docomber transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template x lsx". Uso the following accounts as aporopniate Post all of the Docomber transactions from the "General Journal tab to the T-accounts under the "T-Accounts" tatb in the oxcel template file "Acoounting Cycle Exool Tomplato x isx". Assume there are no beginining belances in any of the accounts. Compule the balance for each T-account after a all of the entrias have been posted Propare the unadjusled trial byance on the "Uradiusied Trual Balance" tab. 1 Provide the total of the crodit column from the Unadiusted Irial Balance Record the Docerabor adfusting entries on the "Genoral Jouenal" tab. 31-Doc Ono month's insurance has expired $40. 31. Dec: The tomaining a riventory of umased offeo sunclios is 390 31 Doc tho estirnated dopreciation on equeperont is 560. 31. Deo Sakanos incurrod from Docomber 20 to Docember 31 but not yot poid or rocorded fotal $450 Step 6: Pose all of the adgrsting entnes to the Traccounts on the "T.Accounte" tab. Computo the balance for each T-account after all of the adisting critios hawe boon postod. Slep 7. Pregare the adjusted trial balance on the 'Aldusted Trial Balanoe' tab Check point 1: Adjusted trial balance total debicicredt = 20,390 Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no artswer should be left blank.) Provide the following amount from the income Statement: (Be sure to enter all numbers as positive and no answer should be left blank.) Provide the following account balances from the Balance sheet: (De sure to enter all numbers as positive and no answer should be left blank.) Provide the following account balance from the statement of stockholders' Equity: Be sure to enter all numbers as pesitive and no answer should be left blank.) Dividends Provide the following account balance from the statement of stockholders' Equity: (Ble sure to enter all numbers as positive and no answer should be left blank.) 28 Dimbonds: Step 9. Rocord the elosing entres on the "General wournal" tob hamo beon posted Step 11- Prepare the post closing tral bolance tor tlvi month ended Decentor 31, 200 con the Poat Closina. Trial Balance tob. 29 Provise the total of the dobit coturn from thw Post Closing Inal flalance been poslend Check Point 2 Totat Assets is 14.570 QUESTION2 31. Doess the ending talarke of the Retarned Rarnings tuccount agree with tho balanco af Retained Earnings on the Bdance Sheet? Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answer should be left blank.) Prepare the ficcorio Statement, Staternent of Stockholder's Equity and Classified Balance Sheot on the "Fuancial Statements" tab for the Fionth ended Decrember 31,20x Provide the following amount from the lncome statement: (Be sure to enter all numbers as positive and no answer should be left blank.) 15 Service Perenue 16 Deprecation Expense