We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: support@assignmentbank.co.uk after completing this order process.
0% Plagiarism Guaranteed & Custom Written
This consists of 60% of the overall module mark.
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:
Uncertain Inputs
Distribution
Parameter 1
Parameter 2
Parameter 3
Investment Cost
Triangular
£90,000
£100,000
£150,000
Year 1 Revenue
£80,000
£110,000
Annual Fixed Cost
£32,000
£35,000
£38,000
Annual Revenue Growth Rate
Normal
5%
8%
Annual Variable Cost
Percentage
50%
2%
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:
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)
The report should have the following features:
Title page
Terms of reference Summary (Abstract) Table of contents Introduction Methods
Results and Discussions (include the relevant diagrams, graphs or tables that support your results).
Conclusion and Recommendations. References
Note: An electronic copy must be submitted via “Turnitin” on GCU-Learn on or before 5pm Friday January 7th 2022. Failure to submit an electronic copy will automatically constitute a fail. Please refer to the University Guidelines on plagiarism.
Any coursework not submitted by the due date will be zero marked unless an approved MITS
is submitted for consideration by the Assessment Board
What is a Report: A report is written for a clear purpose and to a specific audience (in this case an uninformed audience). You are advised to use a clearly structured format making use of sections and headings so that the information is easy to locate and the flow is coherent. Calculate the Discounted Cash Flows (DCF) for 10-years and derive the Net Present Value using the uncertain input variables.
The Structure of the Report Title Page: This will include:
Terms of Reference: Under this heading you could include a brief explanation of who will read the report (audience), and why it was written (purpose). Given that this is an academic piece of work the terms of reference will include:
“A report submitted in fulfilment of the requirements for the module Bank Operational Risk Management (MMN324977), Department of, Finance, Accounting and Risk, Glasgow Caledonian University”. In addition to other elements listed above.
Summary (Abstract): The summary should briefly describe the content of the report. This will cover the following:
Note: The summary should provide the reader with a clear, helpful overview of the content of the report.
Table of Contents: The contents page should list the different headings together with the page numbers. This should be presented in such a way that the reader can quickly scan the list of headings and locate a particular part of the report. You can use whatever numbering system you choose.
Introduction: This should include all the relevant components of an introduction including: The aims and objectives, any necessary background history, amongst others.
Methods: This will include explanations of procedures followed; relevant information on the modelling process, amongst others. Keep in mind that you are writing to an uninformed audience.
Results and Discussion: This section should include a summary of the results of the Discounted Cash Flows modelling together with any necessary diagrams, graphs or tables of data that support your results. This should be presented in a logical order with your discussions. You can also use appendix to show more graphs or tables. Discussion: The main body of the report is where you discuss your material. The facts and evidence you have gathered from your literature review should be analysed and discussed with specific reference to the problem or issue. If this section is lengthy you might divide it into section headings. All sources used should be acknowledged and correctly referenced (using the Harvard referencing style).
Conclusion and Recommendation: In the conclusion and recommendation section, you should show the overall significance of what has been covered. You may want to reiterate the most critical points in the report. Make recommendations based on your a Calculate the Discounted Cash Flows (DCF) for 10-years and derive the Net Present Value using the uncertain input variables.nalysis. You can choose to highlight what you consider the most central findings from your report and the possible limitations of the analyses
Aspect
Mark Available
Mark Awarded
Comments
1
Building of the DCF Model and the Use of @Risk for Risk Analysis: Single Simulation of 10,000 Iterations. Report Probability of a Zero NPV.
7%
2
Perform Sensitivity Analysis for NPV output and Report the Following:
a) Change in output
b) Regression Coefficient
c) Correlation Coefficient
d) Contribution to Variance.
3
Literature Review: Gather, evaluate and analyse relevant information. Relevant concepts explored, clear and progressive discussion and critical evaluation evidenced.
25%
4
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.
5
Conclusion and 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—
20%
Financial Risk Modelling Essay Feedback 2021/22 Essay Title: Discounted Cash Flow Modelling and Sensitivity and Risk Analysis
Plagiarism Report
Formatting
Bibliography
Outline
Limitless Amendments
Get all these features for £83.00 FREE
View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains