Calculate Growth Amount from Total Revenue

Didn't find your answer?

Hi 

I am reconciling revenue for the month and need to calculate the growth amount for fees that have an uplift 

For example our standard fee might be £350 and we charged an uplift fee of 40% which is £490. The growth amount is £140. On the spreadsheet the revenue amount is the total amount we have charged ie £490 so what formula can I use to calculate the growth amount?

The current formula is revenue amount X 40% which is technically incorrect

Replies (2)

Please login or register to join the discussion.

avatar
By alfredpennypinch
17th Apr 2019 18:38

490 / 1.4 * 0.4 = 140

Or revenue / 1+growth% * growth%

Thanks (1)
Replying to alfredpennypinch:
avatar
By Jeran91
17th Apr 2019 19:45

Thank you so much that works!0

Thanks (0)