Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

One Trick Pony (OTP) incorporated and began operations near the end of the year, resulting in the following post-closing balances at December 31: * credit

One Trick Pony (OTP) incorporated and began operations near the end of the year, resulting in the following post-closing balances at December 31:

image text in transcribed

* credit balance.

The following information is relevant to the first month of operations in the following year:

  • OTP will sell inventory at $145 per unit. OTPs January 1 inventory balance consists of 35 units at a total cost of $2,800. OTPs policy is to use the FIFO method, recorded using a perpetual inventory system.
  • In December, OTP received a $4,350 payment for 30 units OTP is to deliver in January; this obligation was recorded in Deferred Revenue. Rent of $1,300 was unpaid and recorded in Accounts Payable at December 31.
  • OTPs note payable matures in three years, and accrues interest at a 10% annual rate.

January Transactions

  1. Included in OTPs January 1 Accounts Receivable balance is a $1,500 balance due from Jeff Letrotski. Jeff is having cash flow problems and cannot pay the $1,500 balance at this time. On 01/01, OTP arranges with Jeff to convert the $1,500 balance to a six-month note, at 12% annual interest. Jeff signs the promissory note, which indicates the principal and all interest will be due and payable to OTP on July 1 of this year.
  2. OTP paid a $500 insurance premium on 01/02, covering the month of January; the payment is recorded directly as an expense.
  3. OTP purchased an additional 150 units of inventory from a supplier on account on 01/05 at a total cost of $9,000, with terms n/30.
  4. OTP paid a courier $300 cash on 01/05 for same-day delivery of the 150 units of inventory.
  5. The 30 units that OTPs customer paid for in advance in December are delivered to the customer on 01/06.
  6. On 01/07, OTP received a purchase allowance of $1,350 on account, and then paid the amount necessary to settle the balance owed to the supplier for the 1/05 purchase of inventory (in c).
  7. Sales of 40 units of inventory occurring during the period of 01/0701/10 are recorded on 01/10. The sales terms are n/30.
  8. Collected payments on 01/14 from sales to customers recorded on 01/10.
  9. OTP paid the first 2 weeks wages to the employees on 01/16. The total paid is $2,200.
  10. Wrote off a $1,000 customers account balance on 01/18. OTP uses the allowance method, not the direct write-off method.
  11. Paid $2,600 on 01/19 for December and January rent. See the earlier bullets regarding the December portion. The January portion will expire soon, so it is charged directly to expense.
  12. OTP recovered $400 cash on 01/26 from the customer whose account had previously been written off on 01/18.
  13. An unrecorded $400 utility bill for January arrived on 01/27. It is due on 02/15 and will be paid then.
  14. Sales of 65 units of inventory during the period of 01/1001/28, with terms n/30, are recorded on 01/28.
  15. Of the sales recorded on 01/28, 15 units are returned to OTP on 01/30. The inventory is not damaged and can be resold. OTP charges sales returns directly against Sales Revenue.
  16. On 01/31, OTP records the $2,200 employee salary that is owed but will be paid February 1.
  17. OTP uses the aging method to estimate and adjust for uncollectible accounts on 01/31. All of OTPs accounts receivable fall into a single aging category, for which 8% is estimated to be uncollectible. (Update the balances of both relevant accounts prior to determining the appropriate adjustment.)
  18. Accrue interest for January on the note payable on 01/31.
  19. Accrue interest for January on Jeff Letrotskis note on 01/31 (see a).

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Cash Accounts Receivable Allowance for Doubtful Accounts Inventories Deferred Revenue (30 units) Accounts Payable Note Payable (long-term) Common Stock Retained Earnings $ 18,620 9,650 900* 2,800 4,350 1,300 15,000 5,000 4,520 Requirement General Journal General Ledger Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Analysis General Journal tab - Prepare all January journal entries and adjusting entries for items (a)-(s). Review the 'General Ledger' and the adjusted 'Trial Balance' Tabs to see the effect of the transactions on the account balances. Trial Balance tab - Review the adjusted 'Trial Balance' as of January 31. Income Statement tab - Prepare an income statement for the period ended January 31 in the 'Income Statement' Tab. Statement of Retained earnings - Prepare a statement of retained earning in the 'Statement of Retained earnings' Tab. Balance Sheet tab - Prepare a classified balance sheet as of January 31 in the 'Balance Sheet' Tab. Analysis tab - Using the information from the requirements above, complete the 'Analysis' tab. Journal entry worksheet Requirement General Journal General Ledger Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Analysis Notice the dropdown below that gives the options to select the unadjusted, adjusted or post-closing trial balance. The option you choose will be the values used to populate the income statement and balance sheet tabs. Unadjusted ONE TRICK PONY Trial Balance January 31, 2021 Account Title Debit Credit Cash $ 18,620 9,650 Accounts Receivable Allowance for Doubtful Accounts 900 2,800 Inventory Accounts Payable Deferred Revenue Notes Payable (long-term) Common Stock Retained Earnings 1,300 4,350 15,000 5,000 4,520 31,070 Total $ 31,070 $ Requirement General Journal General Ledger Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Analysis Choose the appropriate accounts to be reported on the income statement. Select the 'adjusted' from the dropdown, which will then populate the balances in those accounts from the trial balance. However, you will need to calculate and enter the amount of the net income or loss for the period. Unadjusted ONE TRICK PONY Income Statement For the Month Ended January 31 Income from Operations Interest Revenue (Expense), net 0 Requirement General Journal General Ledger Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Analysis Prepare the statement of retained earnings at the end of January 31. You will need to determine and enter the accounts and balances to prepare the Statement of Retained Earnings. Unadjusted ONE TRICK PONY Statement of Retained Earnings For the Month Ended January 31 Balance, January 1 $ 4,520 Balance, December 1 ONE TRICK PONY Balance Sheet At December 31 Requirement General Journal General Ledger Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Analysis For the month ended January 31, indicate the (i) gross profit percentage, (ii) number of units in ending inventory, and (iii) cost per unit of ending inventory. % Gross profit percentage Number of units in ending inventory Cost per unit of ending inventory Units per Unit If OTP had used the percentage of sales method (using 2% of Net Sales) rather than the aging method, what amounts would OTC's January financial statements have reported for (i) Bad Debt Expense and (ii) Accounts Receivable, net? Bad Debt Expense Accounts Receivable, net If OTP had used LIFO rather than FIFO, what amount would OTC have reported for Cost of Goods Sold on 01/10? Cost of Goods Sold

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Forensics Body Of Knowledge

Authors: Darrell D. Dorrell, Gregory A. Gadawski

1st Edition

0470880856, 978-0470880852

More Books

Students also viewed these Accounting questions

Question

Determine the domain of the function. (x) = 1/x 2 + 4

Answered: 1 week ago