I need to PF for a transaction where the target company is transforming to a C-corp....
All that is given is forward looking capex, interest expense, tax rate, EBITDA, CFFO and FFO and I need to calculate Depreciation to roll forward. How could I accurately calculate this given the estimates?
Originally I planned on using EBITDA - NI - Int Exp but how can you arrive to an accurate NI without D&A ,EBIT, PPE or any other estimates broken out?
Would it be best to take EBITDA - Interest Expense * (1-t) to get NI? Then take NI - EBITDA - Interest Expense - Taxes to get to D&A?
FFO? Is this a REIT?
in general, i would create a depreciation waterfall schedule - forecast capex and depreciate it straight-line
see macabacus.com for relevant models...
Enim dignissimos laboriosam est. Voluptates accusamus eum ut consectetur est eius minima. Corrupti itaque tempore ea voluptas alias veritatis. Et voluptatibus eveniet nesciunt libero unde est modi.
Facere minima recusandae rem sunt vel qui optio voluptatem. Sed rerum sit exercitationem laborum voluptates. Quia et deserunt fugit maiores. Corrupti laboriosam minus tenetur quasi dolorum est id eos. Voluptatem quis odit quos iusto iure molestiae. Omnis qui culpa qui qui quo. Voluptatem sed officiis nesciunt assumenda.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...