November 19, 2016
David Marks
- Business
0

Investment Assessment Help

Emu Electronics is a producer of electronics goods in Australia which is situated at Box Hill, Victoria. The company has started their business of electronics 50 years ago mainly in the household appliances and radio repairing sector. As per the given case the company earns their major revenue from the selling of the smart phones which is manufactured by the company itself. The smart phone they make are very much exclusive item in the market but recently they are facing a huge challenge due to the rapid change and development in the field of electronics. This pressure situation now forcing them to come up with a new prototype of the smartphone, which must have some key features like facility for Wi-Fi hotspot to compete with the market opponents (Walkowiak, 2003).

The complete monetary necessities for the market research and development for prototype of the new smart phone which the company will manufacture in the upcoming time:

Estimated development cost of the new smart phone = $7, 50,000

Estimated cost for the required research work on the new smart phones = $2, 00,000

Particular of the other costs estimated relating to the manufacturing of the smart phone by the company:

Variable cost per unit of smart phone = $205

Fixed cost assumed per year for the production of the smart phones = $5.1 million

Required primary investments to buy the equipment and machinery for developing the new phones = $34.5 million

Estimation of the selling of the new smart phones in year is given below:

*Year*	*Unit Sales*
First	64000
Second	106000
Third	87000
Fourth	78000
Fifth	54000

The assumption of the generation of the revenue for the company as per the estimated sales of the new smart phones per year:

*Year*	*Unit Sales*	*Revenue (in $)*
First	64000	1,31,20,000
Second	106000	2,17,30,000
Third	87000	1,78,35,000
Fourth	78000	1,59,90,000
Fifth	54000	1,10,70,000

After launching the new phone the cash flow of the company is being estimated and tabled below:

*Year*	*Cash Flow (in $)*
Primary Investment	-4,05,50,000
First	1,31,20,000
Second	2,17,30,000
Third	1,78,35,000
Fourth	1,59,90,000
Fifth	1,65,70,000

The expected flow of cash of the new product of the company and generated revenue as per the present market value is below:

*Year*	*Cash Flow*	*PVIF Calculator*	*Present Value of the cash flows*
Primary Investment	-40550000	1	-40550000
First	13120000	0.8929	11714847.52
Second	21730000	0.7972	17323155.68
Third	17835000	0.7118	12694953.24
Fourth	15990000	0.6355	10161644.97
Fifth	16570000	0.5674	9401818.14

Issue 1: Payback Period of the Project

The initial time period which is required for the recuperating the invested money in any business from the market is known as the Payback period. It is technique of recovering the initial investment from the market in as much as less time possible.

The payback period for any company is calculated with the help of “Payback Period Calculator” and in this case the payback period is also being calculated in the same process for the Emu Electronics (Romele, 2013).

As per the above calculations on the given data of the purchase and revenue estimation of the Emu Electronics for their new smart phone business, the payback period for the company is = 2.908.

So it can be studied from the above assumptions that the Emu Electronics needs minimum two years and few months to recover their initial investment in the new project of making smarter phones.

Issue 2: Probability Index of the Project

The investment assessment of any business can be done in a different procedure which is the Probability Index method. In this method the relation between the cost which is used to establish the project and the revenue expected from that project is being identified and evaluated (Mu?ller-Fu?rstenberger, 1997).

The probability index of the project is calculated as a ration among the ‘Current values of cash flows’ to ‘primary investment’ essential for the project from the viewpoint of the fiscal management.

Profitability Index of the Project= (Current Value of Cash Flows / Primary Investment)

Calculation of the Probability index of the Emu Electronics for this project:

Current Value of Cash Flows:

$(11714847.52+17323155.68+12694953.24+10161644.97+9401818.14)

= $61296420

Primary Investment =$ 17450000

Profitability Index = (Current Value of Cash Flows / Primary Investment)

= ($61296420/$ 40550000)

= 1.51

So the probability index for the Emu Electronics for their new project of smart phones, is 1.51which is very much profitable from the company’s perspective.

Issue 3: Internal rate of return of the project

The other most popular techniques of calculating the investment assessment is the ‘internal rate of return’. If the ‘present value of cash flows’ for any business is zero then it is very easy to find out the suitable discount for the business as per the internal rate of return. It can also determine the probability of nay firm for the investments should be made for the new project or not (Romele, 2013).

As the above case the given rate of internal rate of return or IRR for the Emu Electronics is given 17% for their new project.

This IRR for the Emu Electronics for their new phone project is very high and it states that this project is very much profitable for the company.

Issue 4: Net Present Value of the Project

