Business Finance Homework Help

Columbia Southern University Unit IV Case Study Excel

 

Instructions
Cookie Creations (Chapter 4)

This assignment is a continuation of the Cookie Creations case study from Chapters 1–3. You will use the information from the previous chapters and from this chapter to complete the actions for the case study and to apply what you have learned to this point.

The Cookie Creations case study for Chapter 4 can be found below and also on pp. 4-51 to 4-52 in the textbook SEE ATTACHMENT BELOW. The textbook provides you with the adjusted trial balance, and it is also located below for quick reference. Read the case information, and complete the actions listed below.

Natalie had a very busy December. At the end of the month, after journalizing and posting the December transactions and adjusting entries, Natalie prepared the following adjusted trial balance.

COOKIE CREATIONS Adjusted Trial Balance

Using the information from the adjusted trial balance, complete the tasks below.

  1. Prepare an income statement and an owner’s equity statement for the 2 months ended December 31, 2019, and a classified balance sheet as of December 31, 2019. The note payable has a stated interest rate of 6%, and the principal and interest are due on November 16, 2021.
  2. Natalie has decided that her year-end will be December 31, 2019. Prepare and post-closing entries as of December 31, 2019.
  3. Prepare a post-closing trial balance.

Make sure to complete item “a” completely before moving to item “b,” and then move to item “c.” You cannot jump ahead unless you have completed each step sequentially in full.