Hello, I am trying to figure out a formula that will: Determine ending number from a starting number based on a monthly % decline a well as a static number monthly decline...Example below...First column is months, second column starting number, third column a 1k decline per month and 4th column a .005 rate of decline. Each row recalculates by reducing the number above it by the 1000 and the "rate". How can I get to the final number using a formula? I can do it for just the rate but the monthly static number is throwing it off. Thank you
1 | 100000 | 1000 | 500 |
2 | 98500 | 1000 | 493 |
3 | 97008 | 1000 | 485 |
4 | 95522 | 1000 | 478 |
5 | 94045 | 1000 | 470 |
6 | 92575 | 1000 | 463 |
7 | 91112 | 1000 | 456 |
8 | 89656 | 1000 | 448 |
9 | 88208 | 1000 | 441 |
10 | 86767 | 1000 | 434 |
11 | 85333 | 1000 | 427 |
12 | 83906 | 1000 | 420 |