Do you guys budget and forecast? - GoFuckYourself.com

Rick Latona · 03-20-2003, 11:37 AM

Do you guys budget and forecast?

We've been working on putting together the perfect MS Excel workbook that can be used to make our Sponsorship Program run as smoothly as possible. Something that can help us forecast out based on predicted retention rates, conversion rates, trail to join, etc.

We want the expenses, revenue, profit and loss broken down per site.

This is quite a task but something that must be done. The funny thing that I've found is that when asking around I've noticed that most of the people I know in this business don't have anything in place to track and predict cash flow, etc.

What are you guys doing out there in GFY land?

foreverjason · 03-20-2003, 11:38 AM

I do away more forecasting that budgetting

Easton · 03-20-2003, 11:38 AM

we're all too busy fucking hot chicks and cashing cheques!

Pipecrew · 03-20-2003, 11:41 AM

Quote:

Originally posted by Easton
we're all too busy fucking hot chicks and cashing cheques!

me too! i swear

Rick Latona · 03-20-2003, 12:35 PM

Hmm. Ok, how about those of you who run Sponsor Programs?

WiredGuy · 03-20-2003, 12:40 PM

Check out QuickBooks Pro, there's some great forecasting tools in there. I forecast on markets which I can assess, such as PPC and PPI search engines but when it comes to Google, those monthly updates are very unpredictable so that's an area I can't forecast until the Google dance is over.

WG

Kimmykim · 03-20-2003, 12:45 PM

Quote:

Originally posted by Rick Latona
Hmm. Ok, how about those of you who run Sponsor Programs?

I'm having a deja vu moment here, meet me at Cheesecake Factory for lunch?

OY · 03-20-2003, 12:51 PM

Quote:

Originally posted by Rick Latona
Do you guys budget and forecast?

We've been working on putting together the perfect MS Excel workbook that can be used to make our Sponsorship Program run as smoothly as possible. Something that can help us forecast out based on predicted retention rates, conversion rates, trail to join, etc.

We want the expenses, revenue, profit and loss broken down per site.

This is quite a task but something that must be done. The funny thing that I've found is that when asking around I've noticed that most of the people I know in this business don't have anything in place to track and predict cash flow, etc.

What are you guys doing out there in GFY land?

That is something any serious webmaster should be using. I want a copy - let's see if we can implement it with MPA2 too. As it is right now, and I am sure you are using it, the MPA2 will run profit reports and break down what you HAVE DONE in order to use this in your projections...

Rick Latona · 03-20-2003, 12:52 PM

Quote:

Originally posted by Kimmykim

I'm having a deja vu moment here, meet me at Cheesecake Factory for lunch?

KK, ur so smart!

Kimmykim · 03-20-2003, 12:54 PM

Quote:

Originally posted by Rick Latona

KK, ur so smart!

Hahaha, the correct answer was: I hate those ads on the menu!

Rick Latona · 03-20-2003, 12:55 PM

Quote:

Originally posted by Oystein

That is something any serious webmaster should be using. I want a copy - let's see if we can implement it with MPA2 too. As it is right now, and I am sure you are using it, the MPA2 will run profit reports and break down what you HAVE DONE in order to use this in your projections...

Yes and no Oystein. From what I can tell in the MPA2 system it tells me only what the webmaster traffic is doing and the webmaster payouts. It does not seem to have any report that tells me what the total revenue was and the breakdown of where the money went and came from. If it did this, and then made the data available to Quick Books, it would be easy to forcast out from there.

bauhaus · 03-20-2003, 02:32 PM

I was pretty sure in Mexico we already worked out this formula??

But none the less if we are going to figure it out again, I did see a post a while ago where one guy actually cut and pasted one hell of a formula for calculating returns..... I will try to look for it, pretty sure it was on this board even.

We are always forcasting for new projects, the returns should be built into your project from the beginning there is of course the learning curve, but eventually you come close to guessing things.

