Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  How to calculate future revenue

    Posted 16 days ago
    Edited by Klaus T 16 days ago
    Hi

    I want to calculate/estimated the revenue the first 4 month after a deal. It is lower the first 4 month.

    Invoicing
    MRR 7. WON Mth 1 Mth 2 Mth 3 Mth 4
    Case 1 10,000 10/31/2022 0% 25% 75% 100%
    0 2,500 7,500 10,000
    Mth 1 Mth 2 Mth 3 Mth 4
    Case 2 25,000 11/30/2022 0% 25% 75% 100%
    0 6,250 18,750 25,000
    Invoicing
    Oct Nov Dec Jan Feb Mar
    Case 1 0 0 2,500 7,500 10,000 10,000
    Case 2 0 0 0 6,250 18,750 25,000
    Total 0 0 2500 13750 28750 35000
    Contract signment

    I know the monthly revenu and contrract date at contract signment, and then I want to calculate MR the next 4  month for all won cases.

    How to?

    ------------------------------
    r
    ------------------------------


  • 2.  RE: How to calculate future revenue

    Posted 11 days ago

    Hi Klaus,

    What do you mean by MRR?

    The data presentation is quite confusing as how you distribute the MRR of 10,000 in case 1. The value in revenue exceed 10,000 from Dec-Mar i,e, 2.5K + 7.5K + 10K + 10K = 30K. 

    Rd



    ------------------------------
    Rd 3nidad
    Senior Finance Analyst
    ------------------------------



  • 3.  RE: How to calculate future revenue

    Posted 11 days ago
    Edited by Klaus T 11 days ago
    Hi

    Sorry. MRR means Monthly Revennue in the contract period.

    In case 1 the monthly revenue is 0% (0), 25%(2.5K), 75%(7.5K) and 100%(10K) in the first 4 month. After that it is 100%(10K) per month.

    I hope that helps with the confusion. :-)




  • 4.  RE: How to calculate future revenue

    Posted 11 days ago

    Hi,

    For how long the monthly revenue will exist? Let say case 1, you have 1st 4 months but there is still a value on 5th month? When it will stop?




    ------------------------------
    Rd 3nidad
    Senior Finance Analyst
    ------------------------------



  • 5.  RE: How to calculate future revenue

    Posted 11 days ago
    Edited by Klaus T 11 days ago
    Hi

    In month 5 to 12 it is 100% per month , and then it will stop.

    /



  • 6.  RE: How to calculate future revenue
    Best Answer

    Posted 11 days ago
      |   view attached

    Hi,

    You can directly work on power query to generate the series required. Check the attached file and view it in power query and check the query steps.

    Rd



    ------------------------------
    Rd 3nidad
    Senior Finance Analyst
    ------------------------------

    Attachment(s)

    pbix
    MRR_01.pbix   72 KB 1 version


  • 7.  RE: How to calculate future revenue

    Posted 11 days ago
    Edited by Klaus T 11 days ago
    Hi

    Brilliant, fantastic.

    Thank you. :-)