Question

In: Finance

Task #2: Tomewin Water Company Role and Context You are a newly-hired financial analyst with Tomewin...

Task #2: Tomewin Water Company

Role and Context

You are a newly-hired financial analyst with Tomewin Water Company (TWC), a company operating in most states of Australia, which specialises in bottling purified water sourced from Tweed Valley springs. TWC is considering adding to its product mix a ‘healthy’ bottled water geared towards children, aimed at improving both its business focus and the return to shareholders.

Scenario

TWC currently has 30,000,000 ordinary shares outstanding that trade at a price of $41 per share. TWC also has 500,000 bonds outstanding that currently trade at $923.38 each. The company’s bonds have 20 year to maturity, a $1,000 par value and a 8% coupon rate that pays interest semi-annually. TWC has no preferred equity outstanding and has an equity beta of 1.30. The risk free rate is 1.5% and the market is expected to return 11.5%. TWC has a tax rate of 30%.

The initial outlay for the new project is expected to be $3,000,000, which will be depreciated over the next 3 years using the straight-line method to a zero salvage value, and sales are expected to be 1,250,000 units per year at a price of $2.15 per unit. Variable costs are estimated to be $0.54 per unit and fixed costs are estimated at $50,000 per year. The above estimations are valid for 3 years of project life after which a terminal value of $500,000 in year 3 is expected to cover all cash flows to be earned in the future. For the purpose of this project, working capital effects are ignored.

TWC’s CEO, Dr. Bob Green, has asked the finance department if they consider such project to be an acceptable investment. The CFO, Mrs. Sally Johnson, intends to evaluate the project based on the net present value approach. She agrees with Dr. Green on the major assumptions that will affect these cash flows, but they disagree on the appropriate discount rate. Dr. Green believes that they should use the company’s weighted average cost of capital (WACC), however, the CFO disagrees, arguing that the bottled water targeted at children has different risk characteristics from the company’s current products. She argues that the company’s WACC is inappropriate as a discount rate and they should instead use the ‘pure play’ approach and estimate a cost of capital based on companies that sell similar type of products. To do this, Mrs. Johnson obtains some data for several comparable companies as follows:

Company

Cost of Equity

Cost of Debt

D/E

Tax Rate

Fruity Water

21.0%

8%

0.43

34%

Ladybug Drinks

19.70%

7.75%

0.35

36%

Task

1. The CEO and CFO have asked you to provide a recommendation on the appropriate discount rate to be used in the appraisal of the new project.

2. Concerned about the forecasting risk of this project, they also ask that you perform a risk evaluation in the form of:

- Sensitivity analysis for sales price, variable costs, fixed costs and unit sales at ±10%, ±20%, and ±30% from the base case, showing on a graph which variables are most sensitive;

- Scenario analysis on the following two scenarios:

a) Worst Case: selling 1,000,000 units at a price of $1.85 and variable cost of $0.63 per unit;

b) Best Case: selling 1,550,000 units at a price of $2.25 and variable costs of $0.49 per unit.

3. Based on the above analysis, provide a recommendation on whether TWC should invest in this project.            

Solutions

Expert Solution

1.In the given case,company's weighted average cost of capital refers to minimum rate of return needed from an investment to make it worthwhile,whereas the discount rate is the rate used to discount the future cash flows from an investment to the present value to determine if an investment will be profitable.The discount rate takes into consideration the risk premium and thus usually higher than the weighted average cost of capital.

In the given case,company's WACC is as follows;

a)Cost of equity(Ke)=risk free rate+beta(Market return-risk free rate)

=1.5%+1.3(11.5%-1.5%)=14.5%

b)Weight of equity(We)=Value of equity/Value of equity+value of debt

=$41*30 million/$41*30 million+$923.38*0.5million

=$1230 million/$1691.69million

=0.73 or 73%

c)Cost of debt(Kd)=Coupon amount+(Face value-Purchase price)/Years to maturity/(Face value+Purchase price)/2

=($80)+($1000-923.38)/40/($1000+923.38)/2

=$81.9155/961.69

