XLS www.stern.nyu.edu

Enter the type of cash flow that you are discounting =GA[S=Simple; A=Annuity; GA=Growing Annuity; P=Perpetuity; GP=Growing Perpetuity]Enter the dollar amount of the cash flow =2000For S: Enter the single cash flowFor A and P: Enter the cash flow each periodFor GA and GP: Enter the current year's cash flow]Enter the number of years for the cash flow =10For S: Specify the year of the cash flowFor A and GA: Enter the number of years for annuityFor P and GP: Leave blankEnter the annualized discount rate to use on cash flows =0.085Enter the annualized discount rateEnter the expected growth rate in the cash flow =0Leave blank for S, A and PEnter the annualized growth rate for GA and GPSpecify the number of compounding periods per year =12If semi-annual enter 2, if monthly enter 12 ….Output for Present Value and Future ValueDiscount Rate per period ==(1+F13)^(1/F16)-1Number of periods ==F10*F16Present Value of Cash Flow(s) ==IF(F2="S",F7/(1+D19)^D20,(IF(F2="A",F7*((1-(1+D19)^(-D20))/D19),(IF(F2="GA",F7*(1+F14/F16)*(1-(1+F14/F16)^D20/(1+D19)^D20)/(D19-F14/F16),(IF(F2="P",F7/D19,F7*(1+F14/F16)/(D19-F14/F16))))))))Future Value of Cash Flow(s) ==IF(F2="P", "NA",(IF(F2="GP","NA",F21*(1+D19)^D20)))Warnings=IF(F2="P",(IF(F14>F13,"Growth Rate cannot exceed discount rate in perpetuity"," "))," ")=IF(F2="GP",(IF(F14>F13,"Growth Rate cannot exceed discount rate in perpetuity"," "))," ") ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download