Please display each requirement in Excel.

Make sure numbers are represented with a $ sign and shown to two decimal points

P8-28A Requirement 1 WELL HEALTHCARE Bank Reconciliation August 31, 2018 BOOK $ 4.540 Balance, August 31, 2018 ADD: EFT collection on account 1,310 Dividend revenue 5.850 Interest revenue BANK Balance, August 31, 2018 ADD: Deposit in transit Bank crror $ 2.800 $ 260 1,050 $ 1,200 800 120 2,120 4,920 $ LESS: Outstanding checks No. 237 No. 288 No. 291 No. 294 No. 295 No. 296 Adjusted bank balance, August 31, 2018 80 190 570 600 30 70 LESS: NSF check #1 NSF check w2 1,540 Service charge Adjusted book balance, $ 4,310 August 31, 2018 380 180 SO 610 $4310 Credit Debit 1,200 1,200 Requirement 2 Date Accounts and Explanation Aug. 31 Cash Accounts Receivable To record EFT collection on account 31 Cash Dividend Revenue To record dividend revenue 31 Cash Interest Revenue To record interest revenue 800 800 120 120 560 31 Accounts Receivable ($380 + $180) Cash To record NSF checks 560 50 31 Bank Expense Cash To record hank service charges incurred 50 2018 Pearson Education, Inc. -17