I am building a financial model and need help with how to accelerate revenue drivers without doing it manually. What I am trying to do is build a revenue schedule where a piece of equipment is added on a start date and then based on the accelerator an additional piece is added every Nth month. What is a good excel formula to accomplish this?
| +125 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 2d |
| +76 | Return Rates For Interns Are Falling? | 32 | 16m |
| +61 | London IB BB is a challenge | 38 | 2h |
| +52 | VP Lifestyle at Top BB Coverage Groups | 32 | 37m |
| +52 | I am a drunk MD AMA | 29 | 55m |
| +46 | SharePoint makes IB hours HELL | 15 | 1d |
| +46 | An Outsider’s View of RX Banking Out of College | 6 | 4h |
| +41 | momentum of Rx groups | 13 | 2h |
| +38 | Fired during interview | 7 | 4h |
| +27 | Series 79 Help | 13 | 13h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Let me get this straight: you want to add a piece of equipment in month one and then add another piece of equipment in every Nth month, where N is a hard-coded driver, correct? So, for example, if N=3, you add one piece of equipment in January, another piece of equipment in April, another in July, etc., correct?
Yes. That is what I am trying to achieve.
Ok, give me a few minutes. I can think of some "sloppy" way to do this, but there is probably a neat way. Have you tried anything yet?
I tried by listing the equipment individually and set dates for each piece then use an if/then. But I don't think this looks as clean.
You could use a hidden MONTH() row, then use a IF statement to calculate the difference between months. If difference between months = n, add equipment, if not, "".
Ea dolorem officiis nulla et deserunt rem et odio. Eligendi sed at expedita. Earum sequi voluptates est libero.
Illo sunt non reprehenderit fugit quod ducimus. Et dolorem id cum nulla molestiae. Ex possimus qui voluptatem optio.
Pariatur dolor aliquam corrupti sunt ut similique. Animi nisi eveniet porro laudantium. Magnam nemo enim repudiandae sed est. Omnis reiciendis velit excepturi ullam recusandae molestiae. Et ab temporibus eligendi soluta mollitia et. Qui dicta fuga et saepe maiores fuga. Cumque nisi aut eaque.
Suscipit deserunt qui nostrum voluptatem aut. Laborum impedit ut qui. Qui sequi quos omnis qui corporis quaerat officiis. Veniam sint voluptatem est voluptas molestiae quibusdam. Qui laboriosam iste voluptate.
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...