+ Reply to Thread
Results 1 to 2 of 2

amortize revenue

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    US
    MS-Off Ver
    2010
    Posts
    1

    amortize revenue

    if i have customers paying me one time for 48 months; & if i have spread out revenue equally every month

    how do i calculate monthly revenue for 5 years in excel

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: amortize revenue

    Hello bhavin.gandecha, Welcome to Excel Forum.
    If I understand correctly you may be looking for something like: =A2/B2 as applied to the attached file. If this isn't what you are looking for please upload a sample spreadsheet, that shows the results (manually entered) that you expect a formula to return, by clicking on the GO ADVANCED below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 11-18-2015, 02:33 AM
  2. Revenue Calculation based on Variable revenue Percentage
    By suhabthan in forum Excel General
    Replies: 0
    Last Post: 06-19-2014, 12:48 PM
  3. [SOLVED] Formula to Amortize Expected Revenue across Months of a project
    By Awdvgyjmko in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2014, 03:57 PM
  4. Revenue recognition and deffered revenue
    By saurabhwise in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-08-2013, 11:12 AM
  5. [SOLVED] Difference between total revenue - last days revenue
    By vinodt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-08-2012, 02:35 PM
  6. [SOLVED] do I have to manually change PER to amortize a loan out 40 years?
    By Chuck Snyder in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 09:05 PM
  7. do I have to manually change PER to amortize a loan out 40 years?
    By ldk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1