09-02-2018, 10:17 AM
Hi all can anyone get this calculator off this site in any usable offline format (ex. excel)?
Site:
Much thanks
MassBlack
Site:
Magic Button :
Much thanks
MassBlack
SubscriptionCost, NumberOfSubscribers, CampaignsPerMonth, AverageReadRate, EstimatedResponseRate, AverageSpend
NumberOfSMSTextReaders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100))
CostPerSMSReaders = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100))
NumberOfSMSTextResponders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100))
CostPerSMSTextResponders = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100))
EstimatedTotalRevenue = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100)* AverageSpend)
CostPerSMSText = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth)
EstimatedTotalProfit = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100) * AverageSpend) - SubscriptionCost
ReturnOnInvestment = ((EstimatedTotalProfit - SubscriptionCost)/SubscriptionCost) * 100
(09-03-2018 01:07 AM)feefiefohfum Wrote: [ -> ]After some copy paste, search and replace, here is the next best thing (if you are okay to do the calculations manually):
Have the following inputs:
Code:
SubscriptionCost, NumberOfSubscribers, CampaignsPerMonth, AverageReadRate, EstimatedResponseRate, AverageSpend
Use the following formulae to get the results:
Code:
NumberOfSMSTextReaders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100))
CostPerSMSReaders = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100))
NumberOfSMSTextResponders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100))
CostPerSMSTextResponders = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100))
EstimatedTotalRevenue = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100)* AverageSpend)
CostPerSMSText = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth)
EstimatedTotalProfit = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100) * AverageSpend) - SubscriptionCost
ReturnOnInvestment = ((EstimatedTotalProfit - SubscriptionCost)/SubscriptionCost) * 100
Cheers,
FFFF