Cash Flows(现金流)

Annuities(年金)

1. 年金的单期收益率(Periodic interest rate of annuity)

annurate(num,payment,pv <,fv,due>)

2. 未来获取目标收益所需要的期数(Number of periods to obtain value)

annuterm(rate,payment,pv <,fv,due>)

Amortizationand Depreciation(分期偿还与折旧)

1. 等额分期偿还安排(Amortization schedule)

[principal,interest,balance,payment]:amortize(rate,num,pv,fv,due)

2. 常规的余额递减折旧计划(General declining-balance depreciation schedule)

depgendb(cost,salvage,life,factor)

3. 固定折旧率的余额递减折旧计划(Fixed declining-balance depreciation schedule)

depfixdb(cost,salvage,life,period)

4. 等额折旧计划(Straight-line depreciation schedule)

depstln(cost,salvage,life)

5. 按年限折旧计划(Sum of years' digits depreciation)

depsoyd(cost,salvage,life)

6. 剩余折旧额(Remaining depreciable value)

deprdv(cost,salvage,accum)

Present Value(现值)

1. 变动现金流的现值(Present value of varying cash flow)

pvvar(cash_flow,rate <,irr_cfdates>);

2. 等额支付的现值(Present value with fixed periodic payments)

pvfix(rate,num,payment <,ext_payment,due>)

Future Value(终值)

1. 变动现金流的终值(Future value of varying cash flow)

fvvar(cash_flow,rate <,irr_cfdates>);

2. 等额支付的终值(Future value with fixed periodic payments)

fvfix(rate,num,payment <,present_val,due>)

3. 已贴现证券的到期价值(Future value of discounted security)

fvdisc(settle,maturity,price,discount <,basis>)

Payment Calculations(等额支付的计算)

1. 标准的等额支付(Periodic payment of loan or annuity)

payper(rate,num_periods,present_value,future_value <,due>)

2. 给期数提前还款情况下的等额支付(Periodic payment given number of advance payments)

payadv(rate,num_periods,present_value,future_value,advance)

3. 与变化现金流等价的等额支付(Uniform payment equal to varying cash flow)

payuni(cash_flow,rate)

4. 首期有时间零头的等额支付(Payment of loan or annuity with odd first period)

payodd(rate,num,pv,fv,days)

Rates of Return(收益率)

1. 实际收益率(Effective rate of return)

effrr(rate,num_periods)

2. 票面收益率(Nominal rate of return)

nomrr(rate,num_periods)

3. 税后收益率(After-tax rate of return)

taxedrr(pre_tax_return,tax_rate)

4. 内部收益率(Internal rate of return)

[return,all_rates]:irr(cash_flow)

5. 非周期性现金流的内部收益率(Internal rate of return for nonperiodic cash flow)

xirr(cash_flow,cash_flow_dates <,guess,max_iterations,basis>)

Cash Flow Sensitivities(现金流的敏感性)

1. 现金流的久期和修正久期(Cash-flow duration and modified duration)

cfdur(cash_flow,yield)

2. 现金流的凸率(Cash flow convexity)

cfconv(cash_flow,yield)

混沌 <youliang@chaoskey.com>

http://blog.chaoskey.com