=0.08512 or 8.52% semi-annually

Thus cost of debt=8.52%*2=17.04%

Weight of debt(Wd)=1-weight of equity

=1-.73=0.27

d)WACC=Ke*We+Kd*(1-tax rate)*We

=14.5%*.73+7.04%(1-0.30)*0.27

=10.585%+1.33056%=11.92%

WACC of Fruity Water=21%*1/1.43+8%(1-0.34)*.43/1.43

=16.27%

WACC of Ladybug Drinks=19.70%*1/1.35+7.75%*(1-0.36)*.35/1.35

=15.88%

From the above,we can observe that company in the business of similar project has higher wacc,it means that the company need to add risk premium related to proposed project in its wacc to make it appropriate discount rate.


Related Solutions

You are a newly hired financial analyst with Gold Coast Water Company (GCWC), a company operating...
You are a newly hired financial analyst with Gold Coast Water Company (GCWC), a company operating in Queensland, which specialises in bottling purified water sourced from Tambourine Mountains springs. GCWC is considering adding to its product mix a 'healthy' bottled water geared towards children, aimed at improving both its business focus and the return to shareholders. Scenario GCWC currently has 30,000,000 ordinary shares outstanding that trade at a price of $35 per share. GCWC also has 400,000 bonds outstanding that...
Task #1: Multi-chem Role and Context You are a financial analyst in the capital projects department...
Task #1: Multi-chem Role and Context You are a financial analyst in the capital projects department of Multi-chem, a speciality chemicals producer of fire-control chemicals, additives, and pesticides based in Queensland. Currently, Multi-chem is small in scale, but embarking on a rapid expansion and modernization program. It is also expanding its range of products into dyes, rubber compounds, and water treatment chemicals. While Multi-chem has a large and expanding capital budget, it is currently considering which of two possible projects...
You are a newly hired analyst at a top company Your starting salary is $80,000 year...
You are a newly hired analyst at a top company Your starting salary is $80,000 year You are attempting to save about 10% of your income You have the following options for savings and investment. A Company 401K Plan that matches the first 6% Pretax Contributions at a 50% Match rate Your own Individual Retirement Account (IRA) with a balance of $5,500. Your own Roth IRA with a balance of $1,250. Your brokerage account with a balance of $2,500 how...
You have been hired by Amazon to serve as their international financial analyst. Your first task...
You have been hired by Amazon to serve as their international financial analyst. Your first task is to support Amazon’s M&A prospecting efforts by create a country risk rating for three countries: Algeria, Hungary, and Laos. To do so, you must select and use a method to assess these country’s risks. Name and describe a method (or methods) that you would use to gather information to evaluate these three countries’ risks. Name at least three steps Amazon can take to...
Assume that you are a newly hired treasury analyst that is tasked with improving the liquidity...
Assume that you are a newly hired treasury analyst that is tasked with improving the liquidity position and overall financial management of Firm Y. Firm Y was incorporated 10 years ago and operates in the manufacturing industry. To begin your new position, you have been tasked with benchmarking Firm Y’s liquidity position. In terms of the key performance indicators to benchmark, your treasurer states that the “Current and quick ratios provide the best measures of our firm’s overall state of...
You are a newly hired analyst at one of the leading bond rating agencies, Standard and...
You are a newly hired analyst at one of the leading bond rating agencies, Standard and Poor’s. The first day on the job you are asked to rate the following bonds: a. The bonds of an Internet start-up company b. The bonds of a country with a history of inflation and political instability c. The bonds of company operating a network of toll highways d. The bonds of a company with a long illustrious history that has fallen on hard...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 960,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,700,000 1,800,000 Inventory 3,900,000...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 940,000 $ 1,200,000 Marketable securities 0 300,000 Accounts receivable, net 2,620,000 1,720,000 Inventory 3,580,000...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,020,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,940,000 2,040,000 Inventory 3,660,000...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,040,000 $ 1,280,000 Marketable securities 0 300,000 Accounts receivable, net 3,020,000 2,120,000 Inventory 3,680,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT