Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Transaction/Valuation Date of 4/7/16 1) Frozen Food Co, has a Fiscal Year-End (FYE) of June 30,2016. 2) Last FYE, the Company generated revenues of $185.7
Transaction/Valuation Date of 4/7/16 1) Frozen Food Co, has a Fiscal Year-End (FYE) of June 30,2016. 2) Last FYE, the Company generated revenues of $185.7 million. 3) Management believes it can grow revenues by 5% for the five year forecast period. 4) EBIT margins are expected to increase from 12% last year to 15% this year and remain that way for the next five years 5) D\&A was 3\% of revenues in FYE 2015 and is expected to remain constant over the forecast period. 6) CapEx is also expected to be 3% of revenue for the foreseeable future: 7) Below are projections for Current Assets and Current Liabilties over the forecast period (link model to these annual figures) 8) For the effective tax rate, you can use 35%. 9) Discount rate is based on WACC of comparable public companies (use 6%, similar to the WACC conclusion at the bottom of the "WACC" tab). 10) Terminal EBITDA multiple will be 13.0x (base cas hard code in terminal multiple 11) 1.0x sensitivity on the terminal EBITDA multiple. 12) 1.0% sensitivity on the discount rate == Financial projections (next tab) should link to these figure: Transaction/Valuation Date of 4/7/16 1) Frozen Food Co, has a Fiscal Year-End (FYE) of June 30,2016. 2) Last FYE, the Company generated revenues of $185.7 million. 3) Management believes it can grow revenues by 5% for the five year forecast period. 4) EBIT margins are expected to increase from 12% last year to 15% this year and remain that way for the next five years 5) D\&A was 3\% of revenues in FYE 2015 and is expected to remain constant over the forecast period. 6) CapEx is also expected to be 3% of revenue for the foreseeable future: 7) Below are projections for Current Assets and Current Liabilties over the forecast period (link model to these annual figures) 8) For the effective tax rate, you can use 35%. 9) Discount rate is based on WACC of comparable public companies (use 6%, similar to the WACC conclusion at the bottom of the "WACC" tab). 10) Terminal EBITDA multiple will be 13.0x (base cas hard code in terminal multiple 11) 1.0x sensitivity on the terminal EBITDA multiple. 12) 1.0% sensitivity on the discount rate == Financial projections (next tab) should link to these figure
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started