CALCULATE YOUR DAILY INCOME AND EXPENSE
SIGN UP NEOBUX
Download Spread Sheet here:
Daily Profit Calculator Excel 2007
Daily Profit Calculator Excel 97-2003
Formula Reference:
Daily Income:
[(# of rented refs clicks) x (ref earnings per click)]
+
[(# of direct refs clicks) x (ref earnings per click)]
+
[(# of your clicks) x (your earnings per click)]
=Total Income
Daily Expense:
[(days renewing) / 30 x (1 - discount%) x (cost of 1 ref per month)
= (answer then needs to be round off to two decimal places)
x
(# of referrals) / (days renewing)]
=(renewing costs of all refs per day)
+
[(total yearly membership cost) / 365]
+
(recycling cost)
=Total Expense
Net Profit = (total income) - (total expense)
For example: Golden member
with 325 rented refs renewing at 240 days
with a 0.7 avg (325x0.7=227.5 clicks)
and 150 clicks from direct refs:
Daily income:
(227.5 clicks x 0.01)
+
(150 clicks x 0.005)
+
(9 clicks x 0.01)
Total income = $3.115
Daily expense:
[240 / 30 x (1 - 0.30) x 0.21
= 1.18 (rounded to two decimal places)
x
(325/240)]
Renewing cost = $1.598
+
(90/365)
+
(recycle cost)
Total expense = $1.844
Daily Net Profit (3.115-1.844) = $1.271
For example: Standard member
with 100 rented refs renewing at 150 days
with a 1.2 avg (100x1.2=120 clicks)
Daily income:
(120 clicks x 0.005)
+
(4 clicks x 0.001)
Total income = $0.604
Daily expense:
[150 / 30 x (1 - 0.25) x 0.20
= 0.75 (rounded to two decimal places)
x
(100/150)]
Renewing cost = $0.50
+
(recycle cost)
Total expense = $0.50
Daily Net Profit (0.604-0.50) = $0.104
SIGN UP NEOBUX
