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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pdf how to estimate the long term growth rate in the discounted
- xls edu
- pdf handout on growth rates discrete time analysis
- pdf graphing the von bertalanffy growth equation
- pdf npv calculation illinois institute of technology
- xlsx
- pdf growthratesandlogarithms arefresher
- pdf estimating tumor growth rates in vivo edu
- pdf downloading gurufocus data into excel the powerful guruf
- pdf section ii 5 growth rates of functions dartmouth college
Related searches
- https www municipalonlinepayments
- nyu admissions staff
- nyu admissions requirements
- nyu admission requirements gpa
- nyu admission requirements for transfer
- nyu requirements for admission sat
- nyu school of dentistry implant
- nyu freshman admission requirements
- nyu application requirement
- nyu office of undergraduate admissions
- nyu gpa and sat requirements
- nyu admission requirements sat