Evaluate the two options using NPV analysis

Assignment Help Corporate Finance
Reference no: EM132276921

BUSINESS FINANCE ASSIGNMENT -

In this assignment you will pull together your understanding of the main concepts in Business Finance and analyse financial statements to make some 'real' business decisions. Some of the figures used in the following scenario are real, some are not.

Scenario -

Your financial analysis team at BLD Wealth Group has been tasked by the executive management team to provide careful financial decision analysis for its client Tesla Inc. This will require preparing a business report which will be presented to the executive management of both BLD and Tesla Inc.

Background -

Read the following article from the Financial Review to get some background.

Article - Elon Musk's Tesla in breakthrough lithium off-take deal with Kidman Resources by Brad Thompson.

Kidman Resources is considering a binding agreement with Tesla inc. to supply 5000 tonnes of lithium hydroxide for three years. However in order process the required amount of lithium hydroxide, Kidman Resources must consider whether to build a new refinery or outsource their supply ore (Li20).

Kidman Resources has undertaken a feasibility study costing $2 million to explore these two strategies.

Option 1: Building a new refinery

The construction and installation of a new refinery will cost $25 million. In addition, a processing plant will also need to be constructed at a cost $5 million. This plant will need to be supplied with grinding machines, DMS flotation machines and other equipment at a total cost of $15 million. Kidman Resources' current fleet of Haul trucks, water carts and dump trucks will meet the needs for this project, however until recently, the fleet has been earning a rental income of $100,000 per year.

Under the agreement with Tesla inc., the lithium mined is expected to generate a revenue of $16 million per year, which will increase by 2.5% per annum adjusted for rising costs. Due to the additional complexities involved with the construction and management of this new refinery, 5 new engineers (yearly salary per engineer $180,000) will replace 5 existing engineers (yearly salary per engineer $120,000). All other remaining labour force required is expected to cost $3 million per annum for the duration of the project.

For tax reasons you will expense the cost of the processing plant immediately. The cost for the construction and installation of the new refinery and associated machines and equipment will be depreciated over three years using the straight-line method. Due to the nature of the mining project, the machines and equipment will likely have a salvage value of $9 million at the end of three years. Finally, the required net working capital is $2 million.

Option 2: Outsourcing the supply of ore

Alternatively, Kidman Resources can contract BHP to supply the required ore to process into lithium hydroxide. Based on the required amount of lithium hydroxide, management has quoted a total cost of $30 million. BHP has however offered this rate on the condition that Kidman Resources pays 20% of the total cost in advance in the beginning of the year, with the remaining paid in equal instalments thereafter. Kidman Resources will process the ore into lithium hydroxide using existing facilities at an expected cost of $4.5 million per year.

Your task -

Part A: To carry out an analysis, you will need to calculate the appropriate Weighted Average Cost of Capital (WACC). Kidman Resources executive management team are particularly concerned that the WACC be accurate, thus you are expected to determine the WACC based on recent market and other data. (Read below for additional information).

Part B: Carry out a detailed analysis of the two given options and make recommendations to Kidman Resources about those options.

To establish the WACC you have already assembled the following information

  • Previous year's stock exchange data for the market (ASX200) and for Kidman, adjusted for dividends and capitalization (Price Index). This data is organized in the file: Project Data.xlsx. Use this dataset to calculate beta. For CAPM purposes use the return on the market (%) provided in the next section.

Balance Sheet of Kidman Resources as of 30 June 2018

Extract of Balance Sheet for Kidman Resources

Issued Capital

$ million

405,000,000 Ordinary shares of $2.00 full paid

810.00

1,500,000 5% Preference Shares of $1.00 fully paid

1.50

 

 

Current Liabilities and Provisions

 

Bank Overdraft

4.00

Trade Creditors

6.00

Unsecured Notes

7.00

 

 

Non-Current Liabilities

 

Debentures

16.00

Term Loans

8.00

Mortgage

