Depreciation Expense

Hi Experts

I have a requirement where the planning cycle run from April 2013 to December 2018. We also have information about the various Projects and their In-Service Month, Asset Value, Asset Useful Life. The In-Service month can be any month in the planning cycle and the depreciation expense should be calculated (Asset Value / Asset Useful Life) and allocated starting from the month after the In-Service month until end of planning cycle month (if the asset life is longer than the plan cycle) or whatever the month when the life ends (if the asset life is shorter than the plan cycle).

Kindly request your expert advise on the approach as to what function should I use in the script logic.

Thanks

Ashok