jd92
New Member
Hey Guys
Looking to get a bit of help here making a more efficient formula for one of my financial models. Any help is greatly appreciated! I have attached a rough version for your reference.
The model:
Right now, all I am using is a simple 'if' formula to determine whether or not there is a certain value present. You will note this formula in row 10, columns I through Q. All I am trying to do with this formula is determine whether or not production has begun. The 'if' formula is looking at row 9 to determine whether on not there is a value. The purpose is to determine in what year production begins, and designates this year "1", and so forth.
Once production has begun and the year has been identified (row 10), we link the value to row 6 columns I through Q. In row 7 (I though Q), I am using an index,match function to find the appropriate value based off of when production has begun.
In short, if you toggle to "1" you will note that production has begun in year 1, which tells the index,match function to find the appropriate percentage of depreciation from the schedule in row 15. If you toggle to "2", you will note that production begins in year 2 which in turn tells the index,match function to begin depreciating a year later.
An important point of this model is that there are multiple scenarios controlled via the toggle which determine annual production, so production is different from year to year and starts at different years as well. Ultimately, my goal is to create a better formula in row 7 (I through Q) in order to more efficiently pull depreciation based off of when production begins.
Thanks in advance!
Looking to get a bit of help here making a more efficient formula for one of my financial models. Any help is greatly appreciated! I have attached a rough version for your reference.
The model:
Right now, all I am using is a simple 'if' formula to determine whether or not there is a certain value present. You will note this formula in row 10, columns I through Q. All I am trying to do with this formula is determine whether or not production has begun. The 'if' formula is looking at row 9 to determine whether on not there is a value. The purpose is to determine in what year production begins, and designates this year "1", and so forth.
Once production has begun and the year has been identified (row 10), we link the value to row 6 columns I through Q. In row 7 (I though Q), I am using an index,match function to find the appropriate value based off of when production has begun.
In short, if you toggle to "1" you will note that production has begun in year 1, which tells the index,match function to find the appropriate percentage of depreciation from the schedule in row 15. If you toggle to "2", you will note that production begins in year 2 which in turn tells the index,match function to begin depreciating a year later.
An important point of this model is that there are multiple scenarios controlled via the toggle which determine annual production, so production is different from year to year and starts at different years as well. Ultimately, my goal is to create a better formula in row 7 (I through Q) in order to more efficiently pull depreciation based off of when production begins.
Thanks in advance!