OY · 03-20-2003, 06:03 PM

Rick - You are right. I thought it was because I read about it in our "next update" white paper... my bad. ;-)
If you have any good ideas for us to add, lmk.

Tim! Wassup! Will I see you in Phoenix?

magnatique · 03-27-2003, 03:06 AM

hey Rick, I made some kind of spreadsheet like that a while ago... hit me up on icq if you need it...

just using simple stats formulas, but could be having some error in there... don't want u sueing me cuz it says you'd make 10$ more a signup lol

but it seems pretty much what stats tell on an infinite amount of time (real signup value) based on all factors.... according to what I was taught in school that is ;)

421704

BrettJ · 03-27-2003, 03:32 AM

cash flow has killed more businesses than bad decisions ever will.

budgeting and forecasting is critical in an affiliate program.

for exact budgeting - we only go about 6 weeks out - for both revenue and expenses. it's important to note that we are also a partnership program. rebills are still a critical component but don't play a life altering role in budgets.

for us... after 6 weeks is a crap shoot for what is going to happen.

leedsfan · 03-27-2003, 01:00 PM

I use Quickbooks Pro.

I cant imagine a company looking at expansion, in our ever more diluted industry, not being logistically secured by preparing and constantly re-evaluating their forecasts and budgets.

I am constantly looking to ensure the future of our company, given that it helps me to make sound business decisions that will help me grow the fundamental bottom line of our business.

Without it, I'd be steering a ship with no compass...and no fucking paddles.

OY · 03-27-2003, 05:46 PM

Rick . . . Also, in MPA2, when you print out the profit reports you will be able to see and use the numbers to make a good budget. Let us expand on that and make it work...

PS. http://www.gofuckyourself.com/showth...hreadid=114166

03-20-2003, 11:37 AM	#1
Rick Latona The Best Ideas Start Here Join Date: Dec 2002 Location: Atlanta Posts: 6,037	Do you guys budget and forecast? Do you guys budget and forecast? We've been working on putting together the perfect MS Excel workbook that can be used to make our Sponsorship Program run as smoothly as possible. Something that can help us forecast out based on predicted retention rates, conversion rates, trail to join, etc. We want the expenses, revenue, profit and loss broken down per site. This is quite a task but something that must be done. The funny thing that I've found is that when asking around I've noticed that most of the people I know in this business don't have anything in place to track and predict cash flow, etc. What are you guys doing out there in GFY land? __________________ Regards, Rick Latona http://latonas.com Latona's - We Sell Money Making Web Properties Note to buyers of websites and traffic: please check our inventory at http://latonas.com/websites-for-sale. If you would like to make an offer on something, just let me know.

03-20-2003, 11:38 AM	#3
Easton Too lazy to set a custom title Industry Role: Join Date: Sep 2002 Location: Phoenix, AZ Posts: 9,825	we're all too busy fucking hot chicks and cashing cheques! __________________ New models booked and shot every week... MILFs, pornstars and teens. Girls for every niche and project. Looking for high-quality affordable exclusive content? Check me out at Easton Content for all the details.

03-20-2003, 12:35 PM	#5
Rick Latona The Best Ideas Start Here Join Date: Dec 2002 Location: Atlanta Posts: 6,037	Hmm. Ok, how about those of you who run Sponsor Programs? __________________ Regards, Rick Latona http://latonas.com Latona's - We Sell Money Making Web Properties Note to buyers of websites and traffic: please check our inventory at http://latonas.com/websites-for-sale. If you would like to make an offer on something, just let me know.

03-20-2003, 12:40 PM	#6
WiredGuy Pounding Googlebot Industry Role: Join Date: Aug 2002 Location: Canada Posts: 34,483	Check out QuickBooks Pro, there's some great forecasting tools in there. I forecast on markets which I can assess, such as PPC and PPI search engines but when it comes to Google, those monthly updates are very unpredictable so that's an area I can't forecast until the Google dance is over. WG __________________ I play with Google.

