Deferred Revenue Schedule

[hongho]

I need to set up a deferred revenue schedule (see file attached). The revenue is deferred using a % spread from Month 1 to Month 5 Can anyone help me with a formula that could be copied into all other rows and columns in the table? Thanks so much!

[azumi]

Perhaps put on C6 and copied cross and down:

=$B6*C$3

[hongho]

Hi Azumi,

Thanks for your quick reply. However, the revenue generated in Jun will only start deferred in June, not in May. In another word, Cell C7 should be 0.

Thanks again for your help!

[azumi]

Then change to

=$B6*D$3

[hongho]

Hi Azumi,

Seems like I'm not successful in describing the problem. In the worksheet I attached in my original post, I've illustrated how the calc should be. Yours are not yielding the same results.

Thanks again.

[JeteMc]

Try pasting the following into cell C6 and dragging over and down:

Please Login or Register  to view this content.

Let us know if you have any questions.

[hongho]

Hi JeteMc,

I tried but the cell doesn't render any value? Could you please help?

Thanks,
Hong

[JeteMc]

Sorry, I left out a part of the solution. Cells C2:G2 are changed to numbers then custom formatted "M"0.
Let us know if you have any questions.