17.00

  • The company's preference shares are currently trading at $0.70 each. The company's ordinary shares are currently trading at $1.17 each.
  • The risk-free rate of return is 2.38 % p.a., and the return on the market is 7.80 % p.a.
  • Debentures have a coupon interest rate of 9% p.a. and could be re-issued at the present time at an interest rate of 8.5% p.a. The debentures will be redeemed at their face value in three years' time.
  • The mortgage loan is repayable in eight years' time and the current interest rate is 5.25% p.a. The mortgage was initially negotiated at 9.35% p.a.
  • Term loans have a current interest rate of 6% p.a., but were negotiated at an interest rate of 7% p.a. They are repayable in full in three years' time. The term loans consists of regular semi-annually interest payments with the principal repaid at maturity.
  • Unsecured notes will mature in six months and will not be replaced. They have a current interest rate of 2.8% p.a.
  • The current interest rate on the bank overdraft is 6.0% p.a.
  • Interest on all debt securities is paid twice-yearly and the corporate tax-rate is 28 percent.

Your assessment requirements -

Part A -

Calculate WACC: The first part of the analysis requires you to work out the Weighted Average Cost of Capital (WACC) for Kidman Resources. With the help of the given information and given data, you need to work out the individual costs1 and value of each of the sources of capital and apply that to the WACC equation to work out the overall weighted cost.

Part B -

Calculate NPV: Evaluate the two options using NPV analysis and clearly identify which of the two alternatives results in a higher valuation for Kidman Resources. Include your opinion.

Beta analysis: Describe in a short paragraph (less than half a page) what risks/events may cause Kidman's resources beta to significantly change. Assume due to some unforeseen event (as you may have described), the beta of kidman's Resources is now 20 % higher than your original estimates. Would this change your previous analysis? Describe

Part C -

Business Report overall quality.

The assignment is to be presented as a business report to both Kidman Resources executive management and BLD management.

Business reports are structured with:

  • an executive summary
  • table of contents
  • informative headings and sub-headings
  • numbered sections
  • page numbering
  • labelled graphs and tables (if used)
  • a reference list.

The main content of your report should be 3-4 pages, excluding appendix and be professionally presented. A concise, relevant and visually appealing paper is essential for business communication.

Regarding the WACC calculations, whilst you need to present your final work in a table in the main body of your report, all subsidiary calculations need to be provided in an appendix.

The report is to be submitted as a PDF version of your work.

It must use a font/fonts suitable for business communication. The reference style to be used is Harvard style referencing (author-date).

More specifically, your report in this case needs to set out the following:

1. An executive summary

2. A table showing the calculation of Kidman's WACC using market data.

3. A table(s) showing your NPV calcualtions of both Alternative 1 and Alternative 2.

4. A recommendation to Kidman Resource managements as to which alternative it should adopt.

5. An analysis of beta risk and any recommendations.

6. A reference list.

7. Appropriate appendices.

Attachment:- Assignment Files.rar

Reference no: EM132276921

Questions Cloud

Develop work breakdown structure for project : Develop a work breakdown structure (WBS) for a project to build new student housing for 300 students on campus at LTU in Southfield, Mi.
Parts of warehouse layout that are considered : Receiving docks, shipping docks, and a staging area are parts of a warehouse layout that are considered______________.
Reflect on your research - how to grow your business : Report and presentation must reveal that you understand your thesis, your research and utilize it in developing the analytical content of your paper
First-mover-first-follower or slow-mover : One of the competitive strategies to consider is whether to be a “first-mover,” “first-follower,” or “slow-mover.”
Evaluate the two options using NPV analysis : BUSINESS FINANCE ASSIGNMENT - Evaluate the two options using NPV analysis and what risks/events may cause Kidman's resources
How can a firm achieve sustained competitive advantage : Explain the relationship between strategic management and competitive advantage for firms. How can a firm achieve sustained competitive advantage?
Ethical values appear to be compromised by big box-bloggers : Which of the AMA ethical values appear to be compromised by Big Box and the bloggers. Read the AMA ethics information in chapter one.
What are the leadership traits that bring out best in people : Based on your experience, what are the leadership traits that bring out the best in the people around you? Why do you think these leadership traits work well.
Which job requires the highest level of emotional labor : Which factor is positively correlated with performance? Which job requires the highest level of emotional labor?

