One Trick Pony (OTP) incorporated and began operations near the end of the year, resulting in the following post-closing balances at December 31: Cash $28,660 11,360 310* 2,000 Accounts Receivable Allowance for Doubtful Accounts Inventories Deferred Revenue (40 units) Accounts Payable Note Payable (long-term) Common Stock Retained Earnings 5,600 1,680 12,000 5,330 17,100 * credit balance. The following information is relevant to the first month of operations in the following year: OTP will sell inventory at $140 per unit. OTP's January 1 inventory balance consists of 50 units at a total cost of $2,000. OTP's policy is to use the FIFO method, recorded using a perpetual inventory system. In December, OTP received a $5,600 payment for 40 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. OTP's note payable matures in three years, and accrues interest at a 10% annual rate. January Transactions a. Included in OTP's January 1 Accounts Receivable balance a $1,200 balance due from Jeff Letrotski. Jeff is having cash flow problems and cannot pay the $1,200 balance at this time. On 01/01, OTP arranges with Jeff to convert the $1,200 balance to a six- month note, at 10% 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. b. OTP paid a $180 insurance premium on 01/02, covering the month of January; the payment is recorded directly as an expense. C. OTP purchased an additional 200 units of inventory from a supplier on account on 01/05 at a total cost of $8,000, with terms n/30. d. OTP paid a courier $400 cash on 01/05 for same-day delivery of the 200 units of inventory. e. The 40 units that OTP's customer paid for in advance in December are delivered to the customer on 01/06. f. On 01/07, OTP received a purchase allowance of $1,200 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). g. Sales of 60 units of inventory occurring during the period of 01/0701/10 are recorded on 01/10. The sales terms are n/30. h. Collected payments on 01/14 from sales to customers recorded on 01/10. i. OTP paid the first 2 weeks' wages to the employees on 01/16. The total paid is $4,450. j. Wrote off a $850 customer's account balance on 01/18. OTP uses the allowance method, not the direct write-off method. k. 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. 1. OTP recovered $530 cash on 01/26 from the customer whose account had previously been written off on 01/18. n. An unrecorded $120 utility bill for January arrived on 01/27. It is due on 02/15 and will be paid then. n. Sales of 70 units of inventory during the period of 01/10-01/28, with terms n/30, are recorded on 01/28. o. Of the sales recorded on 01/28, 10 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. p. On 01/31, OTP records the $4,450 employee salary that is owed but will be paid February 1. 9. OTP uses the aging method to estimate and adjust for uncollectible accounts on 01/31. All of OTP's accounts receivable fall into a single aging category, for which 10% is estimated to be uncollectible. (Update the balances of both relevant accounts prior to determining the appropriate adjustment.) r. Accrue interest for January on the note payable on 01/31. s. Accrue interest for January on Jeff Letrotski's note on 01/31 (see a). General Statement of General Income Requirement Retained Trial Balance Balance Sheet Journal Analysis Ledger Statement Earnings 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. 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. Adjusted ONE TRICK PONY Income Statement For the Month Ended January 31 Sales Revenue $ Cash $ 22,400 21,560 840 $ 0 Cost of Goods Sold 5,960 Bad Debt Expense 1,781 0 0 0 $ Income from Operations Interest Revenue (Expense), net (6,901) 90 $ (6,991) 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 Sales Revenue $ 22,400 28,080 Cash $ (5,680) 0 Cost of Goods Sold 5,960 0 Bad Debt Expense 0 0 0 $ (11,640) Income from Operations Interest Revenue (Expense), net 0 $ (11,640) 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 $ 5,330 (11,640) Add: Net Income Less: Dividends Balance, December 1 $ (6,310) Unadjusted ONE TRICK PONY Balance Sheet At December 31 Current Assets Cash $ Accounts Receivable 28,080 18,560 (310) 3,240 Allowance for Doubtful Accounts Inventory Interest Receivable 0 Notes Receivable (short-term) 1,200 $ 50,770 0 0 0 0 0 $ 0 0 0 $ 0 $ 0 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. (Round percentage answer to 1 decimal place.) % 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