ITC556 Database Systems Assignment Help
Delivery in day(s): 4
In this finance business group assignment we will have clear idea about the project vulnerability which an organization could elect out of the following investment options. There are various methods and means which are used in this project report to develop an effective business decision to find out several inflows and outflows of the company throughout the time. In the starting of this finance business project report we will discuss details of Emu Electronics which is working in selling electronics items in the growingindustry. Different cost of equity and cost of debts have been calculated to determine that cost of capital of the company HCL owned by Bob. In addition to this Pure play approach has been used in this file to represent the data of HCL and all the relevant data to compute financial analysis Harvey Norman Company’s annual report has been taken into consideration.
Payback period is the time required to collect the cash invested in acquiring project which is done by calculating the time engaged in generating adequate amount of cash inflows to cover the total outflow made in business life cycle. In the other term it is the simple ways to evaluate the risk associated with a proposed project. The payback period is calculated in terms of years or fraction is converted in months (Stubbs, 2011).
Calculation of IRR  Amount($) 
Year 0  35450000 
Year1  4023214.286 
Year2  6906887.755 
Year3  5407366.071 
Year4  4697066.327 
Year5  52381249.63 
IRR  19% 
Calculation of payback period

Profitability index is also known with its other name profit investment ratio and value driven investment ratio. It is the tools or method to give the ranking to vulnerability of the project in orderly manner. This index is the simple measures to identify the project effectiveness in terms of its cash inflow and particular investment amount in the given time span.
Profitability index = present value of cash inflow/ present value of cash outflow
75069650/108388240.9=1.4438357
The IRR stands for internal rate of return on a project. It is used to determine the rate of return of the project at which Net present value of the project will be zero. In this project report I have calculated all the possible IRR and the idol IRR should be 19 % (Byung, et. AL., 2013).

Net present value is the amount which is the sum of the discounted cash inflow deducted with the original investment made in the initial time period of the project.
Net present value factor will be 30907178.21. This calculation is made by considering all the possible factors which is necessary for finding the present value of the investment made and the following inflows received throughout the time.
Total outflow of the project will be


If price of the product sold in the market is being changed then there will be following changes to the amount of NPV which could be seen with the help of below computation.
In this case price of the product rate has been changed to$ 500. Therefore company has seen increment in the net present value.

NPV will be changed to 33318591 when there is made 5 % changes in the quantity of the product sold in the market by the company (Zhang, et. Al., 2012).

As per the details available to us we would find that Net present value of the project undertaken is positive. Therefore EMU electronics produce the new smart phone.
In this case we would be considering all the relevant cost of the project and profits derived by the company from the entireproject. There is need to measures all the possible benefits to the Emu electronics by selling all of its products in the market and then comparative analysis would be implemented to analysis the benefit of selling new products in the market and losses occurred due to loss in selling of other outdated models.
With the help of the complete analysis I would say that in order to maintain the adequate sell of other models in the phone industry company needs to keep the price of the product very high so that other buyers who are ready to buy give existing models could go for that. Therefore it could be said that if new model of the phone impacts sell of other model offering in the market analysis then company need not to invest its money in developing a new model phon.
Case study: In this scenario we are given that I have been hired in the treasury management department in the Hubbard Computer Ltd which was founded 8 years ago by the BOB. This company makes sales of the product to the customers who walks in store and talk with representative. Here in this case study we are asked to determine the cost of capital involved in the project. But Hubbard Computer Ltd is a private company whose shares are not listed on the ASX security exchange nor are even proper books of accounts maintained. Now bob wants to know the real cost of capital and advise us to use the pure play approach to estimate the cost of capital for Hubbard Computer Ltd. We have been given instruction to evaluate the cost of capital of the company by undertaken all the details of Harvey Norman as a representative company ( Block, 2011).
Book value it is the amount of debts and equity are the amount shown in the balance sheet of the company. With the help of the annual report of Harvey Norman we could say that company is having following book value of its capital structure
Equity capital structure
Particular  2014 Amount(“000)$  2015 Amount(“000) $ 
Contributed equity  380,328  259,610

Reserves  113,290  102,735

Retained profits  25 2,043,463  2,109,032

Controlling interest  2,537,081  2,471,377

Noncontrolling interests  26 19,779  19,729

