Prepare the requirements below using Excel. Required: Prepare the journal entries to record iransactions...
50.1K
Verified Solution
Question
Accounting
Prepare the requirements below using Excel. Required: Prepare the journal entries to record iransactions through Then prepare the neosssa adjusting entries through to correctly report net income for the period. Post each journal entry to Taccounts in the general iedger. Prepare a rial balance; Prepare a multiplesiep income statement for the year ended December Prepare the statement of changes in stockholders' equity for the year ended December Prepare a balance sheet at December Prepare the statement of cash flows for year ended December Record the closing entries as of December in the general joumal. Post each closing entry to Taccounts in the general ledger. Prepare a postclosing trial balance. The trial balance of Pacilio Security Services Inc. as of January had the following normal balances: Cash $ Accounts Receivabie Supplies Prepaid Rent Land Uneamed Revenue Salaries Payable In Pacio Security Services decided to expand its business to sell secunty systems and offer hour alarm moniloring services, It plans to phase out its current service of providing security personnel at various events. The following summary transactions occurred during Paid the salaries payable from Acquired an additional $ cash from the issue of common stack. Rented a larger building on May : paid $ for months' rent in advance. Paid $ cash for supplies to be used over the next several months by the business. Purchased alarm systems for resale at a cost of $ each. The alarm systems were purchased on account with the terms Rctumed three of the alarm systems that each had a cost of Instalied alarm systems during the year at a price to customers of $ each. The cost of these systems was $ each. Sales on account were $ and cash sales were $ Paid the installers and alher employees a total of $ in salaries. Sold $ of monitaring services for the year, The services were billed to customers. Paid cash on accounts payable of $ less applicable discount, since the payment was made before the discount period expired. Purchase terms were Paid cash to settle an additional $ of accounts payable after the discount period expired. Collected $ of accounts receivable during the year. Performed $ of security scrvices for area events; $ was on account and $ was for cash. Paid advertising cost of $ for the year. Paid $ for utilities expense for the year. Paid a dividend of $ to the shareholders. Adjustment Information: Supplies of $ were on hand at the end of the year. Recognized the expired rent for the year. Recognized the balance of the unearned revenue; cash was received in Accrued salaries at December were $ Common Stock Retained Earnings
Prepare the requirements below using Excel.
Required:
Prepare the journal entries to record iransactions through Then prepare the neosssa adjusting entries through to correctly report net income for the period.
Post each journal entry to Taccounts in the general iedger.
Prepare a rial balance;
Prepare a multiplesiep income statement for the year ended December
Prepare the statement of changes in stockholders' equity for the year ended December
Prepare a balance sheet at December
Prepare the statement of cash flows for year ended December
Record the closing entries as of December in the general joumal.
Post each closing entry to Taccounts in the general ledger.
Prepare a postclosing trial balance.
The trial balance of Pacilio Security Services Inc. as of January had the following normal balances:
Cash
$
Accounts Receivabie
Supplies
Prepaid Rent
Land
Uneamed Revenue
Salaries Payable
In Pacio Security Services decided to expand its business to sell secunty systems and offer hour alarm moniloring services, It plans to phase out its current service of providing security personnel at various events. The following summary transactions occurred during
Paid the salaries payable from
Acquired an additional $ cash from the issue of common stack.
Rented a larger building on May : paid $ for months' rent in advance.
Paid $ cash for supplies to be used over the next several months by the business.
Purchased alarm systems for resale at a cost of $ each. The alarm systems were purchased on account with the terms
Rctumed three of the alarm systems that each had a cost of Instalied alarm systems during the year at a price to customers of $ each. The cost of these systems was $ each. Sales on account were $ and cash sales were $
Paid the installers and alher employees a total of $ in salaries.
Sold $ of monitaring services for the year, The services were billed to customers.
Paid cash on accounts payable of $ less applicable discount, since
the payment was made before the discount period expired. Purchase terms were
Paid cash to settle an additional $ of accounts payable after the discount period expired.
Collected $ of accounts receivable during the year.
Performed $ of security scrvices for area events; $ was on account and $ was for cash.
Paid advertising cost of $ for the year.
Paid $ for utilities expense for the year.
Paid a dividend of $ to the shareholders.
Adjustment Information:
Supplies of $ were on hand at the end of the year.
Recognized the expired rent for the year.
Recognized the balance of the unearned revenue; cash was received in
Accrued salaries at December were $
Common Stock
Retained Earnings
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.