RPI, Inc. Income Statement For the Year Ended 12/31/2019 Sales (all credit) Less: Cost of goods...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
RPI, Inc. Income Statement For the Year Ended 12/31/2019 Sales (all credit) Less: Cost of goods sold Gross profits Less: Operating and interest expenses General and administrative $700,000 500,000 $200,000 $50,000 Depreciation Total 30,000 80.000 $120,000 10,000 $110,000 Profit beforc Interest and taxes (EBIT) Less: Interest Profit before taxes Less: Taxcs 27.100 Net income available S82.900 to common stockholderS Less: Cash dividends 31.800 $51,100 Change in retained earnings Liabilities and Stockholders' Equity 2018 $48,000 16,000 6,000 $70,000 $160,000 $172.200 $402.200 2019 $55,000 13,000 5,000 $73.000 $150,000 $223,300 $446,300 Accounts payable Notes payable Accruals Total current liabilities Long-term debt Common stockholders' equity Total liabilities and equity marks) RPI, Inc. is a manufacturer and retailer of high-quality sports clothing and gear. The firm was started several years ago by a group of serious outdoor enthusiasts who felt there was a need for a firm that could provide quality products at reasonable prices. The result was RPI, Inc. Since its inception, the firm has been profitable with sales that last year totaled $700,000 and assets in excess of $400,000. The firm now finds its growing sales outstrip its ability to finance its inventory needs. The firm now estimates that it will need a line of credit of $100,000 during the coming year. To finance this funding requirement, the management plans to seek a line of credit with its bank. The firm's most recent financial statements were provided to its bank as support for the firm's loan request. Joanne Peebie, a loan analyst trainee for the Morristown Bank and Trust, has been assigned the task of analyzing the firm's loan request. RPI, Inc. Balance Sheets for 12/31/18 and 12/31/19 Assets 2018 2019 Cash $16,000 7.000 $17,000 7,200 38,000 93,000 Marketable securities Accounts receivable Inventory Prepaid rent Total current assets Net plant and cquipment Total assets 42,000 50,000 1.200 $116.200 286.000 $402.200 1.100 $156.300 290.000 $446.300 a. Calculate the financial ratios for 2019 corresponding to the industry norms provided below: (13 Marks) Ratio Norm Current ratio 1.80 Acıd-test ratio 0.90 Debt ratio 0.50 Long-term debt to total capitalization 0.70 Times interest earned 10.00 Average collection period Inventory turnover (based on COGS) Return on total assets 20.00 7.00 8.40% Gross profit margin Operating income return on investment Operating profit margin Total asset turnover Fixed asset turnover 25.0% 16.8% 14.0% 1.20 1.80 b. Which of the ratios reported above in the industry norms do you feel should be most crucial in determining whether the bank should extend the line of credit? Why? (4 Marks) c. Use the information provided by the financial ratios to decide if you would support making the loan. (3 Marks) RPI, Inc. Income Statement For the Year Ended 12/31/2019 Sales (all credit) Less: Cost of goods sold Gross profits Less: Operating and interest expenses General and administrative $700,000 500,000 $200,000 $50,000 Depreciation Total 30,000 80.000 $120,000 10,000 $110,000 Profit beforc Interest and taxes (EBIT) Less: Interest Profit before taxes Less: Taxcs 27.100 Net income available S82.900 to common stockholderS Less: Cash dividends 31.800 $51,100 Change in retained earnings Liabilities and Stockholders' Equity 2018 $48,000 16,000 6,000 $70,000 $160,000 $172.200 $402.200 2019 $55,000 13,000 5,000 $73.000 $150,000 $223,300 $446,300 Accounts payable Notes payable Accruals Total current liabilities Long-term debt Common stockholders' equity Total liabilities and equity marks) RPI, Inc. is a manufacturer and retailer of high-quality sports clothing and gear. The firm was started several years ago by a group of serious outdoor enthusiasts who felt there was a need for a firm that could provide quality products at reasonable prices. The result was RPI, Inc. Since its inception, the firm has been profitable with sales that last year totaled $700,000 and assets in excess of $400,000. The firm now finds its growing sales outstrip its ability to finance its inventory needs. The firm now estimates that it will need a line of credit of $100,000 during the coming year. To finance this funding requirement, the management plans to seek a line of credit with its bank. The firm's most recent financial statements were provided to its bank as support for the firm's loan request. Joanne Peebie, a loan analyst trainee for the Morristown Bank and Trust, has been assigned the task of analyzing the firm's loan request. RPI, Inc. Balance Sheets for 12/31/18 and 12/31/19 Assets 2018 2019 Cash $16,000 7.000 $17,000 7,200 38,000 93,000 Marketable securities Accounts receivable Inventory Prepaid rent Total current assets Net plant and cquipment Total assets 42,000 50,000 1.200 $116.200 286.000 $402.200 1.100 $156.300 290.000 $446.300 a. Calculate the financial ratios for 2019 corresponding to the industry norms provided below: (13 Marks) Ratio Norm Current ratio 1.80 Acıd-test ratio 0.90 Debt ratio 0.50 Long-term debt to total capitalization 0.70 Times interest earned 10.00 Average collection period Inventory turnover (based on COGS) Return on total assets 20.00 7.00 8.40% Gross profit margin Operating income return on investment Operating profit margin Total asset turnover Fixed asset turnover 25.0% 16.8% 14.0% 1.20 1.80 b. Which of the ratios reported above in the industry norms do you feel should be most crucial in determining whether the bank should extend the line of credit? Why? (4 Marks) c. Use the information provided by the financial ratios to decide if you would support making the loan. (3 Marks)
Expert Answer:
Related Book For
Principles of Accounting
ISBN: 978-1133626985
12th edition
Authors: Belverd E. Needles, Marian Powers and Susan V. Crosson
Posted Date:
Students also viewed these accounting questions
-
The condensed single-step income statement for the year ended December 31, 2014, of Conti Chemical Company, a distributor of farm fertilizers and herbicides, follows. Selected accounts from Conti...
-
The condensed single-step income statement for the year ended December 31, 20Ã9, of Sunderland Chemical Company, a distributor of farm fertilizers and herbicides, appears as follows: Selected...
-
the olive corporation income statement for the year ended december 31, 2019 gross income from operations$270,000 qualified dividends received from a 35 percentowned domestic corporation20,000 total...
-
Select the best answer. 1. A local chapter of the Society for Protection of the Environment beneted from the voluntary services of two attorneys. One served as a member of the Society's board of...
-
Suppose the United States and Japan have a flexible exchange rate system. Explain whether each of the following events will lead to an appreciation or depreciation of the U.S. dollar and Japanese...
-
What is the post-purchase stage? And how significant is it in marketing strategies?
-
Explain with the help of neat sketches, the working of four stroke diesel engine.
-
In two paragraphs, describe some techniques Ryan could use to help identify internal and external duplicates in his companys marketing database. Describe how you would build a marketing database to...
-
10.) How many iterations will the following loop execute? int intIndex = 100; while (int Index < 10) Console.WriteLine ("hello"); int Index += 1;
-
The 450-room Hotel Fernando is a four-star full-service hotel in San Petresco. It is highly regarded among both locals and tourists. Its service standards and ameni- ties complement its exquisite...
-
Jenner Pharmaceuticals - Revenue Breakdown 45%- 40% 35%- 30%+ 25% 20% 15%- 10%- 25% 25% 5%+ 0% Advertising 40% -34%- Salaries 12.5% 2002 10% Training -8.5% 10% Overheads 2003 20% 15% Profit In 2002,...
-
Complete a written analysis of leadership within the film (use the topics you have covered in your readings, assignments. (100 POINTS) This assignment provides the opportunity to synthesize your...
-
Check the articles that talk about (possible shift) in Boeing's Operations Strategy. You are more than welcome to find more in the same alignment. Your main job is to try to compare and contrast. How...
-
Gender schema indicates that we are influenced by society's ideas about what it means to be a male or female in the culture(s) in which we are a part of. Thus, it can be thought of as an organized...
-
Adult children who take care of their aging parent(s) should not do so alone, the adult child needs support as well. The article attached discusses how siblings should work together to care for their...
-
Technological progress results in firms experiencing an ongoing state of change. Using a change model of your choice , describe how you would advise M&Co to manage the ongoing changes associated with...
-
You want to buy your dream car which will cost you $5100. If you could invest your entire savings of $4000 at an annual interest of 11%, how long (in years rounded to two decimal places) would you...
-
The following data are supplied for the common stocks of Nikola Corporation, Tesla, Inc. and General Motors: Nikola Corp (NKLA) Tesla Inc. (TSLA) Close Price ($) Close Price ($) 67.53 30.00 40.81...
-
Arcadia Company, a small retail bookstore, has experienced losses of inventory over the past year. Jason Arcadia, the owner, on the advice of his accountant, has adopted a set of internal controls in...
-
Four conditions must be met before revenue should be recognized. In each of the following cases, tell which condition has not been met: a. Company Alpha accepts a contract to perform services in the...
-
Using 2012 as the base year, prepare a trend analysis for the data that follow, and tell whether the results suggest a favorable or unfavorable trend. (Round to one decimalplace.) 2014 $316,000 2013...
-
(a) Is the magnitude of the gravitational force exerted by Earth on a ball greater than, equal to, or smaller than the magnitude of the gravitational force exerted by the ball on Earth? (b) Is the...
-
Two objects 1 and 2, of mass \(m_{1}\) and \(m_{2}\), are released from rest far from Earth, at a location where the magnitude of the acceleration due to gravity is much less than \(g=9.8 \mathrm{~m}...
-
A communications satellite orbits \(1.4 \times 10^{7} \mathrm{~m}\) from Earth's center, at a location where the magnitude of Earth's gravitational field is \(2.0 \mathrm{~N} / \mathrm{kg}\). (a) If...
Study smarter with the SolutionInn App