Comprehensive Financial Model Build-Out of Publicly Traded Company for Credit Analysis
Budget: $250 – $750 USD
I need an experienced freelancer who can help me build-out a robust financial model for a publicly traded company. I have a financial model that was sent to me that includes historical numbers, however I need the model to be working, and with relevant quantitative analysis.
I need the model to make a recommendation on the company's debt securities.
The model needs to include prominent financial statements including the Income Statement, Balance Sheet, Cash Flow Statement along with in-depth details regarding capital structure, Key Performance Indicators (KPIs), Projections, and Analytics.
Key Responsibilities:
- Build a comprehensive financial model; and/or improve the existing model to make it working, and include forecasts.
- Use the historical financial statements and the model provided to build out a functioning model that includes forecasts.
- Track vital financial metrics including Revenue, Expenses, ROI, Earnings per share, Debt ratios, Profit margins, Working capital, and other metrics crucial for assessing credit quality.
This financial model must provide a quarterly, and annual breakdown, including TTM.. The person I'm looking for should have substantial experience in Finance and Financial Modelling, with the ability to handle a considerable amount of data.
Preferred Skills:
- Proficient in financial analysis
- Understanding of public debt / credit investing
- Strong knowledge of financial ratios and metrics
- Excellent Excel skills
- Understanding of financial statements and pricing models
- Keen attention to detail
- Previous work in creating financial models for public traded companies
The end product should be a detailed, clean, and easy-to-navigate financial model that will allow for effective decision-making. Please provide relevant portfolio pieces or case studies from similar projects.
I will also need a thorough walk-through and explanation of how the model works at the end of the project.
I need the model to make a recommendation on the company's debt securities.
The model needs to include prominent financial statements including the Income Statement, Balance Sheet, Cash Flow Statement along with in-depth details regarding capital structure, Key Performance Indicators (KPIs), Projections, and Analytics.
Key Responsibilities:
- Build a comprehensive financial model; and/or improve the existing model to make it working, and include forecasts.
- Use the historical financial statements and the model provided to build out a functioning model that includes forecasts.
- Track vital financial metrics including Revenue, Expenses, ROI, Earnings per share, Debt ratios, Profit margins, Working capital, and other metrics crucial for assessing credit quality.
This financial model must provide a quarterly, and annual breakdown, including TTM.. The person I'm looking for should have substantial experience in Finance and Financial Modelling, with the ability to handle a considerable amount of data.
Preferred Skills:
- Proficient in financial analysis
- Understanding of public debt / credit investing
- Strong knowledge of financial ratios and metrics
- Excellent Excel skills
- Understanding of financial statements and pricing models
- Keen attention to detail
- Previous work in creating financial models for public traded companies
The end product should be a detailed, clean, and easy-to-navigate financial model that will allow for effective decision-making. Please provide relevant portfolio pieces or case studies from similar projects.
I will also need a thorough walk-through and explanation of how the model works at the end of the project.