- ILM Unit-409: focused on understanding the impact of development on workplace performance: Managing Personal Development, Coursework, UOS, UK
- ILM Unit-409: focused on implementing and evaluating planned development activities and apply learning in the workplace: Managing Personal Development, Coursework, UOS, UK
- ILM Unit-409: focused on identifying and prioritising work-related development requirements: Managing Personal Development, CourseWork, UOS, UK
- 7PS032: Identify type of study design needed, including within or between groups where relevant: Research Methods Course Work, UOW, UK
- 7PS032: What do the means, range and standard deviations show?: Research Methods Course Work, UOW, UK
- 7PS032: You need to write a research proposal. It must be a quantitative research proposal: Research Methods Course Work, UOW, UK
- MN0493: Report the major points of your discussions with the client. This should include the construction of the portfolios: Investments and Risk Management Course Work, NUN, UK
- DAT7303: In portfolio 3, students must complete 4 tasks related to analysing a dataset using CRISP- DM methodology: Data Mining Course Work, UK
- BUSI 1475: Your task is to identify and select an article from the BBC News website (news.bbc.co.uk): Management in a Critical Context Course Work, UOG, UK
- COMP6029: Computer Science and Electronic Engineering related subjects generally use the IEEE referencing style: Network Systems Course Work, UOS, UK
- UMACTF-15-M: You have recently been appointed as a Financial Analyst for a leading investment bank in London: Corporate Financial Strategy Course Work, UWE, UK
- BAM5010: choose an organisation and make some recommendations for the delivery: Work Based Project Course Work, UOB, UK
- You are required to calculate ratios for Fresh Farms Ltd: financial Course Work, UK
- Understand the legal, ethical and theoretical context for health, safety and risk management: leadership and Management Course Work, UK
- P3 Describe the types of training and development used by a selected business: BTEC Business Extended Diploma Pearson Course Work, UK
- Describe how a selected business identifies training needs: BTEC Business Extended Diploma Pearson Course Work, UK
- Discuss your chosen business, background information and why you have chosen that business: BTEC Business Extended Diploma Pearson Course Work, UK
- Activity 7: Risk management in an organisation should be both sensible and proportionate to the level of risk involved: NEBOSH IDIP ID1 Research Paper Course Work, OU, UK
- Activity 6: Reviewing health and safety performance Critique your chosen organisation’s health and safety: NEBOSH IDIP ID1 Research Paper Course Work, OU, UK
- Activity 5: Management of contractors Review how your chosen organisation selects contractors and manages them while they are on site: NEBOSH IDIP ID1 Research Paper Course Work, OU, UK
MN-M024: You are required to build models in an Excel worksheet: Financial Modelling Coursework, SU, UK
| University | University of St Andrews (UOSA) |
| 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 University of St Andrews (UOSA) student struggling with your MN-M024: Financial Modelling coursework? Don’t worry – our assignment writing help service in the UK is here to support you. We understand the complexities of building financial models in Excel worksheets, and our team of experts is ready to assist you. By paying our professionals, you can receive personalized guidance and ensure that your coursework meets the requirements of your SU course. Say goodbye to stress and hello to top-notch grades with our trusted finance assignment help.
Answer
