# Excel Provisions

Here's the project I need help with. I work with an online advertising company that pays back cash rebates equal to 125% of what an advertiser spends when purchasing advertising with our company. The rebate is earned on a daily basis provided the advertiser has surfed 12-24 websites for 15 seconds each daily from other advertisers in our network.

Option #2. The member who purchases ad packages has the option of &quot;Upgrading&quot; in other words; the member can elect to upgrade daily with their rebate monies and purchase additional ad packages, thus compounding their rebates. When I put together the existing spreadsheet I used a rebate percentage of 1% knowing that on day 125 the initial ad package expired, but I changed the percentage to 1.3% and I can't figure out how to make the adjustment, that's where I need your help.

You can see from my spreadsheet that the daily rebates accumulate and compound so that the number of ad packages increase, and hence so do their rebates. I am trying to illustrate potential income by upgrading rebates daily until there is enough per day to begin taking out some money. You will see on the spreadsheet that on day 126 the member begins setting aside 80% of the rebate that day and upgrading to purchase additional ad packages, and keeping 20% of that days rebate for income.

I really need you to understand this model so you can perhaps make some adjustments that I haven't thought about and at the same time fix my challenge.

Then I want to create another spreadsheet (calculator) that shows a person taking out 20% of the rebate money from the first day and upgrading with 80%, but the minimum number of ad packages needs to be set at \$12,000.

Evner: Excel

Om arbejdsgiveren:
( 0 bedømmelser ) Scottsdale, United States

Projekt ID: #292375