Open Side Menu Go to the Top
Register
Formula help Formula help

01-18-2019 , 12:17 AM
I’m dumb and sort of drunk.

Say a company receives 386 million over 15 years.

They receive 100 percent of the money first 11 years.

Then it burns off 80 percent, 60 percent, 40 percent, 20 percent the last 4 years.

What formula do I run to calculate how the 386 million is split over the 15 years.
Formula help Quote
01-18-2019 , 02:14 AM
11x + .8x + .6x +.4x +.2x = 386 million dollars
Formula help Quote
01-18-2019 , 08:41 AM
How can you write this in Excel.

I'm missing something. If you add those up and divide 386/13 you get 29.6
Formula help Quote
01-18-2019 , 02:28 PM
Quote:
Originally Posted by TheWhoWhat
How can you write this in Excel.

I'm missing something. If you add those up and divide 386/13 you get 29.6
29.6 million for the first 11 years = 325.6
plus 80% of 29.6 million or 23.68
plus 60% of 29.6 million or 17.76
plus 40% of 29.6 million or 11.84
plus 20% of 29.6 million or 5.92

Add all that up and you get your 386 million(it will be a little off because of rounding errors). I don't know much about making spread sheets.
Formula help Quote
01-18-2019 , 09:32 PM
yeah, I get that. I did that on my own but I'm looking for a proper method to figuring out the formula.
Formula help Quote
01-24-2019 , 12:49 PM
A1: 386
B1: =B2+B3+B4+B5+B6
B2: =1*11
B3: =0.8*1
B4: =0.6*1
.
.
.
A2: = ($A$1/$B$1)*B2
A3: = ($A$1/$B$1)*B3
.
.
.

This is what you are looking for?
Formula help Quote

      
m