Explore BrainMass

Explore BrainMass

    Capital Budgeting in Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. If two mutually exclusive projects were being compared, would a high cost of capital favor the longer-term or the shorter-term project? Why? If the cost of capital declined, would that lead firms to invest more in longer-term projects or shorter-term projects? Would a decline (or increase) in the WACC cause changes in the IRR ranking of mutually exclusive projects?

    2. Capital Budgeting criteria- A firm with a 14 percent WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows:

    0 1 2 3 4 5
    Project A -$6000 $2000 $2000 $2000 $2000 $2000
    Project B -$18,000 $5,600 $5,600 $5,600 $5,600 $5,600

    a. Calculate NPV, IRR, MIRR, payback, and discounted payback for each project.
    b. Assuming the projects are independent, which one or ones would you recommend?
    c. If the projects are mutually exclusive, which would you recommend?
    d. Notice that the projects have the same cash flow timing pattern. Why is there a conflict between NPV and IRR?

    Please see the attachment for clarity in the 2 questions.

    © BrainMass Inc. brainmass.com June 3, 2020, 7:29 pm ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/capital-budgeting-in-excel-100649

    Attachments

    Solution Summary

    This solution provides explanations and equations for various equations regarding capital budgeting in Excel.

    $2.19

    ADVERTISEMENT