Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

make an excel sheet for the following using the numbers 2 2 9 1 8 + 8 7 5 , 0 0 0 November: 1

make an excel sheet for the following using the numbers 22918+875,000
November:1 Issued 897,918 of common shares in the new company for cash.1 Purchased land and a building for the new clinic site worth $435,000 and $200,000respectively, by making a down payment of $90,000 and securing a mortgage throughRBC for the difference.1 Purchased a two-year insurance policy for $26,100 effective today.1 Maple Leaf Sports & Entertainment paid $49,000 in advance for physiotherapy servicesto be provided to Pascal Siakam for the basketball season.3 Purchased $1,300 of office supplies from Staples on account.12 Paid employees $7,500 representing two weeks salary.21 Summarized and recorded the billings to customers for the first three weeks ofNovember for physiotherapy services rendered. Billings totaled $92,000.26 Paid another $7,500 for two weeks salary.28 Received $55,000 from clients in partial settlement of accounts billed on the 21st.29 An early ice storm caused some minor damages to the roof. A roofing company repairedthe damages and invoiced $1,950 for the work.29 Paid Staples for the office supplies purchased on November 3.30 Paid a total of $4,600 for the months utilities.30 Paid out dividends to shareholders totaling $3,000.30 Made a mortgage payment of $3,220 to the bank consisting of $1,700 in interest and$1,520 in principal.Use the following information to journalize and post the adjustments for the month.a. One month's insurance coverage was consumed.b. There were $700 of office supplies on hand at the end of the month.c. The building has an estimated useful life of 30 years and a salvage value of $30,000.d. Employees earned $1,500 of unpaid and unrecorded salary.e. A review of the contract with Maple Leaf Sports & Entertainment, revealed that one-seventh of the services were provided to Siakam in the month.f. The company earned $19,200 of fees that had not yet been billed.g. Income taxes for the month were estimated to be $2,450.This should matchthe last 5 digits ofyour student ID +$875,000REQUIRED:1. Prepare journal entries for each transaction with descriptions. (Including adjusting journalentries).2. Prepare T accounts and post the transactions.3. Prepare an adjusted trial balance as at November 30.4. Prepare an income statement for the month.5. Prepare a statement of changes in equity.6. Prepare a classified statement of financial position.7. Prepare closing journal entries.8. Post the closing entries to T accounts.9. Prepare a post closing trial balance.Notes:Only one set of T accounts are required. Do not prepare a separate set of T accountsfor requirement #8, for example.Dates for the adjusting journal entries should be the last day of the month.This assignment should be prepared using Microsoft Excel. Within the Excel workbook,use a separate worksheet for each of the required, except for #2 and #8 which willappear on the same worksheet. Do not duplicate T-Accounts.If applicable, round to the nearest dollar.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach

Authors: Jeffrey Slater, Brian Zwicker

11th Canadian Edition

132564440, 978-0132564441

More Books

Students also viewed these Accounting questions