(Ratio analysis) The financial statements and industry norms for Pamplin Inc. are shown in the popup...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(Ratio analysis) The financial statements and industry norms for Pamplin Inc. are shown in the popup window: a. Compute the ratios in the popup window, E. for 2017 and 2018 to compare both against the industry norms. b. How liquid is the firm? c. Are its managers generating an adequate operating profit on the firm's assets? d. How is the firm financing its assets? e. Are its managers generating a good return on equity? Note: 15% of sales are cash sales, with the remaining 85% being credit sales. a. Compute the following ratios for 2017 and 2018 to compare both against the industry norms. (Round the numbers to two decimal places and select your evaluation from the drop-down menu.) 2017 2018 Evaluation Industry Norm 5.00X X x Current ratio Poor KIED Pamplin Inc. Balance Sheet at 12/31/2017 and 12/31/2018 ASSETS Cash Accounts receivable Inventory Current assets Plant and equipment Less accumulated depreciation Net plant and equipment Total assets LIABILITIES AND OWNERS' EQUITY Accounts payable Notes payable current (9.00% interest) Current liabilities Bonds (8.33% interest) Total debt Owners' equity Common stock Paid-in capital Retained earnings Total owners' equity Total liabilities and owners' equity Sales (85% credit sales) Cost of goods sold Gross profit Operating expenses Depreciation $ 2,200 Operating profits Interest expense Profit before taxes Taxes (21%) Net Income (1,001) $ 35 221 $ 295 599 703 (Click on the following icon in order to copy its contents into a spreadsheet.) Pamplin Inc. Income Statement for Years Ending 12/31/2017 and 12/31/2018 2017 $ 1.201 696 $ 505 2017 $ 201 445 555 ||$ $ 1,201 $ $ 1.199 $ 2,400 $ 201 0 $ 201 602 $803 $ 1,597 $ 2,400 256 $ 249 54 195 41 154 $ 2,603 (1,201) $ 295 599 798 $ 42 200 2018 $150 428 621 $ 1,199 $ 1,402 $ 2,601 154 153 $ 307 $ $ 602 909 $ 1,692 $ 2.601 2018 $ 1,452 853 $599 I 242 357 295 $ 233 (Click on the following icon in order to copy its contents into a spreadsheet.) 2017 Industry Norm 5.00 3.00 2.20 90.00 33% Current ratio Acid-test (quick) ratio Inventory turnover Average collection period Debt ratio Times interest earned Total asset turnover Fixed asset turnover Operating profit margin Return on common equity 7.00 0.75 1.00 20.0% 9.0% 2018 its 120 TY rest) Pamplin Inc. Balance Sheet at 12/31/2017 and 12/31/2018 ASSETS Cash Accounts receivable Inventory Current assets Plant and equipment Less accumulated depreciation Net plant and equipment Total assets LIABILITIES AND OWNERS' EQUITY Accounts payable Notes payable current (9.00% interest) Current liabilities Bonds (8.33% interest) Total debt Owners' equity Common stock Paid-in capital Retained earnings Total owners' equity Total liabilities and owners' equity $ 2,200 (1,001) 295 599 703 2017 $ 201 445 555 $ 1,201 $ 1,199 $ 2,400 $ 201 0 $ 201 602 $ 803 $ 1,597 $ 2,400 opy its (Click on the following icon in order to copy its contents into a spreadsheet.) Endin $ 2,603 (1,201) 295 599 798 2018 $ 150 428 621 $ 1,199 $ 1,402 $ 2,601 $ 154 153 $ 307 602 $ 909 $ 1,692 $ 2,601 n QUITY (Click on the following icon in order to copy its contents into a spreadsheet.) Pamplin Inc. Income Statement for Years Ending 12/31/2017 and 12/31/2018 2017 ty Sales (85% credit sales) Cost of goods sold Gross profit Operating expenses Depreciation interest) Operating profits Interest expense Profit before taxes Taxes (21%) Net income $ 35 221 $ 1,201 696 $ 505 256 $ 249 54 $ $ 195 41 154 $ 42 200 2018 $ 1,452 853 $ 599 ****** 27 242 $ 357 $ 295 $ 233 (Click on the following icon in order to copy its contents into a spreadsheet.) 2017 Industry Norm 5.00 3.00 2.20 90.00 33% 7.00 0.75 1.00 20.0% 9.0% Current ratio Acid-test (quick) ratio Inventory turnover Average collection period Debt ratio Times interest earned Total asset turnover Fixed asset turnover Operating profit margin Return on common equity 2018 (Ratio analysis) The financial statements and industry norms for Pamplin Inc. are shown in the popup window: a. Compute the ratios in the popup window, E. for 2017 and 2018 to compare both against the industry norms. b. How liquid is the firm? c. Are its managers generating an adequate operating profit on the firm's assets? d. How is the firm financing its assets? e. Are its managers generating a good return on equity? Note: 15% of sales are cash sales, with the remaining 85% being credit sales. a. Compute the following ratios for 2017 and 2018 to compare both against the industry norms. (Round the numbers to two decimal places and select your evaluation from the drop-down menu.) 2017 2018 Evaluation Industry Norm 5.00X X x Current ratio Poor KIED Pamplin Inc. Balance Sheet at 12/31/2017 and 12/31/2018 ASSETS Cash Accounts receivable Inventory Current assets Plant and equipment Less accumulated depreciation Net plant and equipment Total assets LIABILITIES AND OWNERS' EQUITY Accounts payable Notes payable current (9.00% interest) Current liabilities Bonds (8.33% interest) Total debt Owners' equity Common stock Paid-in capital Retained earnings Total owners' equity Total liabilities and owners' equity Sales (85% credit sales) Cost of goods sold Gross profit Operating expenses Depreciation $ 2,200 Operating profits Interest expense Profit before taxes Taxes (21%) Net Income (1,001) $ 35 221 $ 295 599 703 (Click on the following icon in order to copy its contents into a spreadsheet.) Pamplin Inc. Income Statement for Years Ending 12/31/2017 and 12/31/2018 2017 $ 1.201 696 $ 505 2017 $ 201 445 555 ||$ $ 1,201 $ $ 1.199 $ 2,400 $ 201 0 $ 201 602 $803 $ 1,597 $ 2,400 256 $ 249 54 195 41 154 $ 2,603 (1,201) $ 295 599 798 $ 42 200 2018 $150 428 621 $ 1,199 $ 1,402 $ 2,601 154 153 $ 307 $ $ 602 909 $ 1,692 $ 2.601 2018 $ 1,452 853 $599 I 242 357 295 $ 233 (Click on the following icon in order to copy its contents into a spreadsheet.) 2017 Industry Norm 5.00 3.00 2.20 90.00 33% Current ratio Acid-test (quick) ratio Inventory turnover Average collection period Debt ratio Times interest earned Total asset turnover Fixed asset turnover Operating profit margin Return on common equity 7.00 0.75 1.00 20.0% 9.0% 2018 its 120 TY rest) Pamplin Inc. Balance Sheet at 12/31/2017 and 12/31/2018 ASSETS Cash Accounts receivable Inventory Current assets Plant and equipment Less accumulated depreciation Net plant and equipment Total assets LIABILITIES AND OWNERS' EQUITY Accounts payable Notes payable current (9.00% interest) Current liabilities Bonds (8.33% interest) Total debt Owners' equity Common stock Paid-in capital Retained earnings Total owners' equity Total liabilities and owners' equity $ 2,200 (1,001) 295 599 703 2017 $ 201 445 555 $ 1,201 $ 1,199 $ 2,400 $ 201 0 $ 201 602 $ 803 $ 1,597 $ 2,400 opy its (Click on the following icon in order to copy its contents into a spreadsheet.) Endin $ 2,603 (1,201) 295 599 798 2018 $ 150 428 621 $ 1,199 $ 1,402 $ 2,601 $ 154 153 $ 307 602 $ 909 $ 1,692 $ 2,601 n QUITY (Click on the following icon in order to copy its contents into a spreadsheet.) Pamplin Inc. Income Statement for Years Ending 12/31/2017 and 12/31/2018 2017 ty Sales (85% credit sales) Cost of goods sold Gross profit Operating expenses Depreciation interest) Operating profits Interest expense Profit before taxes Taxes (21%) Net income $ 35 221 $ 1,201 696 $ 505 256 $ 249 54 $ $ 195 41 154 $ 42 200 2018 $ 1,452 853 $ 599 ****** 27 242 $ 357 $ 295 $ 233 (Click on the following icon in order to copy its contents into a spreadsheet.) 2017 Industry Norm 5.00 3.00 2.20 90.00 33% 7.00 0.75 1.00 20.0% 9.0% Current ratio Acid-test (quick) ratio Inventory turnover Average collection period Debt ratio Times interest earned Total asset turnover Fixed asset turnover Operating profit margin Return on common equity 2018
Expert Answer:
Related Book For
Probability & Statistics for Engineers & Scientists
ISBN: 978-0130415295
7th Edition
Authors: Ronald E. Walpole, Raymond H. Myers, Sharon L. Myers, Keying
Posted Date:
Students also viewed these finance questions
-
The following data represent the number of hours that two different types of scientific pocket calculators operate before a recharge: is required. Use the rank-sum test with ? = 0.01 to determine if...
-
The data shown here represent the number of hours that 12 part-time employees at a toy store worked during the weeks before and after Christmas. Construct two boxplots and compare the distributions....
-
The following data show the number of hours per day 12 adults spent in front of screens watching television related content: 1.3 4.9 4.2 4.8 7.6 6.9 5.4 2.2 5.3 1.8 2.4 8.3 a. Construct a 95%...
-
In Exercises 1114, graph each equation in a rectangular coordinate system. If two functions are indicated, graph both in the same system. Then use your graphs to identify each relations domain and...
-
The HR department acts as an internal service provider, helping various divisions throughout the company with hiring, benefits, training, and other employment functions. An HR rep is assigned to each...
-
Regardless of the sport, the owners of professional sports teams are local monopolists. Many people argue that increasing attendance (and revenue) at sporting events should be a key objective of any...
-
Using the data in question 4, Department Xs contribution to overhead as a percentage of sales is a. 20%. c. 12%. e. 32%. b. 30%. d. 48%. Data From Question 4 A company operates three retail...
-
Operating data for Jacobs Corporation are presented below. Instructions Prepare a schedule showing a vertical analysis for 2014 and 2013. 2014 2013 Sales revenue Cost of goods sold Selling expenses...
-
quick question are they same " the function of database management system and the characteristics of database management system? explain maintaining data integrity and give simple explanation to...
-
For each item listed in the table below, input the balance for the date range 10/1/20XX to 12/1/20XX. For the Journal, input the balance for the date range 11/13/20XX to 12/1/20XX. Note: Enter your...
-
When establishing budgets for a company, the starting point is: A.The cash budget B.The production budget C.The direct materials budget D. The sales budget
-
Demonstrate the concept of Threads to achieve multitasking program using Thread class and Runnable Interface (separately) for the below scenario: Create an Array of 9 numbers. And create three...
-
!)A hotel wants to remodel and gets a loan for $344,546.2 today but will owe $420,000 at the maturity date. the rate of interest is 8% compounded quarterly. How long is the loan. ________ ...
-
A large office building is being designed to house manydifferent sized businesses. They have several floor plansavailable. Each plan has 3 types of office suites: small, medium,and large. Floor plan...
-
On June 21 of this year, $4,000 is deposited in a bank that pays 30% simple annual, determine the accumulated amount as of December 15 of the same year.
-
Twelve cakes are entered in a cake contest. Judges select the best tasting, the best decorated, and the most unusual cakes. How many ways can the cakes be selected (a) if the three cakes must be...
-
Discuss the key barriers to small business internationalization. What recommendations would you make to small businesses in overcoming these barriers? What challenges do you think small businesses...
-
The registrar of a college with a population of N = 4,000 full-time students is asked by the president to conduct a survey to measure satisfaction with the quality of life on campus. The following...
-
Suppose it is not known in Exercise 11.35 whether the true regression should pass through the origin. Estimate the linear model y׀x = a + x and test the hypothesis that = 0 at the 0.10 level of...
-
An electron, trapped in a one-dimensional infinite potential well 250 pm wide, is in its ground state. How much energy must it absorb if it is to jump up to the state with n = 4?
-
Let X have the probability distribution show that the random variable Y = ?2 In A' has a chi-squared distribution with 2 degrees of freedom. 1. 0
-
Why do you and your business need to be able to communicate well?
-
What are the basic criteria for effective messages?
-
What are the questions for analyzing a business communication situation?
Study smarter with the SolutionInn App