Question

In: Accounting

P3-10A Pamper Me Salon Inc.’s general ledger at April 30, 2017, included the following: Cash $5,000,...

P3-10A Pamper Me Salon Inc.’s general ledger at April 30, 2017, included the following: Cash $5,000, Supplies $500, Equipment $24,000, Accounts Payable $2,100, Notes Payable
$10,000, Unearned Service Revenue (from gift certifi cates) $1,000, Common Stock $5,000, and Retained Earnings $11,400. The following events and transactions occurred during May.

May 1 Paid rent for the month of May $1,000.
4 Paid $1,100 of the account payable at April 30.
7 Issued gift certifi cates for future services for $1,500 cash.
8 Received $1,200 cash from customers for services performed.
14 Paid $1,200 in salaries to employees.
15 Received $800 in cash from customers for services performed.
15 Customers receiving services worth $700 used gift certifi cates in payment.
21 Paid the remaining accounts payable from April 30.
22 Received $1,000 in cash from customers for services performed.
22 Purchased supplies of $700 on account. All of these were used during the
month.
25 Received a bill for advertising for $500. This bill is due on June 13.
25 Received and paid a utilities bill for $400.
29 Received $1,700 in cash from customers for services performed.
29 Customers receiving services worth $600 used gift certifi cates in payment.
31 Interest of $50 was paid on the note payable.
31 Paid $1,200 in salaries to employees.
31 Paid income tax payment for the month $150.
Instructions
(a) Using T-accounts, enter the beginning balances in the general ledger as of April 30,
2017.
(b) Journalize the May transactions.
(c) Post the May journal entries to the general ledger.
(d) Prepare a trial balance on May 31, 2017.

e) prepare the Income Statement for the month ended May 31, 2017

f) Prepare the Statement of Retained Earnings for the month ended May 31, 2017

g) Prepare the Balance Sheet for May 31, 2017

h)Prepapre the Statement of Cash Flows for the month ended May 31, 2017

I) Calculate the following for May: Working Capital, Current Ratio, Debt to Asset Ratio, Profit margin, & Return on Equity

Solutions

Expert Solution

Trial Balance as on May 31, 2017
Particulars Debits Credits
Cash $5,100
Supplies $500
Equipment $24,000
Salaries $2,400
Utilities $400
Advertising Expense $500
Rent $1,000
Interest Expense $50
Income tax Expense $150
Consumables $700
Accounts Payable $1,200
Notes Payable $10,000
Unearned Service Revenue
(Gift Certificates)
$1,200
Common Stock $5,000
Retained Earnings $11,400
Service Revenue $6,000
Total $34,800 $34,800
Income Statement for the Month ended 31st May 2017
Particulars Amount $ Amount $
Service Revenue $6,000
Gross Revenue $6,000
Less : Expenses
Salaries 2400
Utilities 400
Advertising Expense 500
Rent 1000
Interest Expense 50
Income tax Expense 150
Consumables 700 $5,200
Net profit $800
Statement of retained earnings for the Month ended 31st May 2017
Particulars Amount $ Amount $
Opening Balance $11,400
Add: Net profit $800
Closing Balance $12,200
Balance Sheet as on 31st May 2017
Liabilities Amount $ Assets Amount $
Common Stock $5,000 Equipment $24,000
Retained Earnings $12,200 Supplies $500
Accounts Payable $1,200 Cash $5,100
Notes Payable ( Long term) $10,000
Unearned Service Revenue
(Gift Certificates)
$1,200
$29,600 $29,600
Statement of Cash Flows for the Month ended 31st May 2017
Particulars Amount $ Amount $ Amount $
Cash flows from operating Activity
Add : Operating cash received $6,200
Less : Operating expenses ($5,900)
Operating cash flows before payment of taxes $300
Less : Income Taxes paid ($150)
Cash flows from operating Activity (After payment of Taxes) $150
Cash flows from Investing Activity $0
Cash flows from Financing Activity
Interest paid on Notes payable $50 ($50)
Net changes in the Cash Flows $100
Opening cash Balance $5,000
Closing cash Balance $5,100

Working capital  
Current Assets   $5,600
Current Liabilities   $2,400
Working capital   $3,200
  
Current Ratio  
Current Assets   $5,600
Current Liabilities   $2,400
Current Ratio   2.33
  
Debt to Asset Ratio  
Total Debt   $12,400
Total Assets   $29,600
Debt to Asset Ratio   0.42

Profit Margin  
Net profit   $800
Revenue   $6,000
Net Profit Margin   $13.33
Gross profit   $1,000
Gross Profit Margin   $16.67


Related Solutions

