Powered By Blogger

Tuesday, August 23, 2011

Research Proposal: The recognition the compressive strength of weak concretes by using of Ultrasonic method (NDT)




Introduction
Once concrete has hardened it can be subjected to a wide range of tests to prove its ability to perform as planned or to discover its characteristics if its history is unknown. For new concrete this usually involves casting specimens from fresh concrete and testing them for various properties as the concrete matures. The ‘concrete cube test' is the most familiar test and is used as the standard method of measuring compressive strength for quality control purposes. Concrete beam specimens are cast to test for flexural strength and cast cylinders can be used for tensile strength. Specimens for many other tests can be made at the same time to assess other properties (For example: Drying shrinkage, thermal coefficient, modulus of elasticity).
For existing concrete samples will need to be taken from the structure (smaller precast units can be tested as found). Non destructive testing (NDT) methods are useful in some instances and can help identify areas from which samples should be taken. The normal method of concrete sampling is by coring although some chemical analysis techniques can be carried out on drilling dust samples. Once back in the laboratory many techniques can be used to examine and test hardened concrete to assess a wide variety of properties. Due to the large expansion in concrete projects and due to the importance of time and its direct impact on project cost, an essential need to estimate the hardened concrete strength.

Problem Statement
Concrete is unique in that it is the only engineering material in which strength determination is attempted from ultrasonic measurements. The reason for this unusual attempt is the need created by the acute infrastructure problem. If the concrete is not strong enough (for instance, it has deteriorated) the consequence can be excessive repair, shortened service life and, in extreme cases, collapse of the structure causing property loss, injuries and even loss of life. Once a reliable conclusion as to the condition of a structure has been reached, then, and only then, it can a technically and economically sound selection be made among alternative repair strategies.
Nowadays, the quality control of hardened concretes as a structure into buildings (beams, columns, footings etc) is the problem. Perhaps, it could be considered that there is an easy way to control the quality of hardened concretes and this way is the coring by using of rotary machinery. But when we utilize from coring method, as the matter of fact, we are destroying the structure by cutting some steel bars replaced into concrete. On the other hands, there is notably limitation to check the quality of the concrete by this way. Assume there are 200 concrete columns at the site that should be controlled. Can we test all of 200 columns by using of the coring method? This method is very expensive and takes too much time. In fact, we have to proceed to test hardened concretes by using of coring method randomly. The seriousness of the infrastructure problem is well known. According to the "ASCE 1998 Report Card for America's Infrastructure,” 59 percent of our roadways are in poor, mediocre or fair condition.
It will cost a total of $357 billion to eliminate the backlog of needs and produce modest improvement. In addition, 31.4 percent of our bridges are rated structurally deficient or functionally obsolete. It will require $80 billion to eliminate the current backlog of bridge deficiencies and maintain repair levels”. Yet there is unanimous agreement among engineers that the presently available test methods for non-destructive determination of concrete strength are, without exception, inadequate. Fifty years of research in this area could produce no better solution to the problem than empirical formulas obtained by elementary curve fitting for the calculation of the strength. In view of the complexities of the problem, discussed in the article, it would appear to be overly optimistic to attempt to formulate an ultrasonic test method for the determination of concrete strength. However, considering the seriousness of the infrastructure problem and the magnitude of the cost of rehabilitation, major advancement is desperately needed to improve the current situation. There is no acceptable method at present for the non-destructive determination of concrete strength.

Goals and Objective
The objective of this research is to contribute to the development of a pragmatic method for the improved non-destructive determination of concrete strength in structures. One novel Strategy is discussed that seem promising for such development. In this new idea the velocity of ultrasonic waves in concrete is used. This feature is called pulse velocity in this research. The purpose of this research is to develop rapid, reliable, low-cost experimental techniques for evaluating the compressive strength of weak concretes. 
The objective is to determine whether nonlinear ultrasonic methods can be used in combination with the commonly used expansion tests to provide an earlier indication of aggregate, the rocks (especially sedimentary rocks) in which we are able to utilize the concepts of Rock Mechanics accompanied by Concrete Technology.
The goals of this research are:
-To determine the compressive strength of weak hardened concretes
-To examine the compatibility Rock Mechanics science and Concrete Technology in order to use of Ultrasonic method
-To recognize low strength concretes from high strength concretes at the site
- To control the quality of hardened concretes clearly
-To find out Non-uniformity of hardened concretes at the site

