Question

In: Finance

INSTRUCTIONS for the Case Analysis: 1. Read the case below and answer ALL the questions which...

INSTRUCTIONS for the Case Analysis:

1. Read the case below and answer ALL the questions which follow.

2. Your answers may be entered using a Microsoft Excel spreadsheet OR may be entered in a table format using Microsoft Word.

HEALTHY OPTIONS INC.

Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000 and falls within a MARCS depreciation of 5 years, and is expected to have a scrap value of $200,000 at the end of the project. Other than the equipment, the company needs to increase its cash and cash equivalents by $100,000, increase the level of inventory by $30,000, increase accounts receivable by $250,000 and increase accounts payable by $50,000 at the beginning of the project. Healthy Options expects the project to have a life of five years. The company would have to pay for transportation and installation of the equipment which has an invoice price of $450,000.

The company has already invested $75,000 in Research and Development and therefore expects a positive impact on the demand for the new product line. Expected annual sales for the ECG machines in years one to three are $1,200,000, and $850,000 in the following two years. The variable costs of production are projected to be $267,000 per year in years one to three and $375,000 in years four and five. Fixed overhead is $180,000 per year over the life of the project.

The introduction of the new line of portable ECG machines will cause a net decrease of $50,000 in profit contribution after taxes, due to a decrease in sales of the other lines of tester machines produced by the company. By investing in the new product line Healthy Options would have to use a packaging machine which the company already has and which will be sold at the end of the project for $350,000 after-tax in the equipment market.

The company’s financial analyst has advised Healthy Options to use the weighted average cost of capital as the appropriate discount rate to evaluate the project. Information about the company’s sources of financing is provided below:

• The company will contract a new loan in the sum of $2,000,000 that is secured by machinery and the loan has an interest rate of 6 percent. Healthy Options has also issued 4,000 new bond issues with an 8 percent coupon, paid semiannually, and which matures in 10 years. The bonds were sold at par, and incurred floatation cost of 2 percent per issue.

• The company’s preferred stock pays an annual dividend of 4.5 percent and is currently selling for $60, and there are 100,000 shares outstanding.

• There are 300,000 million shares of common stock outstanding, and they are currently selling for $21 each. The beta on these shares is 0.95. Other relevant information about the company follows:

The 20-year Treasury Bond rate is currently 4.5 percent and you have estimated market-risk premium to be 6.75 percent using the returns on stocks and Treasury Bonds from 2010 to 2019. Healthy Options has a marginal tax rate of 25 percent.

As a recent graduate of the UWIOC, The General Manager of the company has hired you to work alongside the Financial Controller of the company to help determine whether the company should invest in the new product line. He has provided you with the following questions to guide you in your assessment of the project and to present your findings to the Company.

REQUIRED:

7. Determine the weighted average cost of capital (WACC) for Healthy Options.

8. Calculate the initial investment cash-flows.

9. Calculate the after-tax operating cash-flows.

10. Determine the tax on salvage value of the equipment, then show the terminal year cash-flows.

11. Identify three (3) relevant cash flows which were mentioned in the case and how they should be treated in the capital budgeting decision.

12. Taking into consideration all the information given, determine the Net Present Value of the project and advise the company on whether to invest in the new line of product.

Solutions

Expert Solution

7.

Loan amount 2000000
Interest rate 6%
Par Value 1000
Coupon rate 8%
Time to maturity 10
Payment frequency 2
Bond price 980
YTM 4.15%
No. of bonds 4000
Debt raised 3920000
Market Value of Debt (MVd) 5920000
% Debt 32.49%
Before tax Cost of debt 4.77%
After tax Cost of debt 3.58%
Dividend on Preferred Stocks 4.50%
Par Value of preferred stock 100
Preferred stock price 60
Cost of preferred stock (Ks) 7.50%
No. of Preferred Stock 100000
Market Value of Preferred Stock (MVs) 6000000
% Preferred Stock 32.93%
β 0.95
Rf 4.50%
Market risk premium 6.75%
Cost of common stock (Ke) 10.91%
No. of outstanding shares 300000
Current stock price 21
Market Value of common stock (MVe) 6300000
% Common Equity 34.58%
Cost of Capital (WACC) 7.41%

8.

Increase in Current Assets 380000
Increase in Current Liabilities 50000
Investment in Working Capital 330000
Capital Investment 2950000

10.

Depreciation Schedule 1 2 3 4 5
Depreciation rate 20% 32% 19.20% 11.52% 11.52%
Depreciation amount 590000 944000 566400 339840 339840
Ending Book Value 2360000 1416000 849600 509760 169920
Salvage Value 200000
Book Value at the end of 5 years 169920
Tax on Capital Gains 7520
After-tax Salvage Value 192480
Corporate tax rate 25%

9 & 12.

0 1 2 3 4 5
1. Initial Cash Flow
Capital Investment -2950000
Working Capital -330000
2. Operating Cash Flows
Sales 1200000 1200000 1200000 850000 850000
Variable Costs 267000 267000 267000 375000 375000
Fixed Overhead 180000 180000 180000 180000 180000
Depreciation 590000 944000 566400 339840 339840
Pretax profit 343000 -11000 366600 135160 135160
Tax 85750 0 91650 33790 33790
Profit after Tax 257250 -11000 274950 101370 101370
Cash Flow (PAT + Dep) 847250 933000 841350 441210 441210
3. Terminal Cash flow
Working Capital 330000
After-tax Salvage Value 192480
4. Opportunity Cost
Lost sales of other lines of tester machines 50000 50000 50000 50000 50000
Net Cash flow (1+2+3-4) -3280000 797250 883000 791350 391210 913690
NPV -200466

