Hi,
Am trying to build a 3-statement model for a tech services company and am stuck trying to figure out how to address stub periods. Here is the summary of where I am presently.
Financial year is April-to-March
10K data available for 2017, 2018 & 2019 (ending Mar-2019). 10K-2019 is for period Apr-18 to Mar-19.
10Q data available for periods ending Q1-2020 (Jun-2019), Q2-2020 (Sep-2019)
Have prepared the 3-statement model for historic years.
Here is where I am stuck.
Am reasonably confident to project full-year income statement for 2020 (barring Depreciation & Amortization) which are dependent on PP&E & Intangible Assets.
The challenge is - I have the latest balance sheet from Q2-2020. How do I project Mar-2020 (full year 2020) BS? Do I assume for the sake of the model that the <abbr title="balance sheet">BS</abbr> does not change from Q2-2020 through Q4-2020; and therefore, consider the most recent <abbr title="balance sheet">BS</abbr> as the projected <abbr title="balance sheet">BS</abbr> for Mar-2020?
Looking forward to your inputs. Thanks in advance.
Voluptatem voluptas atque molestiae. Natus qui assumenda sit eos et. Consequatur cumque laborum ut modi soluta rerum voluptatem. Veritatis accusantium modi aliquid delectus repudiandae sed.
Impedit perspiciatis asperiores aut non fugiat voluptates quasi. Eum saepe dolorum a assumenda blanditiis odio et. Expedita facere quas consectetur aliquid fugiat et.
Quam officia accusamus quaerat quia id iste. Voluptatibus rem dicta dolores deleniti veritatis. Libero nihil labore perspiciatis et. Velit recusandae molestiae minus quae non voluptas corrupti. Occaecati nemo quidem rerum accusamus quae et autem. Vero ut sit sit modi rerum. Molestiae nostrum in et perspiciatis est.
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...