Tuesday 24 June 2014

Discounted Cash Flow (DCF) Analysis Excel Template (v1.10)

Yesterday I have posted the v1.02 analysis template with various update on the Financial Statement Analysis Template and I have used the said template to perform financial statment analysis on APOLLO.

Today, I make an intiative to incorporate the DCF valuation to the excel template. You can click here to access the said template on the One Drive.

 

The V-DCF worksheet is a new valuation worksheet that I created based on the existing Financial Statement Analysis Template and all the required data will be auto picked by the V-DCF worksheet after you filled in the purple colour input worksheet as per specified in Financial Statement Analysis Template.


The V-DCF worksheet will perform valuation against different type of free cash flow i.e. FCF, FCFF, FCFE and Owner Earnings. (Read Cash Flow Statement Analysis if you not sure what is FCF.) The user can key in the self defined cash flow and check out the calculation result too.

You can review the data setup sections in order to confirm all of the inputs. Please refer to DCF writeup if you not sure about the setup in DCF Valuation. The input data can be override on the grey color cell. (It is similar to Financial Statement Analysis Template.)


After that, you can review the results for various free cash flow and check out what is the stock intrinsic value based on the DCF valuation on the  "Summary of Intrinsic Value" sections.


You can open the matrix to see the intrinsic value and MOS based on different growth rate and discount rate.




Or, review the "Calculation Details" to dissect the calculations



I hope this tools can help me to become a good hunter in bursa. And, I will develop more asset based or earning based valuations template in coming future.

Stay tuned.

Note: I have make some corrections on this version and upgrade it to v1.11. Please click here for details.

You may interest to read:-

7 comments:

  1. Good articles, Have you heard of LFDS (Le_Meridian Funding Service, Email: lfdsloans@outlook.com --WhatsApp Contact:+1-9893943740--lfdsloans@lemeridianfds.com) is as USA/UK funding service they grant me loan of $95,000.00 to launch my business and I have been paying them annually for two years now and I still have 2 years left although I enjoy working with them because they are genuine Loan lender who can give you any kind of loan.

    ReplyDelete
  2. The bottom line is that cash prices aren't illegal, but not declaring income or 'sales' is. But it's also a common practice - a 'second economy' or 'black market'. Cash Discount Program

    ReplyDelete
  3. This is so nice and helpful post
    Do visit our blog
    Jobs for Pregnant Women

    ReplyDelete
  4. GOOD DAY AND WELCOME TO ASDA FINANCE LTD®
    We Are Currently Trying To Invest In A Good Profitable Business, Please Present Only Viable Business Ideas. If You Have Projects That Need Financing Kindly Come Back With Your Business Plan.
    If We Find Your Business (Investment) Profitable, Then you Will Be Contacted As Soon As Possible.
    Whatever Your Circumstances are, Self-Employed, Retired, With Poor Credit.
    We Can Help You With Our Flexible Repayment Schedule of about 2.7 to 3.2% interest rate only.
    We Can Also Meet Your Financial Need Without Repayment Problems(1year) after the loan is transferred.
    Please Contact Us:
    asdaservices24@gmail.com
    Thanks And God Blessings.

    ReplyDelete
  5. Greetings....
    Check out these credit cards today.
    My name is Robert Williams from California. A successful business owner and father. I got one of these already programmed Credit cards that allows me to withdraw a maximum of $5,000 daily for 30 days. I am so happy about these cards because I received mine last week and have already used it to get $20,000. Mr Frank Richard of Creditcards.atm@gmail.com is giving out these cards to support people in any kind of financial problem. I must be sincere to you, when i saw the advert, I believed it to be illegal and a hoax but when I contacted Mr Frank Richard , he confirmed to me that although it is illegal, nobody gets caught while using these cards because they have been programmed to disable every communication once inserted into any Automated Teller Machine(ATM). If interested contact him as soon as possible
    **WHAT WE OFFER**
    *1)WESTERN UNION TRANSFERS/MONEY GRAM TRANSFER*
    *2)BANKS LOGINS*
    *3)BANKS TRANSFERS*
    *4)CRYPTO CURRENCY MINNING*.
    *5)BUYING OF GIFT CARDS*,
    *6)LOADING OF ACCOUNTS*
    *7)WALMART TRANSFERS*
    *8)BITCOIN INVESTMENTS*
    *9)REMOVING OF NAME FROM DEBIT RECORD AND CRIMINAL RECORD*
    *10)BANK HACKING*
    Email:Creditcards.atm@gmail.com

    Whatsapp:+1(305) 330-3282.....
    .......

    ReplyDelete
  6. Discounted Cash Flow analysis is widely used in finance and investment decision-making. It is commonly applied to value businesses, projects, or investment opportunities. However, it's essential to note that the accuracy of the valuation heavily relies on the quality of the assumptions made, especially regarding cash flow projections and discount rate estimation. As with any financial modeling, DCF should be used as a tool within a broader analysis, considering various factors and scenarios.

    Best Cash Flow Forecasting Software | Financial Forecasting Tips | Moolamore Cash Flow Management

    ReplyDelete