Scope of Study
One of the research goals was to identify a strategy on how to proceed in the testing so to get the best possible outcome out of each technique and what each one could actually achieve compatibly with the limited time resources, given also the number of specimens to undergo investigation. Furthermore, from the combined use of the various techniques it was hoped that not only the results from one could be confirmed by other techniques, where possible, but that they could complement each other in carrying out a thorough investigation and in refining the information regarding the presence of defects, their location, depth and possible size. Therefore, at the first, we have to define the period of time and maximum cost for this research. In the case of this study, we consider minimum 12 months of work included in all of Lab. tests and analysis of data. We should make at least 500 samples of fresh standard cubic concrete accompanied by specimens of aggregate and tin-section study by microscope. In the meanwhile, we should consider all of made fresh concretes will be low compressive strength that this target also is our limitation. 

Literature Review
The non-destructive testing (NDT) of concrete is of great scientific and practical importance. The subject has received growing attention during recent years, especially the need for quality characterisation of damaged constructions made of concrete, using NDT methods. Malhotra (1976) presented a comprehensive literature survey for the non-destructive methods normally used for concrete testing and evaluation. Leshchinsky (1991) summarized the advantages of non-destructive tests as reduction in the labour consumption of testing, a decrease in labour consumption of preparatory work, a smaller amount of structural damage, a possibility of testing concrete strength in structures where cores cannot be drilled and application of less expensive testing equipment, as compared to core testing. These advantages are of no value if the results are not reliable, representative, and as close as possible to the actual strength of the tested part of the structure.
Longitudinal ultrasonic waves are an attractive tool for investigating concrete. Such waves have the highest velocity so it is simple to separate them from the other wave modes
The equipment is portable, usable in the field for in situ testing, is truly non-destructive and has been successful for testing materials other than concrete. In addition, none of the available non-destructive methods for testing concrete strength is better. Nevertheless, there are intrinsic and practical factors that may interfere with the determination of concrete strength by ultrasonic means. Concrete is a mixture of four materials: Portland cement, mineral aggregate, water and air. This complexity makes the behaviour of ultrasonic waves in concrete highly irregular, which, in turn hinders non-destructive testing. In the view of the complexities of the problem it would appear to be overly optimistic to attempt to formulate an ultrasonic test method for the determination of concrete strength. However, considering the seriousness of the infrastructure problem and the magnitude of the cost of rehabilitation, major advancement is desperately needed to improve the current situation. For instance, Popovics (1998) stated that it has been demonstrated repeatedly that the standard ultrasonic method using longitudinal waves for testing concrete can estimate the concrete strength only with ± 20 percent accuracy under laboratory conditions.
Earlier researchers such as Prassianakis (2003) and Arioglu (1998) on finding the correlation between concrete strengths and UPV were generally limited to the specimens prepared in laboratory conditions. In these researches different correlation formulas were found for different concrete mixture ratios.
Furthermore, a general expression of a concrete strength and UPV correlation by not taking the ratio of concrete mixture and its age into consideration does not exist in these earlier researches (Prassianakis and Arioglu). Beside, the concrete mixture ratios were variable and the ages of the specimens were generally 28 days. Only Prassianakis (2003) used a restricted amount of specimens with 28 years old. In this research, the ages of existing reinforced concrete structures taken cores ranges between 28 days to 36 years and their concrete mixture ratios are not known. Unknown concrete mixture ratios in existing reinforced concrete structures are one of the most common issues that cause difficulties so as to determinate the strength-UPV relationship. In this respect, because of variability in the concrete mixture ratio findings obtained from laboratory researches (Prassianakis and Arioglu) do not have a general pattern, the strength of concrete cannot be determined appropriately. Thus, these findings cannot represent a general way of analysis as well.

Research Methodology
The methodology of this research will be in accordance with below procedure.
 At the first time, we should make Index Tables by using of following steps:
Step1) To do Ultrasonic test on mix of aggregate (coarse and fine) with variable ratios and compactions. Of course, the appropriate (qualified) material of mould should be selected.
Step2) To do Ultrasonic test on rocks which are the source of aggregate (ASTM D2845).
Step3) To do Ultrasonic test on cement paste (Portland type1) with various types of water to cement (W/C) ratios and degree of hydration equal to %100 (ASTM C597).
Step4) To do Ultrasonic test on concrete with maximum compaction (entrapped air=%1) and different water to cement (W/C) ratios and h=%100 and cement type1 (ASTM C597).
Step5) To do Ultrasonic test on concrete with W/C=0.7 and with various types of compactions (vice versa of Step 4).
Step6) Calibration of experimental formulas of Fourmaintraux (1976) in Rock Mechanic to use of steps 1,2,3,4 and 5.
All of above steps have been included in below chart:

 Significant of Research
