Business Template - DCF Analysis

DCF Analysis Dates Cash Flows Net Present Value 1 Jan 05 (300) 1 Jan 06 (100) NPV Date 1 Jan 06 100 Discount Rate AER * 1 Jan 06 67 How time differences are to be measured: 1 Jan 06 (100) DayCount (optional) 1 Jan 06 150 Periods for use with DayCount type 6 (optional) 1 Jan 06 250 The Net Present Value (NPV) is Internal Rate of Return (IRR) Whats the maximum the IRR could be? Whats the minimum the IRR could be? The Internal Rate Of Return (IRR) is * Discount Rate The discount rate you specify is an annual effective (annually compounded) rate. If you have a Simple interest rate, you can convert it to Annual Effective (Equivalent) using the formula below: Simple Interest Rate How often per year does interest accrue? Discount Rate as an AER1 Jan 05 The date where cashflows are discounted to. 5.1162% Annual Effective Rate * 0 30/360 (PSA). -12 in arrear, monthly (1 Jan payment of Dec accrual, etc) 49.14 10000% -90% 22.3333% specify is an annual effective (annually compounded) rate. interest rate, you can convert it to Annual Effective (Equivalent) 5% -12 +12 payments per year in arrear 5.1162% Now input this in the cyan colored Discount Rate cell above