Excel Expense sheet with a donation account accruing
Budget: $10 – $30 USD
Make an excel sheet.
1. I won $1,000,000,000
2. After all taxes tomorrow I will have $540,000,000
3. I have decided to immediately set aside ($100,000,000 or $200,000,000 or $300,000,000 for yearly donations.)
4. Show projections if the amount set aside grows 3%, 5%, 7% each year minus obviously the amount donated that year.
4.1A. Show projections if interest on the remaining amount after the donation set aside grows 3%, 5%, 7% each year.
5. Show projections if interest is accumulated and paid monthly vs. quarterly, vs yearly.
6. I expect to live another 50 years from today.
7. I now have ($540,000,000 - either ($100,000,000 or $200,000,000 or $300,000,000)) depending on my set aside donation level.
8. Assume my expenses to deduct from the the $540,000,000 minus either ($100,000,000 or $200,000,000 or $300,000,000 that I'm setting aside for donations)) are $25,000,000 the first year and $5,000,000 every year thereafter for 50 years. (These yearly expenses are totally separate from the 100k, 200k, or 300k donation amounts.)
9. Make a table that I can fill in with individual donations that deducts from the total.
10. See the spreadsheet I'm attaching here, it's a less complex version of what I'm asking you for.
11. Some of the formulas in the spreadsheet I'm attaching are wrong so DO NOT rely on them.
1. I won $1,000,000,000
2. After all taxes tomorrow I will have $540,000,000
3. I have decided to immediately set aside ($100,000,000 or $200,000,000 or $300,000,000 for yearly donations.)
4. Show projections if the amount set aside grows 3%, 5%, 7% each year minus obviously the amount donated that year.
4.1A. Show projections if interest on the remaining amount after the donation set aside grows 3%, 5%, 7% each year.
5. Show projections if interest is accumulated and paid monthly vs. quarterly, vs yearly.
6. I expect to live another 50 years from today.
7. I now have ($540,000,000 - either ($100,000,000 or $200,000,000 or $300,000,000)) depending on my set aside donation level.
8. Assume my expenses to deduct from the the $540,000,000 minus either ($100,000,000 or $200,000,000 or $300,000,000 that I'm setting aside for donations)) are $25,000,000 the first year and $5,000,000 every year thereafter for 50 years. (These yearly expenses are totally separate from the 100k, 200k, or 300k donation amounts.)
9. Make a table that I can fill in with individual donations that deducts from the total.
10. See the spreadsheet I'm attaching here, it's a less complex version of what I'm asking you for.
11. Some of the formulas in the spreadsheet I'm attaching are wrong so DO NOT rely on them.