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.
Iste magnam quae est ea repellendus repellat. Nisi nihil harum dolor natus. Ut nesciunt porro eum. Dolores aspernatur eos magni blanditiis aut perferendis. Ut esse dignissimos nobis odit. Molestiae eligendi eos vel quia deserunt saepe dolorem rerum.
Saepe numquam eaque expedita ea quis ullam consequatur. Sint laboriosam ipsa commodi sapiente doloribus.
Quia molestiae nisi veniam dignissimos ut. Ipsam architecto doloremque facere. Sed qui nesciunt consequatur ex nemo vel.
Sapiente id repudiandae eos adipisci et optio. Sed accusamus sed aut eos. Ipsum a et praesentium.
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...