TOTAL EQUITY  2,556,860  2,491,106 
Debt capital structure
Particular  2014 Amount(“000)$  2015 Amount(“000) $ 
Interestbearing loans and borrowings  290,000  238,094 
Cost of Equity: The cost of equity is the amount required to pay for holding the cash in the company’s operation. Shareholders are the actual owners of the company who accepts definite amount of return on their investment. The return they require from the company in return of their investment made in the company process is called cost of equity.
Cost of Equity = Risk free rate of return + Beta of Asset * (Expected Return of market – Risk Free Rate of Return)
The 10 years Treasury constant maturity rate can be used as the risk free rate for the company. Therefore the Risk Free rate as per updated Treasury Constant Maturity Rate is 2.48%.
Beta of the company is the sensitivereturn to the company and it is calculated on the basis of market share and its return to the shareholder in the significant time period.
It denotes the risk of the returns of company. The beta of Harvey Norman.7465.
The Market premium which is given to us could be computed with the help of given data which is between 4 to 6%.
It is the different between market rate of return and company’s rate of return.
In this project report we have taken market premium return is 4 %
Thus Cost of Equity = 1.75% + .7465 * 4.5%
= 5.11%
The most recent stock listed price for the shares for Harvey Norman is 5.12.
Market value of the equity is also called market cap therefore with the help of annual report data we could say that Harvey Norman market capitalization is $4539.224 Million (Febijanto, 2013).
Harvey Norman is having 1112.56 million shares outstanding during the year 2105.
Annual dividend of the company is 17 cents.
Yes we can easily use this model to estimate the price of the share in the given time period. There is following formulas given in this report which could be used todeterminethe price of the share.
5.12=100/X14.30=5.11
There for with the help of this computation we could say that cost of equity is 5.11.
Beta of the Harvey Norman is 0.7658
Yield on government debts is also known risk free investment bonds and yield is not fixed rate. It is varied with the type of guilt securities throughout the time. Yield on the government debts increased with the increment of the time period of the investment made. The average rate which could be used for determining the yield on government debts is 1.75 %.
Cost of Equity = Risk free rate of return + Beta of Asset * (Expected Return of market – Risk Free Rate of Return)
For determine the risk free rate of return we have taken The 10 years Treasury constant maturity rate that can be used as the risk free rate for the company. Therefore the Risk Free rate as per updated Treasury Constant Maturity Rate is 1.75%.
Beta of the company is the sensitivereturn to the company and it is calculated on the basis of market share and its return to the shareholder in the significant time period(weighted average cost of capital 2014).
It denotes the risk of the returns of company. The beta of Harvey Norman is .7465.
The Market premium which is given to us could be computed with the help of given data which is between 4 to 6%.
It is the different between market rate of return and company’s rate of return.
In this project report we have taken market premium return is 4.5 %
Thus Cost of Equity = 1.75% + .7465 * 4.5%
= 5.11%
The cost of debt is very easy to calculate. In order to determine the actual cost of debt we first need to take different average of debts and interest rate then calculation will be made to decide the actual cost of debts. The interest expense of the company is $33327.22 millionthe average value of its debt is $ 561947 Million. (Elena, 2014).
This calculation is made on the basis of market value of the debts shown in the balance sheet of the Harvey Norman.
Particular  Amount of debts(Millions )  Interest rate  Interest rate amount(Millions) 
Financial lease  139  9.50%  13.21 
Borrowings  561808  5.92%  3331521 
Total  561947 
 33327.22 
Weighted average cost of debts of HarveyNorman would be 33327.22/561947*100=5.94%
Particular  Amount of debts  Interest rate  Interest rate amount(Millions) 
Financial lease  2900000000  5.33%  17197000 
Total  290000 
 17197000 
The Weighted Average Cost of Capital is the rate that a company is expected to pay on to all its securities holders to finance its assets. By using this information we could easily estimate the how much interest company’s paying to hold capital for the smooth running of the business in the long run. With the help of the formula given we could easily show the weighted average cost of capital of the company(Cuthbert, & Magni, 2016).
Weighted Average Cost of Capital
WACC = Equity/ (Equity + Debt) * Cost of Equity + Debt/ (Equity + Debt) * Cost of debt (1tax
Rate)
2556860/2,556,860+290000000*5.13 + 290000000/2,556,860+290000000*5.94/1.30
26.3169+ 5.88= 8.41 (Bas, . 2013).
Pure play method is a method used to estimate the beta coefficient of a company whose stocks are not publically traded on the securities stock exchange. Pure play method is used to represent data of HCL and Harvey Norman has been taken as representative company(Mawih, 2015).
In this finance for business group assignment we have understood various problems related with the cost of capital of the HCL limited owned by BOB. With the help of the given data I have understood the different pure play approach in which HarveyNorman has been taken as a representative company of HCL limited. There are several calculation is made to determine the cost of capital and market capitalization of the company. In addition to this I have gone through all the sensitiveinformation given in annual report of the company and measured several changes occurred in the capital structure of the company for understanding HCL cost of equity and debts of the HCL. Now I would like to end my report by saying that annual report is the complete set of information which represents company’s capital structure and its various corporate governance activities in identified manner.
Bas, E. 2013, "A robust approach to the decision rules of NPV and IRR for simple projects”, Applied Mathematics and Computation, vol. 219, no. 11, pp. 59015908.
Block, S. 2011, "Does the Weighted Average Cost of Capital Describe the RealWorld Approach to the Discount Rate?", The Engineering Economist, vol. 56, no. 2, pp. 170180.
ByungCheol, K., Euysup, S. &Reinschmidt, K.F. 2013, "Probability distribution of the project payback period using the equivalent cash flow decomposition", Engineering Economist, vol. 58, no. 2, pp. 112.
Chang, C., Lin, H., Tzeng, C., Yang, K., Chuah, Y. & Ho, M. 2012;2011;, "Energy saving and payback period for retrofitting air conditioning systems in Taiwan", Trans Tech Publications Ltd, Zurich, pp. 2850.
Cuthbert, J.R. &Magni, C.A. 2016, "Measuring the inadequacy of IRR in PFI schemes using profitability index and AIRR", International Journal of Production Economics, vol. 179, pp. 130140.
Febijanto, I. 2013, "?Economic system of Cikaso Mini Hydro Power Plant as A CDM Project for Increasing IRR", Mechatronics, Electrical Power, and Vehicular Technology, vol. 4, no. 2, pp. 8998.
Mawih Kareem Al Ani 2015, "A Strategic Framework to Use Payback Period (PBP) in Evaluating the Capital Budgeting in Energy and Oil and Gas Sectors in Oman", International Journal of Economics and Financial Issues, vol. 5, no. 2