The best way to find the investment appraisal for any firm is the ‘Net present value’. In this method the difference among the present value of cash inflow and cash outflow can be easily determined. The net present value in considers the value of money and time in the calculation technique (Hock, 2005).

I this particular case the Net Present Value of the project of manufacturing and selling of new smart phones in Australia is calculated very well considering all the cash inflows and outflows of the Emu Electronics:

*Year*	*Cash Flow*	*PVIF Calculator*	*Present Value of the cash flows*
Primary Investment	-40550000	1	-40550000
First	13120000	0.8929	11714847.52
Second	21730000	0.7972	17323155.68
Third	17835000	0.7118	12694953.24
Fourth	15990000	0.6355	10161644.97
Fifth	16570000	0.5674	9401818.14

So the Net Present Value of the new project by the Emu Electronics is

= $[(13120000+21730000+17835000+15990000+16570000)-40550000]

=$ 20746420

So after the calculation it is sure that the cash inflow is better than the cash outflow and the value is positive. The value amount is very high so the profit margin for the Emu Electronics for their new venture of new smart phone is going to be hugely beneficial for the company.

Issue 5: Analysis and evaluation of sensitivity of net present value with respect to price change

The net present value of any product for the company mainly depends on the price of the product they are launching. The price of the product mainly changes the cash flow of the corresponding business for the company. So the cost flow and the price of the product has a direct relation if the price increases the cash flow will increase automatically and vice-versa.

In the following part the sensitivity of the Present value of the smart phone is discussed:

Sensitivity of NPV with a rise of 10% in the price then the value is $225.5

*Year*	*Cash Flow(in $)*	*PVIF @12%*	*Present Value of the cash flows*
Primary Investment	17450000	1	17450000.00
First	14432000	0.8929	12886333.20
Second	23903000	0.7972	19055471.85
Third	19618500	0.7118	1396444.40
Fourth	17589000	0.6355	11177810.00
Fifth	17677000	0.5674	10029930.28

For the increase rate 10% of the product the net present value of the product will be = $26563993

Sensitivity of NPV with a decrease of 10% in the price then the value is $184.5

Year	Cash Flow(in $)	PVIF @12%	Present Value of the cash flows
Primary Investment	-40550000	1	-40550000
First	11808000	0.8929	10543363.77
Second	19557000	0.7972	15590841.48
Third	16051500	0.7118	11425457.56
Fourth	14391000	0.6355	9145480.41
Fifth	15463000	0.5674	8773706.27

Now the Net present value for the decrease in the price will be = $14928847

Hence it can be easily understood that the NPV is directly connected with price of the product, increase or decrease in the price of the product will have a huge impact on the NPV of the company in that product.

Issue 6: Analysis of the Sensitivity in the NPV for changes in the selling quantity

Now the number of quantity sold have some great impacts on the net present value of the product. The selling quantity is also directlyrelated with the NPV. Increase or decrease in the quantity sold will change the NPV of the product for the company.

The sensitivity analysis for the NPV of the product on the basis of selling quantity of the product is calculated and described below:

10% rise in the unit sales of the smartphones

*Year*	*Unit Sales*	*10% increase in Unit Sales*	*New Revenue (in $)*
1^st year	64000	70400	14432000
2^nd year	106000	116600	23903000
3^rd year	87000	95700	19618500
4^th year	78000	85800	17589000
5^th year	54000	59400	12177000

Sensitivity of NPV calculation with 10% increase in selling quantity

*Year*	*Cash Flow*	*PVIF @12%*	*Present Value of the cash flows*
Primary Investment	-40550000	1	-40550000
1^st year	14432000	0.8929	12886332.87
2^nd year	23903000	0.7972	19055470.56
3^rd year	19618500	0.7118	13964447.37
4^th year	17589000	0.6355	11177808.98
5^th year	17677000	0.5674	10029929.88

Now form the above calculation for 10% hike in the selling quantity the NPV of the product for the company will be = $26563995

10 % fall in the unit sales of the product

*Year*	*Unit Sales*	*10%decrease in Unit Sales*	*New Revenue (in $)*
1^st year	64000	57600	11808000
2^nd year	106000	95400	19557000
3^rd year	87000	78300	16051500
4^th year	78000	70200	14391000
5^th year	54000	48600	9963000

Sensitivity of NPV calculation with 10% decrease in selling quantity

*Year*	*Cash Flow*	*PVIF @12%*	*Present Value of the cash flows*
Primary Investment	-40550000	1	-40550000
1^st year	11808000	0.8929	10543363.27
2^nd year	19557000	0.7972	15590840.45
3^rd year	16051500	0.7118	11425457.85
4^th year	14391000	0.6355	9145481.11
5^th year	15463000	0.5674	8773705.98

