the answer its not correct, excel applications for accounting pag 40 to 44 are asking for
P4 + MERCHANDISING COMPANY FINANCIAL STATEMENTS (FMERCH) LeAANING ODJECTIVES - Compare and anayze the change in briances ove two nortes. - Aruyze tie montit trends in soles, groes grott and net income. : Areer tho wonsheot by resertanging ree order of the Arswer Section. - Create a chart showing the anourt of all seling experses. Note: For a problem using the sole proprietsestip torn of business organization, downioad PMEACH Ifom the wibsto for the book at corgagetrin coon PROELEM DATA The following information is for Bomie's Bods, a nursery and fors thop, for the month ended May 31,2012 : the problem have aready been entered into the top section of the workshisest. farmuas onto the worksheet, these zeros will be replaced by values. and Titut A is Sales Diseount. When you soe triathod make thre that your balarce sheet: WYEATHF ANALYSIS 3. To tost your model, enter the tollowing dath in the Data Soction tor the monti ended June When you are finishod thale 7are your bulance theet balarices. Save your cormpletod Nie as FMFPich3. Peptint the worksteet 4. Compare the Mily and Junt incoene statemients. Commert on any trends noted. CHANT ANALYSTS 5. Cick the Chart shoet tab on the FMEFCHS tis. You win seet a chart dapicting the five - mot tent in sales, gross profit. and net inpoithe. What tavorable ard unfavoratis urends do y soo in this month-10-morti comparison? Comment on any unusual charges. When assignment is corrplele, close the lise without saving it again. 42 EARNING OBJECTIVES - Prepare a bank reconciliation statement and the necessary adjusting journal entries. - Prepare a bank reconciliation statement with incomplete data. - Interpret differences between book and bank balances. - Alter the file to accept additional outstanding checks - Create a chart plotting book and bank balances. AOBLEM DATA thye Boats deposits all receipts in a night depository atter banking hours. The data neede aconcile the bank statement as of October 31, 2011. have been extracted from records and s follows: 'Date and amount of each deposit in Cctober: Oct 3, 5545.25; Oct. 8, $842.00;0 $978.35; Qct. 16,$658.05; Oct 19,$643.90; Qet. 24,$352.62; Oct. 28, \$715.28. " Number and amount of each check issued in October. 'Date and amount of each deposit in Octoberk Oot, , \$361.90, Oct.4, \$545.2 5842.00; Qct. 12, $978.35; Oct, 17, \$658.05; Oct. 20, S643.90; Oct 25,$352.6 "-Number and amount of each check in October: REOUIREMENT 1. As treasurer, you have beon askod to prepare a bark reconoliation statement as of October 31. Review the Nlo callod BANKFEC that follows these requirements. The bark reconcilation as of September 30 is provided for you as a sample complefed worksheet. You may need to reter to the September 30 barik reconcilation for informaticn on outstanding checks. 2. Open the Ale BANKREC from the website for this book at oengagebraincom. Enter the formulas where indicaled on the worksheet. Prepa'e a bask reconciliation statement as of October 31. Assume that at orrors are the depositirs' taut. Cnecks 754-757 were for salaries: all other checks were payments to suppliers on acoount. The reconcilation is rot complete until the ditlerenoe between the adjusted bolances (cell C45) is zero. Enter your name in cell A1. Save your completed file as OCT31. Print the worksheet. Also print your formulas, Check figure: Adiustad balance (cel E25), 39995.60. 3. In the space provided below, prepare the necessary adfusting journal entries. 4. Erase al October data and use the woncuheet to compiets the telowitg back reochcliation at Noweriber 30, 2011 Save your completed toe as NOV30. Print the wonkteec. CHART ANALYSIS 5. Open the OCT3) fies. Click the Chart sheet tab On the saveen, a column chart acpesis isistrating relative book and bank balances at July 31 and Augost 31 in the tooce provided below, list at least two reasons wtiv the diecepancy betesen bock and tark balances may nove existed at taly 3 1 al. b. Why may the discrepancy have existed at August 317 . 3 b. When the assignment is complete, close the tie withous switrg e again. TICKLEAS (optional) Warksheet. At the end of November 2011, 5uppose taat the \$547 of checiss outstanding consat of check Nos. 801 to 809 for 550 each and chack No. b10 for 997 The NoV30 workshect does not have encugh rows to ist al these chacks ndibually. Expand the NOV30 worksheet and redo the reconcliation by listing all these checks. Enter yout name in cell hi. Preview the printout to make sure that the worksheet will print nesiy on cne page, and then print the worksheot. Save the complated tie as BANKAECT Chart. Using the OCT31 Ele, prepare a line chart 19 show both tho monthly ending bark balance and the adjusted book balance from suly 31 though Noveriber 30. Use the Chart Data Table as a basis for preparing the chart. Expand the tabie to include data. for September. October, and November based on the intormation provided in the problam. Enter yout name somenhere on the chart. Save the file again as OCT3j. Select the chart and than print it out. LEARNNGG OBJECTIVES - Prepare a bank reconclation statemert and the recestary aduating fourail ontries. - intopref diferencess between book and banik besances. - AMer the fle to acoept additional outstanding check. - Crome a chat plotting book and benk balanses. PAOELEM DATA syep Boass deposits all receipts in a night depository atwe buraing hours. The data needed to reoonole the bank statement as of October 21, 2011, heve been evtracted from records and are as follows: Dale and amount of each deposit in Oclober, Oct 3, 3545 25, Oct. 8. 3842.00, Oct. 11, 4976.35; Oct. 16,5958.05; Oct 19, 5643 , 90; Oct. 24, 5352 e2; Oct. 26, 571520 "Number and amount of eacti check issued in October: -Date and amount of each deposit in Octoberi Oct 1, 5361 90: Oct, 4, \$545,25; Oct. 9, "Number and amount of each check in October
