Sales Projection

• A Sales Projection is the amount of revenue a company expects to earn after a certain amount of time. It helps determine if company sales will trend upward or downward.
• The formula to calculate the future value is

  =-FV(RATE,NPER,PMT,PV,TYPE)
• FV (Future Value) - Value of an investment based on periodic, constant payments and a constant interest rate.
• Rate - Interest Rate (Ex: 5%, 10%, 15%)
• NPER - Total Number of Periods (Ex: 5 years)
• PMT - Annuity paid regularly per period (Ex: $100, $200)
• PV - (Optional) is the present cash value of an investment.
• Type - (Optional) defines whether the payment is due at the beginning (1) or the end (0) of a period.
• IF FORMULA: =IF(TEST,THEN_VALUE,OTHERWISE_VALUE)
• The Paste special tool gives you more control on which properties you are copying and pasting onto a range of cells.