There are some new Accounts in this HW, so make sure you reference Chapters 7 and 8 of the book to see how they’re handled. Please ensure that your submission looks good once you’ve submitted it, as a blank page will receive 0 credit. Any late assignment submissions will get 10% off for every hour that it’s late, starting with the due time of 9am PT. This assignment is worth 80 points, please submit by excel document

BIG NOTE: Start your journal entries with Debits, as that’s typical Accounting convention. You will be marked off points if you do otherwise.

Background: Jack decides on April 2nd 20X1 that he wants to run a fitness-based consulting business. He decides to put $10,000 of his own savings into Jack’ed Up Solutions Energy Drinks, “JUSED” for short.
Month of April
•   4/3/20X1 – Given the recent COVID-X1 situation, he decides that he should deliver his consulting business directly to his clients, so JUSED purchases a used motorcycle (labeled as Vehicles in the General Ledger) for $6,500 cash in total. He believes this motorcycle has a useful life of 6 years and has a salvage value of $1,000. Although he’s a speed demon and has no regard for his own life on the road, he feels it’s appropriate to depreciate this motorcycle on a Straight-Line basis.
•   4/4/20X1 – JUSED purchases 1,000 bottles of protein shakes from Vendor 1, which it plans to sell as merchandise. Each bottle costs $2 each, was paid in Cash, and is under FIFO.
•   4/5/20X1 – JUSED sold Customer 1 protein shakes: 26 at $8 each. This customer pays on account, due in 14 days, no discount with early payment
•   4/6/20X1 – Jack notices that his motorcycle starts wobbling a little bit on the road, and this worries him. He realizes that it needs repairs, which would have been covered by a warranty, had he paid for one. He goes to YouTube to learn how to repair his motorcycle and spends $150 Cash repairing it
•   4/8/20X1 – JUSED sold Customer 2 protein shakes: 38 shakes at $8 each. This customer pays on account, due in 14 days, no discount with early payment
•   4/11/20X1 – Customer 1 informs JUSED that they can no longer pay for their purchase on 4/5/20X1 due to filing for extreme financial hardships. JUSED uses the Direct write-off method
•   4/19/20X1 – Customer 2 pays for purchase on 4/8/20X1
•   4/25/20X1 – Customer 1 comes back with the cash payment for the services provided on 4/5/20XX, as the government has given them federal loan support.

Excel Tab 1
Objective 1: What are the Debit/Credit Journal Entries recorded for the business during the month of April?

Excel Tab 2
Objective 2: Post the Journal Entries to the Ledger T-Accounts and note the ending balances of each Account.

Excel Tab 3
Objective 3: What Depreciation entry will JUSED post at 12/31/20X1? What will the depreciation entries be for the end of 20X2, 20X3, 20X4, 20X5, 20X6, 20X7?

Objective 4: What if Jack decided to use Double Declining Balance Depreciation on the motorcycle instead? What will the depreciation entries be for the end of 20X1, 20X2, 20X3, 20X4, 20X5, 20X6, 20X7 be then?

Objective 5: Let’s say it’s 20X8, and Jack decides to finally sell the motorcycle that he starts his business with. Someone tells him that it’s worth no more than $600 and that they won’t pay a penny more than that. The motorcycle has a lot of sentimental value, but all Jack is thinking about is what he can buy with $600. He decides to sell the motorcycle to this person. What does the journal entry look like, and was it a good idea if JUSED wants higher Net Income?

Objective 6: The example above, we assumed that JUSED is using a Direct write-off method. Let’s assume JUSED uses the Allowance method instead. The following are beginning balances for select Accounts in 20X2:

Accounts Receivable – Debit 24,000
Allowance for Doubtful Accounts – Credit 300

Assume there were $700 worth of write offs throughout 20X2 and that the ending balance of Accounts Receivable in 20X2 was a Debit of 40,000. If JUSED uses the Percent of Receivables method and estimates that 1% of Accounts Receivable is uncollectible, what is the Bad Debts journal entry that’ll be posted at the end of 20X2, based on the Allowance method?