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?

Benton company (bc), a calendar year entity, has one owner, who is in the 37% federal income tax bracket (any net capital gains or dividends would be taxed at a 20% rate). bc's gross income is $395,000, and its ordinary trade or business deductions are $245,000. ignore the standard deduction (or itemized deductions) and the deduction for qualified business income. if required, round computations to the nearest dollar. a. bc is operated as a proprietorship, and the owner withdraws $100,000 for personal use. bc's taxable income for the current year is $ , and the tax liability associated with the income from the sole proprietorship is $ . b. bc is operated as a c corporation, pays out $100,000 as salary, and pays no dividends to its shareholder. bc's taxable income for the current year is $ , and bc's tax liability is $ . the shareholder's tax liability is $ . c. bc is operated as a c corporation and pays out no salary or dividends to its shareholder. bc's taxable income for the current year is $ , and bc's tax liability is $ . d. bc is operated as a c corporation, pays out $100,000 as salary, and pays out the remainder of its earnings as dividends. bc's taxable income for the current year is $ , and bc's tax liability is $ .

Brian has been working for a few years now and has saved a substantial amount of money. he now wants to invest 50 percent of his savings in a bank account where it will be locked for three years and gain interest. which type of bank account should brian open? a. savings account b. money market account c. checking account d. certificate of deposit

An object that is clicked on and takes the presentation to a new targeted file is done through a