home *** CD-ROM | disk | FTP | other *** search
-
- Problem Amortization schedule worksheet that calculates the number of
- periods a loan will last given principal, mo pymt, and int rate.
- Will handle up to a 20 year loan.
-
-
-
-
- Block Diagram
- ___________________
- | |
- | Inputs |
- |___________________|
- | |
- | Amort Sched. |
- |___________________|
- | |
- | Macros & Crit. |
- |___________________|
-
-
-
-
-
- Tips
- @DCOUNT formula used to calculate the number of periods.
- (C6)
-
-
-
-
-
-
-
-
-
-
-