can someone help me with part 3 and the final submission asap... thank you in advance 
acc p2 Q Search Sheet 2+ Share Home Insert Page Layout Formulas Data Review View ALtaSumA Cut Calibri (Body) 11 General A A SWrap Text Copy Fill Cell IU A Conditional Fermat Formattirg Sort & Filter Peste B Morge & Center Insert Deiste Forma Farmat Clear Tabla Styes 59 P C P T Income Statement 10 11 13 14 15 17 Statoment of Owner's Equity 18 .. 21 24. 25 27 Balancs Sheat 28 37 24 35 38. General Ledger Financial Statements GJ Page 1 Worksheet GJ Page 2 GJ Page 3 PC TB 100% Ready SACC111 Practice Set Instruct X C Home | Chegg.com Can Someon Please Holp Can Someone Please Help N X Practice Set: PV 2019 SUMH Learn.maricopa.edu ACC11 X ACC111 Accounting Principles Practice Set James Regal, Esquire is an Altomey and has fomed his awn law firm, Regal Law Firrm. You have been hired by James, you prepare his chart s bookkeeper, After talking t accounts, which is bekyw, James as Chart of AcEourts Account Name Account a 102 Acons Reiahe Regal, Crawrg 501 Fent Fxpense Regal Law Fim is March 2018 The transactions for the month af March are: The first month af business for Date Transaction James cpened the bank account and depasited $5.000 far his capital contribution. 3/1/2018 James paid $250 for rent 3/5/2018 3/10/2018 James received S1,000 from a new dient, Sue Barnes, as a deposit for legal services. 315/2018 James paid S375 of salaries to his legal assistant James received a bill of $75 for office supplies which will be paid next month. 3/22/2018 James withdraw $1,000 for his personal use. 3/30/2018 Practice Set Part 1 carapicte urinn Micronat Exrl f it is pot.complatad in Excal wour assinnmant may pot he accented Sea the sylabus to download a free copy of Microsoft Excel. 1.Using the chart of accounts, open the accounts in the general ledger Maka sure that you 2. Record the joumal entrios for the March transactions using Goneral Joumal Page include explanations. A Calculate n. egeneral ledger ledger accounts. 5. Pregare the Trial Balance Columns in the worksheet Make sure you properly camplele the heading After completing the Triel Balance in Step 5, compare the balance vou calculated with Trial Balance in the Instructions. (If you have trouble getting it to agree, you may send me your excel workbook to check by attaching it to a Canvas message.) Do not move on until your trial balance agrees. e check figure for the Pages 74-75 in your textbook contains step post them to the general ledger. step instructions on how to jaurnaliza transactions and SACC111 Practice Set Instruct X Can Someone Please Help N X Home Chegg.com Practice Set: PV 2019 SUM Can Somecne Please Help Learn.maricopa.edu ACC11 X X Practice Set Part 2: 6. Prepare the fallowing adjustments in the warksheet: During March, James performed services for cients which were nat billed for 1.750 During March, James performed services for Sue Barnes for $750. A1 the end of the month $25 in office supplies were remaining. 7. Prepare the Adjusted Trial Balance Columns in the worksheet After completing the Adjusted Trial Balance in Step 7, compare the balance you calculated with the check ma your RXcel workhock to check hy atteching it to a Canvas message) Do not mova on until wour adiuated rial balance agrees. Suggesian Pages 187-18a in your lexbook cantain instructions ow fo comalele he wovksheel ahoue and nost them to the General Ledner and calaulate the ccount hslance djustments prepared in W8 Submt your asaignvment by attaching your excel worksheet to the Practdce Set Part 2 asaignment in Canvas. Practice Set Part 3. 9. Pregare the Income Slatement and Balance Sheet Columns in the worksheet. ing (f you hava trouhle getting it to agrae vou mew send ma wur exCe workhoak to check by attaching it to a Canvas message.) Do not move on until your Net Income agrees. Suggestian: Pages 187- 188 in your fextbook contain instructions on how to complete the worksheet 10. Prepa ndinn for aarh ri ent of Owner's Equity and Balance Sheet. Mako suro you properly Check the Capital balanoe you cakulated in the Siaiement of Owner's Equity (and Balance Sheet, it should be the same) in Step 10 against the check figures in the Instructions before proceeding. f you have trouble workbook to check by attaching it to a Canves message.) Do pot move on until vour Capital balance agrees. Submt your esalgnment by atteching your excel worksheet to the Practice Set Part 3 asagnment in Canvas Practice Set (Final Submisslon): 1. Prepare the ling Enines ere i ti t Genr eruse Acrount #600 for Income Summary) and cakculato the account balances 12. Prnparn a post-closing trial balance. Submit yur assigrnent by attaching your axcn wrkshot the Practicn Set assignment in Canvas Check Figures: Trial Balance S6,075 Sten 5 Stop 7-Adustod Trial Balance $7,825 Warksheot: CalCulate Net Income $1,825 Stop 9 Statement of Owner's Equity: Rogai, Capital Mrch 31, 2018 $5,825 Stop 10
