Greetings! First post here at Mr. Excel I wanted to see if this could be done:
I have a data set where I'm wanting to amortize an amount of a certain period of time. Let's say for a certain property, their implementation fee is $24000 and the implementation period/contract life is 24 months. I have a three year period, let's say Jan 2017 - Dec 2019. The implementation period starts in March 2017 and continues for 24 months. Additionally, the first months' implementation ($1k) needs to be prorated. For example, if implementation began on March 15, the implementation revenue recognized in March would be ($1k * 16/31). Thus, month 24 would reflect the final 15 days from the from month. Months 2 - 23 will be for the full amount.
Any thoughts how this can be done?
Thanks for all the help!
I have a data set where I'm wanting to amortize an amount of a certain period of time. Let's say for a certain property, their implementation fee is $24000 and the implementation period/contract life is 24 months. I have a three year period, let's say Jan 2017 - Dec 2019. The implementation period starts in March 2017 and continues for 24 months. Additionally, the first months' implementation ($1k) needs to be prorated. For example, if implementation began on March 15, the implementation revenue recognized in March would be ($1k * 16/31). Thus, month 24 would reflect the final 15 days from the from month. Months 2 - 23 will be for the full amount.
Any thoughts how this can be done?
Thanks for all the help!
