Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-10-2015, 03:22 AM
sshetty sshetty is offline Revenue REcognition for Leasing business Windows 8 Revenue REcognition for Leasing business Office 2013
Novice
Revenue REcognition for Leasing business
 
Join Date: May 2015
Posts: 1
sshetty is on a distinguished road
Thumbs up 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
Reply With Quote
  #2  
Old 05-11-2015, 01:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Revenue REcognition for Leasing business Windows 7 64bit Revenue REcognition for Leasing business Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,462
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Hi and welcome
could you please post a sample sheet? ( no pics please)
Reply With Quote
Reply

Tags
recognition, revenue

Thread Tools
Display Modes


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
Revenue REcognition for Leasing business 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft