Excel Online Structured Activity: Capital budgeting criteria A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7
Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180
Project B -$405 $132 $132 $132 $132 $132 $132 $0
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
1. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations.
2. What is each project's IRR? Round your answer to two decimal places
3. What is each project's MIRR?

You are the manager in charge of global operations at bankglobal – a large commercial bank that operates in a number of countries around the world. you must decide whether or not to launch a new advertising campaign in the u.s. market. your accounting department has provided the accompanying statement, which summarizes the financial impact of the advertising campaign on u.s. operations. in addition, you recently received a call from a colleague in charge of foreign operations, and she indicated that her unit would lose $8 million if the u.s. advertising campaign were launched. your goal is to maximize bankglobal’s value. should you launch the new campaign? explain. pre-advertising campaign post-advertising campaign total revenues $18,610,900 $31,980,200 variable cost tv airtime 5,750,350 8,610,400 ad development labor 1,960,580 3,102,450 total variable costs 7,710,930 11,712,850 direct fixed cost depreciation – computer equipment 1,500,000 1,500,000 total direct fixed cost 1,500,000 1,500,000 indirect fixed cost managerial salaries 8,458,100 8,458,100 office supplies 2,003,500 2,003,500 total indirect fixed cost $10,461,600 $10,461,600