Financial Modelling Case Study

완료 등록 시간: 4년 전 착불
완료 착불

Background:

As an Investment Professional, you have been approached by your Senior Manager to analyze a potential club-style equity investment into Symantec Corporation as part of a wider diversification strategy, which partially complements KSA’s vision 2030 program

• Your key relationship General Partner (“GP1”) has been monitoring the asset for quite some time and has been able to gauge interest from Symantec management to potentially form an equity syndicate alongside one other General Partner (“GP2”), management and XYZ for a large take-private transaction

• As part of the process, your Senior Manager has asked you to provide a high-level investment analysis and form an underlying recommendation to be provided to the Investment Committee of XYZ to determine commercial and strategic feasibility

Investment Analysis

• Investment Model Requirements

− Operating Model (3-year historical; 5-year projected using your own sensible assumptions; base and downside case model preferred)

i. Please use provided equity research and industry reports to determine projections of KPIs and underlying rationale

− Valuation Model (DCF & Trading Comps Analysis)

− Deal Structuring & LBO Model (Pro forma IS & CF projected statements sufficient)

i. Please determine purchase price assumption on the basis of preceding valuation analysis and provide your own rationale on what premium to current market price would be sensible

ii. Take private transaction assuming 75/25 equity split between Partners/Management & XYZ (view on common equity structure versus SHLs)

iii. Please provide your own contemplated capital structure (i.e. debt/equity split at entry including types of debt and equity instruments to support deal structure with what you think is achievable in the current market environment considering the underlying asset)

− IRR and MM sensitivity

i. Please sensitize returns analysis with changes in underlying KPIs

• Presentation Deck Requirements (1 slide each for each point)

− Business and KPI overview

− Investment Highlights & Risks

− Qualitative view on structuring considerations/acquisition tactics and recommendation (minority vs. majority vs. full LBO)

− Valuation analysis and conclusion with complementary discussion

− Sources & Uses + Pro forma IS and CF statement with complementary discussion

− Returns Analysis and Investment Recommendation (both from commercial & strategic viewpoint)

Format:

• Case presentation and investment model to be submitted to PER

− You will be given 48 hours (preference over the weekend) to complete the task

− Please send to PER a copy of the presentation and the investment model

− Attached a number of research reports which you may find helpful, feel free to use additional sources available to you but please do not use any private non-public information

기업 분석 금융 분석 금융 Financial Modeling

프로젝트 ID: #23372656

프로젝트 소개

18 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

수상자:

charleslimnet

Dear esteemed client, I possess exceptional financial analysis skills and experience. I have successfully completed over 2000 related projects and the responses are positively overwhelming as you can see from my review 기타

$380 USD (3일 이내)
(262건의 리뷰)
7.2

이 일자리에 대한 프리랜서 18 명의 평균 입찰가: $357

khurram1984

"CHECK MY SAMPLE WORK (DELIVERY TIME: 48 HOURS) Hi. I am ranked among Top Business Plan & financial model writers with 400+ project awards on freelancer. I have read your requirements mentioned in the project details. 기타

$400 USD (3일 이내)
(331 리뷰)
7.8
ShahzaibKhalid1

*** FINANCIAL MODELING ON EXCEL (NPV, IRR, FCF, DCF, DVM, EV, LBO, M&A and Sensitivity Analysis + more) *** I am ACCA Member and Certified Financial Modeling and Valuation Analyst (FMVA) from Corporate Finance Institu 기타

$750 USD (5일 이내)
(28 리뷰)
5.8
Freelancersedo

Dear client? I will assure you of good quality that is free from any errors and plagiarism. I will provide an originality report to confirm that. I have  access to enough journals to use in your financial modelling cas 기타

$250 USD (3일 이내)
(65 리뷰)
5.6
waseemdhatoo

I have incredible expertise in helping start-up companies & growing businesses get their vision and story told to potential on looking investors! In the modern business environment, effective communication is essentia 기타

$389 USD (6일 이내)
(9 리뷰)
5.2
topacademictutor

Hi, Hope you are fine I have 12 years of experience in the Writing Industry and I can provide you “SUPREME QUALITY WORK” within your “GIVEN DEADLINE” with “PERFECT GRAMMAR” and “ZERO PLAGIARISM”. I have 650+ "EXCELLE 기타

$250 USD (1일 이내)
(48 리뷰)
5.2
Amrsamra

Hello I*`m CMA holder and financial analyst can u msg me please to share some details ty

$500 USD (10일 이내)
(52 리뷰)
5.0
tianaonline

Hi! I have checked your requirements on this Financial Modelling Case Study. I have checked the details and so far the idea is clear enough. Do you have any additional instruction sheet? The PDF files you have shared a 기타

$250 USD (2일 이내)
(11 리뷰)
5.2
josh20114

Hi, I have more than 7 years experience in financial modeling, financial analysis, and equity research. Hence, I can provide you with high-quality work. I have ready samples for your review. Regards

$250 USD (4일 이내)
(23 리뷰)
4.7
Valuesolutions

Hello, how are you? I hope you have a bright day/evening from your side. I have read the details provided, but please contact me so that we can discuss more on the project. I believe I have the required skills in this 기타

$250 USD (5일 이내)
(21 리뷰)
4.8
amybrownthatsit

Hi! I have gone through your project details on this financial modeling. The idea is clear so far but what about the company? Have you selected any company? What about the presentation? Do you have any additional guide 기타

$250 USD (2일 이내)
(9 리뷰)
4.7
ResearchDoll

Hi, I’m Ghulam, I’m an MBA holder in Finance, many clients approach me to get their detailed financial analysis of businesses. I will completely assess the viability, stability, and profitability of a business, sub-bus 기타

$250 USD (7일 이내)
(13 리뷰)
4.9
SUMMERISEME

If you are reading this proposal, it’s a success already! I have checked the project description and attached file on this case study. BUT, it lacks a few information, like a detailed guideline, Class notes, marking 기타

$250 USD (2일 이내)
(8 리뷰)
4.6
writingstudio22

I am a multi-skilled person with sound proficiency in English language for being a native writer and proofreader while I am also well-versed in French and Portuguese languages. Furthermore, I am a PR professional with 기타

$250 USD (5일 이내)
(8 리뷰)
3.2
atyourservice475

Let's chat and discuss regarding the project .I can assure you A grade quality work. Running Academic writing firm since 2005. Have served over 200,000 of students all over the world in their online course and degree. 기타

$250 USD (1일 이내)
(1 리뷰)
1.6
AwaisChaudhry

Hi, I have read the brief details on the job listing. I am a full stack web developer with 9 years of coding experience. I have worked with multiple similar jobs before. I have completed 150+ major projects just on thi 기타

$750 USD (9일 이내)
(0 리뷰)
0.0
writiqueproject

Hello, I have read the details of the project Financial Modelling Case Study and I will complete the task perfectly with my 6+ years experience in it. I am pleasure with your job as detailed. Thank you for the job post 기타

$250 USD (2일 이내)
(0 리뷰)
0.0
genius1226

Dear sir. I read your project description very carefully. I've really rich experience in Financial Modeling Programming, so your project is very interesting to me. I'm really confident about your project, and very eage 기타

$500 USD (7일 이내)
(0 리뷰)
0.0