ACC 201 Great Basin College Neon Lumber Company Income Statement Excel Worksheet.
Can you help me understand this Accounting question?
Using the Excel file provided below as a starting point, or by creating your own Excel file, complete the following problem, and submit your assignment as an attachment here. Be sure to save your work before you submit, and present your work in a reasonable format with major answers highlighted. Because you have plenty of time to do this assignment, and given that the textbook is available for your use, this assignment should really be close to perfect.
Here is the problem:
The Neon Lumber Company uses the periodic inventory method, and it has a policy of adjusting and closing its books only at year end. The following adjusted trial balance for the company was prepared after posting the normal adjusting entries on December 31, 2020:
|Merchandise Inventory, January 1, 2020||289,620|
|Supplies on Hand||5,200|
|Retained Earnings, January 1, 2020||
|Sales Returns and Allowances||6,530|
|Purchase Returns and Allowances||2,400|
|Sales Salaries Expense||120,550|
|Administrative Salaries Expense||60,300|
|Delivery Expenses (Freight Out)||2,610|
|Legal and Accounting Expense||3,200|
|Miscellaneous Administrative Expense||1,030|
The ending inventory balance at Dec. 31, 2020 was $280,000.
A. Following the example on page 242 of the textbook, prepare the income statement for the year ended December 31, 2020. Do your best to distinguish between selling expenses and administrative expenses. Both interest revenue and interest expense, of course, are non-operating items.
B. Using the example on page 249 of the textbook, prepare the statement of retained earnings for the year ended December. 31, 2020.
C. Using the example on page 250 and other locations in the textbook, prepare the balance sheet as of December. 31, 2020.
D. Prepare the closing entries as of December 31, 2020.
Here is a very rough document that you might use to get you started on this assignment. Please feel free to modify it to the extent necessary to complete this assignment. In doing so, please change the name of the file to include your name before submitting it.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more