How do you figure in the cost of sponsored ads on your eBay Profit Calculator?

If you have the ability to promote an item, you will see Promoted Listings at the bottom when you list that item.

Changing the percentage will also show you the cost, and you can then add that to the spreadsheet.