03-20-2003, 02:32 PM	#12
bauhaus Confirmed User Join Date: May 2001 Location: Costa Rica Posts: 773	I was pretty sure in Mexico we already worked out this formula?? But none the less if we are going to figure it out again, I did see a post a while ago where one guy actually cut and pasted one hell of a formula for calculating returns..... I will try to look for it, pretty sure it was on this board even. We are always forcasting for new projects, the returns should be built into your project from the beginning there is of course the learning curve, but eventually you come close to guessing things. __________________ Insane, Color and Instant Sensation REalize the potential of dynamic coded features all in real time Vivid Php Code This is the reality of Outsoursouring SKype HolyBauhaus Deep, Deep in the Tropical Dry Rainforest.

03-20-2003, 11:38 AM	#2
foreverjason Confirmed User Join Date: Mar 2003 Posts: 1,452	I do away more forecasting that budgetting

03-20-2003, 06:03 PM	#13
OY Industry Pioneer Industry Role: Join Date: Oct 2002 Location: USA/EU/ASIA Posts: 5,401	Rick - You are right. I thought it was because I read about it in our "next update" white paper... my bad. ;-) If you have any good ideas for us to add, lmk. Tim! Wassup! Will I see you in Phoenix? __________________ Around since 1997, and the company that introduced "Cascading Billing" in MPA3® Affiliate Management and Tracking Software Outsourcing With A Norwegian Twist - NordBits - Inquire within!

03-27-2003, 03:06 AM	#14
magnatique Confirmed User Join Date: Jan 2001 Location: Montreal Posts: 1,830	hey Rick, I made some kind of spreadsheet like that a while ago... hit me up on icq if you need it... just using simple stats formulas, but could be having some error in there... don't want u sueing me cuz it says you'd make 10$ more a signup lol but it seems pretty much what stats tell on an infinite amount of time (real signup value) based on all factors.... according to what I was taught in school that is ;) 421704 __________________ Stunner Media Programs: StandAhead \| IndieBucks \| BoyCrushCash \| Phoenixxx \| EmoProfits \| BritishBucks \| HunkMoney \| LatinoBucks Make $$$ with Gay! Lowest Minimum Payouts in the Business, Perfect Track Record, Amazing Sites

03-27-2003, 03:32 AM	#15
BrettJ ol' timer Industry Role: Join Date: Jan 2001 Location: Seattle WA Posts: 4,715	cash flow has killed more businesses than bad decisions ever will. budgeting and forecasting is critical in an affiliate program. for exact budgeting - we only go about 6 weeks out - for both revenue and expenses. it's important to note that we are also a partnership program. rebills are still a critical component but don't play a life altering role in budgets. for us... after 6 weeks is a crap shoot for what is going to happen.

03-27-2003, 01:00 PM	#16
leedsfan leedsfan Industry Role: Join Date: Jul 2002 Location: purgatory Posts: 2,564	I use Quickbooks Pro. I cant imagine a company looking at expansion, in our ever more diluted industry, not being logistically secured by preparing and constantly re-evaluating their forecasts and budgets. I am constantly looking to ensure the future of our company, given that it helps me to make sound business decisions that will help me grow the fundamental bottom line of our business. Without it, I'd be steering a ship with no compass...and no fucking paddles. __________________ Advertise on Sex2ube.com New Tube Content Packages Save $10K +

03-27-2003, 05:46 PM	#17
OY Industry Pioneer Industry Role: Join Date: Oct 2002 Location: USA/EU/ASIA Posts: 5,401	Rick . . . Also, in MPA2, when you print out the profit reports you will be able to see and use the numbers to make a good budget. Let us expand on that and make it work... PS. http://www.gofuckyourself.com/showth...hreadid=114166 __________________ Around since 1997, and the company that introduced "Cascading Billing" in MPA3® Affiliate Management and Tracking Software Outsourcing With A Norwegian Twist - NordBits - Inquire within!