Coca$-$Cola has decided to run a new marketing campaign. In the campaign, individuals can collect the letters XBOX by opening lids. If they collect all $4$ letters, and turn them in they will receive a free Xbox.

Wholesale, the Xbox costs Coca$-$Cola $$300$ a prize. They puchased $50,000$ Xboxes to give away. The company believes that sales for individual bottles will increase by $6\%$ during the life of the campaign, which

will run for $6$ months. Currently, the profit on an individual bottle of Coca Cola is $$0\mathrm{.}80.$ The company sells $200$ million bottles of Coca$-$Cola per month. Assuming a $30$ day month, what is the Payback Period, Discounted Payback Period, IRR, and NPV of the marketing campaign? Assume Coca$-$Cola's cost of capital is $6\mathrm{.}5\%.$

create and provide excel spreadsheet with formula and answers