Note:

(i) You can enter the number of months to calculate the cost and revenue for the opportunity in “Calculate the total for # months”

(ii) Calculation of Totals and Margin:

Total Revenue = One-time revenue

+ (Weekly revenue * 4 * Number months to calculate totals)

+ (Monthly revenue * Number months to calculate totals)

+ (Quarterly revenue/3 * Number months to calculate totals)

+ (Half-yearly revenue/6 * Number months to calculate totals)

+ (Yearly revenue/12 * Number months to calculate totals)

Total Cost = One-time cost

+ (Weekly cost * 4 * Number months to calculate totals)

+ (Monthly cost * Number months to calculate totals)

+ (Quarterly cost/3 * Number months to calculate totals)

+ (Half-yearly cost/6 * Number months to calculate totals)

+ (Yearly cost/12 * Number months to calculate totals)

Margin Value = Total revenue - Total Cost

Margin Percentage = (Total revenue - Total Cost) / Total revenue

Total Revenue: 1000 + (100 * 4 * 6) + (500 * 6) + (1000/3 * 6) + (5000/6 * 6) + (10000/12 * 6) = 18400

Total Cost: 800 + (80 * 4 * 6) + (400 * 6) + (800/3 * 6) + (4000/6 * 6) + (8000/12 * 6) = 14720

Margin Value: 18400 - 14720 = 3680

Margin percentage: 3680 / 18400 = 20%