Choose theWaterfalloption and clickOK. A cash flow diagram has been created using the dataset. Read More:How to Calculate Discounted Cash Flow in Excel Step 4 –Add a Title Give your chart the titleCash Flow Diagram. Read More:How to Forecast Cash Flow in Excel Step 5 – Format the Diag...
Formula to Calculate The Discounted Cash Flow The total amount of the cash flow for every period of time divided by one increment of the discount rate raised to the power of the period count is theDiscounted Cash Flow(DCF) formula. DCF=CFt/(1+r)^t CFt= Cash flow in period t (time) ...