Caesar's Entertainment Debt Financing
This debt vs. equity financing consultation project was given as part of my financial modeling course at the University of Texas, at San Antonio.
Tasked to determine a prudent source of financing for a target company, Caesar’s Entertainment, the due diligence process revealed that the casino gaming industry overwhelming employs the use of debt financing to fund new projects and enhance growth opportunities.
Armed with the knowledge that debt financing is the most likely source of financing a new project for a casino gaming company, this financial model and final report details the optimal capital financing structure and sources of funding to maximize growth opportunities.
After thorough research, analysis and financial modeling, I completed a debt financing financial model and final recommendation for Caesar’s Entertainment, that included:
- Financial Reporting & Analysis (FP&A)
- Pro Forma Operating Cash Flows
- Capital Structure
- WACC
- Data Visualization
- Financial Reporting
- Net Present Value (NPV)
- Internal Rate of Return (IRR)
- Pro Forma Income Statement
- Earnings Per Share (EPS)
- Return on Equity (ROE)
- DuPont Analysis
- Ratio Analysis
Below is the completed Finance Consulting project with debt financing model in Microsoft Excel, and final report / task guidelines in Adobe PDF.
If you have any questions and would like to learn more about this or any project, are interested in networking, or ready to discuss why I should be your next financial analyst, please don’t hesitate to reach out directly through the contact form, by email at codyhspicer@gmail.com, by phone at (210) 272-7534, or let’s connect through LinkedIntoday. I look forward to hearing from you!
Kind regards,
