Answered step by step
Verified Expert Solution
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
November: Issued of common shares in the new company for cash Purchased land and a building for the new clinic site worth $ and $respectively, by making a down payment of $ and securing a mortgage throughRBC for the difference Purchased a twoyear insurance policy for $ effective today Maple Leaf Sports & Entertainment paid $ in advance for physiotherapy servicesto be provided to Pascal Siakam for the basketball season Purchased $ of office supplies from Staples on account Paid employees $ representing two weeks salary Summarized and recorded the billings to customers for the first three weeks ofNovember for physiotherapy services rendered. Billings totaled $ Paid another $ for two weeks salary Received $ from clients in partial settlement of accounts billed on the st An early ice storm caused some minor damages to the roof. A roofing company repairedthe damages and invoiced $ for the work Paid Staples for the office supplies purchased on November Paid a total of $ for the months utilities Paid out dividends to shareholders totaling $ Made a mortgage payment of $ to the bank consisting of $ in interest and$ 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 $ of office supplies on hand at the end of the month.c The building has an estimated useful life of years and a salvage value of $d Employees earned $ of unpaid and unrecorded salary.e A review of the contract with Maple Leaf Sports & Entertainment, revealed that oneseventh of the services were provided to Siakam in the month.f The company earned $ of fees that had not yet been billed.g Income taxes for the month were estimated to be $This should matchthe last digits ofyour student ID $REQUIRED: Prepare journal entries for each transaction with descriptions. Including adjusting journalentries Prepare T accounts and post the transactions Prepare an adjusted trial balance as at November Prepare an income statement for the month Prepare a statement of changes in equity Prepare a classified statement of financial position Prepare closing journal entries Post the closing entries to T accounts 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 # 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 # and # which willappear on the same worksheet. Do not duplicate TAccounts.If applicable, round to the nearest dollar.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started