How to Use Excel to Calculate Deferred Revenue

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Email

If you are in business, the chances are you've received income from a customer but haven't yet provided a service. The money for services or items that you have received but have not yet delivered on is deferred revenue. Deferred revenue could be a factor if you are a business that offers prepaid plans of any kind, including yearly contracts, discounts for pay-in-advance or any other service where you have been paid but have not yet delivered a service or item. Microsoft Excel can calculate deferred revenue for your business.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Excel 2007 or Excel 2010

Show MoreHide

Instructions

  1. 1

    Open a blank worksheet in Microsoft Excel, Click the "Office" button and then click "New." Click "Blank Workbook" and then click "Create."

  2. 2

    Click cell "A1" and then type "Earnings."

  3. 3

    Click cell "B1" and then type "Prepaid."

  4. 4

    Click cell "C1" and then type "Percentage of contract left."

  5. 5

    Click cell "D1" and then type "Deferred income."

  6. 6

    Click cell "A2" and then type the name of your first customer or income source.

  7. 7

    Click cell "B2" and then type the amount the customer has paid you for the work. For example, type "$2400."

  8. 8

    Click cell "C2" and then type the percentage of the contract that is remaining. For example, if you have contracted with a customer to clean its building for 12 months and there are 11 months remaining, the percentage is 11/12 or 0.92.

  9. 9

    Click cell "D2" and then type "=b2*c2." Press the "Enter" key to calculate the deferred revenue for the item.

Tips and warnings

  • If you have multiple customers and multiple rows of information, you don't have to retype the formula each time. Grab the fill handle, which looks like a little black square, at the bottom right hand corner of cell D2. Drag the fill handle down the column to fill as many rows as you need. Excel will automatically calculate the deferred revenue for each row.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.