|
| | 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 | ||
|
|
|
|
|
|
|
| ||
0 = PV + | | + | i% ⋅ | S | ⋅ PMT ⋅ USPV(i% : n) + FV ⋅ SPPV(i% : n) | ||||
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%YR
i = P /YR ⋅ 100
For each payment amortized:
B: More About Calculations 247
File name :