GB-530: CORPORATE FINANCE FINAL PROJECT GUIDELINES
Objective:
The primary object
GB-530: CORPORATE FINANCE FINAL PROJECT GUIDELINES
Objective:
The primary objective of this project is to perform a comprehensive stock evaluation using the Discounted Cash Flow (DCF) model. The DCF model is a widely-used method for estimating the intrinsic value of a stock based on its future cash flows.
Scope:
This project will involve collecting financial data, forecasting future cash flows, determining the discount rate, and ultimately valuing the stock through the DCF model. The analysis will provide insights into the potential investment value of the stock.
Project Phases:
1. Data Collection:
1.1 Financial Statements
● Gather historical financial statements (income statement, balance sheet, and cash
flow statement) for the past 5-10 years.
● Ensure data consistency and accuracy.
1.2 Market Data
● Collect relevant market data such as risk-free rates, market risk premium, and beta
for the stock.
2. Financial Analysis:
2.1 Historical Performance
● Analyze historical financial performance, identifying trends and anomalies.
● Calculate key financial ratios (e.g., profitability, liquidity, leverage).
2.2 Cash Flow Forecasting
● Project future cash flows, considering revenue growth, operating expenses, and
capital expenditures.
● Apply sensitivity analysis to account for uncertainties.
GB-530: CORPORATE FINANCE FINAL PROJECT GUIDELINES 3. DCF Model Application:
3.1 Trinity of Cash Flow Statements
● Income Statement
● Balance Sheet
● Cash Flow Statement
3.2 WACC Calculation 3.3 LBO Modeling
3.4 IRR Evaluation
Deliverables:
1. Comprehensive presentation on the entire analysis process.
○ Presentation must be 15-20 minutes with a group of size between 2-4.
○ Presentation must be 10-15 minutes with an individual presentation.
2a. Excel spreadsheet containing financial data, calculations, and the DCF model.
(or)
2b. Python/R code evaluation containing financial data, calculations and the DCF model.
Conclusion:
This project aims to provide a thorough evaluation of the stock’s intrinsic value using the Discounted Cash Flow model. Regular communication, attention to detail, and rigorous analysis are crucial for the success of this project.