#1
|
|||
|
|||
Revenue REcognition for Leasing business
Hi
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 |
#2
|
||||
|
||||
Hi and welcome
could you please post a sample sheet? ( no pics please)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
recognition, revenue |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Formula Showing Revenue Recognition Based on Days and Months | stratcat | Excel | 4 | 03-16-2014 10:09 AM |
Business letter | MK_Huef | Word | 1 | 03-27-2012 03:27 AM |
Need Business Cards for 80 Attendees | ruganesh10 | Word | 2 | 03-06-2012 03:22 AM |
Business Powerpoint Presentation | Corneb | PowerPoint | 0 | 01-23-2012 01:45 AM |
Emails during business hours ONLY. | sdavisoftv | Outlook | 4 | 09-17-2011 03:23 PM |