- Network Threats and Vulnerabilities, UNIS, Coursework
- Corporate Finance and Business Valuation Coursework
- 5301ELE Digital System Evaluation Coursework, Level 5, LJMU 2024
- Power Electronic Applications and Control Coursework 1 2024
- PE7007 Construction Economics, Coursework Brief – 2024/2025 , NU, UK
- Level 3 Diploma in Adult Care, Coursework, UK: Understand the application of personcentred practices in care settings
- Decide whether each of the following statements is true or false. Justify your answer in each case by giving an example or stating any general result seen at the lecture: Mathematics, Coursework, NU, UK
- 7CO03: Critically assess different ethical standpoints on people practice and the maintenance of high standards of ethical behaviour: CIPD level 7 , Coursework, UK
- SQE2: Oral Skills-Written Skills- Apply the law comprehensively to the client’s situation, identifying any ethical and professional conduct issues: Reflective Portfolio, Coursework, UK
- SQE 1 Preparation: Portfolio Assessment-analyse and reflect upon your development of the practical legal skills that the Solicitors Regulation Authority (the SRA) : Reflective Portfolio, Coursework, UK
- DSM120: Financial Data Modelling, Coursework 1, UK
- DSM070: Building the Blockchain: the chain, mining, and the consensus mechanism: Blockchain Programming, Coursework 3, UOL, UK
- FHEQ Level 7 ES5800 – Systematic review protocol In this assessment you are asked to write a systematic review protocol: Analytical skills for Environmental Managers, Coursework, BUL, UK
- FHEQ Level 7 ES5800 – Data analysis As part of your learning activities in the autumn 2023 term, you have measured reaction times using the ruler drop test among athletes: Analytical skills for Environmental Managers, Coursework, BUL, UK
- FHEQ Level 7 ES5800 – Analytical skills for Environmental Managers, Coursework, BUL, UK
- CIPD – 5CO02: Quantitative and qualitative analysis review: Evidence-based practice, Coursework, MOL, UK
- CIPD – 5CO02: You are to produce a report that provides the Senior Management team with knowledge and understanding of what evidence based practice: Evidence-based practice, Coursework, MOL, UK
- CIPD – 5CO02: Your manager has just returned from the monthly Senior Management meeting where all departmental heads have been asked to present a report: Evidence-based practice, Course Work, MOL, UK
- To apply the concepts covered during the lectures to practical reactor engineering design problems: Advanced Reaction Engineering, Coursework, LSBU, UK
- In this part of the coursework, you will determine the mechanism and develop a rate law for a catalytic reaction from experimental data: Advanced Reaction Engineering, Coursework, LSBU, UK
MN-M024: You are required to build models in an Excel worksheet: Financial Modelling Coursework, SU, UK
Subject | MN-M024: Financial Modelling |
General requirement and description:
This assignment consists of two parts. In Part A, you are required to build models in an Excel worksheet, whereas in Part B, you are required to write a report based on Part A to explain source of information, modelling method and calculation of results.
The total word count of the report, excluding tables and references, should be no more than 3,750 words. A word count must be provided on the cover page.
Part A – Creating the Excel workbook
A.1 – Financial statement analysis
You are an analyst at the corporate banking department of a consulting firm. You are required to build a valuation forecast model and arrive at a valuation calculation for one of following four companies: Persimmon plc, BAE System plc, Tesco plc, NEXT plc.
The data Collect all data required from internet and company’s annual reports.
Tasks In Excel worksheet, complete the following tasks:
a) Clearly indicate your assumptions of Capex for fade period.
b) Complete an income statement forecasting model.
c) Complete a balance sheet forecasting model.
d) Complete a cash flow statement forecasting model.
e) Calculate key ratios, WACC.
f) Perform cash flow valuation.
g) Perform sensitivity analysis.
Do You Need Assignment of This Question
A.2 – Modelling the yield curve
You are a corporate finance analyst in an investment bank. One of the bank’s clients is interested in raising $5m of debt financing through the issue of a bond. The bond would have a face value of $1000, a maturity of 15 years, and a coupon rate of 5.5%.
The company has a credit rating of A. Your manager wants you to estimate the
number of bonds that the company would have to issue in order to fulfil the financing requirement.
The data
The data file contains details on all A-rated bonds issued by US companies, except for those with very short maturity.
Tasks In Excel worksheet, complete the following tasks: Assume that the current date is 4 Oct 2014.
h) Plot and estimate a third order polynomial trend for the YTM.
i) Use the estimated yield curve to estimate the YTM that the new bond would
have.
j) Use the estimated YTM to compute the fair price of the bond.
k) Calculate the number of bonds that the firm would have to issue to raise $5m.
Buy Answer of This Assessment & Raise Your Grades
Are you a student in the UK struggling with report writing? Don’t worry, you’re not alone. Many students find report writing to be a challenging and time-consuming task. But there’s no need to despair! Students Assignment Help UK can provide you with the report writing help you need to get the job done right. We have a team of experienced writers who are familiar with all the ins and outs of report writing. So, get in touch with us today, and let us help you get the report you need!