{"id":430946,"date":"2018-10-01T17:29:28","date_gmt":"2018-10-01T17:29:28","guid":{"rendered":"https:\/\/essaypaper.org\/compute-the-following-ratios-and-show-the-answer-to-two-digits-past-the-decimal-i-the-current-ratio-ii-the-acid-test-ratio-use-excel-formulas-in-the-cells-indicated-below-in-yellow-for-calculat\/"},"modified":"2018-10-24T08:32:41","modified_gmt":"2018-10-24T08:32:41","slug":"compute-the-following-ratios-and-show-the-answer-to-two-digits-past-the-decimal-i-the-current-ratio-ii-the-acid-test-ratio-use-excel-formulas-in-the-cells-indicated-below-in-yellow-for-calculat","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/compute-the-following-ratios-and-show-the-answer-to-two-digits-past-the-decimal-i-the-current-ratio-ii-the-acid-test-ratio-use-excel-formulas-in-the-cells-indicated-below-in-yellow-for-calculat\/","title":{"rendered":"Compute the following ratios and show the answer to two digits past the decimal: (i) the current ratio, (ii) the acid-test ratio. Use Excel formulas in the cells indicated below in yellow for calculating your ratios."},"content":{"rendered":"
<\/span><\/p>\n

Discuss recruitment strategies with hiring managers.<\/h6>\n

October 1, 2018<\/span><\/p>\n

\n
\n
\n
\n
\n

Instructions<\/h2>\n\n\n\n
INSTRUCTIONS: Complete parts A and B of this exercise. Examples can be found in Chapter 21 of your textbook. Be sure to notice that Part A is a balance sheet and Part B is an income statement. Also, be sure to note that the most recent year is shown on the left in these financial statements. Formulas and examples for interpretation of results can be found in Table 21-1 of your textbook or the last worksheet tab of this file.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n

Part A \u2013 Balance sheet Analysis<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Part A \u2013 Chapter 21 in your textbook contains examples that will be helpful for completing the exercises below.<\/td>\n<\/tr>\n
1. Using Excel formulas, prepare a vertical analysis for 2017 for the balance sheet below (only use 2017).<\/td>\n<\/tr>\n
2. Using Excel formulas, prepare a horizontal analysis for the balance sheet below (use 2016 & 2017 \u2013 also note the order of the columns below).<\/td>\n<\/tr>\n
3. Compute the following ratios and show the answer to two digits past the decimal: (i) the current ratio, (ii) the acid-test ratio. Use Excel formulas in the cells indicated below in yellow for calculating your ratios. Formulas for this exercise are located on page 779 in your textbook or on the Table 21-1 tab in this Excel file.<\/td>\n<\/tr>\n
Current ratio:<\/td>\n<\/tr>\n
Acid-test ratio:<\/td>\n<\/tr>\n
4. Using Table 21-1, how would you interpret the current ratio result you computed above?<\/td>\n<\/tr>\n
5. Using Table 21-1, how would you interpret the acid-test ratio result you computed above?<\/td>\n<\/tr>\n
Green\u2019s Landscaping<\/td>\n<\/tr>\n
Balance Sheet<\/td>\n<\/tr>\n
December 31, 2016 and 2017<\/td>\n<\/tr>\n
2017<\/td>\n2016<\/td>\n<\/tr>\n
Assets<\/td>\n<\/tr>\n
Current Assets<\/td>\n<\/tr>\n
Cash<\/td>\n$5,275<\/td>\n$4,507<\/td>\n<\/tr>\n
Accounts receivable<\/td>\n7,305<\/td>\n5,118<\/td>\n<\/tr>\n
Merchandise inventory<\/td>\n45,522<\/td>\n48,722<\/td>\n<\/tr>\n
Total current assets<\/td>\n58,102<\/td>\n58,347<\/td>\n<\/tr>\n
Plant and equipment<\/td>\n<\/tr>\n
Equipment<\/td>\n20,173<\/td>\n25,942<\/td>\n<\/tr>\n
Total assets<\/td>\n78,275<\/td>\n84,289<\/td>\n<\/tr>\n
Liabilities<\/td>\n<\/tr>\n
Current liabilities<\/td>\n<\/tr>\n
Accounts payable<\/td>\n3,809<\/td>\n4,476<\/td>\n<\/tr>\n
Wages payable<\/td>\n2,432<\/td>\n1,973<\/td>\n<\/tr>\n
Total current liabilities<\/td>\n6,241<\/td>\n6,449<\/td>\n<\/tr>\n
Long-term liabilities<\/td>\n<\/tr>\n
Mortgage note payable<\/td>\n36,454<\/td>\n45,899<\/td>\n<\/tr>\n
Total liabilities<\/td>\n42,695<\/td>\n52,348<\/td>\n<\/tr>\n
Owner\u2019s Equity<\/td>\n<\/tr>\n
A. Green, capital<\/td>\n35,580<\/td>\n31,941<\/td>\n<\/tr>\n
Total liabilities and owner\u2019s equity<\/td>\n78,275<\/td>\n84,289<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n

Part B \u2013 Income Statement<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Part B \u2013 Chapter 21 in your textbook contains examples that will be helpful for completing the exercises below.<\/td>\n<\/tr>\n
1. Using the information below, prepare a vertical analysis for the income statement for 2017.<\/td>\n<\/tr>\n
2. Using the information below, prepare a horizontal analysis of the income statement from 2017.<\/td>\n<\/tr>\n
3. In which areas, if any, has the company seen increases since 2016?<\/td>\n<\/tr>\n
4. In which areas, if any, has the company seen decreases since 2016?<\/td>\n<\/tr>\n
5. Compute the following ratio and show the answer to two digits past the decimal. Use an Excel formula in the cell indicated below in yellow for calculating your ratio.<\/td>\n<\/tr>\n
Operating ratio:<\/td>\n<\/tr>\n
6. Using table 21-1, how would you interpret this ratio?<\/td>\n<\/tr>\n
Artie\u2019s Painting<\/td>\n<\/tr>\n
Income Statement<\/td>\n<\/tr>\n
For the Years Ending December 31, 2016 and 2017<\/td>\n<\/tr>\n
2017<\/td>\n2016<\/td>\n<\/tr>\n
Net sales<\/td>\n$24,789<\/td>\n$23,642<\/td>\n<\/tr>\n
Cost of goods sold<\/td>\n15,323<\/td>\n14,239<\/td>\n<\/tr>\n
Gross profit<\/td>\n9,466<\/td>\n9,403<\/td>\n<\/tr>\n
Operating expenses<\/td>\n3,873<\/td>\n3,702<\/td>\n<\/tr>\n
Net income<\/td>\n5,593<\/td>\n5,701<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n

Table 21-1 from Business Math<\/h2>\n\n\n\n
Cleaves, C., Hobbs, M., & Noble, J. (2017). Business Math (11th ed.). New York City, NY: Pearson Education, p.779.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00a0<\/p>\n

“PLACE THIS ORDER OR A SIMILAR ORDER WITH ESSAY PAPER LTD AND GET AN AMAZING DISCOUNT”<\/h4>\n

\"\"<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Discuss recruitment strategies with hiring managers. October 1, 2018 Instructions INSTRUCTIONS: Complete parts A and B of this exercise. Examples can be found in Chapter 21 of your textbook. Be sure to notice that Part A is a balance sheet Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[144,16,145,146],"tags":[],"class_list":["post-430946","post","type-post","status-publish","format-standard","hentry","category-academic-papers","category-academic-writing","category-academic-writing-service","category-academy-management-assignment-help"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/430946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=430946"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/430946\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=430946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=430946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=430946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}