Now for the decrease by 10% in the selling quantity will make the NPV of cash flow of the product = $14928850

After comparison between the increase and decrease of the selling quantity it is well understood that the direct relation between the selling quantity and NPV has a huge outcome in cash of the cash inflow of the company.

Issue 7: Endorsement of the Product

From the above discussion and the cash inflow results it is sure that the business will be very much beneficial for the Emu Electronics. Evaluating all the financial investment assessment methods like Profitability Index, Net Present Value, Payback Period and Internal Rate of Return,it is found that the cash inflow of the company after launching the new smart phone will be huge. As the results are all positive the recommendation for the Emu Electronics for their new venture should be to go with this business and endorse their new product.

Issue 8: Analyzing the loss on selling other old Smartphone model

The necessary step to succeed in the business is to come up with something new always as the market demands. So by selling the old products the company may face some loss in there but the huge success of the new product will cover up the loss for them as per the above assumptions and calculations. Without hesitating about the losses the company should come with the new product which is going be a great hit in the market for them as analyzing is being done the different methods. All the investments assessments are carried out the new exclusive product for the company (Grigg, 2010).

Part B

Cost of capital (HCL)

Issue 1: First of all need to find the book value of the equity and debt

FY16 results had been published by the company and from that source the result has been given like;

Particulars	Jun-15 ($‘000)	Jun-16($’000)
Short term debt
Secured:
Non-trade amount
– Bank overdraft	32,620.00	36,243.00
– Commercial bills	9,750.00	9,750.00
– Syndicated Facility	1,70,000 .00	2,60,000.00
– short-term borrowings	1,01,808.00	1,02,110 .00
Lease Liabilities	139 .00	364 .00
Unsecured:
Derivatives owed	4,104 .00	325.00
Non trade amount
– Directors	78,972.00	38,134.00
– Related party	10,956 .00	5,932.00
– Unrelated party	89 .00	177 .00
Total Short Term(S.T.) Debt	4,08,438 .00	4,53,035.00

Long term debt
Secured:
Syndicated Facility Agreement	2,90,000 .00	2,00,000.00
Lease liabilities		1,042.00
Total Long Term(L.T.) Debt	2,90,000 .00	2,01,042 .00

Total Debt	6,98,438 .00	6,54,077 .00

EQUITY
contribute equity	3,80,328.00	3,85,296 .00
Reserves	1,13,290 .00	1,55,814 .00
Retained pr	20,43,463 .00	21,25,186.00
Parent entity interests	25,37,081 .00	26,66,296.00
Non-controlling interest	19,779 .00	22,378 .00
TOTAL EQUITY	25,56,860 .00	26,88,674 .00

It can be identified that the book value of debt in FY16 is equals to $6, 54,077,000.00 approx

And the equity is equals to $26, 88,674,000.00 approx

As on the 23^rd Sep value of the current share price of Harvey Norman is equals AUD5.20 (from yahoo finance)

The market capitalization: AUD 5,774,159,999
Outstanding share number = 1, 112, 555, 911
Annual devident is basically:
Final dividend + interim dividend = AUD 0.3

Dividend discount model: This is the model where expected dividend of future will be discounted at the rate or cost of the equity as according to the current market value of those stocks. DDM needs three major inputs which are:

Growth rate –> Current dividend –> Current price of the share

According to source Bloomberg: Yield on Government debt = 2.034

Cost of equity is basically defined:

Risk free rate + market risk premium * Beta of each stock

As already get the value of the Rf and risk free rate so can easily find the market risk premium. According to the excel sheet calculation as per ASX 200 market returned will be estimated easily.

6% market return value and the risk premium is = 6% – 2% = 4% approximately

Cost of equity = 2% + 4%*0.75 = 5% approx

Issue 2: Interest rate market rate

In $’000		Interest Rate	Jun-16	Interest
Borrowings		5.25%	5,62,110	29,455
Other Loans		5.25%	44,243	2,318
Bank Overdraft		6.45%	36,243	2,334
Bills payable		5.25%	9,750	511
Finance Lease liabilities		5.25%	1,406	74
Other financial liabilities		5.25%	325	17
Total			6,54,077.00	34,709.00

Book value Pre tax cost of debt	5.30%
(Calculated Interest/Debt)

(Yahoo! Finance – Currency Conversion, 2016)

[www.westpaccom source it can be found]

Issue 3: Interest rate

From the annual report cost of debt can be easily identified as according to the given market rate. In according with FY16 (published) pre tax debt will be as per below;

