I need one Word document containing responses for Parts I and II (two-page minimum) and two Excel spreadsheets containing Natalie’s journal transactions from Part I and the depreciation tables from Part II. Use the same Word document that you used to record your Part I responses (one page in length), and add your responses for the Part II questions (1–5), which should be one page in length. A minimum of 2 pages and the two excel spreadsheets filled out. Read carefully and answer fully.
There are no resources required for this assignment; however, your Word document should be formatted using APA Style.
Cookie Creations (Chapters 9 and 10)
This assignment will focus on the Cookie Creations case study from Chapter 9 (page 9-37) and Chapter 10 (page 10-42) of your textbook. There are two parts to this assignment. Review the case situations for each part (i.e., in each chapter), and then complete the instructions.
Part I
One of Natalie’s friends, Curtis Lesperance, runs a coffee shop where he sells specialty coffees and prepares and sells muffins and cookies. He is eager to buy one of Natalie’s fine European mixers, which would enable him to make larger batches of muffins and cookies. However, Curtis cannot afford to pay for the mixer for at least 30 days. He asks Natalie if she would be willing to sell him the mixer on credit.
Natalie comes to you for advice. She asks you to address the questions below.
The following transactions occurred in June through August 2020.
June 1: After much thought, Natalie sells a mixer to Curtis on credit, terms n/30, for $1,150 (cost of mixer $620).
June 30: Curtis calls Natalie. He is unable to pay the amount outstanding for another month, so he signs a 1-month, 8.35% note receivable.
July 31: Curtis calls Natalie. He indicates that he is unable to pay today but hopes to have a check for her at the end of the week. Natalie prepares the journal entry to record the dishonor of the note. She assumes she will be paid within a week.
Aug. 7: Natalie receives a check from Curtis in payment of his balance owed.
Instructions:
To reiterate, you will write your responses to Natalie’s questions (1–3) in a Word document, and you will complete the journal transactions in an Excel spreadsheet. Your responses to Part I (Natalie’s questions) should be a minimum of one page in length, and you will add your responses for Part II to this document before submitting.
Part II
Natalie is also thinking of buying a van that will be used only for business. The cost of the van is estimated at $36,500. Natalie would spend an additional $2,500 to have the van painted. In addition, she wants the back seat of the van removed so that she will have a lot of room to transport her mixer inventory as well as her baking supplies. The cost of taking out the back seat and installing shelving units is estimated at $1,500. She expects the van to last 5 years, and she expects to drive it for 200,000 miles. The annual cost of vehicle insurance will be $2,400. Natalie estimates that at the end of the 5-year useful life, the van will sell for $7,500. Assume that she will buy the van on August 15, 2020, and it will be ready for use on September 1, 2020.
Natalie is concerned about the impact of the van’s cost on her income statement and balance sheet. She has come to you for advice on calculating the van’s depreciation.
Instructions:
Cookie Creations – Part 1 – Case Scenario | |||||||
Instructions: | |||||||
Prepare journal entries for the transactions that occurred in June, July, and August. (The company uses a perpetual inventory system). Round to nearest dollar. | |||||||
NOTE: Enter the debit/credity account name and the number in cells requesting a dollar value.. | |||||||
Debit | Credit | ||||||
1-Jun | Account | Value | |||||
Account | Value | ||||||
30-Jun | Account | Value | |||||
Account | Value | ||||||
31-Jul | Account | Value | |||||
Account | Value | ||||||
7-Aug | Account | Value | |||||
Account | Value |
,
Straight-Line Depreciation | |||||
Year | Depreciable Cost | Depreciation Rate | Depreciation Expense | Accumulated Depreciation | Net Book Value |
2020 | |||||
2021 | |||||
2022 | |||||
Double-Declining Balance Depreciation | |||||
Year | NBV (Beg. of Year) | Depreciation Rate | Depreciation Expense | Accumulated Depreciation | Net Book Value |
2020 | |||||
2021 | |||||
2022 | |||||
Units-of-Activity Depreciation | |||||
Year | Units of Activity | Depreciation Cost/Unit | Depreciation Expense | Accumulated Depreciation | Net Book Value |
2020 | |||||
2021 | |||||
2022 |
We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.
1. Click on the “Place order tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.
3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
Need this assignment?
Order here and claim 25% off
Discount code SAVE25