Reviews

len2276921

4/7/2019 10:50:31 PM

In this assignment you will pull together your understanding of the main concepts in Business Finance and analyse financial statements to make some ‘real’ business decisions. Some of the figures used in the following scenario are real, some are not. The point is to analyse the figures, whether they be provided or sourced.

len2276921

4/7/2019 10:50:23 PM

The main content of your report should be 3-4 pages, excluding appendix and be professionally presented. A concise, relevant and visually appealing paper is essential for business communication. The report is to be submitted as a PDF version of your work. It must use a font/fonts suitable for business communication. The reference style to be used is Harvard style referencing (author-date).

len2276921

4/7/2019 10:50:15 PM

Further guidelines - Refer to the tutorial/additional questions for the topics - Capital Budgeting and Cost of Capital to setup your spreadsheets for WACC and NPV analysis. Please round off your values to 4 decimal places for interest rates and 2 decimal places for amounts e.g. 0.0659 or 6.59%, and $10,369.78. All assessment of numerical work is marked consequentially. So, you will be awarded marks for all correct calculations and procedures. To calculate beta please see the video on canvas.

len2276921

4/7/2019 10:50:06 PM

Assignment requirements - This assessment contributes 40% to the total assessment for this unit. Your report must be submitted via Turnitin/CANVAS by 11.59 pm on the due date. Late submissions where special consideration has not been granted will be penalized. Please go through the course guide to understand the implications. You are very much encouraged to ask assignment questions in your tutorials. You are not allowed to ask any questions about this assignment in the lecture or emails. Emails regarding the assignment will not be answered. Again, please make use of the tutorials to address any questions you may have about your assignment.

Write a Review

Corporate Finance Questions & Answers

  What about financing sources

Using any approach that you find helpful, see how many of the unidentified industries you can identify. Why does each industry have its particular pattern of asset use? What about financing sources? Profitability?

  1 abilene corporation stock sells at a price of 80 a share

1. abilene corporation stock sells at a price of 80 a share and the riskless rate is 7. calculate the price of a

  Discuss the risks the delta airlines company faces

Using the annual report from the company that you have selected for your Final Project, discuss the risks the company faces and the actions they take to mitigate those risks.

  Explain value of the public communication in given situation

Explain the value of the public communication in this situation. Examine the balance between calming external stakeholders and the ethical considerations of providing all the information that is required by the SEC.

  Find predicted maximum probable loss

Bell Curve, corporation, determines the expected rate and standard deviation of its total liability losses for forthcoming year as $10 million & $3 million respectively.

  What is and expected return and variance of a portfolio

What is and expected return and variance of a portfolio which is equally weighted in investments of each of the three stocks?

  Compute the repricing gap for the bank

Compute the repricing gap for the bank using those assets and liabilities repricing or maturing in 2 years or less and what is the duration of assets

  Are dillons plans to announce earnings per share

Are Dillon's plans to announce earnings per share of $1.05 without mentioning the $0.20 impact of selling the land ethical and professional?

  Norman co a fast-growing golf equipment company uses us

norman co. a fast-growing golf equipment company uses u.s. gaap. it is considering the issuance of convertible bonds.

  Analyse the performance of gwa group

ACC10007: Financial Information for Decision Making Assessment: Company analysis report. The purpose of this assessment task is for your team to apply your ratio analysis and financial analysis skills to a real company. You will work in teams of th..

  What is the yield on 3-month treasury bills

Calculate the weighted average cost of capital for Dell using book value weights and market value weights assuming Dell has a 35 percent marginal tax rate.

  Name and briefly describe one type of policy in which

name and briefly describe one type of policy in which intertemporal preferences over consumption or production is

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd