Calculating Exponents for Business Model

[DesperatelyLost]

Hi, Everyone.

I suspect I am a bit unique here. I'm struggling with a math problem for a business model rather than a homework assignment. It's been quite a while since I have worked with exponents and I am hoping someone can assist me with a question.

I have the following calculations:
280*.985^11
280*.985^10
280*.985^9
280*.985^8
280*.985^7
280*.985^6
280*.985^5
280*.985^4
280*.985^3
280*.985^2
280*.985^1

The base and coefficient are the same, but the exponent is not. I know that I can't add the exponents because they are not like terms. Is there a way to simplify this into one formula or do I need to calculate each one independently?

Thank you in advance for your assistance!

 

[skeeter]

use a capable calculator or a spreadsheet ...

 

[DesperatelyLost]

I'm already using a spreadsheet, but it's cumbersome to write out that large of a formula.

 

[skeeter]

I'm already using a spreadsheet, but it's cumbersome to write out that large of a formula.

I'm not a spreadsheet expert, so you'll probably need to research how to evaluate a function with multiple inputs on one ... or wait until someone with the necessary expertise posts a reply.

 

[tkhunny]

"280*.985^11
280*.985^10
280*.985^9
280*.985^8
280*.985^7
280*.985^6"

Cell A1: Enter 280
Cell A2: Enter 0.985
Cell A3: Enter 0
Cell A4: Enter =A3+1
Cells A5-A100: Copy the contents of A4 and paste
Cell B3: =A[dollar sign]1*A[dollar sign]2^A3
Cells B4-B100: Copy the contents of B3 and paste

It's upside down from your design, but small changes will solve that problem.

 

[I like Serena]

I'm not sure what you are looking for.
The general formula is 280*.985^n.
Each next value can be found by multiplying the previous value by .985,
Or alternatively each value can be found by the general formula.
Can you clarify what you are looking for?