Display Future projection for Oracle Assets

Currently I am working on fixed asset register report wand and I need to add Projection columns in SQL query.

Current query o/p will look like below,

   

Asset Number	Depreciation Amount	Remaining Life of asset in   months
1	400	6
2	200	3
3	100	4
4	600	1

Now, I want modification in SQL that according remaining life of asset in months column should generate. For 1st asset remaining life of asset in months is 6, so total 6 projection columns should come with value as 400. If remaining life is less than maximum no. i.e 6 then it should give 0 for rest of columns.

I want final solution like below,

     

Asset Number