DCF Financial Model #1

 I have completed this DCF Model for the company listed on the DAX index Bayerische Motoren Werke Aktiengesellschaft (BMW).

The market risk premium in Germany at that point of time was 5.70% which is 5.80% at present.

The yearly risk-free rate in Germany at that time was 1.10% which is 0.6% at present according to Statista

The formula for calculating Free Cash Flow (FCF) :

FCF = EBIT*(1-Tax Rate) + Depreciation & Amortization - Net Capex - Increase in Working Captial

Here you can download the DCF Model  - DCF Model BMW.xlsx

Comments

Post a Comment

Popular posts from this blog

Net Present Value (NPV) On Python Using Numpy

Image
Net present value (NPV) is the difference between the present value of cash inflows and the present  value  of cash outflows over a period of time.   NPV is used in  capital budgeting  and investment planning. The NPV Rule is:- If  NPV > 0  Then the project is Accepted  If  NPV < 0 Then the project is Rejected The formula for calculating NPV is - = net present value = net cash flow at time t = discount rate = time of the cash flow This is how NPV is calculated manually with the generic formula, now we are going to use NumPy for calculating the NPV of a project. Here is an example. The initial investment is $100. The cash inflows in the next five years are $50, $60, $70, $100, and $20, starting from year one. If the discount rate is 11.2%, what is the project's NPV value?  #import Numpy  import  numpy  as  np #Put/define values in the cashflows & Interestrate. CF0 =...
Read more

Commodity Channel Index ( CCI ) Using Python

Image
The CCI compares the  current price  to an  average price  over a period of time. The indicator fluctuates above or below zero, moving into positive or negative territory. While most values, approximately 75%, fall between -100 and +100, about 25% of the values fall outside this range, indicating a lot of weakness or strength in the price movement. CCI is calculated with the following formula: (Typical Price - Simple Moving Average) / (0.015 x Mean Deviation) When the CCI is above +100, this means the price is well above the average price as measured by the indicator. When the indicator is below -100, the price is well below the average price. A basic CCI strategy is used to track the CCI for movement above +100, which generates  buy signals , and movements below -100, which generates  sell  or  short  trade signals. Investors may only want to take the buy signals, exit when the sell signals occur, and then re-invest when the buy signal...
Read more

SMA Trading Strategy Using Python

Image
This strategy works on the basic logic that whenever the 30 Day Simple Moving Average is greater than the closing price of the stock it gives a Buy signal and whenever the 30 Day SMA is smaller than the closing price then it gives a sell signal. This way we get a clear understanding of when to place a buy order and when to exit our position. I've built this strategy using python and here is the program and logic for the strategy. #import libraries import  pandas  as  pd import  numpy  as  np import  matplotlib.pyplot  as  plt plt.style.use ( 'fivethirtyeight' ) #Load data from  google.colab  import  files files.upload () #Store the data df = pd.read_csv ( 'HDFC.NS.csv' ) #set date as index df = df.set_index ( pd.DatetimeIndex ( df [ 'Date' ] .values )) #show data df #visualize the close price plt.figure ( figsize= ( 16 , 8 )) plt.title ( 'Close Pri...
Read more