Perform a risk evaluation on the base case npv in the form

Assignment Help Finance Basics
Reference no: EM132461571

The assignment consists of two individual practical tasks where students are required to apply capital budgeting techniques and perform a risk analysis on a project. The timed assignment will be available on the course site for a specified period only.

Assessment Task #1: Natural Amalgamated

Role and Context You are a financial analyst in the capital projects department of Natural Amalgamated Chemicals (NAC), a speciality chemicals producer of fire-control substances, additives, and pesticides based in Queensland. NAC is currently considering these two possible projects, both of which will be used to manufacture furfural (an organic compound derived from agricultural by- products) and furfural-based derivatives to make resins, urethanes, and refining solvents over a 10- year operating period. Currently, NAC is small in scale and cannot take both projects, however the management is eager to embark on a rapid expansion and modernization program.

The second project, the Mackay Plant, is a modification of an existing plant NAC already owns in the city of the same name in north Queensland. The Mackay Plant has been idle for many years, but with renovation would be well suited to furfural production. If not used for the proposed project, NAC will lease out the existing plant for $60,000 after tax per year. The estimated development and construction costs are $15 million this year in 2020, alongside with the investment in plant and equipment of $5 million. NAC will again need to invest in working capital. The change in net working capital is 4% of sales every year. Sales will be $45 million in 2021, the first year of production, increasing by 7% per annum thereafter. Given the relative geographic isolation of the plant and the stricter environmental controls given the proximity to the Great Barrier Reef, the cost of goods sold is 75% of sales. Fixed costs are $5 million in 2021, increasing by 4% per year. The buildings and plant/equipment will again be depreciated straight line to zero over the 10-year project life. The renovated buildings will have no salvage value and the plant and equipment have 20% salvage value. At the end of the project, the Mackay Plant will revert to being idle awaiting potential future developments at no cost. The company tax rate in Australia is 30%.

Task

Briefly outline the benefits/limitations of each project and recommend to NAC's CFO, Ms. Alexandra Robinson, whether NAC should invest in these projects, if any. Your recommendation should be supported by appropriate calculations. Assume NAC has a cost of capital of 12% for domestic projects and 15% for international projects.

Assessment Task #2: Smart Water

Role and Context You are a newly hired financial analyst with Smart Water Group (SWG), a company operating in most states of Australia, which specialises in bottling purified water sourced from local water springs. SWG is considering adding to its product mix a ‘healthy' bottled vitamin water geared towards children, aimed at improving both its business focus and the return to shareholders.

Assessment Task

Question 1) The CEO and CFO have decided to rely on your newfound expertise as to recommendation on the appropriate discount rate to be used in evaluation of the new project.

Question 2) Concerned about the forecasting risk of this project, they also ask that you perform a risk evaluation on the base case NPV in the form of: - Sensitivity analysis for sales price, variable costs, fixed costs and unit sales at ±10%, ±20%, and ±30% from the base case, showing on a graph which variables are most sensitive; - Scenario analysis on the following two scenarios:

Part 1) Worst Case: selling 925,000 units at a price of $1.80 and variable cost of $0.65 per unit;

Part 2) Best Case: selling 1,550,000 units at a price of $2.25 and variable costs of $0.49 per unit.

Question 3) Finally, advise the CEO and CFO whether this project is an acceptable investment taking in consideration the capital budgeting technique used and the risk analysis performed.

Attachment:- Assessment - Smart Water.rar

Reference no: EM132461571

Questions Cloud

Calculate the 90 percent confidence interval : Calculate the 90 percent confidence interval for the true mean metal thickness. (Round your answers to 4 decimal places.)
Find a 90 percent confidence interval for µ : Problem: A random sample of 16 pharmacy customers showed the waiting times below (in minutes).
What are the cultural norms of a tattoo parlor : What is the material culture that can be observed in a skateboard park? What underlying values or beliefs does this material culture support?
Calculate the beta of stock : Problem - Based on the chart, the beta of stock A's return is:
Perform a risk evaluation on the base case npv in the form : Briefly outline the benefits/limitations of each project and recommend to NAC's CFO, Ms. Alexandra Robinson, whether NAC should invest in these projects
Compared with their academic achievement levels : The correlation of IQ scores and academic achievement was positive. Thus, it could be said that the IQ scores had?
What is the probability that whole shipment : If a particular shipment of thousands of aspirin tablets actually has a 5?% rate of? defects, what is the probability that this whole shipment will be? accepted
What impact workplace diversity have on legal organization : What impact workplace diversity have on legal organization?In what ways is workplace diversity and culture paramount for modern day law firms?
Probability that at least four of the subjects experience : Find the probability that at least four of the subjects experience headaches. Is it unusual to have fewer than four subjects experience? headaches?

Reviews

len2461571

2/22/2020 12:55:10 AM

Create one file using MS Excel ensuring: o The file contains two worksheets, named Task 1 and Task 2

Write a Review

Finance Basics Questions & Answers

  How to contribute to crisis in savings institution industry

What has happened to the value of savings institutions' charters in the period of time since October 1979?

  How low would the interest rate on the loan

If the interest rate on the $200,000 loan is 12 percent, how low would the interest rate on the loan with the compensating balance have to be in order for you to choose it?

  What is the bond price if the market interest rate increase

Bond valuation) Assume that Barclays Plc. issued coupon bonds with fixed coupon rate 5 percent redeemed at par (£100) in 5 years.

  Evaluate the payback period for the project

McKenna Sports Authority is getting ready to produce a new line of gold clubs by investing $1.85 million. the investment will result in additional cash flows.

  What will be their optimal upper cash limit

Hollywood Shoes would like to maintain their cash account at a minimum level of $50,000, but expects the standard deviation in net daily cash flows to be $4,000.

  Capital budget decision models

1. Contrast the strengths and weaknesses of each capital budget decision models

  Equivalent annual cost if the required rate of return

The operating cost is $47,000 a year. Ignore taxes. What is the equivalent annual cost if the required rate of return is 12.5 percent?

  Complete the portfolio performance measure

Can someone please help me with this question? Complete the portfolio performance measure with each of the following categories:

  Calculate the value of cost of goods sold

Calculate the value of cost of goods sold for Peterson Brewing given the following information: Current liabilities = $340,000; Quick ratio = 1.8; Inventory turnover = 4.0; Current ratio = 3.3.

  What is the weighted cost of capital

The company's captial structure is comprised fo 40% debt, 30% equity and 30% preferred stock. What is the weighted cost of capital?

  Why is it desirable to pretest survey instruments

Why is it desirable to pretest survey instruments? What information can you secure from such a pretest?

  What is the yield to maturity

Various calculated Bond Yields are listed as Answer along with name of each type of yield as questions. Your task is to match the appropriate Answer with Question.

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