Time-Value-of-Money and Amortization Worksheets 货币的时间价值与摊销表
00:48:12点击观看
1. 用TVM 功能: equal and regular cash 相等且有规律的现金流
- 按[N] [I/Y] [PV] [PMT] [FV] 中任5个键中的1个
- 已知其中4个变量,才能求出第5个变量
Variable | 中文 | Key |
Number of periods (N) | 期数 | [N] |
Interest rate per year (I/Y) | 年利率 | [I/Y] |
Present value (PV) | 现值 | [PV] |
Payment (PMT) | 付款 | [PMT] |
Future value (FV) | 未来值 | [FV] |
Number of payments per year (P/Y) | 每年支付次数 | 2nd [I/Y] |
Number of compounding periods per year (C/Y) | 每年复利计算期数 | 2nd [I/Y] ↓ |
End-of-period payments (END) | 期末支付 | 2nd [PMT] Setting |
Beginning-of-period payments (BGN) | 期初支付 | 2ndPMT |
时间线及每个数值的含义
TVMD的计算器显示
英文术语 | 中文翻译 |
---|---|
Perpetual bond | 永续债券 |
Perpetual ordinary annuity | 永续普通年金 |
Perpetual annuity due | 永续期初年金 |
Mortgage at 5% | 5%年利率的抵押贷款 |
Annual payment | 年付款 |
Outstanding balance | 未偿还余额 |
2. Amortization :使用 AMORT AMORTAMORT摊销功能
- 按 [2nd] [PV]
2.1 摊销表功能实现
Variable | 中文 | Key |
Starting payment (P1) | 起始支付时间 | 2nd [PV] |
Ending payment (P2) | 结束支付时间 | 2nd [PV] 2nd [Enter] |
Balance (BAL) | 余额 | 2nd [PV] ↓ |
Principal paid (PRN) | 偿还的本金 | 2nd [PV] ↓ |
Interest paid (INT) | 偿还的利息 | 2nd [PV] ↓ |
2.2 操作逻辑
输入:[N] [I/Y] [PV] [FV] 后,可计算出 [PMT]
再输入 [P1] [P2]后, BAL,PRN,INT可直接得出。
Cash Flow Worksheet 现金流量表计算
- variable cash flows,变动的现金流使用 CF 功能(Cash Flow)
- 按[CF ]直接输入
现金流量表的功能
Variable 中文 Key Initial cashflow (CF0) 初始现金流 (CF0) CF Amount of nth cashflow (Cn) 第n个现金流的金额 (Cn) CF↓ Frequency of nth cashflow (Fn) 第n个现金流的频率 (Fn) CF↓ Discount rate (I) 折现率 (I) NPV↓ Net present value (NPV) 净现值 (NPV) NPV ↓ Internal rate of return (IRR) 内部收益率 (IRR) IRR
如何恢复现金流量计算的默认模式
恢复CF 0,C nn 、F nn 到默认值(0):按[CF] [2ND] [CE|C]
恢复NPV到默认值(0) :按[NPV] [2ND] [CE|C];
恢复IRR到默认值(0):按[IRR] [2ND] [CE|C] ;
- 注: [2ND] [CE|C]表示:CLR WORK , 恢复默认值