A Step-by-Step Guide for P&L and Balance Sheet
When constructing a financial model, two critical milestones must be reached. In this chapter, we will meet the first one while the second milestone will be accomplished in the next.
Prior to our continued progression, I’d like to remind you of all the methods we’ve used in our economic modelling process. Should you have difficulty with any particular topic, it may be prudent to examine the pertinent chapter and read through it once more. If you have any questions, don’t hesitate to inquire.
We began the module by formatting an excel workbook into a layout suited for financial modelling. After indexing the columns and locking them in place, we made certain each column corresponded to the same year throughout the model, thus preserving its accuracy.
We thoroughly studied the annual report to confirm the accuracy of the statements; we then transferred the Profit and Loss and Balance Sheet figures from the past five years onto a prearranged excel sheet. The only numerical information entered by hand into the financial model were those two, while all remaining numbers were either estimated or derived.
We introduced an assumption sheet that included P&L and Balance Sheet assumptions. These assumptions were either based on growth rate or determined as a larger line item percentage.
Once the assumption sheet is in place, it’s time to construct the revenue model. This model will provide an insightful, detailed look at all of the factors that affect revenue.
In our model, ‘schedules’ were used as a concept. This notion essentially functions as an assumption, but dissecting it into its components allows us to gain more profound understanding.
This follows the principle that the closing balance of one year is the opening balance for the next.
We have been able to use the assumptions and timetables to forecast a balance sheet and profit & loss statement.
As you can see, the figures are interconnected from one sheet to the next, creating a cohesive system.
In this chapter, we will generate a five-year P&L and Balance sheet as part of our financial modelling expedition. It’s an important step forward.
– P&L Projection
We’ve reached an exhilarating point in our financial modelling trek. A financial modelling lover likened it to a wedding kitchen scene.
At a wedding kitchen, it is not uncommon to have someone chopping vegetables, someone grinding the masala, another frying items, and yet another mashing them. Eventually everything comes together in on
e pot for the final recipe.
Up to this point in our financial model, we’ve been dealing with individual components. Now it’s time for us to join everything together and integrate the model.
© 2021 BP Equities Pvt. Ltd.
All Rights Reserved
By signing up, you agree to receive transactional messages on WhatsApp. You may also receive a call from a BP Wealth representative to help you with the account opening process
Disclosures and Disclaimer: Investment in securities markets are subject to market risks; please read all the related documents carefully before investing. The securities quoted are exemplary and are not recommendatory. Past performance is not indicative of future results. Details provided in the above newsletter are for educational purposes and should not be construed as investment advice by BP Equities Pvt. Ltd. Investors should consult their investment advisor before making any investment decision. BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), IN-DP-CDSL-183-2002 (CDSL), INH000000974 (Research Analyst), CIN: U45200MH1994PTC081564. Please ensure you carefully read the Risk Disclosure Document as prescribed by SEBI | ICF
Attention Investors
Issued in the interest of Investors
Communications: When You use the Website or send emails or other data, information or communication to us, You agree and understand that You are communicating with Us through electronic records and You consent to receive communications via electronic records from Us periodically and as and when required. We may communicate with you by email or by such other mode of communication, electronic or otherwise.
Investor Alert:
BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), INZ000030431 (MCX/NCDEX), IN-DP-CDSL-183-2002 (CDSL),
INH000000974 (Research Analyst) CIN: U45200MH1994PTC081564
BP Comtrade Pvt Ltd – SEBI Regn No: INZ000030431 CIN: U45200MH1994PTC081564
For complaints, send email on investor@bpwealth.com
