Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Hatfield medical supplies mini case

28/12/2020 Client: saad24vbs Deadline: 3 days

1. Mini Case

11/21/18

Chapter 12 Mini Case

Hatfield Medical Supply’s stock price had been lagging its industry averages, so its board of directors brought in a new CEO, Jaiden Lee. Lee had brought in Ashley Novak, a finance MBA who had been working for a consulting company, to replace the old CFO, and Lee asked Ashley to develop the financial planning section of the strategic plan. In her previous job, Novak’s primary task had been to help clients develop financial forecasts, and that was one reason Lee hired her.

Novak began as she always did, by comparing Hatfield’s financial ratios to the industry averages. If any ratio was substandard, she discussed it with the responsible manager to see what could be done to improve the situation. The following data shows Hatfield’s latest financial statements plus some ratios and other data that Novak plans to use in her analysis.

Hatfield Medical Supply: Balance Sheet (Millions of Dollars), December 31 Hatfield Medical Supply: Income Statement (Millions of Dollars Except per Share)

2018 2018

Cash $90 Sales $9,000.9

Accts. rec. 1,260 Op. costs (excl. depr.) 8,100.9

Inventories 1,440 Depreciation 360.0

Total CA $2,790 EBIT $540.0

Net fixed assets 3,600 Interest 144.0

Total assets $6,390 Pretax earnings $396.0

Taxes (25%) 99.0

Accts. pay. & accruals $1,620 Net income $297.0

Line of credit 0

Total CL $1,620 Dividends $100

Long-term debt 1,800 Add. to RE $197

Total liabilities $3,420 Common shares 50

Common stock 2,100 EPS $5.94

Retained earnings 870 DPS $2.00

Total common equ. $2,970 Ending stock price $41.00

Total liab. & equity $6,390

Selected Ratios, Calculations, and Other Data, 2018

Operating Ratios and Data Hatfield Industry Other Ratios Hatfield Industry

(Op. costs)/Sales 90% 88% Profit margin (M) 3.30% 5.60%

Depr./FA 10% 12% Return on assets (ROA) 4.6% 9.5%

Cash/Sales 1% 1% Return on equity (ROE) 10.0% 15.1%

Receivables/Sales 14% 11% Sales/Assets 1.41 1.69

Inventories/Sales 16% 15% Asset/Equity 2.15 1.59

Fixed assets/Sales 40% 32% Debt/TA 28.2% 16.9%

(Acc. pay. & accr.)/Sales 18% 12% (Total liabilities)/(Total assets) 53.5% 37.3%

Tax rate 25% 25% Times interest earned 3.8 11.7

Target WACC 10% 11% P/E ratio 6.9 16.0

Interest rate on debt 8% 7% OP ratio: NOPAT/Sales 4.5% 6.1%

CR ratio: (Total op. capital)/Sales 53.0% 47.0%

ROIC 8.5% 13.0%

a. Using Hatfield’s data and its industry averages, how well run would you say Hatfield appears to be in comparison with other firms in its industry? What are its primary strengths and weaknesses? Be specific in your answer, and point to various ratios that support your position. Also, use the DuPont equation (see Chapter 3) as one part of your analysis.

Hatfield has lower operating profitability as shown by operating profitability (OP) ratio: 4.5% vs. 6.1%. Hatfield utilizes operating capital less efficiently, as shown by capital requirement (CR) ratio: 53% vs. 47%. As a consequence, Hatfield has a lower ROIC: 8.5% vs. 13%. In fact, Hatfield’s ROIC is less than its 10% WACC.

The debt/TA ratio and the TL/TA ratio indicate that Hatfield has more leverage than its industry competitors. The combination of higher interest payments and lower operating profitability cause Hatfield's times interest earned ratio to be much lower than the industry average.

Du Pont ROE M x Sales/Assets x Assets/Equity = ROE

Hatfield 3.30% 1.41 2.15 = 10.0%

Industry 5.60% 1.69 1.59 = 15.1%

The DuPont analysis confirms the conclusions.

b. Use the AFN equation to estimate Hatfield’s required new external capital for 2019 if the sale growth rate is 11.1%. Assume that the firm’s 2018 ratios will remain the same in 2019. (Hint: Hatfield was operating at full capacity in 2018.)

Data for AFN Method

Growth rate in sales (g) 11.1%

Sales (S0) $9,001

Required assets (A0*) $6,390

Spontaneous liabilities (L0*) $1,620

Forecasted sales (S1) $10,000

Increase in sales (ΔS = gS0) $999

Profit margin (M) 3.30%

Assets/Sales (A0*/S0) 71.0%

Payout ratio (POR) 33.7%

Spont. Liab./Sales (L0*/S0) 18.0%

AFNHatfield = Required increase in assets − Increase in spontaneous liabilities − Increase in retained earnings

= (A0*/S0)∆S − (L0*/S0)∆S − M ×S1 × (1–POR)

= (0.7099)(999.1) − (0.18)(999.1) − (0.033)(10000)(0.6633)

= $709.3 − $179.8 − $218.9

AFNHatfield = $310.60 million

c. Define the term capital intensity. Explain how a decline in capital intensity would affect the AFN, other things held constant. Would economies of scale combined with rapid growth affect capital intensity, other things held constant? Also, explain how changes in each of the following would affect AFN, holding other things constant: the growth rate, the amount of accounts payable, the profit margin, and the payout ratio. Answer: See PowerPoint Show

d. Define the term self-supporting growth rate. What is Hatfield’s self-supporting growth rate? Would the self-supporting growth rate be affected by a change in the capital intensity ratio or the other factors mentioned in the previous question? Other things held constant, would the calculated capital intensity ratio change over time if the company were growing and were also subject to economies of scale and/or lumpy assets? Answer: See PowerPoint Show

