+ Reply to Thread
Results 1 to 2 of 2

Income Projection/ Revenue Projection templates

  1. #1
    Registered User
    Join Date
    09-17-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    35

    Income Projection/ Revenue Projection templates

    Hello,
    I am looking to overhaul the current income projection that my company has which is quite basic in the sense that it just shows everysingle's project revenue projection throughout the year and total spend per project and how much it is overservicing, I wanted to analyse more 'costs incurred' vs billed and because every project is owned by a project manager, like a summary sheet to analyse a few aspects.
    Does anyone know where i can get templates/programs that would help me analyse this?
    Many thanks,
    David

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Income Projection/ Revenue Projection templates

    Hi,

    Personally I'd build a normalised two dimensional database of records. The column headers would be each unique type of information and the rows every individual record. So for instance the column headers would be

    Date
    Project ID
    Source - information in this column would be text like 'Revenue Projection', 'Spend', 'Cost Incurred','Billed'
    £ Value

    Should you need a sub analysis of cost incurred then an additional column header 'Cost Type' should be included and values in this column would be cost descriptors like say, 'wages', 'materials' , 'expenses' etc..

    A separate table would contain a list of Project Ids and their manager

    Once you have two tables like this then analysis by Pivot Table or regular Excel formulae is simplified considerably.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. sales projection
    By ANSARI102 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-04-2014, 04:36 AM
  2. [SOLVED] Budget Projection
    By danmarsh in forum Excel General
    Replies: 1
    Last Post: 07-11-2013, 07:34 AM
  3. Projection formula
    By dougmcc1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-18-2012, 01:35 PM
  4. Excel 2008 : Creating a Revenue Projection Graph
    By zachg18 in forum Excel General
    Replies: 1
    Last Post: 11-30-2011, 06:20 PM
  5. Replies: 1
    Last Post: 07-13-2009, 11:52 AM
  6. dealing with a projection
    By Larry Holt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-15-2006, 12:10 PM
  7. Projection !
    By tanksalevikrant in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-24-2005, 03:28 AM

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