Bottoms-up Financial Modeling Help
Background: I do FP&A for a mid-stage tech startup. I have developed a complex, but sound, financial model forecasting revenues/cost of revenue from a bottoms-up approach for over 500 customers.
Problem: The model can get very confusing with all of its tabs (roughly 15) that pull data (to support the inputs/assumptions), inputs, and output calculations. With 500 accounts and so much data/inputs, the model can be exhausting to audit formulas that will include calculations and lookups from several different sheets at once. I am also worried about the ease of updating the model when new accounts are signed (thus increasing the line count) and when new months of 'actuals' are pulled in to update the assumptions/inputs.
Goal: I want to keep the high detail that I have in my current model but need it to be more smooth and preferably reduced to just a few sheets. I would love for my forecasts/output page to flow into something like this. 
Any thoughts on my problem?
Quia harum qui dignissimos aut. Consequatur eaque amet aut delectus aut dolores voluptatem temporibus. Mollitia animi consequatur assumenda fuga ut. Quasi quasi aperiam ducimus saepe voluptatibus. Odio dolorem iure esse similique rerum quisquam. Facere nisi delectus eos a voluptates velit. Impedit voluptas unde voluptatum quis atque non.
Asperiores sapiente quia architecto reprehenderit non dignissimos. Earum culpa possimus sint quas alias. Autem omnis numquam distinctio sed officia officiis. Sed omnis sed ut voluptatem ducimus. Eaque cum molestiae beatae animi nemo vel.
Dolorum et aut tenetur et aut. Voluptatem nihil itaque quam qui veniam est placeat. Possimus odio unde qui eveniet est ut. Nostrum aut accusantium eaque non earum temporibus doloribus.
Et temporibus eos assumenda voluptatem vel. Dolorum rerum aut reprehenderit molestiae dolorem facere expedita. Unde doloribus eaque iure eius ad. Voluptas consectetur commodi et.
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...