Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Financial analysis) The T. P. Jarmon Company manufactures and sells a line of exclusive sportswear. The firm's sales were 5605,000 for the year just ended,

image text in transcribedimage text in transcribedimage text in transcribed

(Financial analysis) The T. P. Jarmon Company manufactures and sells a line of exclusive sportswear. The firm's sales were 5605,000 for the year just ended, and its total assets was $407,730. The company was started by Mr. Jarmon just 10 years ago and has been profitable every year since its inception. The chief financial officer for the firm, Brent Vehlim, has decided to seek a line of credit totaling $85,000 from the firm's bank. In the past, the company has relied on its suppliers to finance a large part of its needs for inventory. However, in recent months tight money conditions have led the firm's suppliers to offer sizable cash discounts to speed up payments for purchases. Mr. Vehlim wants to use the line of credit to replace a large portion of the firm's payables during the summer, which is the firm's peak seasonal sales period. The firm's two most recent balance sheets were presented to the bank in support of its loan request. In addition, the firm's income statement for the year just ended was provided. These statements are found in the popup window. Mike Ameen, associate credit analyst for the Merchants National Bank of Midland, Michigan, was assigned the task of analyzing Jarmon's loan request. a. Calculate the financial ratios for 2018 corresponding to the industry norms provided in the popup window: b. Which of the ratios reported in the industry norms do you feel should be most crucial in determining whether the bank should extend the line of credit? c. Prepare Jarmon's statement of cash flow for the year ended December 31, 2018. d. Use the information provided by the financial ratios and the cash flow statement to decide if you would support making the loan T.P. Jarmon Company, Balance Sheet for 12/31/2017 and 12/31/2018 ASSETS 2017 2018 Cash $ 15,000 $ 13,990 Marketable securities 6,000 6,160 Accounts receivable 42,000 32,910 Inventory 51,000 83,500 Prepaid rent 1,200 1,070 Total current assets $ 115,200 $ 137,630 Net plant and equipment 286,000 270,100 $ 401,200 $ 407,730 Total assets LIABILITIES AND OWNERS' EQUITY Accounts payable $ 48,000 $ 57,060 Notes payable 15,000 12,950 Accruals 6,000 4,920 Total current liabilities $ 69,000 $ 74,930 Long-term debt 160,000 136,884 Common stockholders' equity 172,200 195,916 $ Total liabilities and equity 401,200 $ 407,730 $ $ T.P. Jarmon Company, Income Statement for the Year Ended 12/31/2018 Sales (all credit) 605,000 Less cost of goods sold 464,000 Gross profit 141,000 Less operating and interest expenses General and administrative 29,800 Interest 10,900 Depreciation 29,900 Total $ 70,600 Earnings before taxes $ 70,400 Less taxes 14,784 Net income available to common stockholders $ 55,616 Less cash dividends 31,900 $ 23,716 Change in retained earnings NORM RATIO Current ratio Acid-test ratio Debt ratio Times interest earned Average collection period Inventory turnover (based on cost of goods sold) Return on common equity Operating return on assets Operating profit margin Total asset turnover Fixed asset turnover 1.80 0.90 0.47 9.00 19.00 7.08 17.0% 17.1% 14.1% 1.20 1.80 (Financial analysis) The T. P. Jarmon Company manufactures and sells a line of exclusive sportswear. The firm's sales were 5605,000 for the year just ended, and its total assets was $407,730. The company was started by Mr. Jarmon just 10 years ago and has been profitable every year since its inception. The chief financial officer for the firm, Brent Vehlim, has decided to seek a line of credit totaling $85,000 from the firm's bank. In the past, the company has relied on its suppliers to finance a large part of its needs for inventory. However, in recent months tight money conditions have led the firm's suppliers to offer sizable cash discounts to speed up payments for purchases. Mr. Vehlim wants to use the line of credit to replace a large portion of the firm's payables during the summer, which is the firm's peak seasonal sales period. The firm's two most recent balance sheets were presented to the bank in support of its loan request. In addition, the firm's income statement for the year just ended was provided. These statements are found in the popup window. Mike Ameen, associate credit analyst for the Merchants National Bank of Midland, Michigan, was assigned the task of analyzing Jarmon's loan request. a. Calculate the financial ratios for 2018 corresponding to the industry norms provided in the popup window: b. Which of the ratios reported in the industry norms do you feel should be most crucial in determining whether the bank should extend the line of credit? c. Prepare Jarmon's statement of cash flow for the year ended December 31, 2018. d. Use the information provided by the financial ratios and the cash flow statement to decide if you would support making the loan T.P. Jarmon Company, Balance Sheet for 12/31/2017 and 12/31/2018 ASSETS 2017 2018 Cash $ 15,000 $ 13,990 Marketable securities 6,000 6,160 Accounts receivable 42,000 32,910 Inventory 51,000 83,500 Prepaid rent 1,200 1,070 Total current assets $ 115,200 $ 137,630 Net plant and equipment 286,000 270,100 $ 401,200 $ 407,730 Total assets LIABILITIES AND OWNERS' EQUITY Accounts payable $ 48,000 $ 57,060 Notes payable 15,000 12,950 Accruals 6,000 4,920 Total current liabilities $ 69,000 $ 74,930 Long-term debt 160,000 136,884 Common stockholders' equity 172,200 195,916 $ Total liabilities and equity 401,200 $ 407,730 $ $ T.P. Jarmon Company, Income Statement for the Year Ended 12/31/2018 Sales (all credit) 605,000 Less cost of goods sold 464,000 Gross profit 141,000 Less operating and interest expenses General and administrative 29,800 Interest 10,900 Depreciation 29,900 Total $ 70,600 Earnings before taxes $ 70,400 Less taxes 14,784 Net income available to common stockholders $ 55,616 Less cash dividends 31,900 $ 23,716 Change in retained earnings NORM RATIO Current ratio Acid-test ratio Debt ratio Times interest earned Average collection period Inventory turnover (based on cost of goods sold) Return on common equity Operating return on assets Operating profit margin Total asset turnover Fixed asset turnover 1.80 0.90 0.47 9.00 19.00 7.08 17.0% 17.1% 14.1% 1.20 1.80

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Handbook Of Fixed Income Securities

Authors: Frank Fabozzi, Steven Mann

8th Edition

0071768467, 978-0071768467

More Books

Students also viewed these Finance questions

Question

What is the preferred personality?

Answered: 1 week ago

Question

What is the relationship between humans?

Answered: 1 week ago