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...
-
How do materiality judgments affect risk assessment in an audit of financial statements?
-
In Problems 1324, find the exact value of each expression. sin 17T 12
-
Consider the multiple linear regression model fit to the baseball data in Problem 3.41. Problem 3.41 Consider the 2016 major league baseball data in Table B.22. While team ERA0 was useful in...
-
Using the following financial statements for Pamplin, Inc: a. Compute the following ratios for both 2012 and 2013 using the financial statements that follow. Industry Norm Current ratio...
-
[The following information applies to the questions displayed below.] The Sky Blue Corporation has the following adjusted trial balance at December 31. Cash Accounts Receivable Prepaid Insurance...
-
You will need to adapt the configuration on both Newton and Einstein and configure the Heisenberg and Schrodinger switches to complete this task. You will need to VLSM the network, to ensure that...
-
Prove that n-n is a multiple of 3 for every positive integer n 2 by the Principle of Mathematical Induction.
-
In 1991, the California Department of Consumer Affairs began investigating Sears Auto Repair Centers. Sears' automotive unit, with 850 repair shops nationwide, generated 9 % 9 % of the merchandise...
-
Apple is famous for its attractive and highly prized electronics, including iPhones, Mac computers and laptops, and iPad tablets. However, Apple doesnt actually make any of its products. Rather, it...
-
Following the September 11, 2001, attacks on the World Trade Center and Washington, DC, there were many who had lost loved ones, their homes or businesses, or both. The outpouring of support from the...
-
Using an Internet browser or a colleges library research portal, identify a recent article from such business news outlets as The Wall Street Journal, Bloomberg Business, Forbes, or Fast Company that...
-
There are 22 million American who have federal student loans. The total amount owed is \(\$ 1.2\) trillion. And \(43 \%\) of that 22 million are either behind on their payments or arranged to have...
-
Derive the Boolean expression for the output of the circuit in figure 1 by deriving all intermediate functions. You can express higher levels as a function of lower levels:
-
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?...
-
Input information from the SBA Personal Financial Statements given to Sharptop Bank into a spreadsheet. a. Separate personal items (e.g., residence) from business items (e.g., inventory). b....
-
Compare your recalculated ending inventory to that given to Sharptop Bank and to Southern Appalachian Insurance. Is either estimated ending inventory materially different from that reported on the...
-
What accuracy certifications on the tax return and bank financial statement address providing materially inaccurate information?
Study smarter with the SolutionInn App