Finace case help for brain girl only

profilehbk
capital_budgeting_updatedd.docx

Running HEAD: Capital Budgeting: Google Glass2 1

Capital Budgeting: Google Glass2 2

Capital Budgeting: Google Glass2

Name: Ahmed Altuwaijri

Course Title: Fin 319

Professor: David Nickel

Portland State University

Date of Submission: 2/12/2015

Executive Summary

Google Inc is planning to launch a revised product in response to the low sales of Google Glass2. Google glass2 are smart – phone gadgets that display information in a hands free format and enable users communicate with the device via voice command. The company has already done some preliminary research on the needs of customers and probable sales over the time and determined that low cost production techniques will be available. While Google has already been using the Google glass technology for the product for some time, the sales have been below expectations. For this reason, the firm is seeking to reinvent itself and introduce a better product with superior features: Google Glass2. This paper seeks to carry out different analysis to establish whether the product will be viable according to the projections based on the current debt, equity and sales figures. The product will have a 4.5 years life before being renovated or abandoned depending on the outcomes of the projections.

Free Cash Flow Forecast

Google glass2 units will depend on the total number of smartphones and will be launched 2 years from the current year. In the first year of sale, the number of units will be 0.5% of total smartphone market and will later increase by 0.25% per annum. The initial selling price of the product will be $500 and will decrease at a rate of 5% per year, with the variable cost being $395 in the first year before decreasing by 6% in the subsequent years. The company will also incur cash expenses of marketing, and general and administrative expenses in addition to the non- cash expense of depreciation. Before the launch of the product, the company will also have to incur costs in research and development, test marketing, equipment and investment in working capital. The cost of the equipment will be depreciated based on 5 year MACRS and provided as depreciation expense for the year.

Weighted Average Cost of Capital (WACC)

The WACC is the weighted expected return from each components of finance in the capital structure of an organization (Brealey, Myers, & Allen, 2011). Google Inc has both equity and debt components in its capital structure. The WACC will therefore be the weights of respective equity and debt components and this will be used for discounting or accumulation of the cash flows for investment decisions.

Market Weights of Equity and Debt Components

The market value of a company’s stock is a function of stock price at given time and the number of shares in the company. Googles Inc has 678277 shares divided into various classes and the current market price of a stock of the company is $539 (Google Inc, 2014). Therefore, the market value of equity is $365,591,303. Google Inc also has three outstanding corporate bonds with different maturity dates and different prices. The market price of corporate bonds can be determined as number of bonds multiplied by the current market price of the bond (Berk & Demarzo, 2013).

Bond Details

Bonds

Current Price

Market Value

GOOG409982

1000000

107.54

107540000

GOOG.AB

1000000

102.29

102290000

GOOG.AC

1000000

109.32

109320000

319,150,000

Therefore, the market weights of equity components can be determined as

Value

Weight

Market Value of Equity

365591303

53.39%

Market value of debt

319150000

46.61%

684741303

100.00%

Cost of Equity

The cost of stock equity is the required rate of return that is attributable to the common stock investors in the company (Brealey, Myers, & Allen, 2011). It can be determined by the use of CAPM model. CAPM model requires the cost of equity be determined as

Rs = Rf +b (Rm –Rf)

Where; Rf – Risk free rate; b – beta; Rm –Market return

The risk free rate is the rate of return on default free securities such as Treasury bill and bonds. Google glass2 has an average life of 4.5 years and being that the risk free rate should be equal to the life of the project; the best estimate of risk free rate is a 5-year US Treasury bond, which averaged 1.32% in 2014.The beta of Google Inc, has been estimated to be 1.16.The market return is 10.86%. The market return of used to estimate market return is the NASDAQ100 index for one year ending September 2014.

The CAPM can then by calculated as

1.32% + 1.16(10.86% - 1.32%) = 11.066%

Cost of debt

The cost of debt is coupon rate of the bond. Google Inc has three different bonds with different coupon rates (Google Inc, 2014)The weighted average cost of debt is

Bond Details

½ annual coupon rate

face value

coupon interest

GOOG409982

3.38%

1000000

33750

GOOG.AB

2.13%

1000000

21250

