financial modelling ONLY PROFESSIONAL ! 16th Dec 9 am needed!!!
£10-20 GBP
Completato
Pubblicato più di 7 anni fa
£10-20 GBP
Pagato al completamento
General requirement and description:
This 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.
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 that the current date is 14 November 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.
A.3 – Portfolio optimisation
You are an analyst in a US fund management company that specialises in global equity investment. The company is considering launching a new fund, the ‘G7 Equity Fund’, which will invest in a broad selection of large stocks in the equity markets of the G7 countries (US, UK, Japan, Germany, France, Canada and Italy). Your manager has asked you to establish the efficient frontier for these markets, both with and without a risk free asset. As a proxy for the investment in each market, you decide to use the aggregate equity return index for each market.
The data
The data file contains the adjusted close prices for the seven indices. Ignore exchange rate fluctuations (you could assume that the currency risk is perfectly hedged).
Tasks
In Excel worksheet, complete the following tasks:a) Use the return index data to compute monthly simple returns.
b) Use the return data to compute the covariance matrix for the seven markets.
c) A significant problem with applying portfolio optimisation in practice is that sample estimates of expected returns are very noisy, and hence not reliable. The fund company has, using another approach, estimated the following expected monthly returns for the G7 markets: Using the above information, compute the efficient set. Graphically estimate the efficient frontier of the seven equity markets both with and without a risk free asset. Obtain the US risk free rate from Yahoo! Finance for a three-month holding [login to view URL] a report that provides a critical summary of the computations and results from Part A. In particular, you should describe in detail how you carried out the tasks in
Part A and a discussion of the results obtained. .....
Greetings !
I am a "Dean Scholarship" recipient for business graduate studies from a leading public university in New York, USA. I am CFA (Level 2) USA certified chartered financial analyst. I am expert in financial modelling and have carried out equity research in UBS for a number of industrial sectors. I have access to Bloomberg, Financial Times, Wall Street Journal and Thomson Financial databases.
I have prepared business plans for a number of start ups as well as for established companies planning to venture to new geographies. I have prepared comprehensive granular level market research data especially for Australia, United Kingdom, EU, United States and Canada geography specific businesses.
I have got published 40 articles in my name in Economic Times (leading finance/business daily), UK based forex traders' journal and in international USA academic journal. Few of my recent publications are :
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
I have headed chairman's office of a large listed company in Singapore.
£150 GBP in 2 giorni
4,9 (27 valutazioni)
5,2
5,2
4 freelance hanno fatto un'offerta media di £207 GBP
Greetings!
I am qualified Accountant with ten years of experience in accounts and financial analysis. Please PM me to discuss the project further. Thank you.
I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extensive experience and knowledge in corporate finance, accounting, financial statements, financial analysis, modelling, projections etc.
So lets discuss this project in detail and start at your earliest convenience. I can guarantee you the best possible work in least possible price.