Independent marketing representative
This page is not finished yet. Sorry!
| A | B | C | D | E | |
| 1 | Number of Years | 30 | |||
| 2 | Interest Rate | 7.50% | |||
| 3 | Principle | $100,000.00 | |||
| 4 | Payment | =PMT(b2/12,b1*12,b3) | |||
| 5 | |||||
| 6 | Balance | Interest | Principle Paid | PrePaid | New Balance |
| 7 | =b3 | =a7*$b$2/12 | =$b$4-b7 | $200.00 | =a7-c7-d7 |
| 8 | =e7 | =a8*$b$2/12 | =$b$4-b8 | $125.00 | =a8-c8-d8 |
| 9 | =e8 | =a9*$b$2/12 | =$b$4-b9 | $400.00 | =a9-c9-d9 |
| A | B | C | D | E | |
| 1 | Number of Years | 30 | |||
| 2 | Interest Rate | 7.50% | |||
| 3 | Principle | $100,000.00 | |||
| 4 | Payment | $699.21 | |||
| 5 | |||||
| 6 | Balance | Interest | Principle Paid | PrePaid | New Balance |
| 7 | $100,000.00 | $625.00 | $74.21 | $200.00 | $99,725.79 |
| 8 | $99,725.79 | $623.29 | $75.93 | $125.00 | $99,524.86 |
| 9 | $99,524.86 | $622.03 | $77.18 | $400.00 | $99,047.67 |
