Question: For A please use the FSET Excel template below. a. Prepare its adjusting entries at June 30, 2019, using the financial statement effects template. d.
For A please use the FSET Excel template below. 



a. Prepare its adjusting entries at June 30, 2019, using the financial statement effects template. d. Prepare its income statement for June and its balance sheet at June 30, 2019. B C Cash Account Name $ Amount Account Name Cash 450 3100 Prepaid Rent Supplies Equipment 2520 4440 8 Adjusting Entries (one income statement account & one asset or liability (not cash) 9 1) Rent 10 11 2) Supplies 12 13 3) Depr 14 15 4) Salaries 16 17 5) Utility 18 19 6) Revenue 20 21 22 Total Balance 1180 10510 23 24 Total Assets 25 26 27 1234567 00 A 1180 A/R D E + Non Cash Assets 11690 $ Amount F G - Contra Assets Account Name $ Amount 0 H I Liabilities Account Name Acct Pay J $ Amount Account Name 760 Common Stock 760 K L + Contributed Capital Total Liability & Equity 11690 M + Earned Capital $ Amount Account Name 2000 RE RE 2000 N $ Amount 5300 3630 8930 O P Q R S Revenue -Expenses Account Name $ Amount Account Name $ Amount 4650 Wage Exp Svc Revenue 1020 4650 Total Exp 1020 Total Rev T =Net Income $ Amount 3630 3630 Net Income MURDOCK CARPET CLEANERS Unadjusted Trial Balance June 30, 2019 Debit Credit Cash. $ 1,180 Accounts receivable. 450 Prepaid rent 3,100 Supplies 2,520 Equipment 4,440 Accounts payable. Common stock. 760 2,000 Retained earnings 5,300 4,650 Service fees revenue Wages expense 1,020 $12,710 $12,710 The following information is available. 1. The balance in Prepaid Rent was the amount paid on June 1 for the first four months' rent. Supplies available at June 30 were $820. 2. 3. Equipment, purchased June 1, has an estimated life of five years. 4. Unpaid and unrecorded employee wages at June 30 were $210. 5. Utility services used during June were estimated at $300. A bill is expected early in July. 6. Fees earned for services performed but not yet billed on June 30 were $380. The company uses the account Accounts Receivable to reflect amounts due but not yet billed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
