Excel P&L projection multiple locations
I'm building a P&L projection for a rollout that's adding locations as time goes by. I have the performance projections for a single location, the next step is to combine these at specific times.
I want the model to be as flexible as possible, which is where my relatively limited knowledge of Excel comes into play. The goal is to have around 50 locations in 5 years, so it's necessary that you can easily change the number of locations opened and the time they are opened, with the projections updating.
I uploaded an example (see below) where the sum of all locations is hardcoded. Ideally, you could place any number in any quarter of the "added locations" row and have the projections updated - or something that works like that.
Doc: http://rapidshare.com/files/410007814/proj_exampl… or http://www.speedyshare.com/files/23590730/proj_ex…
Any ideas? Thanks in advance.
pm me your email
Worked out. Thanks a ton.
Distinctio molestiae nostrum et omnis non. Voluptates sequi omnis quos ullam nostrum molestias. Quae aut officia at aliquid ab. Id velit optio ut ut delectus eos. Totam reiciendis sed molestiae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...