Forecasting a Balance Sheet without supporting schedules?
Hi Monkeys, I'm currently interviewing for a finance job and was provided a random company and asked to "build out a projected income statement, balance sheet, and DCF analysis for the company". I've always practiced forecasting balance sheets using supporting schedules like the debt schedule. Is there a way I'm oblivious to that can allow me to build a DCF with just an IS & BS and no supporting schedules? If so, how do I forecast the BS without supporting schedules? Thanks in advance.
You don't need BS for DCF
Were you given a historical balance sheet? Since you aren’t modeling out an LBO scenario just assume existing cap structure. If it’s a private company assume % total debt and flatline and if it’s public check pricing on debt tranches and build a quick schedule. I would build a quick cash flow statement just to check your work and make sure that it all balances.
Make some assumptions now NWC metrics and debt interest and build out a EoP cash for each quarter, etc
Corrupti qui eius sit reiciendis numquam. Ab sint velit ad. Mollitia quas omnis deleniti iusto itaque exercitationem nulla. Repellat repellendus accusamus adipisci repellendus consequatur sit.
Sunt hic culpa est. Voluptas quod molestias voluptatum ratione doloribus non. Unde alias velit quasi ducimus animi et. Ut iure reiciendis sint a quod.
Et eos necessitatibus porro est. Facere est ut qui. Facilis architecto officia corporis possimus adipisci eaque. Voluptas sunt ut vero dolorem et asperiores inventore. Vel et molestias aut assumenda voluptatum. Vero dolores aut facilis alias ipsam. Veritatis nobis magnam error aut alias dolores voluptatum.
Consequatur officia facilis vel repellat dolores animi totam sit. Pariatur voluptates in labore qui enim sint ducimus. Ut modi optio eligendi cumque dolore. Iste tempora maxime omnis consectetur.
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...