Section 4: Financial Stmts for Earthshine, Inc. a) Given the CSV trial balance shown on the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Section 4: Financial Stmts for Earthshine, Inc. a) Given the CSV trial balance shown on the worksheet, use Text to Columns to break out the data in Column A into Columns C, D, and E of the Accounting Worksheet. b) Complete the accounting worksheet using Columns F and G to record cost of goods sold and adjust inventory. A physical count of inventory taken at 12/31/2112 was $8,000. c) After you complete the worksheet through Column I, prepare a properly formatted income statement, statement of retained earnings, and balance sheet. The statements are for a single year only, i.e., not comparative. d) Prepare your income statement starting in cell K1, your statement of retained earnings under your income statement, and your balance sheet starting in Cell N1. Present statements using one only column for your numbers. e) You must show a calculation of net sales, either in the income statement or in a separate schedule. f) You must show calculation of cost goods sold (CGS). You may show the calculation as part of the income statement or in a separate schedule that supports your CGS figure. g) The note receivable matures in 2115, unearned revenue will be earned in 2113, the loan payable is due in 2113, and the mortgage payable is due in 2120. h) Miscellaneous income, interest expense and miscellaneous expense are nonoperating items and should be presented below operating income. i) Follow the formatting and presentation guidelines presented in the video lectures. j) Be sure you present your work neatly and using proper formatting to avoid losing points for this section. Cash Short-Term Investments Accounts Receivable Allowance for Doubtful Accounts Prepaid Insurance Inventory Equipment Equipment A/D Building Building - A/D Account Description Land Note Receivable Accounts Payable Salaries and Wages Payable Payroll Tax Payable Property Tax Payable Unearned Revenue Loan Payable Mortgage Payable Deferred Tax Liability Common Stock Additional Paid-In Capital Retained Earnings Dividends Sales Revenue Sales Discounts Sales Returns and Allowances Miscellaneous Income Purchases Purchases Discounts Purchases Returns and Allowances Freight-In Cost of goods sold Salaries and Wages Expense Payroll Tax Expense Rent Expense Insurance Expense Freight-Out Property Tax Expense Office Supplies Expense Maintenance and Repairs Expense Bad Debt Expense Depreciation Expense Interest Expense Miscellaneous Expense Income Tax Expense Totals Unadjusted Balance Cr Dr 25,000 125.000 75,000 3,500 18,000 17,500 175,000 25,000 7,000 - . 20,000 10,000 7,000 613,000 19,500 591,185 45,800 24,000 9,000 6,750 3,500 2,750 3,750 23.750 7,500 4,050 1,750 36,915 1,901,200 . 5,000 3,500 17,500 32,000 12,000 1,200 3,500 5,000 8,000 135,000 6,000 10,000 40,000 85,000 1,525,000 3,500 7,000 2,000 - . - 1,901,200 JE to and Adjust Inventory Dr Cr Adjusted Balance Dr Cr Section 4: Financial Stmts for Earthshine, Inc. a) Given the CSV trial balance shown on the worksheet, use Text to Columns to break out the data in Column A into Columns C, D, and E of the Accounting Worksheet. b) Complete the accounting worksheet using Columns F and G to record cost of goods sold and adjust inventory. A physical count of inventory taken at 12/31/2112 was $8,000. c) After you complete the worksheet through Column I, prepare a properly formatted income statement, statement of retained earnings, and balance sheet. The statements are for a single year only, i.e., not comparative. d) Prepare your income statement starting in cell K1, your statement of retained earnings under your income statement, and your balance sheet starting in Cell N1. Present statements using one only column for your numbers. e) You must show a calculation of net sales, either in the income statement or in a separate schedule. f) You must show calculation of cost goods sold (CGS). You may show the calculation as part of the income statement or in a separate schedule that supports your CGS figure. g) The note receivable matures in 2115, unearned revenue will be earned in 2113, the loan payable is due in 2113, and the mortgage payable is due in 2120. h) Miscellaneous income, interest expense and miscellaneous expense are nonoperating items and should be presented below operating income. i) Follow the formatting and presentation guidelines presented in the video lectures. j) Be sure you present your work neatly and using proper formatting to avoid losing points for this section. Cash Short-Term Investments Accounts Receivable Allowance for Doubtful Accounts Prepaid Insurance Inventory Equipment Equipment A/D Building Building - A/D Account Description Land Note Receivable Accounts Payable Salaries and Wages Payable Payroll Tax Payable Property Tax Payable Unearned Revenue Loan Payable Mortgage Payable Deferred Tax Liability Common Stock Additional Paid-In Capital Retained Earnings Dividends Sales Revenue Sales Discounts Sales Returns and Allowances Miscellaneous Income Purchases Purchases Discounts Purchases Returns and Allowances Freight-In Cost of goods sold Salaries and Wages Expense Payroll Tax Expense Rent Expense Insurance Expense Freight-Out Property Tax Expense Office Supplies Expense Maintenance and Repairs Expense Bad Debt Expense Depreciation Expense Interest Expense Miscellaneous Expense Income Tax Expense Totals Unadjusted Balance Cr Dr 25,000 125.000 75,000 3,500 18,000 17,500 175,000 25,000 7,000 - . 20,000 10,000 7,000 613,000 19,500 591,185 45,800 24,000 9,000 6,750 3,500 2,750 3,750 23.750 7,500 4,050 1,750 36,915 1,901,200 . 5,000 3,500 17,500 32,000 12,000 1,200 3,500 5,000 8,000 135,000 6,000 10,000 40,000 85,000 1,525,000 3,500 7,000 2,000 - . - 1,901,200 JE to and Adjust Inventory Dr Cr Adjusted Balance Dr Cr
Expert Answer:
Answer rating: 100% (QA)
Unadjusted Balance Adjustments Adjusted Balance Account DR CR DR CR DR CR Cash 25000 25000 ShortTerm Investments 125000 125000 Accounts Receivable 75000 75000 Allowance for Doubtful Accounts 5000 5000 ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
The retail inventory method is used by The Bronx Company. Inventory, purchases, and sales data for 2016 are as follows: Using the retail method, calculate the Lower-of-Average-Cost or Market of the...
-
The Candle Shoppe reports the following sales forecast: August, $ 150,000; September, $ 170,000. Cash sales are normally 40% of total sales and all credit sales are expected to be collected in the...
-
Refer to Example 2-11. Would the pump recommendation change if the cost of electricity was $0.15 per kWh? What if the pumps were only required for 3,000 operating hours
-
Under what circumstances should a party be joined in an action?
-
The comparative balance sheet of Morston Educational Supply at December 31, 2016, reported the following: Morstons transactions during 2016 included the following: Requirements 1. Prepare the...
-
The speed ratio of the reverted gear train shown in Fig.15.23 is to be 12. The module of gears A and B is 3.125 mm and of gears C and D is 2.5 mm. Calculate the suitable number of teeth for the...
-
Get It Right, CPAs, has been retained to review its client's corporate formation calculations for 20XX. Maria, Roger, and Novak created Grassroots Tennis, Inc. (GTI), which began operations on March...
-
75 kW, Mphase, 440 V.Xoanatcted, 50 tynchranoua motor opeudes al rated coalition power leading. The euchading field and stator losles, is 95% and synchronour reactance X "250em and resistance Rw0...
-
Discuss the meaning of international business.
-
Would you want to work for a foreign-owned firm? Why or why not?
-
What are the primary causes of globalization?
-
Which markets are more important to international businessesthe traditional markets of North America, the EU, and Japan, or the emerging markets? Defend your answer.
-
Does your college or university have any international programs? Does this make the institution an international business? Why or why not?
-
Mary has been working for Paperbase Inc. and she is a member of the company's contributory, best-earnings, defined-benefit plan. Mary's pensionable earnings is $97,000 and the YMPE is $62,000. Any...
-
Clark, PA, has been engaged to perform the audit of Kent Ltd.s financial statements for the current year. Clark is about to commence auditing Kents employee pension expense. Her preliminary enquiries...
-
Phil and Linda are 25-year-old newlyweds and file a joint tax return. Linda is covered by a retirement plan at work, but Phil is not. a. Assuming Phil's wages were $27,000 and Linda's wages were...
-
Sally hires a maid to work in her home for $250 per month. The maid is 25 years old and not related to Sally. During 2012, the maid worked 10 months for Sally. a. What is the amount of Social...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
Weights, in pounds, of a sample of male college soccer players were measured. The following display from a TI-84 Plus calculator presents a 98% confidence interval for the population mean weight. a....
-
A sample of used cars on a lot was taken, and the age of each car was recorded. The following MINITAB output presents a confidence interval for the population mean age. a. How many degrees of freedom...
-
A sample of college students was asked how many hours per week they spent reading. The following display from a TI-84 Plus calculator presents a 95% confidence interval for the population mean time...
Study smarter with the SolutionInn App