The outgoing of this research will establish a logical connection between Rock Mechanic and Concrete Technology and so it is a new idea of research to develop concrete technology. On the other hand, we will be able to control the qualification of low strength concretes easily. Where we have so many research materials on correlation between high strength concretes and the velocity of pulse generated from Ultrasonic test but we cannot find any research on low strength concretes while we need to have second one.

Data collection and analysis of discussion
After above steps and to obtain index tables, we can test ultrasonic method on hardened concrete at working place to measure the actual velocity of longitudinal waves (Correct reinforcement according to B.S 1881:part203).
Then we should take samples of hardened concrete particles for utilization of particles thin sections, which will be illustrated by microscope (polarized). Of course, particles (tin sections of concrete) should be saturated. By studying of saturated tin sections, we are able to determine the rate of water absorption for calculating the volume percentage of aggregate (coarse + fine), cement paste and finally total voids in concrete.
According to experimental formulas by Fourmaintraux (1976), we have:
Iq =100-1.6Np%
Where,
Iq: quality index
Np: total voids
On the other hand, we have:
Iq =V/V'*100%
Where,
V: actual velocity of longitudinal waves (at working place)
V': calculated longitudinal wave velocity according to volume percent and longitudinal wave velocity in aggregate (Coarse + fine) and cement paste (step1 to 6)
In addition, V' is equal to:
1/V'=SUM (Ci / Vi)
Where,
Ci: volume percent of materials constituent i
Vi: longitudinal wave velocity in materials constituent i
According to above mentioned, we can obtain longitudinal wave velocity into cement paste and regarding to step3, we will get proportion of water to cement (W/C) to compare the strength of concrete and to define relationship between them.
In the meanwhile, we can control the total void of proportion water to cement obtained (W/C) by using of maximum aggregate size (entrapped air percent) into concrete particles by following formula:
 P = (W/C-0.17+a/C) / (0.317+1/Pf*Af/C+1/Pc*Ac/C+W/C+ a/C)
Where,
P: total void in concrete
a: entrapped air percent
Ac: mass percent of coarse aggregate
Af: mass percent of fine aggregate
C: mass percent of cement
Pc: specific gravity of coarse aggregate
Pf: specific gravity of fine aggregate

Recommendation
Before the start of the test at Libratory, I suggest that we utilize from simulation method by using of some software or design a software for simulation in which we should introduce all reactions among paste, aggregates and Ultrasonic waves.

References
Ø  -Malhotra V. M. (Ed.), Testing Hardened Concrete: Non-destructive Methods, ACI, monograph No. 9, Detroit, US, 1976.
Ø  -Leshchinsky A., Non-destructive methods instead of specimens and cores, quality control of concrete structures, In: Proceedings of the International Symposium Held by RILEM. Belgium, E FN SPON, U.K., 1991, pp.377-386.
Ø  -Popovics S., Strength and related properties of concrete: a quantitative approach, New York: John Wiley Sons Inc., 1998.
Ø  -Prassianakis I.N., Giokas P., Mechanical properties of old concrete using destructive and ultrasonic non-destructive testing methods, Magazine of Concrete Research, 55 (2003) 171-176.
Ø  -Bungey J.H., The validity of ultrasonic pulse velocity testing of in-place concrete for strength, N.D.T. International 13(6) (1980) 296-300.

Ø  -Elvery R.H, Ibrahim LAM., Ultrasonic assessment of concrete strength at early ages, Magazine of Concrete Research (1976) 181-190.
Ø  -Teodoru, G.V., The use of simultaneous nondestructive tests to predict the compressive strength of concrete, ACI SP-112 ,1998,137-152.
Ø  -Arioglu, E., Arioglu, N., Testing of concrete core samples and evaluations, Evrim Publisher, Istanbul, 1998.
Ø  -ASTM C 597-83, Test for pulse velocity through concrete, ASTM, U.S.A., 1991.
Ø  -BS 1881-203, Recommendations for measurement of velocity of ultrasonic pulses in concrete, BSI, U.K., 1986.
Ø  -ACI 318-95, Building Code Requirements for structural concrete, (ACI 318-95) and commentary-ACI 318R-95, ACI, U.S., 1995.
Ø  -BS 1881: Part 120: 1983, Method for Determination of Compressive Strength of Concrete Cores, BSI, U.K., 1983.
Ø  -ASTM C 42-90, Standard test method for obtaining and testing drilled cores and sawed beams of concrete, ASTM, U.S.A., 1992.
Ø  -Popovics, S., Effect of curing method and final moisture condition on compressive strength of concrete, ACI Journal 83 (4) (1986) 650-657.
Ø  -A. Nilsen, P. Aitcin, Static modulus of elasticity of high strength concrete from pulse velocity tests, Cem Concr Aggr 14 (1) (1992) 64-66.

