Blue Corn Manufacturing Ltd is in the business of automobile and other ancillary services. The company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Blue Corn Manufacturing Ltd is in the business of automobile and other ancillary services. The company wants to start its subsidiary business in China as an expansion plan for assembling the auto part. The company's Chief Operating Officer (COO) after taking into consideration the firm's portfolio of investments has derived a Weighted Average Cost of Capital (WACC) of 12% as the appropriate discount rate for calculating the firm's Net Present Value (NPV). Given the uncertainties surrounding Brexit and the current COVID-19 pandemic, the firm's COO has asked you, the risk analyst to model the following uncertain inputs, using appropriate probability distribution functions. Following a detailed analysis of the firm's historical data, you have decided to use the following distributions and parameters to model the uncertain inputs: Table 1: Uncertain Inputs and Parameters of Distributions Uncertain Inputs Investment Cost Year 1 Revenue Annual Fixed Cost Annual Revenue Growth Rate Annual Variable Percentage Cost Distribution Triangular Triangular Triangular Normal Normal Parameter 1 £90,000 £80,000 £32,000 5% 50% Parameter 2 £100,000 £100,000 £35,000 8% 2% Parameter 3 £150,000 £110,000 £38,000 Use the following Sampling Settings: Sampling Type: Latin Hypercube. Random Number Generator: Mersenne Twister. Initial Seed: Fixed at 12345. For the purpose of this coursework, you are required to do the following: 1. Calculate the Discounted Cash Flows (DCF) for 10-years and derive the Net Present Value using the uncertain input variables. (5 Marks) 2. Perform a single simulation of 10,000 iterations for the NPV model and determine the probability of getting a negative (zero) NPV at 95% Confidence Interval (2 Marks) 3. Perform sensitivity analysis for the NPV output to determine the variable with the largest impact on NPV (Biggest Driver of NPV) using the following: a) Change in Output. (2 Marks) b) Regression Coefficient. (2 Marks) c) Correlation Coefficient. (2 Marks) d) Contribution to Variance. (2 Marks) Total (15 Marks) Write a Report to your COO to communicate the findings from your analyses. The report should describe the purpose and result of your analyses. A well written report will demonstrate your ability to: a) Literature Review: Gather, evaluate and analyse relevant information. Relevant concepts explored, clear and progressive discussion and critical evaluation evidenced. (25-Marks). b) Findings and Discussion: Make correct conclusions that are supported by the evidence and analyses of the report. Professional and clear presentation of findings. Progressive discussion grounded in appropriate theory. (25-Marks) c) Recommendations: Cyclical closure evidenced. Discussions are adequate in scope, well underpinned by the project analyses and reflect an understanding of the report's essence. Strengths & limitations assessed-recommendations made with due consideration of the context. (20-Marks). d) Presentation: Structure material in a coherent and logical manner supported with relevant diagrams. (10-Marks). e) Referencing: Follows the Harvard Style. Sources properly referenced and acknowledged within the text. (5-Marks) Blue Corn Manufacturing Ltd is in the business of automobile and other ancillary services. The company wants to start its subsidiary business in China as an expansion plan for assembling the auto part. The company's Chief Operating Officer (COO) after taking into consideration the firm's portfolio of investments has derived a Weighted Average Cost of Capital (WACC) of 12% as the appropriate discount rate for calculating the firm's Net Present Value (NPV). Given the uncertainties surrounding Brexit and the current COVID-19 pandemic, the firm's COO has asked you, the risk analyst to model the following uncertain inputs, using appropriate probability distribution functions. Following a detailed analysis of the firm's historical data, you have decided to use the following distributions and parameters to model the uncertain inputs: Table 1: Uncertain Inputs and Parameters of Distributions Uncertain Inputs Investment Cost Year 1 Revenue Annual Fixed Cost Annual Revenue Growth Rate Annual Variable Percentage Cost Distribution Triangular Triangular Triangular Normal Normal Parameter 1 £90,000 £80,000 £32,000 5% 50% Parameter 2 £100,000 £100,000 £35,000 8% 2% Parameter 3 £150,000 £110,000 £38,000 Use the following Sampling Settings: Sampling Type: Latin Hypercube. Random Number Generator: Mersenne Twister. Initial Seed: Fixed at 12345. For the purpose of this coursework, you are required to do the following: 1. Calculate the Discounted Cash Flows (DCF) for 10-years and derive the Net Present Value using the uncertain input variables. (5 Marks) 2. Perform a single simulation of 10,000 iterations for the NPV model and determine the probability of getting a negative (zero) NPV at 95% Confidence Interval (2 Marks) 3. Perform sensitivity analysis for the NPV output to determine the variable with the largest impact on NPV (Biggest Driver of NPV) using the following: a) Change in Output. (2 Marks) b) Regression Coefficient. (2 Marks) c) Correlation Coefficient. (2 Marks) d) Contribution to Variance. (2 Marks) Total (15 Marks) Write a Report to your COO to communicate the findings from your analyses. The report should describe the purpose and result of your analyses. A well written report will demonstrate your ability to: a) Literature Review: Gather, evaluate and analyse relevant information. Relevant concepts explored, clear and progressive discussion and critical evaluation evidenced. (25-Marks). b) Findings and Discussion: Make correct conclusions that are supported by the evidence and analyses of the report. Professional and clear presentation of findings. Progressive discussion grounded in appropriate theory. (25-Marks) c) Recommendations: Cyclical closure evidenced. Discussions are adequate in scope, well underpinned by the project analyses and reflect an understanding of the report's essence. Strengths & limitations assessed-recommendations made with due consideration of the context. (20-Marks). d) Presentation: Structure material in a coherent and logical manner supported with relevant diagrams. (10-Marks). e) Referencing: Follows the Harvard Style. Sources properly referenced and acknowledged within the text. (5-Marks)
Expert Answer:
Answer rating: 100% (QA)
1 Calculate the Discounted Cash Flows DCF for 10years and derve the Net Present Valve using the uncertain input variables To calculate the DCF for 10 years we need to first calculate the annual cash f... View the full answer
Related Book For
Business Statistics a decision making approach
ISBN: 978-0133021844
9th edition
Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry
Posted Date:
Students also viewed these finance questions
-
A company is in the business of making souvenir spoons to customer order. The customers select the size of the spoons and may specify the design to be embossed on them. One or more spoons may be...
-
A company is in the business of machining parts that go through various work centers. Suppose work center A feeds work center B with parts. The following times (in minutes) are given for each work...
-
The ABC Investment Company is in the business of making bids on investments offered by various firms that want additional financing. ABC has tabulated its bids on the last 25 issues in terms of their...
-
15. Show that the frequency of revolution of the electron in the Bohr model hydrogen atom is given by v = 2|E|/hn where E is the total energy of the electron. 16. Show that for all Bohr orbits the...
-
Why is accident running considered to be so sleazy? Is it really as bad as the press makes it out to be?
-
How many of part J will be needed if 40 units of end item A are needed? Managers have decided to outsource part G. Revise the BOM for end item A, assuming that item G is now purchased from a...
-
Suppose that in the maintenance of a large medicalrecords file for insurance purposes the probability of an error in processing is 0.0010, the probability of an error in filing is 0.0009, the...
-
The following financial statement information was prepared for Blue Corporation and Sparse Company at December 31, 20X2: Blue and Sparse agreed to combine as of January 1, 20X3. To effect the merger,...
-
You are given that xp0 = 1 - ( x /105)2, 0 x 105. What is the probability of (25) dies between ages 54 and 55 OR survives to at least age 55?
-
Recently Santa Fe, New Mexico, was named one of the safest places to live in the United States. Since then, housing development projects have been springing up all around Santa Fe. Six housing...
-
1 Hermione Corporation produces and markets two types of electronic calculators: Model 11 and Model 12. The following data were gathered on activities last month: Sales in units Selling price per...
-
Mr. Trent transferred three apartment buildings to a new corporation in exchange for all its stock. The facts pertaining to the buildings were: a. What gains are realized and recognized on each...
-
The Maximo Business shows the following amounts in its owner's equity accounts at the end of December: R. Maximo, Capital, \(\$ 45080\); Revenues, \(\$ 80220\); Expenses, \(\$ 59920\). Required: Set...
-
The beginning balance in the S. Carton, Capital account on 1 March of the current year was \(\$ 36800\). For March, the Carton Business reported total revenues of \(\$ 12800\) and total expenses of...
-
At the end of September, the Cyclops Bicycle Company's records showed a cash balance of \(\$ 3513\). When comparing the 30 September bank statement, which showed a cash balance of \(\$ 1860\), with...
-
At the end of March, the Elbert Company records showed a cash balance of \(\$ 7027\). When comparing the 31 March bank statement with the business' Cash account, the business discovered that deposits...
-
A property receives a $100,000 gross annual income. It has a 50% operating expense ratio, $25,000 interest expense, and $25,000 depreciation. The net operating income is A) $50,000. B) $100,000. C)...
-
A line l passes through the points with coordinates (0, 5) and (6, 7). a. Find the gradient of the line. b. Find an equation of the line in the form ax + by + c = 0.
-
You are given two paired samples with the following information: Based on these paired samples, test at the = 0.05 level whether the true median paired difference is Item Sample 1 Sample 2 234 245...
-
Recent news stories have highlighted errors national companies such as H&R Block have made in preparing taxes. However, many people rely on local accountants to handle their tax work. A local...
-
What sample size is needed to estimate a population mean within 50 of the true mean value using a confidence level of 95%, if the true population variance is known to be 122,500?
-
Classify these Bluetooth layers using the OSI model: a. baseband; b. L2CAP; c. RFCOMM.
-
Use the power state machine of Fig. 8.12 to determine the energy used in these use cases: a. idle 1 s; receive 10 ms; idle 0.1 s; transmit 5 s; b. sleep 1 min; receive 50 ms; idle 0.1 s; receive 100...
-
What are the main phases of a design review?
Study smarter with the SolutionInn App