Formula to apply multiple rates (that compound) to a core number.

[Bonga]

I seem to recall an excel formula that would allow me to take a direct labor cost, apply a fringe rate, apply an overhead rate, apply a general & administrative rate, and finally apply a profit rate, in one fell swoop. I thought it was the [ =schedule ] function, but that doesn't seem to exist. Example: =???Function????(Labor cost, Fringe Rate, O/H Rate, G&A Rate, Profit Rate) -- instead of ("X" * (1+Fringe)*(1+O/H)*(1+G&A)*(1+Profit).

Can anyone refresh my memory?

Thank you and Kind regards,

Bonga

 

[sheetspread]

This?

Excel 2010
	A	B	C
2	12		0.03
3	15.07544		0.11
4	15.07544		0.05
5			0.0465
Sheet9

Cell Formulas
Range	Formula
A4	=12*(1+C2)*(1+C3)*(1+C4)*(1+C5)
A3	{=A2*PRODUCT(1+C2:C5)}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Bonga]

That will work, thank you... ~bonga

 

[Eric W]

Also:

=FVSCHEDULE(A2,C2:C5)

 

[Bonga]

Eric: This was what I was looking for... Thanks, you da MAN!!!! Thanks.

 

[Eric W]

Some of the financial functions are a little obscure. I knew there was one that did what you wanted, but I had to go search for it.

Glad to help!