Wednesday, July 6, 2011

Case Analysis of Nike, Inc.: Cost of Capital (CON)


Cost of Equity

The cost of equity is comprised the cost of preferred stock and common stock. In this case, I am willing to focus on the cost of common stock because Nike did not pay any dividend after June 30, 2001(see Exhibit 4).

The cost of common stock is the return needed on the stock by shareholders in which investors discount the expected dividends of the firm to ascertain its share price. To perceive this definition, let me bring you an example:
Assume you want to invest on the stock of Nike, Inc. Your expected return is 12% for one year. The current share price is $42. Your benefit of the investment to purchase one share will be $5.04. If the company pay the dividend of $2.04 per share annually, the share value should increase to $45 in the next year to secure your benefit ($5.04). Therefore, the cost of equity is to cope with the risk of share price’s changes and the dividends paid by the company. There are two techniques to obtain the cost of equity as follows:


 1) Capital Asset Pricing Model (CAPM)

As you know, the Capital Asset Pricing Model (CAMP) establishes a rational relationship between Non-Diversifiable risk and return of all assets due to all companies can eliminate or decrease Diversifiable risk by playing on the type and return of assets.
Here is the formula of CAPM:
Rs = Rf  + [ b * (Rm – Rf)]
Where:

Rs: Cost of equity
Rf: Risk – free rate of return (commonly measured by the return on a U.S. Treasury bill)
Rm: market returns (return on the market portfolio of assets)
b: beta coefficient or index of non- diversifiable risk for all assets of company
(Rm – Rf): market risk premium
Referring to above formula, we should find true data and assumptions for Rf, Rm, and beta (B).
At the first, we should consider FRICTO analysis (Flexibility, Risk, Income, Control, Timing and Others).
In this case, the timing is very important factor. We have to recognize what is NorthPoint’s timing. Would it be ok a short term investment or long term?  What will be the period of investment?
Let me remind you about previous article mentioned as follows:
“   "She should use current yields on US Treasuries 3 to 12 months at 3.59% because the yield curve is upward sloping.  Upward sloping yield curve means that North Point Group should rely to short-term financing instead of long term financing.  In fact, by short term financing, the manager can use cheaper cost of equity. It means that North Point Group should sell the purchased shares of Nike during the period of one year.”
    Therefore, my suggestion to NorthPoint is a short – term investment for the period of one year. Consequently, we should consider Rf = 3.59%
    Regarding to Exhibit (4), we have Nike Historic Betas.


    What is our choice for beta? Do we focus on the average (0.8)?
    Let me tell you my analysis as follows:
According to the short term investment and the graph of Nike share price performance relative to S & P 500 presented in Exhibit (4), we can see the interaction between beta (B) and share price of Nike / S &P500 index. In early 2000 (Feb & Mar), Nike / S&P500 = 0.55 that it presents us more risky shares of Nike so that beta is also high (0.83). Higher beta (B) indicates that its return is more responsive to the changes of market returns. Therefore, higher beta is more risky.
But after July 2000, we can see a significant increase of Nike / S&P500 until July 2001 (the time of this case) in which it shows lesser risk of investment for Nike’s share price and we have beta (B) equal to 0.69
In the result, I assumed beta equal to 0.69 (B = 0.69) for a short term investment.
According to Exhibit (4), we have two types of Historical Equity Risk Premiums (Rm – Rf), Geometric mean and Arithmetic mean.
Which one should we consider?
In finance, we usually choose geometric mean because it is a better estimate for longer life valuation while the arithmetic mean is better for a one-year estimated expected return. For longer life valuation, we can find stable valuation. But I would like to refer you to the paper submitted by www.mit.edu that citation is as follows:
Jacquier, E., Kane, A., & Marcus, A. (2002, Dec 18). Geometric or Arithmetic Mean: A Reconsideration. Forthcoming: Financial Analysts Journal. Retrieved May 20, 2003, from http://web.mit.edu/~jacquier/www/papers/geom.faj0312.pdf
According to this paper, the proper compounding rate is in – between these two values. Therefore, I consider 6.7% as market risk premium.
(5.9% + 7.5 %) / 2 = 6.7%
Now, we can calculate the cost of equity as follows:
Rs = 3.59% + [0.69 * (6.7%)] = 8.21%
I also analyzed a long term investment (please see my spreadsheet) in which I used the adjusted beta in the reference with Blume's technique; it is assumed that all of beta in the future will reach to 1. I chose this technique because it presents us the sense of the future for beta instead of historic beta. (Adjusted Beta = 0.343 + 0.677 Bh)
In the case of long term investment, the cost of equity is equal to 10.61% where I considered Bh = 0.8
You can compare the cost of equity for long term and short term investment.
2) The Constant-Growth Valuation (Gordon) Model
We as well as know that the value of a share of stock is equal to the present value (PV) of all future dividends, which in one model were assumed to grow at a constant annual rate over an infinite time horizon (Gordon Model) in which we have below formula:
Po = D1 / (Rs – g)
Where:
Po: Value of common stock
D1: Per – share dividend expected at the end of year 1
Rs: Required return on common stock
g: Constant rate of growth in dividends


