Quick Financial Modeling and Forecast
See more projectsIntensity
3hr/week
Est. Duration
7days
Location
Remote
Project Overview
1 to 8 years professional experience
Finance & Accounting - Financial Modeling
Hello,
I am wondering if you would be able to complete on the following deliverables:
- Create 10 yr Pro Forma income statement and balance sheet forecast for Smuckers maintaining their 3% organic growth (based off of 2016 10-k) along with a common size of the income statement
- Create an income statement using comparable approach for a private company (ClifBar) (finding enterprise value, purchase premium, etc)
- Create forecasted income statement for Smuckers when the acquisition of ClifBar has been made
- Create NPV and DCF analysis of the Smuckers/ClifBar deal
- Find best way for Smuckers to finance the deal using their balance sheet/cashflows/stock
- Forecast Smuckers Cashflows after aquisition takes place
- Determine based off of NPV whether project should take place
all the best,
Marcus
I am wondering if you would be able to complete on the following deliverables:
- Create 10 yr Pro Forma income statement and balance sheet forecast for Smuckers maintaining their 3% organic growth (based off of 2016 10-k) along with a common size of the income statement
- Create an income statement using comparable approach for a private company (ClifBar) (finding enterprise value, purchase premium, etc)
- Create forecasted income statement for Smuckers when the acquisition of ClifBar has been made
- Create NPV and DCF analysis of the Smuckers/ClifBar deal
- Find best way for Smuckers to finance the deal using their balance sheet/cashflows/stock
- Forecast Smuckers Cashflows after aquisition takes place
- Determine based off of NPV whether project should take place
all the best,
Marcus
Additional Notes
Excel forecasting and modeling Preferred Skills and Certifications
Functional
Financial Modeling
About The Client
9 years
Time On Graphite