Hello All,
I need help to perform the following which I have included as an excel paste. Hope its legible. Please see towards bottom on what I need help with. Thanks!!
<tbody>
</tbody>
I need help to perform the following which I have included as an excel paste. Hope its legible. Please see towards bottom on what I need help with. Thanks!!
Company | Start Date | End Date | Commitment | Threshold | Term in Months | Jan-12 | Feb-12 | Mar-12 | Apr-12 | May-12 | Jun-12 | Jul-12 | Aug-12 | Sep-12 | Oct-12 | Nov-12 | Dec-12 | 1/1/2013 | 2/1/2013 | 3/1/2013 | 4/1/2013 | 5/1/2013 | 6/1/2013 | 7/1/2013 | 8/1/2013 | 9/1/2013 | 10/1/2013 | 11/1/2013 | 12/1/2013 |
Association A | 1/1/2012 | 12/31/2012 | $ 40,000 | Amortize | 12 | $ 3,333.33 | |||||||||||||||||||||||
Association B | 2/1/2012 | 1/31/2013 | $ 12,000 | Amortize | 12 | $ 1,000.00 | |||||||||||||||||||||||
Association C | 4/1/2012 | 3/31/2013 | $ 45,000 | Amortize | 12 | $ 3,750.00 | |||||||||||||||||||||||
Association D | 6/1/2012 | 12/31/2012 | $ 15,000 | Amortize | 7 | $ - | |||||||||||||||||||||||
Association E | 11/1/2012 | 10/31/2013 | $ 5,000 | Do not Amortize | 12 | $ - | |||||||||||||||||||||||
Association F | 12/1/2012 | 5/3/2013 | $ 125,000 | Amortize | 6 | $ - | |||||||||||||||||||||||
Requirements - Need a function to perform the following: | |||||||||||||||||||||||||||||
If Commitment amount = "Amortize," Then each month's amortized value needs to pick up value of after start date thru end of contract date. | |||||||||||||||||||||||||||||
For example, in Cell A7, Association C's start date is April 1st, therefore no value will be amortized until April-Dec'12 which will equate to $45000/12 | |||||||||||||||||||||||||||||
If Commitment amount = Do Not Amortize, Then the commitment amount needs to be accounted for at the end of current year (i.e., Dec'12 in this example). | |||||||||||||||||||||||||||||
<tbody>
</tbody>