According to my spreadsheet and Exhibit (4), Rs is calculated as follows:
Rs =  D1/P0 + g
= 0.24 / (42.09+0.063)        
= 6.87%

Since Nike did not pay any dividend after June 30, 2001(see Exhibit 4), I rejected this model because it does not reflect the true cost of capital.

Weighted Average Cost of Capital (WACC)
CAPM was found to be more superior to other methods of calculating cost of equity, hence the cost of equity used in the WACC is one derived by CAPM. At this point, I calculated the WACC of Nike Inc. using the weights and costs of debt and equity. The formula used is as follows:
WACC = wd*kd (1-T) + we*ke

= [10.2%*8.59 ( 1-38%)] + [89.8%*8.21%]
= 0.54% + 7.38%
= 7.92%

The weighted average cost of capital for Nike Inc. is equal to 8.27 percent.

EVALUATION
Kimi Ford used a discount rate of 11 percent to find a share price of $43.22. This makes Nike Inc. share price undervalued as Nike is currently trading at $42.09. I already told you this discount rate does not reflect the true market value and solved for a discount rate that would be more accurate.

I found the weighted average cost of capital by using CAPM that presented a discount rate of 7.92 percent. This discount rate results in a share price of $75.8*, meaning that Nike Inc. is undervalued by $33.71 per share ($75.8 - $42.09).

(Refer to sensitivity analysis table in exhibit 2).

DECISION

Using this data, I found that Nike Inc. should be added to the NorthPoint Large-Cap Fund at this time because the stock is undervalued and I can say to you that the safety factor is equal to 1.8 (Fs = 75.8 / 42.09). Whereas I have still doubt on projection analysis done by Kimi Ford.

Appendix  

Now, let me bring you my detail calculations to explain my spreadsheet about the cost of debt (Method (2): Based on calculating the IRR) as follows:

Calculation of cost of debt by using IRR method:

Note:  “All spreadsheets and calculation notes are available. The people, who are interested in having my spreadsheets of this case analysis as a template for further practice, do not hesitate to ask me by sending an email to: soleimani_gh@hotmail.com or call me on my cellphone: +989109250225. Please be informed these spreadsheets are not free of charge.”





To be continued .......

Tuesday, June 21, 2011

Double Discounting Method to Analyze Financial Case of Euroland Foods S.A.


Following to article of "Case Analysis of Euroland Foods S.A. plus a new implement strategy"I received the emails which presented the concern about Sensitivity analysis and Double discounting methods.

Let me explain you the details each one of this methods as follows:

1) Sensitivity Analysis Method

The common question was: “Why did I choose IRR = 17% for all of projects?
First step, I chose the range of IRR more than WACC = 10.6%. For instance, IRR = 11% to IRR = 14%. Then I ranked all of projects by high NPV and high Equivalent Annuity.
Second step, I increased the range of IRR to 16%. Then I ranked again all of projects.
Third step, I continued to increase of the range IRR and control the rank of all projects in which I obtained the constant ranking for all projects, in this case was IRR = 17%

2) Double Discounting method

In this method, we should compare all projects in minimum time period of cash flows.
The index time period is 3 years that is referred to the project of Inventory-Control System. At the first, we should exchange and discount all cash flows of the projects on three years. Then we will able to calculate NPV and IRR for all projects in the same period (three years).
How can we exchange and discount all cash flows to three years?
There are two ways as follows:

-To subtract present value of total time period from present value for three years

Delta (PV) = PV (t=n) – PV (t=3)

PV (t=n) = SUM [Ct / (1+WACC) ^n]   where: t = 0 to t = n

PV (t=n) = SUM [Ct / (1+WACC) ^n]   where: t = 0 to t = 3

After that, we should replace C3 of each project by Delta (PV) + C3

-In this way, we should calculate present value in which it will be the time equal to zero (t =0) for cash flow of third year. Then all cash flows before third year accompanied by third year will be considered equal to zero. Please see the example of project (1):

