StoxBox
Login

Basics of financial modelling CAPEX and Asset 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
Previous lesson Next lesson
Marketopedia / Financial Modelling / Basics of financial modelling CAPEX and Asset Schedule
Asset Schedule Part 2 We will examine the asset schedule.
  • What is the Base rule?
Before constructing our schedules, let’s make sure we have a good grasp of the base rule. You’re likely already aware of it, but I might as well elucidate it now. Let’s take an example. Electric vehicles have grown in popularity and Ola has set out to take advantage of this by developing and selling electric bikes. This is sure to create a stir in the industry. Ola created 4000 electric bikes during their first year of functioning. Here are a few constructed facts –
  • Number of bikes manufactured in 1st-year operations = 4000
  • The total of bikes that have been sold is 3750.
  • 250 bikes remain unsold.
To begin, the opening balance for Ola’s first year of operation was zero. This was followed by the total number of bikes that were purchased throughout the year. Lastly, it ended with a closing balance, which is an assessment of any remaining unsold bikes at the end of the year. The total number of bikes is 4000, since the opening balance is at a tally of zero. This amount comprises all the bikes that were produced. At the end of the year, we can calculate how many bicycles were not sold. This figure is known as the closing balance. Let us suppose that Ola produces and distributes the same amount of bicycles in the second year. Can you share what the commencement, quantity and ending numbers were for the 2nd year? In this particular case, the opening balance for Year 2 is 250, which is the same as the closing balance of Year 1. They produce 4000 new bikes, bringing their total to 4250. Of these, 3750 have already been sold – leaving a balance of 500 at the end of the year. The opening balance for Year 3 is based on the closing balance of the previous year, and this applies every year. The ‘Base rule’ of linking the closing and opening balance is a technique that’s often used in the schedules we build, particularly in the asset schedule. For now, just remember this base rule – we’ll be referencing it soon.

    captcha


    Marketopedia
    Financial Modelling
    Copy link
    Twitter Facebook Linkedin
    Previous lesson Next lesson
    StoxBox
    © 2021 BP Equities Pvt. Ltd.
    All Rights Reserved
    StoxBox Instagram
    StoxBox Facebook
    StoxBox Twitter
    StoxBox Youtube
    StoxBox Linkedin
    StoxBox Whatsapp
    Get the app
    StoxBox Footer
    StoxBox Google Play Store
    Products
    MentorBox
    HotBox
    More

    *All subscription pricing plans mentioned across the website are exclusive of 18% GST

    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

    1. Stock Brokers can accept securities as margin from clients only by way of pledge in the depository system w.e.f. September 1, 2020.
    2. Update your mobile number & email Id with your stock broker/depository participant and receive OTP directly from depository on your email id and/or mobile number to create pledge.
    3. Pay 20% upfront margin of the transaction value to trade in cash market segment.
    4.  Investors may please refer to the Exchange’s Frequently Asked Questions (FAQs) issued vide circular reference NSE/INSP/45191 dated July 31, 2020 and NSE/INSP/45534 dated August 31, 2020 and other guidelines issued from time to time in this regard.
    5. Check your Securities /MF/ Bonds in the consolidated account statement issued by NSDL/CDSL every month.

    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:

    1. Prevent Unauthorised Transactions in your demat account –> Update your Mobile Number with your Depository Participant. Receive alerts on your Registered Mobile for all debit and other important transactions in your demat account directly from CDSL on the same day………………….issued in the interest of investors.
    2. KYC is one time exercise while dealing in securities markets – once KYC is done through a SEBI registered intermediary (broker, DP, Mutual Fund etc.), you need not undergo the same process again when you approach another intermediary.
    3. No need to issue cheques by investors while subscribing to IPO. Just write the bank account number and sign in the application form to authorise your bank to make payment in case of allotment. No worries for refund as the money remains in investor’s account.

    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

    Copyrights © 2022 BP Group All Rights Reserved