Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Will you please help me with this financial accounting hw question? I attached the images below and the required parts. Thank you. College Coasters is
Will you please help me with this financial accounting hw question? I attached the images below and the required parts. Thank you.
College Coasters is a San Diego-based merchandiser specializing in logo-adorned drink coasters. The company reported the following balances in its unadjusted trial balance at December 1. $ 8,400 1,920 450 600 850 90 1,440 200 a 0 Cash Accounts Receivable Inventory Prepaid Rent Equipment Accumulated Depreciation Accounts Payable Salaries and Wages Payable Income Taxes Payable Common Stock Retained Earnings Sales Revenue Cost of Goods Sold Rent Expense Salaries and Wages Expense Depreciation Expense Income Tax Expense Office Expenses 5,500 2,500 15,510 1,100 8,630 1,800 90 0 1,400 The company buys coasters from one supplier. All amounts in Accounts Payable on December 1 are owed to that supplier. The inventory on December 1 consisted of 900 coasters, all of which were purchased in a batch on July 10 at a unit cost of $0.50. College Coasters records its inventory using perpetual inventory accounts and the FIFO cost flow method. During December, the company entered into the following transactions. Some of these transactions are explained in greater detail below. a. Purchased 400 coasters on account from the regular supplier on 12/1 at a unit cost of $0.52, with terms of n/60. b. Purchased 1,000 coasters on account from the regular supplier on 12/2 at a unit cost of $0.55, with terms of n/60. c. Sold 1,900 coasters on account on 12/3 at a unit price of $1.10. d. Collected $870 from customers on account on 12/4. e. Paid the supplier $1,310 cash on account on 12/18. f. Paid employees $480 on 12/23, of which $260 related to work done in November and $220 was for wages up to December 22. g. Loaded 90 coasters on a cargo ship on 12/31 to be delivered the following week to a customer in Kona, Hawaii. The sale was made d. Collected $870 from customers on account on 12/4. e. Paid the supplier $1,310 cash on account on 12/18. f. Paid employees $480 on 12/23, of which $260 related to work done in November and $220 was for wages up to December 22. g. Loaded 90 coasters on a cargo ship on 12/31 to be delivered the following week to a customer in Kona, Hawaii. The sale was made FOB destination with terms of n/60. Other relevant information includes the following at 12/31: h. College Coasters has not yet recorded $190 of office expenses incurred in December on account. i. The company estimates that the equipment depreciates at a rate of $10 per month. One month of depreciation needs to be recorded. j. Wages for the period from December 2331 are $100 and will be paid on January 15. k. The $600 of Prepaid Rent relates to a six-month period ending on May 31 of next year. 1. The company incurred $800 of income tax but has made no tax payments this year. m. No shrinkage or damage was discovered when the inventory was counted on December 31. n. The company did not declare dividends and there were no transactions involving common stock. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis General Journal tab - Prepare the journal entries to record the transactions (a) through (n). Review the accounts as shown in the General Ledger and Trial Balance tabs. General Ledger tab - Each journal entry is posted automatically to the general ledger. Use the drop-down button to view the unadjusted, adjusted, or post-closing balances in the General Ledger. Trial Balance tab - You may view either the unadjusted, adjusted, or post-closing trial balance by choosing from the drop- down. Income Statement tab - Use the drop-down to select the accounts properly included on the income statement. The unadjusted, adjusted, or post-closing balances will appear for each account based on your selection. Balance Sheet tab - Use the drop-down to select the accounts to properly included on the balance sheet. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Analysis tab - Calculate to one decimal place the inventory turnover ratio and days to sell in 'Analysis Tab.' Journal entry worksheet Purchased 400 coasters on account from the regular supplier on 12/1 at a unit cost of $0.52, with terms of n/60. Record the transaction. Note: Enter debits before credits. Date General Journal Debit Credit Dec 01 208 Inventory Accounts Payable 208 Record entry Clear entry View general journal Journal entry worksheet Purchased 1,000 coasters on account from the regular supplier on 12/2 at a unit cost of $0.55, with terms of n/60. Record the transaction. Note: Enter debits before credits. Date General Journal Debit Credit Dec 02 550 Inventory Accounts Payable 550 Record entry Clear entry View general journal Journal entry worksheet Sold 1,900 coasters on account on 12/3 at a unit price of $1.1. Record the transaction. Note: Enter debits before credits. Date General Journal Debit Credit Dec 03 Accounts Receivable 2,090 Sales Revenue 2,090 Record entry Clear entry View general journal Journal entry worksheet Record the cost of goods sold. Note: Enter debits before credits. Date General Journal Debit Credit Dec 03 Cost of Goods Sold 933 Inventory 933 Record entry Clear entry View general journal Journal entry worksheet The $600 of Prepaid Rent relates to a six-month period ending on May 31 of next year. Record the transaction. Note: Enter debits before credits. Date General Journal Debit Credit Dec 31 Record entry Clear entry View general journal Journal entry worksheet No shrinkage or damage was discovered when the inventory was counted on December 31. Record the transaction. Note: Enter debits before credits. Date General Journal Debit Credit Dec 31 Record entry Clear entry View general journal Journal entry worksheet 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 COLLEGE COASTERS Unadjusted Adjusted Trial Balance December 31, 2020 Account Title Debit Credit $ 8,400 4,010 1,208 600 850 90 Cash Accounts Receivable Inventory Prepaid Rent Equipment Accumulated DepreciationEquipment Accounts Payable Salaries and Wages Payable Common Stock Retained Earnings Sales Revenue Cost of Goods Sold Depreciation Expense Office Expenses Rent Expense Salaries and Wages Expense 2,198 200 5,500 2,500 17,600 8,630 90 1,400 1,100 1,800 Total $ 28,088 $ 28,088 Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Choose the appropriate accounts to be reported on the income statement. Select the 'adjusted' from the dropdov then populate the balances in those accounts from the trial balance. However, you will need to calculate and ente of the net income or loss for the year ended December 31. Unadjusted Unadjusted COLLEGE COASTERS Income Statement Adjusted For the Year Ended December 31 $ 0 0 $ 0 OO 0 0 0 $ 0 0 0 Trial Balance Balance Sheet > Use the dropdowns to select the accounts properly included on the balance sheet. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. However, you will need to enter the amount of the Equipment (Net of accumulated depreciation), Common stock and Retained earnings as of December 31. Unadjusted Unadjusted COLLEGE COASTERS Balance Sheet As of December 31 Adjusted 0 0 0 0 0 0 0 0 0 $ 0 $ 0 $ 0 Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Calculate the inventory turnover ratio and days to sell, assuming that inventory was $450 on January 1 of this year. (Use 365 days a year. Round your intermediate calculations and final answers to 1 decimal place.) times per year Inventory Turnover Ratio Days to Sell days Balance Sheet AnalysisStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started