GOOG.AC

3.63%

1000000

36250

3000000

91250

Weighted Rd

6.08%

The after tax cost of debt involves adjusting pre –tax cost of debt to the tax deductibility of interest thus calculated as Rd (1- T)

6.08% * (1-0.2%) = 4.87%.

The WACC of the company can therefore calculated as

WACC = WsRs + WdRd(1-T)

Equity

Debt

WACC

Weight

53.39%

46.61%

Rate of return

11.07%

4.87%

WACC

5.91%

2.27%

8.18%

Capital Budgeting Technique Analysis and Recommendation

Net Present Value (NPV)

The NPV of a project is the present value of future free cash flows less the cost incurred in the initial outlay (Berk & Demarzo, 2013). A project analyzed using the NPV technique should be approved if the NPV is positive and rejected if the NPV is negative. Based on the analysis in appendix 2, the NPV of the Google2 is -$28.503m. With a negative NPV the project will be rejected since it does not add value to the shareholders of the company.

The calculation of the NPV has been based on the assumptions. First, the useful life of the product is 4 years. In the calculation of the NPV, five years have been used. If the last year was to be divided into two halves and the cash flows from the last half deducted, the NPV would still be negative. Secondly, there are a number of costs which have been incurred before launching the product. Some of the costs such as research and development are incurred two years before launching of the product. Accumulation of the R&D costs gives a total of $129.09m which is included in the cost of initial outlay. Google can do a number of things to ensure that the NPV of the product is positive and thus the project accepted. The WACC is based on the CAPM and cost of debt. Reducing its cost of equity and debts would reduce the rate at which the cash flows are discounted and this would slightly increase the PVs of cash flows. Effective absorption of some of the costs incurred before launch of the product could also reduce the initial outlay (expenses) and thus boost the NPV value.

Internal Rate of Return (IRR)

The IRR of a project is the rate of return that equates the present value of free cash flows to the initial cash outflow (Ehrhardt & Brigham, 2011). The decision criterion for this technique is to accept the project if the IRR is greater than zero since the project will have break evened. The IRR of the Google2 has been calculated through the extrapolation of NPVs at different interest rates. At 8.18%, the NPV is -28.503m. At 5%, the NPV is $49.5222m. Through the extrapolation, the IRR is found to be 6.89%. Based on this IRR, the Google Glass2 product should be accepted since the costs have break evened. In addition, the IRR (6.89%) is relatively higher than zero, and this means that the project will produce some returns. Reduction of some of the initial outlay expenses (those that can be avoided) is a sure way of boosting the IRR. In addition, Google ought to work towards the reduction of the cost of capital such that the cash flows are discounted at a lower rate of interest.

Profitability Index (PI)

The PI of a project is the present value of a project’s future cash flows divided by the initial cash outflow. The decision criteria is to accept the project if the profitability index is greater than 1 or 100% (Berk & Demarzo, 2013). The FV of the future cash flows is $640.587m while the initial outlay is $669.09. Google has a PI of 95.74% (640.587/669.09). Since the PI is less than 100%, Google should reject the Google2 project since it will not be profitable to the firm.

Modified Internal Rate of Return (IRR)

Modified IRR is a project appraisal technique that seeks to equate the terminal value of a project with its initial cash outlay (Berk & Demarzo, 2013). The terminal value of a project is based on the assumption that cash flows are reinvested at the WACC. The MIRR of the Google2 will be:

= (n) sqrt (FV of Cash flows/Initial Outlays) – 1

FV of cash flows = 42.6* 1.0818^4 + 99.26 * 1.0818^3 +128.55 * 1.0818^2 + 186.6 * 1.0818^1 + 412.73 = 949.04424

Initial Outlay = 669.09

So MIRR = {(949.04424/669.09)}^ 1/5 – 1 = 0.0724. So the MIRR will be 7.24%

The decision criteria is to accept the project if the MIRR is larger than the WACC. Projects are rejected if the MIRR is less than the WACC. In this case, the rate of reinvestments of the cash flows is lower than the rate at which the cash flows are being discounted. For this reason, the Google2 ought to be rejected.

Payback Period