Molly's Inc. general ledger reflects a cash balance of $22,400 at April 30, 2014. The bank...
Molly's Inc. general ledger reflects a cash balance of $22,400 at April 30, 2014. The bank balance per the April bank statement reflects a balance of $22,300. Bank charges for the month are $50. Which of the following statements is true? None of the others alternatives are correct Molly's Inc. has recorded twice the bank charges for the month of $50. Every month Molly's Inc. general ledger balance will be higher than the bank balance. Every month Molly's Inc. general...
The April 30 bank statement for KMaxx Company and the April ledger account for cash are...
The April 30 bank statement for KMaxx Company and the April ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other Balance Balance, April 1 $6,000 April 5 #101 $ 700 5,300 April 9 $2,500 7,800 April 12 #102 200 7,600 April 19 #103 500 7,100 April 22 #104 1,000 6,100 April 27 EFT payment $200 5,900 April 29 NSF check 100 5,800 April 30 Service charge 25 5,775 Cash (A) April 1 Balance 6,000 April 8 2,500...
Following is the April 30 Accounts Receivable Subsidiary Ledger of Gabbard, Inc., a retailer of tents...
Following is the April 30 Accounts Receivable Subsidiary Ledger of Gabbard, Inc., a retailer of tents and camping equipment. (The ledger is also available for download at the end of the prompt.) Accounts Receivable Subsidiary Ledger Gabbard, Inc. April 30, 20xx Open Receivables Customer: Acme Sporting Goods Central 4726 Interstate Highway 2L Devron, Kansas 76588 507‐945‐8800 Account 43985 Credit Terms: 30 days Credit Limit: $15,000 Invoice Number Invoice Date Due Date Amount Customer Total 77341 April 27 May 27 $1,366.48...
On February 28, 2018, Wildhorse Inc.’s general ledger showed Cash $ 14,900; Land $ 84,600; Buildings...
On February 28, 2018, Wildhorse Inc.’s general ledger showed Cash $ 14,900; Land $ 84,600; Buildings $ 76,300; Equipment $20,000; Accounts Payable $ 12,100; Mortgage Payable $ 117,400; Common Shares $ 40,400; and Retained Earnings $ 25,900. During the month of March, the following transactions occurred: Mar. 1 Received three movies to be shown during the first three weeks of March. The film rental was $ 27,100. Of that amount, $ 10,100 was paid in cash and the remainder was...
Problem 3-9A On July 31, 2017, the general ledger of Splish Brothers Inc. showed the following...
Problem 3-9A On July 31, 2017, the general ledger of Splish Brothers Inc. showed the following balances: Cash $4,480, Accounts Receivable $1,680, Supplies $560, Equipment $5,600, Accounts Payable $4,590, Common Stock $3,920, and Retained Earnings $3,810. During August, the following transactions occurred. Aug. 3 Collected $1,340 of accounts receivable due from customers. 5 Received $1,460 cash for issuing common stock to new investors. 6 Paid $3,020 cash on accounts payable. 7 Performed legal services of $7,280, of which $3,360 was...
On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance:...
On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance: CASH No. 101 Date Explanation Ref Debit Credit Balance May 31 Balance 6,841 The bank statement from Canada Bank on that date showed the following balance: CANADA BANK Cheques and Debits Deposits and Credits Daily Balance XXX XXX 5/31 6,804 A comparison of the details on the bank statement with the details in the Cash account revealed the following facts. 1.The statement included a...
Riverbed Spa shows a general ledger balance for the Cash account of $5,227.95 on June 30...
Riverbed Spa shows a general ledger balance for the Cash account of $5,227.95 on June 30 and the bank statement as of that date indicates a balance of $4,450.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $34.00. 2. A bank memo stated that Bao Dai’s note for $900 and interest of $46.00 had been collected on June 29, and the bank had charged $6.30...
Novak Spa shows a general ledger balance for the Cash account of $3,974.35 on June 30...
Novak Spa shows a general ledger balance for the Cash account of $3,974.35 on June 30 and the bank statement as of that date indicates a balance of $4,145.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $33.00. 2. A bank memo stated that Bao Dai’s note for $897.00 and interest of $42.00 had been collected on June 29, and the bank had charged $7.50...
Budgeting Cash Flow The following various elements relate to Whitfield, Inc.’s cash budget for April of...
Budgeting Cash Flow The following various elements relate to Whitfield, Inc.’s cash budget for April of the current year. For each item, determine the amount of cash that Whitfield should receive or pay in April. a. At $28 each, unit sales are 5,000 and 6,000 for March and April, respectively. Total sales are typically 40% for cash and 60% on credit; 30% of credit sales are collected in the month of sale, with the balance collected in the following month....
The following payroll liability accounts are included in the ledger of Harmon Company on January 1, 2017.
The following payroll liability accounts are included in the ledger of Harmon Company on January 1, 2017. FICA Taxes Payable...................................................................................$ 760.00 Federal Income Taxes Payable.............................................................1,204.60 State Income Taxes Payable.....................................................................108.95 Federal Unemployment Taxes Payable................................................288.95 State Unemployment Taxes Payable.................................................1,954.40 Union Dues Payable....................................................................................870.00 U.S. Savings Bonds Payable.....................................................................360.00 In January, the following transactions occurred. Jan. 10 Sent check for $870.00 to union treasurer for union dues. 12 Remitted check for $1,964.60 to the Federal Reserve bank for FICA taxes and federal income taxes withheld....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT