Year End Projection

[Yandeez]

Hi,

Please see attached. How can I project the 2015 Year end actual using that completion rate?

thanks in advance.

 

[John Jairo V]

Hi!

If you use 2014YTD/2014YEA = Rate, the same way is in 2015

2015YTD/2015YEA = Rate

Clearing 2015YEA:
2015YTD/Rate = 2015YEA

The resultant formulae in B8 must be:
=B7/B5

Please comment!
I hope it helps. Blessings!

 

[Yandeez]

Hi John,

Thank you much for the response!

 

[Istiyak]

you can use GoalSeek feature of Excel