| | i% n |
|
| ||
| 1 + |
| | - | 1 | |
| ||||||
USFV (i% : n) = | | 100 |
|
|
| |
| i% |
|
|
| ||
|
|
|
|
| ||
|
| 100 |
|
|
|
|
Percentage Calculations in Business (BUS)
%CHANGE = | NEW - OLD | ⋅ 100 | |||
|
| | |||
OLD | |||||
| | |
|
%TOTAL = | PART | | ⋅ | 100 |
|
|
|
| ||||
|
|
|
|
| |
|
|
|
| |||
|
|
|
|
|
|
|
| |||||
| TOTAL |
|
|
|
|
|
| |||||
MARKUP%C | = | PRICE | - COST | ⋅ | 100 | |||||||
|
|
|
|
|
| | ||||||
|
| COST |
| |||||||||
|
|
| |
|
| |
|
| ||||
MARKUP%P | = | PRICE | - COST | ⋅ | 100 | |||||||
|
|
|
|
| | |||||||
|
| PRICE | ||||||||||
|
|
| |
| |
|
|
Time Value of Money (TVM)
S = payment mode factor (0 for End mode; 1 for Begin mode).
|
|
|
|
|
|
| i% | = | I%YR |
|
|
|
|
|
|
|
| P/YR | |||
|
|
|
|
|
|
|
|
| ||
| |
| i% ⋅ | S | ⋅ PMT ⋅ USPV (i% : n) + FV ⋅ SPPV(i% : n) | |||||
0 = PV + | 1 | + |
|
|
| | ||||
100 |
| |||||||||
| |
|
| |
|
|
|
|
Amortization
∑INT=accumulated interest
∑PRIN=accumulated principal i=periodic interest rate
BAL is initially PV rounded to the current display setting. PMT is initially PMT rounded to the current display setting.
i = | I%YR | ||
P /YR | ⋅ 100 |
| |
For each payment amortized: |
|
|
|
| B: More About Calculations 247 | ||
File name : | Print data : 2003/7/11 |