What are the variety of capital budgeting tools including net present value (NPV), internal rate of return (IRR), payback period, and profitability index (PI). Only evaluate the incremental changes to cash flows.

Use an Excel spreadsheet showing the required cash flow forecasts and capital budgeting tool calculations.

Marketing/Advertising Campaign

• A major new marketing/advertising campaign, which will cost $2 million per year and last 6 years.
• It is forecast that the campaign will increase sales/revenues and costs of sales by 15% per year.
• Annual sales for the previous year were $20 million.
• The marginal corporate tax rate is presumed to be 25%.
• Being a moderate risk investment, the required rate of return of the project is 10%.
• Cost of sales costs of sales by 15% per year.