Reserves & Surplus understanding Bata schedule

  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 / Reserves & Surplus understanding Bata schedule

Reserves & Surplus

Let us take a further glance at Equity, or Reserves & Surplus, for Bata India.

This section consists of two line items, Equity Share capital and Other Equity, the details of which can be found in notes 12 and 13.

The share capital of Bata stays the same, so there is no need to model it. However, if they were to raise more money, the situation would be different.

We need to take a look at Note 13 in order to understand the different components of this equity part, or reserves and surplus. This will give us a snapshot of what is contained therein.

I will use the base rule concept to construct a schedule. I won’t dwell on setting up the excel sheet, since we’ve already done that in prior chapters.

Rather than tell you, I’d prefer to demonstrate the excel set up.

I have completed the usual excel set-up, indexing the columns and including the line items while abiding by the base rule. This set-up is consistent with that of the Note 13 associated with it and only considers the most recent annual report similarly to before.

Let us put the data into our schedule.

I’ve maintained the amount of fully paid-up share capital throughout each year.

We previously discussed the ‘Security Premium Reserve’ in this chapter. If no new Equity has been issued by a firm during the year, its security premium reserve remains unaffected.

The annual report has data only for March 2020 and 2021. To create the securities premium reserve, I’ve utilized the base rule in which the closing value of one year becomes the opening balance of the next year.

The ‘General Reserve’ is next in line. It is designated for general business operations of a firm without any specific goal. Companies may either keep the reserve as it is or contribute a bit more each year from their profits and losses.

Bata India has chosen to leave some funds alone, without any annual augmentations, therefore the principle is easy to apply to the general reserve.

The company’s ‘general reserves’ are utilized for working capital needs and other corporate outlays.

Proceeding forward, ‘Retained earnings’ need to be examined. Something of critical importance is that the Profit After Tax (PAT) or bottom line profit of the enterprise is seen as the profit accrued during that fiscal year. This income is amassed in the business’s balance sheet in the retained earnings segment.

The PAT goes to the liabilities section of the balance sheet, and remains in retained earnings. It’s one of the ways these two financial statements are linked together.

The company additionally distributes dividends and associated taxes from the retained earnings segment of the balance sheet. Furthermore, on the Excel spreadsheet – The March 19 balance carries over to become the opening balance of March 2020. To this, we add the PAT figure from the P&L – INR 3289.53 Million.

The company then has two other items to consider, namely the remeasurement of gains/losses on defined benefit plan and the impact from Ind AS 116. These are result of accounting treatments and generally do not have any extensive consequences. You can take cognisance of these figures, but I do not see there being too much need for forecasting or modelling.

Additionally, it is evident that dividend payment and the required dividend distribution tax have been subtracted from the total amount.

The closing balance of retained earnings is the sum of all profits and losses. For March 2021, unfortunately the company reported a deficit, which was noted in the balance sheet. Whenever the company suffers a loss, their retained earnings will be reduced accordingly.

The Share Capital and Reserves & Surplus of the company is its Net worth. If a business has continual losses, then its retained earnings decrease, leading to a reduction in its Net worth.

The combination of the Securities premium reserve, general reserves and retained earnings makes up the Equity included in the balance sheet.

    captcha