Transcribed Image Text
What are the variety of capital budgeting tools including netpresent value (NPV), internal rate of return (IRR), payback period,and profitability index (PI). Only evaluate the incremental changesto cash flows and use applicable metrics that align with the valuesbelow.Use an Excel spreadsheet showing the required cash flowforecasts and capital budgeting tool calculations.Marketing/Advertising CampaignA major new marketing/advertising campaign, which will cost $2million per year and last 6 years.It is forecast that the campaign will increase sales/revenuesand 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 returnof the project is 10%.Cost of sales costs of sales by 15% per year.