more-arw search

Q&A Forum

When forecasting financial models in excel, how do you make the timing of cashflows dynamic?

Robert Green's Profile

I am building a financial model for my company right now. We are a medical device company, so regulatory approvals timing has the ability to dramatically effect when cashflows are expected to occur.

I want to add an assumptions tab, where I will include "Months until reg approval." Based on this number, I want the cashflows to be offset to the right (or left) in a different sheet by the number of months in the assumption "Months until reg approval."

Which functions should I use and/or what are the best practices for doing this?

Any help would be greatly appreciated!

571 views
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.