Year            0     1          2          3       4       5        6        7
Cash flow    -   -11.85   4.5      5.25     6      6.75    7.5     10.5

The present value should be calculated for below state:

Year           0    1     2       3      4      5         6        7
Cash flow   -    0     0       0      6      6.75    7.5      10.5

After that, we should replace C3 of each project by (New present value) + C3
If you calculate the present value by two ways, the result will be the same.
Finally, we should calculate NPV and IRR for all projects in the same period (three years).





Note:  “All spreadsheets are available. The people, who are interested in having my spreadsheets (two Excel files included six sheets) of this case analysis as a template for further practice, do not hesitate to ask me by sending an email to: soleimani_gh@hotmail.com or call me on my cellphone: +98 9109250225. Please be informed these spreadsheets are not free of charge.”

  


 
  

Thursday, June 16, 2011

Case Analysis of Nike, Inc.: Cost of Capital


Apparently, the issue of Nike’s case is to control and check the calculation cost of capital done by Joanna Cohen who is the assistant of a portfolio manager at NorthPoint Group. But I am willing to tell you that it can be a complex case in which we can doubt about sensitivity analysis done by Kimi Ford (portfolio manager) because her assumptions such as Revenue Growth Rate, COGS / Sales, S &A / Sales, Current Assets / Sales, and Current Liability / Sales have been adopted from previous income statements and balance sheets from 1995 to 2001. Perhaps, we can take new assumptions. Generally, the case issue is to examine if the share price of Nike is undervalue or overvalue and the common stock of Nike Inc should be added to the North Point Group’s Mutual Fund Portfolio or not.
Now, let me approve Kimi Ford’s analysis and tell you only the mistakes of Joanna Cohen.
What is the cost of capital?
The cost of capital is the rate of return that a firm must earn on the projects in which it invests to maintain the market value of its stock. Cohen calculated a weighted average cost of capital (WACC) of 8.4 percent by using the Capital Asset Pricing Model (CAPM) for Nike Inc. I do not agree with Joanna Cohen because of below mentioned:
-In the field of Equity’s Cost:
Ø She should use current yields on US Treasuries 3 to 12 months at 3.59% because the yield curve is upward sloping.  Upward sloping yield curve means that North Point Group should rely to short-term financing instead of long term financing.  In fact, by short term financing, the manager can use cheaper cost of equity. It means that North Point Group should sell the purchased shares of Nike during the period of one year.
Ø In the case of value of equity, Cohen’s should use liquidation value in calculating value of equity.  Liquidation value per share is more realistic than book value because it is based on the current market value of the firm’s assets by using of balance sheet data. 
Market Value of Equity (E) Calculation:
E = Stock Price  x  Number of Shares Outstanding
= $42.09 X 271.5
= $11,427.44

This figure is should be used for market value of equity (E) rather than Joanna Cohen figure ($3,494.50).

-In the field of Debt’s Cost:
Ø In calculating value of debt, Cohen should have discounted the value of long-term debt that appears on the balance sheet. It means she should also consider the future value of total long term debt base on coupon rate.

To calculate total value of debt, the steps are as follows:

Market Value of Debt (D) Calculation:

I considered the total amount of Debt for all items which are included by a interest rate as follows:

-Current portion of long -term debt
-Notes payable
-Long - term debt
-Redeemable preferred stock

D = Current LT + Notes Payable + LT Debt (discounted) 
 = $5.40 + $855.30 + $435.9 + 0.3 
 = $1296.9

Using these figures, we can now find the market value of Nike Inc., and the company’s capital structure.

The Calculation of Weighs:

The weights of debt and equity are calculated using the market values of debt and equity as follows:

Weight of Debt (WD)


D + E = 1296.9 + 11,427.44 = 12724.34

WD = D/ D+E

WD = $ 1296.9 /$12724.34
= 10.2%

Weight of Equity (WE)
WE = E/ D +E
WE = 11,427.44/ 12724.34
     =89.8%

 Cost of Debt

There are two types of interest rate for Nike, Inc. as follows:


1) For Notes payable, Current portion of long - term debt and Redeemable preferred stock, all these debts should be cleared during the period of maximum 12 months. Therefore, I calculated the interest rate in accordance with Exhibit 1(Income Statement) for 2001 year as follows:


Interest rate = Interest payment / Operating income
Cost of Debt = Interest rate = (58.7 / 1014.2) * 100 = 5.78%
You can see this interest rate is approximately equal to 20 year yields on U.S Treasuries  
(Exhibit 4).


