Appendix B Excel Program Entries: Automating the Formulas
accounts receivable turnover
| A1 | credit sales |
| B1 | average accounts receivable |
| C1 | =SUM(A1/B1) |
accumulated value of 1 per period
A1: FV(r/n,y*d)
r = interest rate
n = number of periods per year
y = number of years
d = amount of periodic deposits
A/D line
| A1 | money flow multiplier |
| B1 | volume |
| C1 | prior A/D |
| D1 | =SUM(A1*B1)+C1 |
Adjusted breadth of trading
| A1 | high price in the range |
| B1 | spike above price range |
| C1 | low price in the range |
| D1 | =SUM((A1-B1)-C1)/C1 |
adjusted debt ratio
| A1 | long-term debt |
| B1 | mandatorily redeemable preferred stock |
| C1 | total capitalization |
| D1 | =SUM(A1+B1)/C1 |
advance/decline price line
| A1 | previous a/d line |
| B1 | net advances or declines |
| C1 | =SUM(A1+B1) or ... |
Get Stock Market Math now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
