REvenue REcognition

sshetty

New Member
Joined
Apr 16, 2015
Messages
2
Hi

I am not sure how to attach the file I am referring to, in this thread

I am working on Revenue Recognition calculation for a shopping centre

The first sheet is based on straightlining method where each month revenue recognized based on Total Lease Year Rentals/total months in lease year

The second sheet is based on actual cash accounting basis wherein the monthly recognition escalates with every year's rent escalation

Currently I am manually copy pasting the existing formula for each new lease line.

I would love to see one common formula which I can apply in all months cell and with Rent commencement dAte (RCD ) column variable, excel should calculate monthly revenue in both method.

Let me know how can I attach the excel file to this forum, so that it can make sense what I am referring above.

Let me know if this is possible,


Thanks Regards
Santosh
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,578
Messages
5,770,948
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top