Financial Statement Assignment #2 Instructions for Phase C: Use your graded financial statements (from Phase B...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Financial Statement Assignment #2 Instructions for Phase C: Use your graded financial statements (from Phase B of this assignment) to prepare a ratio analysis for Summer Corporation for 2020 versus 2019. You will also need Summer's 2019 financial statements and selected data from 2018 (needed for certain ratio computations including the 2019 averages within sor The 2019 financial statements can be found in the Libby textbook on page 714- they are the Year 1 amounts within AP 13-5. The 2018 selected financial data includes the following: Other financial information needed for 2020 and 2019: Hint: ACCT200-07/-09 Fall 2021 Other instructions: Total Stockholders' Equity at 12/31/18 Total Assets at 12/31/18 Total Net PP&E at 12/31/18 Total Net Accounts Receivable at 12/31/18 Total Inventory a 12/31/18 Dividends Paid during 2019 Market price per share of Summer stock in both 2020 and 2019 It is recommended that you print the ratio table (on the next tab of this Excel workbook), then manually insert the formulas, calculations, and results. All "boxes" in the Ratios worksheet (on the next tab) should be populated with information as indicated in the column headings for formulas, calculatio One of the ratios, Working Capital, has been completed as an example. $ 101,000 150,000 110,000 28,000 19,000 An electronic submission is required, but it must be handwritten. See Canvas for more information. It is recommended that you use pencil in case you need to make erasures as you work through this assignment. 10,000 1,100 Please highlight in yellow any ratio results where Summer has experienced an unfavorable trend from 2019 to 2020. Round your ratio results to two decimal places. For those ratios that are expressed as percentages, first convert the result to a percentage, then round i Note that you are not required to compute any of the cash flow ratios (Quality of Income Ratio and Cash Coverage Ratio). Recall from Phase A that all of Summer's sales are on credit, and that all stock transactions are unchanged from 2016 through 2020. ASSETS: Current Assets: Cash 800 Accounts Receivable, Net 42.000- Merchandise Inventory 25 000- Prepaid Insurance 200 Total Current Assets 74 200- Non-current Assets: Property, Plant & Equipment, Net 130.000 Total Assets Balance Sheet Summer Corporation December 31, 2020 204 LIABILITIES: Current Liabilities Accounts Payable 17,000 Income Taxes Payable 1,000 Total Current Liabilities 8,000. Non-current Liabilities: Bonds Payable 70,000 Total Liabilities 10X a 88,000 STOCKHOLDERS' EQUITY Common Stock 1,000 Additional Paid-in Capital,000- Retained Earnings 1.000 Total Stockholders' Equity if.000-> Total Liabilities & Stockholders' Equity D Statement of Stockholders' Equity Summer Corporation For the Year Ended December 31, 2020 December 31, 2019 Stock Issued Net Income Dividends December 31, 2020 Common Stock $1,000 Additional Paid-in Capital $99,000 Retained Earnings $2.000 25,000 11,200) 166,000 ✓ 799,000 $1.000 Total Stockholders' Equity 102,000 $ 25,200 6.000 Income Statement Summer Corporation For the Year Ended December 31, 2020 Net Sales Revenues 453000 Cost of Goods Sold 250,000 Gross Profit 203,000 - Operating Expenses: Salaries & Wages Expense 4000 Warranty Expense 87,000 Depreciation Expense 10000- Utilities Expense 8,000 Advertising Expense 1,000 Payroll Tax Expense 6,500. Insurance Expense 200 Rent Expense 1,800 Repairs & Maintenance Expense ,DOD Bank Service Expense 500 Total Operating Expenses 10.000 Income from Operations 43,000 Other Expenses: Interest Expense 4000 Income Before Taxes I wrote nex- ble lines y follow Income Tax Expense Net Income 7800 36,000 10.800 25300 ← do Summer Corporation Ratio Analysis Profitability Ratios: Return on Equity (Percentage) Return on Assets (Percentage) Gross Profit Percentage (Percentage) Net Profit Margin (Percentage) Earnings per Share Turnover (Efficiency) Ratios: Total Asset Turnover Ratio Fixed Asset Turnover Ratio Receivable Turnover Ratio Inventory Turnover Ratio Liquidity Ratios: Working Capital Current Ratio Formula Net income Average total SHOCK holdert equity net income Average total Gross profit Net sales Net IncamC net sales net income Average total assets weighted Average number of condo shores outstanding Net sales Net sales Average Net OPSE NOT Credit Sales Average Accounts COGS Average Inventory Current Assets- Current Liabs. 2020 Calculation current asset 25,200/109,000 25,200/ 203,000 453,000 74,000-18,000 2020 4 2312 23.12% $ 56,000 Results 2019 calculation 26.21% 26,60% 101.500 $ 2019 32,000 51,000-19,000 Fixed Asset Turnover Ratio Receivable Turnover Ratio Inventory Turnover Ratio Liquidity Ratios: Working Capital Current Ratio Quick Ratio Solvency Ratios: Times Interest Earned Ratio Debt-to-Equity Ratio Market Ratios: Price/Earnings Ratio Dividend Yield Ratio (Percentage) Net sales Average Net OPSE NCT credit Sales Average Accoun Recievable COGS Average Inventory Current Assets-Current Liabs. current asset current liabilitie con cash equiv. F Current invest. +AR currer Libritied net income interest experise + tax expence interest expense Total Liaialities Stockholder's equity market price per Share earnings per share dividends per share market price per share 74,000 -18,000 $ 56,000 $ 32,000 51,000-19,000 Financial Statement Assignment #2 Instructions for Phase C: Use your graded financial statements (from Phase B of this assignment) to prepare a ratio analysis for Summer Corporation for 2020 versus 2019. You will also need Summer's 2019 financial statements and selected data from 2018 (needed for certain ratio computations including the 2019 averages within sor The 2019 financial statements can be found in the Libby textbook on page 714- they are the Year 1 amounts within AP 13-5. The 2018 selected financial data includes the following: Other financial information needed for 2020 and 2019: Hint: ACCT200-07/-09 Fall 2021 Other instructions: Total Stockholders' Equity at 12/31/18 Total Assets at 12/31/18 Total Net PP&E at 12/31/18 Total Net Accounts Receivable at 12/31/18 Total Inventory a 12/31/18 Dividends Paid during 2019 Market price per share of Summer stock in both 2020 and 2019 It is recommended that you print the ratio table (on the next tab of this Excel workbook), then manually insert the formulas, calculations, and results. All "boxes" in the Ratios worksheet (on the next tab) should be populated with information as indicated in the column headings for formulas, calculatio One of the ratios, Working Capital, has been completed as an example. $ 101,000 150,000 110,000 28,000 19,000 An electronic submission is required, but it must be handwritten. See Canvas for more information. It is recommended that you use pencil in case you need to make erasures as you work through this assignment. 10,000 1,100 Please highlight in yellow any ratio results where Summer has experienced an unfavorable trend from 2019 to 2020. Round your ratio results to two decimal places. For those ratios that are expressed as percentages, first convert the result to a percentage, then round i Note that you are not required to compute any of the cash flow ratios (Quality of Income Ratio and Cash Coverage Ratio). Recall from Phase A that all of Summer's sales are on credit, and that all stock transactions are unchanged from 2016 through 2020. ASSETS: Current Assets: Cash 800 Accounts Receivable, Net 42.000- Merchandise Inventory 25 000- Prepaid Insurance 200 Total Current Assets 74 200- Non-current Assets: Property, Plant & Equipment, Net 130.000 Total Assets Balance Sheet Summer Corporation December 31, 2020 204 LIABILITIES: Current Liabilities Accounts Payable 17,000 Income Taxes Payable 1,000 Total Current Liabilities 8,000. Non-current Liabilities: Bonds Payable 70,000 Total Liabilities 10X a 88,000 STOCKHOLDERS' EQUITY Common Stock 1,000 Additional Paid-in Capital,000- Retained Earnings 1.000 Total Stockholders' Equity if.000-> Total Liabilities & Stockholders' Equity D Statement of Stockholders' Equity Summer Corporation For the Year Ended December 31, 2020 December 31, 2019 Stock Issued Net Income Dividends December 31, 2020 Common Stock $1,000 Additional Paid-in Capital $99,000 Retained Earnings $2.000 25,000 11,200) 166,000 ✓ 799,000 $1.000 Total Stockholders' Equity 102,000 $ 25,200 6.000 Income Statement Summer Corporation For the Year Ended December 31, 2020 Net Sales Revenues 453000 Cost of Goods Sold 250,000 Gross Profit 203,000 - Operating Expenses: Salaries & Wages Expense 4000 Warranty Expense 87,000 Depreciation Expense 10000- Utilities Expense 8,000 Advertising Expense 1,000 Payroll Tax Expense 6,500. Insurance Expense 200 Rent Expense 1,800 Repairs & Maintenance Expense ,DOD Bank Service Expense 500 Total Operating Expenses 10.000 Income from Operations 43,000 Other Expenses: Interest Expense 4000 Income Before Taxes I wrote nex- ble lines y follow Income Tax Expense Net Income 7800 36,000 10.800 25300 ← do Summer Corporation Ratio Analysis Profitability Ratios: Return on Equity (Percentage) Return on Assets (Percentage) Gross Profit Percentage (Percentage) Net Profit Margin (Percentage) Earnings per Share Turnover (Efficiency) Ratios: Total Asset Turnover Ratio Fixed Asset Turnover Ratio Receivable Turnover Ratio Inventory Turnover Ratio Liquidity Ratios: Working Capital Current Ratio Formula Net income Average total SHOCK holdert equity net income Average total Gross profit Net sales Net IncamC net sales net income Average total assets weighted Average number of condo shores outstanding Net sales Net sales Average Net OPSE NOT Credit Sales Average Accounts COGS Average Inventory Current Assets- Current Liabs. 2020 Calculation current asset 25,200/109,000 25,200/ 203,000 453,000 74,000-18,000 2020 4 2312 23.12% $ 56,000 Results 2019 calculation 26.21% 26,60% 101.500 $ 2019 32,000 51,000-19,000 Fixed Asset Turnover Ratio Receivable Turnover Ratio Inventory Turnover Ratio Liquidity Ratios: Working Capital Current Ratio Quick Ratio Solvency Ratios: Times Interest Earned Ratio Debt-to-Equity Ratio Market Ratios: Price/Earnings Ratio Dividend Yield Ratio (Percentage) Net sales Average Net OPSE NCT credit Sales Average Accoun Recievable COGS Average Inventory Current Assets-Current Liabs. current asset current liabilitie con cash equiv. F Current invest. +AR currer Libritied net income interest experise + tax expence interest expense Total Liaialities Stockholder's equity market price per Share earnings per share dividends per share market price per share 74,000 -18,000 $ 56,000 $ 32,000 51,000-19,000
Expert Answer:
Answer rating: 100% (QA)
Step 1 Ratio Analysis It is the relationship between the two or more items of the financial statements which tells profitability liquidity activity an... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Use Books-A-Millions financial statements, which can be found in Appendix A at the back of the book, to answer the following questions: 1. What types of debt does Books-A-Million have? Where did you...
-
The following statements can be found in the American Medical Association's code of conduct. Give the inverse, converse, contra-positive, and negation of each. Simplify and use De Morgan's laws when...
-
The following information can be found in the Murphy Oil Corporation Annual Report to Share-holders. For each variable, indicate the level of data measurement. a. List of Principal Offices (e.g., El...
-
Suppose we want both the sensitivity and specificity to be at least 70%. Use the ROC curve to identify the possible value(s) to use as the cutoff for identifying people with dementia, based on these...
-
To acquire Engels Corporation stock, Kaiser Co. pays $61,500 in cash. What entry should be made for this investment, assuming the stock is readily marketable?
-
In early 2008, the price of oil on the world market increased, hitting a peak of about $140 per barrel in July, 2008. In the second half of 2008, the price of oil declined, ending the year at just...
-
On November 15, 2010, Chandlers Department Store purchased $5,100 of inventory on account from one of its suppliers. The terms were 3/15, n/45, FOB shipping point. On November 18 Chandlers Department...
-
In auditing the Train Company, you obtain directly from the bank Trains bank statement, canceled checks, and other memoranda which relate to the companys bank account for December 2007. In...
-
Define A's competitive advantage clearly vs key competition. Define the customer segments, primary target customer and positioning of the product. Use the frameworks that we saw in our class to...
-
Two graduate students are engaged to one another, and both are working on their master's theses-Michael in music education and Kristen in political science. Because both have incomes that are tied to...
-
How long until you get 1,00,000 if you invest 10,000 a year at a 9% interest rate with a present value of 0 (assuming annual compounding)
-
The Airfoil Aircraft Company has issued 5% convertible bonds that mature October 1, 2029. Suppose the bonds are issued October 1, 2021, and pay interest each April 1 and October 1. (Click the icon to...
-
Choose a person that lived during the Colonial Era. They must have either lived in Colonial America or influenced Colonial American settlement. Why are they important? How did they shape the Era? How...
-
Calculate the freezing point depression and the freezing point after adding 100.0 g of table salt to 400.0 g of water. Show All Work. Then calculate the boiling point elevation and boiling point for...
-
Quentin is considering purchasing an investment. He expects that the investment will pay him $2,600 at the end of every year for 9 years. In addition, he expects to receive $34,752 at the end of the...
-
Ammonium carbonate, (NH 4 ) 2 CO 3 dissolves in water releasing the ammonium ion, NH 4 + , and carbonate ion, CO 3 2- into solution. Both of these ions hydrolyze (react with water). The chemical...
-
Consider two goods, and 2 where the price of x is $10 and the price of x2 is $20. The consumer's income is $200 and the utility function is below: U (x, x) = x(x + 1) (1) How much of and 2 will the...
-
A superior criticized a sales manager for selling high-revenue, low-profit items instead of lower-revenue but higher-profit items. The sales manager responded, My income is based on commissions that...
-
Ozark Publishing Company completed the following transactions during 2012: Nov1 Sold 50 six-month subscriptions, collecting cash of $2,400, plus sales tax of 4%. Dec15 Remitted the sales tax to the...
-
Classify each of the following items as one of the following: Addition to the book balance (+ Book) Subtraction from the book balance ( Book) Addition to the bank balance (+ Bank) Subtraction from...
-
Old Time Bakery reported sales revenue of $134,000 and cost of goods sold of $89,000. Requirements 1. Compute Old Time Bakerys correct gross profit assuming the companys ending inventory is...
-
Jordan Quinn manages the local homeless shelter. He fears that a trusted employee has been stealing from the shelter. This employee receives cash from supporters and also prepares the monthly bank...
-
Refer to question 6. The balance of Allowance for Uncollectible Accounts, after adjustment, will be a. $ 100 $ 100 . b. $ 200 $ 200 . c. $ 300 $ 300 . d. impossible to determine from the information...
-
Refer to questions 6 and 7. Early the following year, Harper wrote off \(\$ 150\) of old receivables as uncollectible. The balance in the Allowance account is now The next four questions use the...
Study smarter with the SolutionInn App