This is the length of time it takes for a firm to recover all the costs incurred in investments. Payback period is a determinant of whether an organization will accept or reject the project under consideration (Ehrhardt & Brigham, 2011). Google has 4.5 years to make sales from the Google Glass2 and thus a payback period of more than 4.5 years will not be accepted. The payback period should be less than 4.5 years.

The payback period is:

4 years + 212.08/412.73 = 4.5138 years.

Since the payback period does not take into account the time value of money, the real cash flows are used. Google Glass2 will take a period of 4.5138 years to recover the initial costs invested. This is more than the economic life of the product. Based on the payback period method, Google should not accept the Google2 product since all the costs invested in the product will not be recouped within its economic lifetime.

Synthesis and Recommendations

A number of approaches have been used in assessing the feasibility of the Google Glass2 project. Based on the evidence from the projections and the cash flows over the useful life of 4.5 years, Google Glass2 should be rejected. The NPV approach takes into consideration the cash flows from the project and for this reason incorporates the risk element. Since the Glass2 project has a negative NPV, rejecting will the option since it will not add value to the portfolio owned by the Google shareholders. Profitability element should also be a part of the feasibility tests. Glass2 project fails to reach the threshold of 1 so as to guarantee acceptance. This means that the project will not be profitable to Google if accepted. Although IRR approach hints at the project acceptance, a more robust approach put forward by MIRR gives further rejection evidence. MIRR is a more realistic approach in assessing performance of project. Since MIRR is less than the WACC, the reinvestment rate is lower and therefore Google Glass2 ought to be rejected.

References

Berk, J., & Demarzo, P. (2013). Corporate Finance (3edn ed.). Boston: Pearson Education Inc. Brealey, R. A., Myers, S. C., & Allen, F. (2011). Principles of Corporate Finance (10th ed.). New York: McGraw -Hill Irwin. Ehrhardt, M. C., & Brigham, E. F. (2011). Finance Management Theory and Practice (13edn ed.). Mason: South Western Cengage Learning. Google Inc. (2014). Finance. New York: Yahoo Finance . Google Inc. (2014). Financial Markets. New York: Morning Star. Google Inc. (2014). Google Earnings. New York: Google Finance .

Appendix

1.

FCF Forecast

 

0

1

2

3

4

5

6

Capital Equipment

(500)

Working Capital

(50.00)

Market Testing

(20)

Research & Development

(129.09)

Smartphone sales

1200

1322.00

1478.5

1641.16

1821.68

Google Glass Units

6

9.915

11.55

14.785

22.771

Selling Price

 

 

500.00

475.00

451.25

428.688

407.253

 

Sales Revenue

3000

4,709.63

5,211.94

6,338.15

9273.56

Variable Cost per unit

395.00

371.30

349.02

328.08

308.40

Total Variable Cost

 

 

2,370

3,681.44

4,031.18

4850.66

7022.58

 

Gross Profit

 

 

630

1028.19

1,180.76

1,487.49

2250.98

 

Sales and Marketing

360

565.16

625.43

760.58

1112.83

General and Admin. Expenses

240

376.77

416.96

507.05

741.88

Depreciation Expense

93.00

148.80

89.28

53.57

53.57

26.78

Total Expenses

 

 

693

1090.12

1,131.67

1321.2

1908.28

26.78

Operating Profit

(63)

(61.93)

49.09

166.29

342.7

(26.78)

Tax

(12.6)

(12.39)

9.82

33.26

68.54

(5.36)

Net Profit/ (Loss)

(50.4)

(49.54)

39.27

133.03

274.16

Add Tax Shield

93.00

148.80

89.28

53.57

53.57

After Tax Salvage Value

35.00

Working Capital

 

 

 

 

 

 

50.00

 

Free Cash Flows

-

(699.09)

42.6

99.26

128.55

186.6

412.73

 

2.

Net Present Value

Year

Cash Outlay

FCF

Discount Rate = 8.18% annually

Present Value

0

(669.090)

1

(669.090)

1

42.6

0.9244

39.379

2

99.26

0.8545

84.818

3

128.55

0.7899

101.542

4

186.6

0.7302

136.255

5

412.73

0.6750

278.593

 

 

 

(28.503)