2) For Long - term debt, Nike, Inc. had issued the Bonds in which the Cost of debt was calculated by finding the yield to maturity on 20-year Nike Inc. debt with a 6.75% coupon semi-annually. I assumed Nike Inc. to have a single cost of capital since its multiple business segments (shoes, apparel, sports equipment, etc.) are not very different and would experience similar risks and betas.

Before-Tax Cost of Debt

I used three (3) methods as follows:
-Method (1):  Using Cost Quotations Based on Coupon Interest Rate and Yield to Maturity (YTM)

Cost of Debt = 14.14%

-Method (2): Based on calculating the IRR
Cost of Debt = 14.15%

-Method (3): Approximating the Cost Based on the Value Bond and Coupon Rate

Cost of Debt = 14%
All of the calculations have been included in my spreadsheet.
 
 

Note:  “All spreadsheets and calculation notes are available. The people, who are interested in having my spreadsheets of this case analysis as a template for further practice, do not hesitate to ask me by sending an email to: soleimani_gh@hotmail.com or call me on my cellphone: +989109250225. Please be informed these spreadsheets are not free of charge.”

 

 
As we can see, all three methods present us approximately the same amount of the cost of debt. I have chosen 14.15% for the cost of debt. 

It is important to find the relationship between the required return and the coupon interest rate. When the required return is greater than the coupon interest rate, the bond value will be less than its par value. We choose cost of debt as 14.15% because it is rational (coupon value annually is 13.50%).  When current value of bond is less than par, required return will be more than coupon rate.


Weight Average of Cost of Debt:


As I mentioned, there are two types of debt and consequently we have two types of Cost of Debt. I calculated the weight average for Cost of debt as follows:


Total debt type 1 = $5.40 + $855.30 + 0.3 = $861 
Total debt type 2 = $435.9 
Total debt = $1296.9


W (type 1) = (861 / 1296.9) * 100 = 66.4% , Cost of Debt (type 1) = 5.78%
W (type 2) = (435.9 / 1296.9) * 100 = 33.6% , Cost of debt (type 2) = 14.15%


Weight Average of Cost of Debt = (66.4% * 5.78) + (33.6% * 14.15) = 


3.84 + 4.75 = 8.59%


Therefore, the Cost of Debt is equal 8.6%

After-Tax Cost of Debt
Cost of financing must be stated on an after-tax basis.  Because interest on debt is tax deductible, it reduces the firm’s taxable income.



ri =rd x (1 –T)
  =8.6% x (1 – 38%)
  =5.33%

Cost of Equity

I have calculated the cost of equity by using of two methods as follows:
Ø Capital Asset Pricing Model (CAPM)

Ø Constant-Growth Valuation (Gordon) Model
 
 To be continued…….

Saturday, June 11, 2011

Case Analysis of Compass Records: A good strategy Implementation (Con)


Now, let me write all “Treats” and “Weaknesses” in accordance with the case to analyze SWOT matrix (W – T) as follows:

Treats

T1: “The $32 – billion music recording industry was dominated by a handful of large, multinational corporations, which accounted for 86 percent of the market for global recorded music”
T2: “The global market for recorded music had stagnated ever since”
T3: “According to the Recording Industry Association of America (RIAA), the industry had registered no growth in any single year since 1995.”
T4: “By 2003, the recorded music sector had shrunk to 1993 levels ($32 billion), and annual dollar sales were estimated to have declined at a compound annual growth rate of 5 percent.”
T5: “And yet something like 98 percent of all records sell fewer than 5,000 copies, so if your benchmark is a million, or even 100,000, you’re obviously overlooking a lot of good music that sells well enough to deserve being out there.”


Weaknesses

W1: “Within the context of the global music business, Compass Records was tiny (very low market share).”
W2: “Brown estimated that 40 percent of Compass Records’ albums sold 5,000 units or more.”
Regarding to W –T analysis, we can mix all above mentioned to find out a new strategy as follows:
(T1, T2, T3, T4, T5, W1, W2)

New Strategy: Compass Record should focus on target sales of 5,000 copies and follow up the variety of albums. In fact, the new strategy is to increase the number of albums and target sales of 5,000 copies instead of going up the sales for an individual album.
This strategy can be translated to a combination strategy included all Intensive strategy in which we have Product development + Market penetration + Market development. It is clear, this is Corporate Level Strategy (C.L.S) of company as the strategy in action. For Business Level Strategy (B.L.S), Compass Records can gain competitive advantage from Focus strategy – Type 4 or 5 (Michael Porter’s Five Generic strategies) in which strategies such as Market penetration and Market development offer substantial focusing advantages. But we have also added Product development and we do not usually use market penetration and market development accompanied by product development strategy to be exchanged to focus strategy (type 4 or 5).
What is going on?