In $	Jun-15	Interest rate	Mid pt	Jun-16	Interest rate
Borrowings	5,61,808	0.47% – 5.93%	3.20%	5,62,110	17,988
Loans	90,017	3.07% – 4.22%	3.65%	44,243	1,613
Overdraft	32,620	1.97% – 6.68%	4.33%	36,243	1,568
Bills paid	9,750	2.08% – 2.72%	2.40%	9,750	234
Lease liabilities	139	9.50%	9.50%	1,406	134
financial liabilities	4,104	5.21% – 5.54%	5.38%	325	17
Total	6,98,438			6,54,077	21,553.00

Pre tax cost of debt	3.30%
(Calculated Interest/Debt)

In order to check the market value and book value will be found market and debt value of the equity. Market value and debt value weights are also differs and since debt value will not being traded in the market can find market and book value weights.

	Book Value	Weights	Market Value	Weights
Debt	6540,77,000	19.7%	6540,77,000.00	10.3%
Equity	26886,74,000	80.4%	57741,59,988.00	89.8%
Total	33427,51,000		64282,36,988.00

According to the both book value and market value weights cost of debt can be identified as well like;

Weighted avg book value = 19.7% * 5.3% = 1.03%
Weighted avg market value = 10.3% * 5.3% = 0.54%
According the Annual report the interest value based like as per FY16:
Weighted avg book value = 19.7% * 3.3% = 0.66%
Weighted avg market value = 10.3% * 3.3% = 0.35%

Issue 4: Weighted avg cost of capital description

From the internet source of www.westpac.com

	Book weights	Pre tax	Post tax	Market weight	Pre tax	Post tax
Debt value	19.7%	5.31%	3.72%	10.3%	5.30%	3.72%
Equity value	80.4%	5.0%	5.00%	89.8%	5.0%	5.0%
Cost of capital value	4.8%			4.9%

Assume the data from the report of FY16 as;

	Book weights	Pre tax	Post tax	Market weights	Pre tax	Post tax
Debt value	19.6%	3.30%	2.31%	10.2%	3.30%	2.31%
Equity value	80.4%	5.01%	5.01%	89.8%	5.01%	5.01%
Cost of capital value	4.5%			4.7%

The yahoo source and FY16 annual report value as approximately same as earlier mentioned.

Issue 5: Capital cost

In according to calculate the major value of cost of capital and weighted capital, market value and book value here as a respective company Harvey Norman had being used. Using the pure play approaches it has been clearly identified and according to see the chart of FY16 it has been identified as well (Editorial data, 2002).

Actually here the two companies are different but the market value of both same and also cost of capital of those company mismatches to some level. Peripherals Company as Harvey Norman and Computer Company as HCL is also not exact type of companies, both are different in nature, so market value, book value should be different also.

The cost of the capital should be differing as the value of the cost of the capital based on the past data and it can be reflected in the future also.

References

Bams, D., Walkowiak, K. and Wolff, C. (2003). More evidence on the dollar risk premium in the foreign exchange market. London: Centre for Economic Policy Research.
Cornell, B. (1999). The equity risk premium. New York: Wiley.
Drury, E., Denholm, P. and Margolis, R. (2011). The impact of different economic performance metrics on the perceived value of solar photovoltaics. Golden, CO: National Renewable Energy Laboratory, U.S. Dept. of Energy, Office of Energy Efficiency and Renewable Energy.
Editorial data. (2002). Journal of Banking & Finance, 26(1), p.viii.
Editorial Data. (2006). Journal of Banking & Finance, 30(1), p.xi.
Grigg, N. (2010). Infrastructure finance. Hoboken, N.J.: John Wiley & Sons.
Hock, R. (2005). Yahoo! to the max. Medford, N.J.: CyberAge Books/Information Today.
Humphreys, B. and Howard, D. (2008). The business of finance Westport, Conn.: Praeger.
Life-cycle cost and payback period analysis for commercial unitary air conditioners. (2004). .
McMath, H. and Zeller, T. (2011). Estimating Investment Growth Rate And Conditional Internal Rate Of Return. JABR, 9(4), p.39.
Meckin, D. (2007). Naked finance. London: Nicholas Brealey Pub.
Mu?ller-Fu?rstenberger, G. (1997). The payback period rule. Bern: Universita?t Bern, Abteilung fu?r Angewandte Mikroo?konomie.
Perrin, R. (2008). Real world project management. Hoboken, N.J.: John Wiley & Sons.
Pratt, S. and Grabowski, R. (2008). Cost of capital. Hoboken, N.J.: John Wiley & Sons.
Romele, L. (2013). Estimation of Internal Rate of Return (IRR) to Investments in Education in Latvia.International Journal of Social Science and Humanity, pp.1-4.
Yahoo! Finance – Currency Conversion. (2002).