Revenue Model & Growth Rate in in P&L Assumptions

  1. Financial Modelling
    1. Financial Modelling Introduction
    2. Financial Modelling Tools & steps
    3. How to Make a Financial Model and choose the best Company and Excel Workbook Setup?
    4. How to build a financial model Step-by-Step Guide to Excel Sheet Setup?
    5. Financial Statements: A Step-by-Step Guide to Extracting Historical Data
    6. Financial modelling excel
    7. Learn financial modelling Balance Sheets, P&L, and Assumptions Know About
    8. What is financial modelling Assumptions and Projections?
    9. Financial modelling and valuation
    10. Investment decision calculation
    11. The balance sheet’s asset side reveals the company’s line items.
    12. Revenue Model & Growth Rate in in P&L Assumptions
    13. Basics of financial modelling CAPEX and Asset Schedule
    14. Financial Analysis: Gross Block and CAPEX
    15. Gross block & Capex: Constructing the Asset Schedule
    16. Depreciation : Connecting P&L and Balance Sheet for Accurate Asset Forecasting
    17. depreciation expense : Exploring Different Methods in Financial Modeling
    18. Debt Management: Connecting P&L and Balance Sheet for Accurate Liability Projection
    19. Interest Rate Calculation & Debt Schedule
    20. Share Capital & Reserves
    21. IPOs and Under subscription : Bata’s Share Capital Dynamics
    22. Reserves & Surplus understanding Bata schedule
    23. Reserves and surplus schedule How to Build on Excel
    24. Financial modelling projections
    25. Balance Sheet Projections and Completing Reserves Schedule
    26. Cash Flow Statements Analysing Operations, Investments, and Financing Activities
    27. What Is Valuation for Investor
    28. Free Cash Flow Key Components, Formulas and How to Calculate?
    29. FCFF and FCFE uses in Mastering Free Cash Flow Calculation
    30. WACC Weighted Average Cost of Capital Analysis
    31. Market Risk Premium analysis
    32. Tax Shield and its Impact on Equity Holder Returns
    33. Weighted Average Cost of Capital and Terminal Growth in Valuation
    34. Terminal Value Understanding Perpetual Cash Flow Projections in DCF Model
    35. Learn Financial Modelling
    36. Free Cash Flow to the Firm (FCFF) Calculation with examples
    37. Stock Valuation DCF Model & Stock Market Value
Marketopedia / Financial Modelling / Revenue Model & Growth Rate in in P&L Assumptions

Revenue Model

Let us begin by examining the P&L –

The P&L has two sides: revenue and expenses. Sales and additional income can be found on the revenue side, while all costs incurred throughout the year are tracked on the expense side.

Creating assumptions around expenses is fairly straightforward; all of these figures are computed as a percent of total income or net sales. With revenues, however, the analysis is far more intricate. You can use growth rate calculations or take a more in-depth approach and construct a revenue model.

Let us focus on two methods. We can begin by examining the growth rate method of revenue forecasting in the primary model we are using, then employ a helper model to construct a revenue model.

We could explore a potential revenue model and the number of days for receivables in the following chapter.

I am now creating an additional part in the assumptions document to include P&L figures. To arrive at a better understanding, this is the present condition of my assumptions sheet.

In the P&L assumptions section, I’ll go through each line item one-by-one, in the same sequence it’s listed.

Earlier, I took into account the rate of increase for net sales. Similarly, for the other line items, their values are expressed as a percentage of the sales figure. For instance, other earnings make up a proportion of net sales; likewise, an increase in inventory is given as a fraction of net sales.

Let us kick off with the Net sales growth rate; as before, this is worked out in the same fashion as calculating the deferred taxes growth rate from our prior chapter. Here is a snapshot of the Net sales growth rate –

81.83% is a sizable figure, however it’s based on the firm’s net sales for Y1 and Y2. To further check its accuracy, one can look into how the other organisations in this field performed during the same timeframe.

If a firm in any sector produces remarkable results for a given year, its peers would likely also have achieved similar outcomes. For instance, if MRF has seen a 20% rise in revenue for Y1, one should assume Apolo Tyres will similarly disclose a 20% increase. Nevertheless, if Apollo’s report shows 16%, then it’s clear that MRF has the upper hand on other competitors.

This is just a rough illustration, meant to give you an idea of how one can go about constructing the model for companies.

I’ll move forward with the P&L assumptions. Shouldn’t be too complicated, considering that we already applied this process to the balance sheet figures.

For your convenience, I’ve highlighted the Year 6 cell in the net sales excel sheet, so you can easily see the values used for subsequent calculations – which are all just simple averages. You’re free to download this excel file and take a closer look at each cell.

The bottom of the P&L reveals Depreciation & Amortization and interest expenses. These figures come from the schedules that will be made in the future.

The assumption sheet has been finished, and this is its present state.


    Get the App Now