Evaluate the financial impact of a new advertising campaign at Coca-Cola using NPV, IRR, and payback period methods.

Investment Components	Initial Investment ($)	Annual Cash Flows ($)	Project Life (years)	Discount Rate (%)
Advertising Campaign	80,000,000	25,000,000	4	6%

Requirements:

Calculate NPV and IRR based on projected cash flows and discount rate.

Determine the payback period for the investment.

Conduct a sensitivity analysis to assess the impact of changes in advertising costs.

Provide recommendations on whether to proceed with the advertising campaign.