Affiliate Ref Comm Projections Calculator SS

I need someone to complete a spreadsheet / calculator function that I have created and attached...which calculates projected incomes from a 5 tiered Affiliate Referral program that is pretty simple. Our program pays out $1/month/referred subscriber or member through 5 tiers or generations. The $1 is the same at each level. As I mentioned I have the spreadsheet laid out already...I just need someone to supply the EXCELL SS functions, macros, and calculations that would allow these projections to be accurate...given the 5 levels or generations and the specified percentages for the response ratios to the Affiliate's email campaign or their effectiveness ratios. thanks, Dave