Self-Supporting Growth Rate. This is the maximum growth rate that can be attained without raising external funds, i.e., the value of g that forces AFN = 0, holding other things constant. We found this rate, ith Excel's Goal Seek function and also algebraically, as explained below.

1. Using algebra. The self-supporting growth rate can also be found by setting the AFN equation to zero and then solving for g.

M(1 – POR)(S0)

Self-Supporting g = = ───────────────────────

A0* – L0* – M(1 – POR)S0

M = 3.30% 3 3.300%

POR = 33.7% 3 33.700%

1-POR = 66.3% 66.300%

S0 = $9,000.9 0 $9,001.0

A* = $6,390 0 $6,390.0

L* = $1,620 0 $1,620.0

M(1 – POR)(S0) $197.00

Self-Supporting g = ─────────────────── = ──────── = 4.3%

A0* – L0* – M(1 – POR)S0 $4,573.00

2. Using Goal Seek. To find the self-supporting growth rate with Goal Seek, select Data, What-If Analysis, and Goal Seek; then choose cell with the AFN (B96) as the value for the "Set Cell" area of the Goal Seek dialog box, choose 0 as the value for the "To Value" area of the dialog box, and choose the cell with the growth rate (C54) as the value for the "By Changing Cell" area of the dialog box. Then hit OK.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Helping Hand
Top Essay Tutor
Homework Guru
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$77 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$75 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$80 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$77 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Internet Marketing - New belgium brewing case study - Levinson's theory of life structure - Genesis 21 commentary david guzik - Left lower lobe collapse sail sign - Hospital giant ds rom - Merck & co inc case analysis - A disk with an initial angular velocity - Psychology Paper due 10/06/2020 - Blackbody spectrum sim homework answers - Privilege power and difference chapter 6 summary - When is elizabethan era - Evaluate own working relationship with colleagues - Study Guide questions for Pollan’s Th e B o tan y o f De s ire : A Plan t’s -Ey e Vie w o f th e Wo rld 1. In his Introduction, Pollan argues that the things that we cultivate and create become our co-creators, so that we are co-evolving with the things we desire. This makes desire a part of our human natural history as well as a part of natural history. How does Pollan support these ideas? Does the analogy that bees are to flowers as people are to potatoes make sense? How do dogs and Darwin fit into his main ideas? How is his thinking different from an anthropocentric point of view? {Please look up: anthropocentric and Darwin’s The Origin of Species if these are not familiar to you!} 2. Considering Chapter 1, according to Pollan, how does the story of “Johnny Appleseed,” a.k.a. John Chapman, fit into this picture of plants using humans to achieve their ends? Why does Pollan care so much about Chapman the man and the myth of “Johnny Appleseed,”? What do we really know about Chapm - Geoforum journal impact factor - What did gottfried leibniz do for math - Unit 8 Public administration assignment - Vosa public inquiry decisions - Why was heck worried about the old sarum bunch - Homework by allen ginsberg analysis - Army training camp pirbright - The madoff affair discussion questions answers - How do you divide a whole number by a decimal - Mini Research Paper - Help - Apa essay - Christology from above - Research paper on blockchain - Design a bridge worksheet - Benefits of wearing casual clothes to school - Cox sports pak channel list - Summarize the key challenges faced in training expatriate managers - Polycom 2457 64356 001 - Honorary president job description - Business Intelligence - 29-41 william street alexandria - Law extension committee past exam papers - Www kidsastronomy com solar system htm - Asap lss - Discussion - Short essay- Nannie Doss - Eutectic point of naphthalene biphenyl system - Empire aggressor 390 crossbow review - Shrek the musical this is our story - Week 4 Journal Article Analysis - Microsoft project 2013, gregg richie - Ask save myloc to help me - Discussion Board - 3rs reduce reuse recycle ppt - Stand alone utility programs - A company reports net accounts receivable of - The competitive power of a company resource depends on - Exclusive sales agency agreement nsw - Physics 12 circular motion worksheet 2 answers - Coraline chapter 4 summary - Interpreting a food web worksheet answers environmental science - A scratch list for a message is - Megt trade support loan - The family crucible chapter summary - A-5 - Complete mathematics for cambridge igcse answers - Find the order of each of the following permutations 14 - Examination of Health Care Laws - Dialectical behavior therapy ppt - Coriolis effect lab activity - How is atomic radius measured - Independent groups design advantages - Macroeconomic analysis - How many janitors per square foot - Carolina windom 40 plus - Harlequin enterprises the mira decision case study - Flash gordon villain crossword clue - Xian janssen pharmaceutical china and the euro - The gambler who blew $127 million - Three ancient arts of discourse - General Biology - Importance of Auction Essay - Online book week activities - Robbers cave experiment criticism - Example of solid liquid and gas - First cirque du soleil show 1984 - Module 05: One-Pager Assignment - Ocr nationals ict level 2 - Kulai preschool aboriginal corporation - Alyeska services company a division of a major oil company - Optiplex 745 ultra small - Characteristics of international financial markets - Chapter 3 nazism and the rise of hitler - Jk rowling 2008 harvard speech transcript - First fleet convicts database - Finance Paper - Lash and brow boudoir 204 church st richmond vic 3121 - Case study one - Develop workplace policy and procedures for sustainability assessment 1 - Accutronics reverb tank codes - Read the summary and response - Discussion - Four types of market structure - Laying egger laminate flooring - What does task interdependence mean in regards to slack