This assignment is due Wednesday, 05/13/20 at 9am PT in Canvas. There are some new Accounts in this HW, so make sure you reference Chapters 7 and 8 of the book to see how theyre handled. Please ensure that your submission looks good once youve submitted it, as a blank page will receive 0 credit. Any late assignment submissions will get 10% off for every hour that its 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 thats 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 Jacked 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 hes a speed demon and has no regard for his own life on the road, he feels its 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: Lets say its 20X8, and Jack decides to finally sell the motorcycle that he starts his business with. Someone tells him that its worth no more than $600 and that they wont 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. Lets 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 thatll be posted at the end of 20X2, based on the Allowance method?