ACCT 2301 HCCS Davis Designs Llc Adjusted Trial Balance Excel Sheet

ALREADY FINISHED PART 1 AND 2 (HAS FILES WITH ANSWERS). NEED HELP ON PART 3 AND 4

PROJECT INFORMATION

Maya Davis is a landscape designer. She has training in botany and the artistic aspects of designing flower, vegetable, and mixed-use gardens. She has decided to form her own company, Davis Designs. She has hired you as the accountant. 

PART 1: TRANSACTIONS AND LEDGERS

Record the following transactions as journal entries in the journal. Post the transactions to the ledger accounts. Find the month end balance for each ledger account.

11/1/2020: Maya Davis forms Davis Designs company by contributing $28,000 cash and $12,000 worth of computer and design software equipment in exchange for Common Stock.

11/1/2020: Davis Designs signs a lease with a lessor for some business office space. The company pays $2,700 for the first 3 months rent.

11/2/2020: Davis Designs buys $540 of supplies for drawing / sketching / printing, etc.

11/2/2020: Davis Designs pays $900 for a 12-month insurance contract covering the company’s legal liability and office asset insurance coverage.

11/3/2020: Davis Designs receives $3,500 from the customer Sketcher Logistics for a design sketch and a plant list that Davis Designs drew up and delivered the same day.

11/6/2020: Davis Designs bills its customer BRX Corporation $1,800 for a sketch performed and submitted that day. The payment terms offered to BRX Corporation are 2/10, Net/45. 

11/10/2020: Davis Designs borrows $50,000 from their bank, in order to have money to pay for things. The note payable is for 180 days, at 4% interest, and will be paid back with the interest at the maturity date.

11/15/2020: Davis Designs purchases, on account, a large copy/print machine from Office Worx for $2,600. The payment terms for Davis Designs are 2/10, Net 30.

11/16/2020: Davis Designs bills its customer Epicenter Construction $1,700 for a design and plant list drawn and delivered that day. The payment terms offered to Epicenter Construction are 2/10, Net 45.

11/19/2020: Davis Designs pays $1,460 to Make It Market advertising agency for a website design, business cards, and some other advertising items.

11/21/2020: Davis Designs bills its customer, Hanover Engineering, $2,800 for a design drawn and delivered that day. The terms offered to Hanover Engineering are 2/10, Net 30.

11/29/2020: Davis Designs receives the full payment from BRX Corporation.

11/30/2020: Davis Designs receives and records the bill for the bundled utility services (electric, phone, and internet) for the office; the bill is $380. Davis Designs will pay it next month.

11/30/2020: Davis Designs pays Maya Davis $3,000 in dividend distributions. As of yet, Davis Designs does not have any employees. (You did advise Maya that she needs to be “employed” as an employee of the company, and start receiving a regular paycheck because the IRS always frowns upon privately-owned companies that do not have regular payroll and payroll taxes…. She said she will think about this.)

11/30/2020: You bill Davis Designs for your services, $450. You are not an employee, but instead a business that bills clients by the hour.

PART 2: TRANSACTIONS AND LEDGERS – DECEMBER 2020

Record the transactions below in the journal; post the entries to the ledgers; find the 12/31/2020 ending balances for each account. 

12/1/2020: Davis Design receives $2,900 from its customer, Bradley Earl Inc., for work that Davis Designs will perform on December 19th.

12/2/2020: Davis Designs pays the bundled utility bill.

12/3/2020: Davis receives payment from its customer, Epicenter Construction.

12/4/2020: Purchased $630 of office supplies on account, terms 2/10, net 30.

12/10/2020: Invoiced the customer Belt and Boots LLC $650 for a design drawn and delivered that day, terms 2/10, net 30.

12/11/2020: Paid for the office supplies purchased on the 4th of December. 

12/12/2020: Invoiced the customer Greer Inc. $1,045 for a design drawn and delivered that day, receiving payment immediately.

12/14/2020: Took a prospective client to lunch, $68.

12/15/2020: Davis Designs pays your accounting invoice.

12/15/2020: Received payment from Hanover Engineering.

12/21/2020: Paid for the copier that was bought on 11/15/2020.

12/30/2020: Received and recorded the bundled utility bill for December, $416.

12/31/2020: Davis Designs pays Maya Davis a salary of $5,000 for the month of December. The federal income withholding tax withheld from Maya’s paycheck was $860. FICA-OASDI is 12.4%, of which half is withheld from Maya’s pay, and the other half is paid by the Employer. Also, FICA-Medicare is 2.9%, and the same rule applies: half comes from Maya’s paycheck and half paid by Davis Designs. FUTA is .6% (decimal form, .006). Ignore SUTA. The payment to the IRS for the payroll taxes will be made 1/20/2021.

PART 3: UNADJUSTED TRIAL BALANCE, ADJUSTING ENTRIES, ADJUSTED TRIAL BALANCE

Prepare the Unadjusted Trial Balance. Make the Adjusting Entries and update ledger accounts. Prepare the Adjusted Trial Balance. 

  • Davis Designs will use the “Percentage of Credit Sales” estimation method for estimating the uncollectible customer accounts. The percentage Davis thinks is appropriate is 2%.
  • Depreciation: the company will depreciate assets straight-line for 6 years, with NO residual (ie, salvage or trade-in) value. Remember to take into consideration the timing of when the assets were received and adjust for part-year, and part-month. Round to the nearest whole dollar.
  • Took a count of office supplies; the office supplies on hand at 12/31 were $160.
  • Look at the Unadjusted trial balance. What other accounts need to be adjusted?

PART 4: FINANCIAL STATEMENTS, CLOSING ENTRIES, POST-CLOSING TRIAL BALANCE

From the Adjusted Trial Balance in Part 3 of this project, prepare the Financial Statements (Multi-step Income Statement, Statement of Retained Earnings, Classified Balance Sheet, Statement of Cash Flows, indirect method). Next, prepare the closing journal entries. Finally, update the Ledgers and prepare the Post-Closing Trial Balance.

Don't hesitate - Save time and Excel

Are you overwhelmed by an intense schedule and facing difficulties completing this assignment? We at GrandHomework know how to assist students in the most effective and cheap way possible. To be sure of this, place an order and enjoy the best grades that you deserve!

Post Homework
Top