Case Study #1 - Revenue Projection Case Outline: Assume that each deal our account executive wins involves software re
Posted: Thu Apr 28, 2022 1:31 pm
Case Study #1 - Revenue Projection
Case Outline:
Assume that each deal our account executive wins involves software
revenue. (We will omit hardware revenue and professional services
which we do sell as well)
The baseline won deals for last month = 100 deals
The baseline for our Starter/Advanced deal won split is 50:50
The baseline for our Monthly/Yearly deal split is 70:30
The baseline for each won deal is 1.2 stores. Means each account
has 0.2 extra stores on average.
Leads to win conversion is 10%.�Cost per lead = RM100 Marketing
budget for next 12 months = RM 1 500 000
Each deal can be Starter or Advanced Plan and Monthly or Yearly.
And depending on the account, it may have additional stores as
well. You can check the pricing on our website. (we will omit Pro
Plan and additional registers for this exercise)
What you will need to do:
Please map out a month to month revenue projections (software only)
on google sheet or excel for the next 12 months (From August 2021
to August 2022) using a bottoms up approach. You are expected to
assess the Malaysia market situation for the 12 months taking into
account seasonalities, covid situation etc and see where you can
tweak the baseline variables above. There is no right or wrong for
the projections. But please state your assumptions.
Case Outline:
Assume that each deal our account executive wins involves software
revenue. (We will omit hardware revenue and professional services
which we do sell as well)
The baseline won deals for last month = 100 deals
The baseline for our Starter/Advanced deal won split is 50:50
The baseline for our Monthly/Yearly deal split is 70:30
The baseline for each won deal is 1.2 stores. Means each account
has 0.2 extra stores on average.
Leads to win conversion is 10%.�Cost per lead = RM100 Marketing
budget for next 12 months = RM 1 500 000
Each deal can be Starter or Advanced Plan and Monthly or Yearly.
And depending on the account, it may have additional stores as
well. You can check the pricing on our website. (we will omit Pro
Plan and additional registers for this exercise)
What you will need to do:
Please map out a month to month revenue projections (software only)
on google sheet or excel for the next 12 months (From August 2021
to August 2022) using a bottoms up approach. You are expected to
assess the Malaysia market situation for the 12 months taking into
account seasonalities, covid situation etc and see where you can
tweak the baseline variables above. There is no right or wrong for
the projections. But please state your assumptions.