Here, I can say to you: “Sometimes small firms are supported by large multinational corporations, even though all of them are the competitors.”

This is just like to an Umbrella. In the field of structural engineering, it is the similar to Hanging Bridges or refers to my article of “

"The Supporter Systems (sleepers) in the Nature for Tunneling" on below link:


 in the field of geotechnical engineering.

How can we expand this strategy to other goods?


Let me focus again on the characters of this market:

-Sales unit benchmark for 86 percent of market is 1000,000 or 100,000
-The growth rate of revenues has been declined and stagnated
-The same raw materials with the variety of finished goods
-Consumer price is approximately the same for all different products

The good strategy:

Regarding to above factors of market, major multinational corporations allow the small firms as well as utilize from scare resources such as land, labor, capital and entrepreneurship to produce the finished goods in which scare resources are the same the recorded albums.
Only you should find out the target sales of goods in market for instance, in this case, it is 5,000 copies from each album.
When the cost of goods sold has a significant increase (high PPI), we should care about the least sales units as target sales and look at the benchmark of major competitors in which two important factors are dominated:
1) The variety of goods with the same raw materials
2) The same price of different products


 

Note:  “All spreadsheets are available. The people, who are interested in having my spreadsheets  of this case analysis as a template for further practice, do not hesitate to ask me by sending an email to: soleimani_gh@hotmail.com or call me on my cellphone: +98 9109250225. Please be informed these spreadsheets are not free of charge.”



Monday, May 23, 2011

Case Analysis of Compass Records: A good strategy Implementation

When we are willing to analysis the case of Compass Records, we encounter the huge data.

There are some cases which present us so many data and assumptions but sometimes we do not need to use all data to analyze them. But in the case of Compass Records, we have to care about all data and utilize them to analysis this case.

In my opinion, the most crucial approach of this case is to design and plan a true income statement in accordance with all data for both financial strategies (to license artist’s music for a limited period of time or to produce and own the artist’s master recording outright). As the matter of fact, the designing of these income statements are the similar basic and detail engineering of a project in the field of Engineering science (the engineers who have the designing experiences, can understand the concept of my opinion). 

After preparing of these income statements, we should forecast them for next 4 and 5 years in accordance with the case’s assumptions. Then we will calculate cash in and cash out flows to obtain net cash flows. Finally, we should calculate Payback, IRR and NPV for each strategy by using of net cash flows. 

How can we design the income statements by using of data?

At the first, we should write all assumptions and data as follows:

-Sale units

-Average unit price

-Sales

-Variable costs

-Fixed costs

-Dividends

Then, we should insert all above data into an income statement framework.

Here are my results of case analysis:

Scenario (A):  The record label licensed

-Payback = 3.73 year

-IRR = 15%

-NPV = $3942.1

Scenario (B): To produce and own a master recording

-Payback = 2.45 year

-IRR = 22%

-NPV = $45808.8

Therefore, scenario (B) will be ok.



Note (1):  “All spreadsheets are available. The people, who are interested in having my spreadsheets of this case analysis as a template for further practice, do not hesitate to ask me by sending an email to: soleimani_gh@hotmail.com or call me on my cellphone: +98 9109250225.. Please be informed these spreadsheets are not free of charge.”


Note (2): As you can see through my spreadsheet, I did not consider 1500 units which will be sold by Roscommon by herself. Why? There were two reasons as follows:

- I should make a new template of spreadsheet for 1500 units while the impact of the result was negligible. If we use from same template of excel, the unit price for 8500 units will be equal to $9.93  whereas we have the unit price for 1500 units  just equal to $ 6.85. It means that  we will lose our net profit for both status ( A &B) by selling of 1500 units. Therefore,the direction of  the case analysis result for 10,000 units will be the same to 8500 units. 

-Since Compass will sell only 5000 units throughout the USA, it is not logical and accurate in accordance with the Marketing Management issues in which the additional sales approximately equal to third of 5000. It means that there is the probabilities which are assigned to the people are purchasing the albums form Compass or Roscommon, will be the same people.




Why did I choose this case?
Because I found a good strategy implementation in this case as follows:

As you can see, the case of Compass Records stated:

“The trouble with those huge corporations is that they have to have enough sales volume on a release……”

Usually we do not use from W – T section of SWOT analysis as the new strategies in action.

In the next my article, I will illustrate this strategy implementation and I will tell you how we can expand it as a new strategy for other goods and services so.