Given that the project has negative NPV, the company should not invest in the new production line of portable electrocardiogram (ECG) machines.


Related Solutions

Section 2 - CASE ANALYSIS (30 marks) INSTRUCTIONS: 1. Read the case below carefully and answer...
Section 2 - CASE ANALYSIS INSTRUCTIONS: 1. Read the case below carefully and answer ALL the questions which follow. 2. Your answers may be entered using a Microsoft Excel spreadsheet OR may be entered in a table format using Microsoft Word. HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which...
INSTRUCTIONS: READ THE FOLLOWING SITUATION AND ANSWER THE QUESTIONS ARISING FOR THE CASE ANALYSIS. “STONYFIELD FARM...
INSTRUCTIONS: READ THE FOLLOWING SITUATION AND ANSWER THE QUESTIONS ARISING FOR THE CASE ANALYSIS. “STONYFIELD FARM GOES TO THE BLOGS” The Stonyfield Farm story is a kind of legend. In 1983, friends and social activists Gary Hirschberg and Samuel Kaymen started with a good yogurt recipe, seven cows, and a dream. They established an organic yogurt company in Wilton, New Hampshire, to take advantage of baby boomers' growing concerns about natural foods and health, and to revitalize the dairy industry...
Instructions: Read the following case study and answer the questions at the end. Devin is a...
Instructions: Read the following case study and answer the questions at the end. Devin is a sixteen year old male with moderate mental delays, living with his parents in an upscale neighbourhood. Since he turned 15, Devin has begun to grab at his genitals and emit loud grunting noises whenever he is in the vicinity of girls his own age. This has caused Mr. and Mrs. Quentin a tremendous amount of distress. Because Mrs. Quentin’s profession requires them to entertain...
Instructions Read the case study details below then answer the questions. Dave is a five-year-old sedentary...
Instructions Read the case study details below then answer the questions. Dave is a five-year-old sedentary male who was referred to a pediatric dietitian due to his pediatrician’s concerns with his weight gain over the past year. His parents recently divorced and both parents have equal custody. Prior to the divorce Dave was physically active and on a regular schedule of meals and snacks. Now Dave has unlimited access to snacks at both parents’ homes and his favorite pastimes include...
Section C: Case study analysis (40%) Read the case provided below and answer the questions. Managers...
Section C: Case study analysis (40%) Read the case provided below and answer the questions. Managers encourage your team to take time off. “I’m going nowhere fast.” This was the concern one of my clients recently. Her complaint wasn’t about working in quarantine per se, but about her frantic pace and static productivity. With the initial adrenaline rush of the crisis passed, vast numbers of my clients are reporting that they and their teams feel exhausted to the point of...
Q 2) Read the case and answer the questions below.                                  &
Q 2) Read the case and answer the questions below.                                        (Marks: 10)     Case: Toyota Motor Corporation is a Japanese multinational automotive manufacturer headquartered in Toyota, Aichi, Japan. Recently a conflict arises from the management styles of two managers, Ralph and George, who head two different departments in the same organization. Ralph’s problem with George is that the latter is taking staff from his department without his approval. On the other hand, George feels that he is doing the right thing...
INSTRUCTIONS Please read the following case study and then answer the three questions at the end....
INSTRUCTIONS Please read the following case study and then answer the three questions at the end. Copy/paste the questions followed by your answers into the Discussion Board. Remember to reply to one other person’s initial post with a minimum of four sentences. Module 4 Chapter 4 Ethics Discussion The discussion board assignment is Case 4 - 34 found at the end of chapter problems in your eTextbook. Your initial post should answer the two questions (a-b) posed at the end...
Instructions: Read the case Below and answer the question that follow: In the garment industry, quality...
Instructions: Read the case Below and answer the question that follow: In the garment industry, quality control is mainly practiced right from the initial stage of sourcing raw materials to the stage of final finished garment. For textile and apparel industry, product quality is calculated in terms of quality and standard of fibers, yarns, fabric construction, color fastness, surface designs and the final finished garment products. David, the quality manager of an international garment company, states that "quality is ultimately...
Please read these instructions and answer the questions below.   Assume that you are a social work...
Please read these instructions and answer the questions below.   Assume that you are a social work practitioner at an agency that provides mental health support services to military veterans. The agency currently serves 396 veterans. Your supervisor asks you to develop a questionnaire and administer a survey to these clients to determine their satisfaction with services and how the agency might improve services. There is a particular concern related to complaints about services to transgender and women clients.   Your supervisor...
Read the following accounting case and then answer the questions thoroughly. Questions are listed below the...
Read the following accounting case and then answer the questions thoroughly. Questions are listed below the case. Taylor and Ryan co-own and operate Hatfield Office Equipment (HOE) for 30 years. A local bank has continually financed HOE, which has an inventory worth millions of dollars. The siblings share ownership of the business. They hired James, Taylor’s son, to handle the company’s bookkeeping responsibilities. James, 30, had been working in various jobs at the business since high school. He eventually was...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT