This practice set is designed in two parts. The first part provides a review of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This practice set is designed in two parts. The first part provides a review of the financial statements of a corporation selling sunglasses. Sally's Sunglasses, a corporation, whose primary operation is the sale of sunglasses to on-line customers and retailers in the market. Each student will prepare a financial analysis and Statement of Cash Flow for the company. In the second part, Sally's Sunglasses decides to start producing the sunglasses and selling them directly to customers. All cases of academic dishonesty will be reported to the Office of Student Life. Part One Instructions The financial information for the past two years (2020 and 2019) is provided. Sally's Sunglasses collection policy is 30 days and the benchmark for the inventory is 35 days. Using a spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: 1. Prepare a statement of Cash Flows for the current year using the indirect method. 2. Using horizontal analysis, prepare a Comparative Balance Sheet. 3. Using vertical analysis, prepare an Income Statement. 4. Using the textbook, calculate the ratios set out below: a. Current Ratio 2020 and 2019 b. Quick ratio 2020 and 2019 c. Accounts Receivable Turnover 2020 d. Number of Days Sales in Receivables 2020 (Company policy states 30 days in receivables e. Inventory Turnover 2020 f. Number of Days Sales in Inventory 2020 (Company policy states 50 days to turn over inventory) g. Ratio of Liabilities to Stockholders' Equity 2020 h. Rate earned on Total Assets 2020 1. Rate earned on Stockholders' Equity 2020 J. Earnings Per Share 2020 and 2019 The financial statements provided in this practice set can be downloaded from Blackboard. An example of a Statement of Cash Flow has been provided at the end of the Practice Set. Download the files and copy and paste them into an Excel spreadsheet (Income Statement and Balance Sheet) and add a column and calculate the ratios for the vertical and horizontal analysis. 5. Acting as an accounting advisor to the firm, prepare a memo in which you analyze the financial statements you prepared in step two and step three and along with the ratios that you have calculated prepare an analysis of the company's financial position. Identify two strengths and two weaknesses in the company. Make two recommendations to improve the company's 21 Page financial position. Be specific in each of the recommendations and use the ratios to support your analysis. The length should be no more than two paragraphs long. Prepare the memo in a word document so that you can copy and paste the information into the correct area in Blackboard. Make sure that proper English is used along with complete sentences. 6. Prepare the following documents before answering the questions on Blackboard. a. Statement of Cash Flows b. Balance Sheet with horizontal analysis c. Income Statement with vertical analysis d. Worksheet showing your ratios done in Excel e. Prepare the memo in Word analyzing the company's strengths and weaknesses with two recommendations. Once the memo is prepared then you will only need to copy and paste it into the box where indicated in Blackboard. Students must use the memo template that is attached at the end of the practice set. 7. Blackboard Instructions a. Memo analyzing the company's strengths and weaknesses with two recommendations. In Blackboard you will write a memo using ratios to analyze the strengths and weaknesses of the company. Make sure there are no spelling, grammatical, or punctuation errors. Or you can copy and paste the prepared Memo. b. Add information concerning numbers here and enter Blackboard as specified below 1. When the answer is in units enter the number as is such as 280 II. When the answer is for ratios (ie. Current ratio) and has a decimal take the decimal out two decimal spaces such as 280.89 iii. When ratios are in days/times take out to two decimal places and write days or times after the number such as 280.96 days or times iv. When the answer is in dollars ALWAYS include a dollar sign and cents even if the cents is zero add .00 such as $280.00 or $3,800.00 Please follow all instructions. If the answers are formatted incorrectly the answer will be counted wrong. Current Assets: Cash Accounts Receivable, Net Inventory (sunglasses) Prepaid Insurance Prepaid Rent Assets Total Assets Total Current Assets Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, Plant, and Equipment Sally's Sunglasses Inc. Comparative Balance Sheet December 31, 2020 and 2019 $ $ S $ $ S SSSS $ $ 2020 90,000 130,000 135,000 25,000 380,000 300,000 -75,000 225,000 605,000 $ $ $ $ $ $ $ $ $ $ 2019 70,000 90,000 80,000 20,000 12,000 272,000 250,000 -50,000 200,000 472,000 Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Notes Payable Salaries Payable Federal Income Taxes Payable Total Current Liabilities Long Term Liabilities Note Payable Total Liabilities Stockholders' Equity: Common Stock, $5 Par Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity $ $ $ $ $ $ $ $ $ $ $ $ 2020 75,000 20,000 40,000 10,000 145,000 60,000 205,000 175,000 25,000 200,000 400,000 605,000 $ $ $ $ $ $ $ SSSSS 2019 40,000 60,000 30,000 25,000 155,000 37,000 192,000 130,000 150,000 280.000 472,000 Sales Cost of Goods Sold Gross Margin Operating Expenses: Salaries and Wages Expense Rent Expense Depreciation Expense Total Operating Expenses Income from Operations Loss on Sale of Equipment Interest Expense Increase (Decrease) in Operating Income Income before Taxes Federal Income Taxes Net Income Sally's Sunglasses Inc. Comparative Statement of Income For the Years Ended December 31, 2020 and 2019 $ $ $ SSSSSSSS 120,000 30,000 32,000 $ 182,000. $ 2020 850,000 475,000 375,000 $ 193,000 $ $ 2,000 4,000 $ -6,000 $ 187,000 56,100 130,900 $ 790,000 $ 450,000 $ 340,000 $ 200,000 40,000 $ 10,000 $ 250,000 90,000 $ 5555 $ $ $ 2019 SSS $ 5,000 -5,000 85,000 25,500 59,500 Retained Earnings, Beginning of Year Sally's Sunglasses Inc. Comparative Statement of Retained Earnings For the Years Ended December 31, 2020 and 2019 2020 $ $ $ $ 150,000 130,900 80,900 200,000 $ $ $ 2019 $ 130,000 Net Income. Less: Dividends Retained Earnings, End of Year 150,000 1. Equipment with a cost of $50,000 on which accumulated depreciation has been recorded for $7,000 was sold for $41,000 cash. Additional equipment was purchased using a long-term note payable and cash. 2. Stock was issued for cash. 3. Dividends were paid in cash. 59,500 39,500 This practice set is designed in two parts. The first part provides a review of the financial statements of a corporation selling sunglasses. Sally's Sunglasses, a corporation, whose primary operation is the sale of sunglasses to on-line customers and retailers in the market. Each student will prepare a financial analysis and Statement of Cash Flow for the company. In the second part, Sally's Sunglasses decides to start producing the sunglasses and selling them directly to customers. All cases of academic dishonesty will be reported to the Office of Student Life. Part One Instructions The financial information for the past two years (2020 and 2019) is provided. Sally's Sunglasses collection policy is 30 days and the benchmark for the inventory is 35 days. Using a spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: 1. Prepare a statement of Cash Flows for the current year using the indirect method. 2. Using horizontal analysis, prepare a Comparative Balance Sheet. 3. Using vertical analysis, prepare an Income Statement. 4. Using the textbook, calculate the ratios set out below: a. Current Ratio 2020 and 2019 b. Quick ratio 2020 and 2019 c. Accounts Receivable Turnover 2020 d. Number of Days Sales in Receivables 2020 (Company policy states 30 days in receivables e. Inventory Turnover 2020 f. Number of Days Sales in Inventory 2020 (Company policy states 50 days to turn over inventory) g. Ratio of Liabilities to Stockholders' Equity 2020 h. Rate earned on Total Assets 2020 1. Rate earned on Stockholders' Equity 2020 J. Earnings Per Share 2020 and 2019 The financial statements provided in this practice set can be downloaded from Blackboard. An example of a Statement of Cash Flow has been provided at the end of the Practice Set. Download the files and copy and paste them into an Excel spreadsheet (Income Statement and Balance Sheet) and add a column and calculate the ratios for the vertical and horizontal analysis. 5. Acting as an accounting advisor to the firm, prepare a memo in which you analyze the financial statements you prepared in step two and step three and along with the ratios that you have calculated prepare an analysis of the company's financial position. Identify two strengths and two weaknesses in the company. Make two recommendations to improve the company's 21 Page financial position. Be specific in each of the recommendations and use the ratios to support your analysis. The length should be no more than two paragraphs long. Prepare the memo in a word document so that you can copy and paste the information into the correct area in Blackboard. Make sure that proper English is used along with complete sentences. 6. Prepare the following documents before answering the questions on Blackboard. a. Statement of Cash Flows b. Balance Sheet with horizontal analysis c. Income Statement with vertical analysis d. Worksheet showing your ratios done in Excel e. Prepare the memo in Word analyzing the company's strengths and weaknesses with two recommendations. Once the memo is prepared then you will only need to copy and paste it into the box where indicated in Blackboard. Students must use the memo template that is attached at the end of the practice set. 7. Blackboard Instructions a. Memo analyzing the company's strengths and weaknesses with two recommendations. In Blackboard you will write a memo using ratios to analyze the strengths and weaknesses of the company. Make sure there are no spelling, grammatical, or punctuation errors. Or you can copy and paste the prepared Memo. b. Add information concerning numbers here and enter Blackboard as specified below 1. When the answer is in units enter the number as is such as 280 II. When the answer is for ratios (ie. Current ratio) and has a decimal take the decimal out two decimal spaces such as 280.89 iii. When ratios are in days/times take out to two decimal places and write days or times after the number such as 280.96 days or times iv. When the answer is in dollars ALWAYS include a dollar sign and cents even if the cents is zero add .00 such as $280.00 or $3,800.00 Please follow all instructions. If the answers are formatted incorrectly the answer will be counted wrong. Current Assets: Cash Accounts Receivable, Net Inventory (sunglasses) Prepaid Insurance Prepaid Rent Assets Total Assets Total Current Assets Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, Plant, and Equipment Sally's Sunglasses Inc. Comparative Balance Sheet December 31, 2020 and 2019 $ $ S $ $ S SSSS $ $ 2020 90,000 130,000 135,000 25,000 380,000 300,000 -75,000 225,000 605,000 $ $ $ $ $ $ $ $ $ $ 2019 70,000 90,000 80,000 20,000 12,000 272,000 250,000 -50,000 200,000 472,000 Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Notes Payable Salaries Payable Federal Income Taxes Payable Total Current Liabilities Long Term Liabilities Note Payable Total Liabilities Stockholders' Equity: Common Stock, $5 Par Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity $ $ $ $ $ $ $ $ $ $ $ $ 2020 75,000 20,000 40,000 10,000 145,000 60,000 205,000 175,000 25,000 200,000 400,000 605,000 $ $ $ $ $ $ $ SSSSS 2019 40,000 60,000 30,000 25,000 155,000 37,000 192,000 130,000 150,000 280.000 472,000 Sales Cost of Goods Sold Gross Margin Operating Expenses: Salaries and Wages Expense Rent Expense Depreciation Expense Total Operating Expenses Income from Operations Loss on Sale of Equipment Interest Expense Increase (Decrease) in Operating Income Income before Taxes Federal Income Taxes Net Income Sally's Sunglasses Inc. Comparative Statement of Income For the Years Ended December 31, 2020 and 2019 $ $ $ SSSSSSSS 120,000 30,000 32,000 $ 182,000. $ 2020 850,000 475,000 375,000 $ 193,000 $ $ 2,000 4,000 $ -6,000 $ 187,000 56,100 130,900 $ 790,000 $ 450,000 $ 340,000 $ 200,000 40,000 $ 10,000 $ 250,000 90,000 $ 5555 $ $ $ 2019 SSS $ 5,000 -5,000 85,000 25,500 59,500 Retained Earnings, Beginning of Year Sally's Sunglasses Inc. Comparative Statement of Retained Earnings For the Years Ended December 31, 2020 and 2019 2020 $ $ $ $ 150,000 130,900 80,900 200,000 $ $ $ 2019 $ 130,000 Net Income. Less: Dividends Retained Earnings, End of Year 150,000 1. Equipment with a cost of $50,000 on which accumulated depreciation has been recorded for $7,000 was sold for $41,000 cash. Additional equipment was purchased using a long-term note payable and cash. 2. Stock was issued for cash. 3. Dividends were paid in cash. 59,500 39,500
Expert Answer:
Answer rating: 100% (QA)
Requirment 1 Cash Flows from Operating Activities Indirect Method Particulars Amoount Amoount Net Income Befor Taxation 18700000 Adjustment For Deprec... View the full answer
Related Book For
Introduction to Accounting An Integrated Approach
ISBN: 978-0078136603
6th edition
Authors: Penne Ainsworth, Dan Deines
Posted Date:
Students also viewed these accounting questions
-
A review of the financial statements of Micromania, Inc., revealed a beginning and ending Allowance for Uncollectible Accounts balance of $ 32,500 and $ 28,600, respectively. If the uncollectible...
-
A review of the financial statements of private and publicly accountable enterprises may result in finding the following measurement approaches used for their non-strategic investments: (1)...
-
Explain why a review of interim financial statements for a public company may provide a greater level of assurance than an SSARS review.
-
Find any horizontal or vertical asymptotes. f(x) = = X 1- X
-
Use the complete pivoting algorithm to repeat Exercise 10 Maple with Digits:= 10. In Exercise 10 a. 58.9x 1 + 0.03x 2 = 59.2, 6.10x 1 + 5.31x 2 = 47.0. Actual solution [1, 10] b. 3.3330x 1 + 15920x 2...
-
Evaluate the integral. TT/2 /6 cotx dx
-
Trouble was being experienced by a new high-tech machine for joining two pieces of sheet metal. The two factors considered first are the pressure (low/high) and temperature of the pump low/high. The...
-
Marya Callais, a citizen of Florida, was walking along a busy street in Tallahassee, Florida, when a large crate flew off a passing truck and hit her, causing numerous injuries. She experienced a...
-
Each of the four independent situations below describes a sales-type lease in which annual lease payments of $185,000 are payable at the beginning of each year. Each is a finance lease for the...
-
Hotel DelRay is located at the heart of the city of Brussels, in Belgium. Brussels is a major hub for international politics, a home for several international organizations and diplomats, and a...
-
The industrial sector has begun prioritizing sustainability in design and operations. Industrial facilities, which include manufacturing buildings, warehouses, and distribution centers have long been...
-
Does a creditor have an obligation to advise a company to obtain legal advice before signing a contract? In this case, a director of a company is saying they did not know what they were signing when...
-
-Evaluate the integral 4 2 [[ cos x 0 y by reversing the order of integration. os x dxdy
-
Randal embezzled $6000 of his employer's money and then disappeared. The employer's accountant called at Randal's residence and found out that his wife had a $3500 term deposit. When the accountant...
-
The appropriate discount rate for the following cash flows is 7.03 percent per year. Year Cash Flow $ 2,410 1 2 0 3 3,850 4 2,100 What is the present value of the cash flows? (Do not round...
-
3-42. CVP, SENSITIVITY ANALYSIS. Jan's Ornaments sells handmade ornaments for $35.00 per ornament. Operating information for 2020 is as follows: Sales revenue ($35 per ornament) Variable cost ($20...
-
. Shao - wei, a single taxpayer reports $ 8 0 , 0 0 0 of gross income. She receives $ 5 , 0 0 0 of tax - exempt interest ( an exclusion ) . She has a $ 2 , 0 0 0 tax credit. She has itemized...
-
The tractor is used to lift the 150-kg load B with the 24-mlong rope, boom, and pulley system. If the tractor travels to the right at a constant speed of 4 m/s, determine the tension in the rope when...
-
Your company has decided to switch from a manual accounting system to a computerized transaction based system with a March 31 fiscal year-end. The system your company is adopting utilizes increases...
-
The following information has been gathered by Miller Company to determine its economic order quantity. Annual demand ...................................................................... 2,000,000...
-
Giovinazzo Construction Company plans to buy a new dump truck that has a sticker price of $ 68,800. The dealer has offered to finance the truck on an installment note at 5 percent interest for 48...
-
Dunkirk Consulting wishes to predict the amount of overhead expense that will be incurred by a consulting contract, to develop more accurate bids for future con- tracts. Dunkirk has the following...
-
Block Commodities has gathered the following information concerning rock salt deliveries to its clients, which it believes are highly seasonal: a. Suppose Block Commodities calculated a set of...
-
The service center at a large automobile dealership is trying to boost revenue by pro- viding no-appointment-necessary oil changes to any type of vehicle that stops by the service center. To quickly...
Study smarter with the SolutionInn App