Explore BrainMass

# Depreciation;tax rates;taxable income;NOPAT;NPV;IRR

Not what you're looking for? Search our solutions OR ask your own Custom question.

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

See attached File.

Capital Budgeting Analysis

I have attached a Unit 3 Professional Challenge- Blank Answer Template. The cells that need to be filled in are in the color gray. Virtually all of the cells should have formulas (or linked to other cells) in order to show the work and logic. You must use formulas for your calculations rather than just pasting in numbers.

1. For the WACC, use 7.50%. I fixed the WACC rate for everyone so you will not have to attempt to calculate it from your chosen company. This will save you time. So you will not need to calculate the WACC, only explain it in your paper. You will be calculating 1) Depreciation, 2) Tax Rate, 3) Taxable Income, 4) NOPAT, 5) Net Cash Flow, and the two major calculations- NPV & IRR.

2. You need to find the Net Cash Flows for years 0 thru 5 for Machine A and B. Then find the NPV and IRR of these cash flows. Year 0 thru Year 5 will be the time line for your cash flows.

3. Plug in the given EBITD numbers for the 5 years for each Machine.

4. For Depreciation, use 33% for year 1, 45% for year 2, 15% for year 3, 7% for year 4, and 0% for year 5. You will multiply these percentages by 120,000 for Machine A and 60,000 for Machine B. (Note: Make sure the \$120,000 and \$60,000 are POSITIVE numbers when you multiply the depreciation percentages by them.

5. Taxes for each year will equal (Taxable Income times 40%.)

6. Taxable Income will equal (EBITD minus Depreciation) for each year.

7. Net Operating Profit After Taxes (NOPAT) equals (Taxable Income minus [email protected]%).

8. To find the Net Cash Flow, negative -\$120,000 will be the year 0 Net Cash Flow for Machine A and negative -\$60,000 will be the year 0 Net Cash Flow for Machine B. (Note: Ignore Salvage Value for Machine A).

9. Net Cash Flow equals (NOPAT + Depreciation). Remember that depreciation is a noncash expense so you add it back to NOPAT.

10. Once you have calculated the Net Cash Flows for Year 0 thru Year 5 for each Machine then you are ready to find the NPV and IRR. Remember, For year 0 for Machine A, you will use the initial cash outlay of -120,000 and -60,000 for Machine B. For the NPV calculation, use the 7.50% WACC as the discount rate.

11. Be sure to use the NPV & IRR formulas in Excel. For the NPV calculations, you want to assume that the cash flows occur at the BEGINNING of each period. So be sure to keep the year 0 cash flow outside and added to the parenthesis of the formula. The Excel Examples spreadsheet that I posted under the Faculty Expectations thread has an example of it.

12. In your Word document, be sure to discuss the following topics:
A) After calculating the NPV and IRR for Machine A and Machine B, choose which one you would choose based on being the most profitable.
B) Would an investor choose an investment with the highest NPV or IRR? Justify which one and why.
C) Discuss capital rationing limits firms have and what, if anything they can do,
E) Discuss the WACC.

#### Solution Preview

See the attached file.

Capital Budgeting Analysis

A) After calculating the NPV and IRR for Machine A and Machine B, choose which one you would choose based on being the most profitable.

The NPV for Machine A is \$225,179 and that for machine B is \$266,905. The IRR for Machine A is 68.75% and that for Machine B is 144.91%. Both machines have positive NPV and hence on NPV criteria both machines should be selected for investment. Similarly, both machines have IRR greater than the WACC and hence on the IRR criteria both machines qualify for investment Thus, if we are evaluating the two machines as independent investment opportunities, then both the machines should be selected for investment.

However, if we are evaluating these two projects as mutually exclusive projects i.e. if we install Machine A, then Machine B cannot be installed and vice versa, then we have to identify the better of the two projects.

NPV for Machine B is higher than that for ...

#### Solution Summary

This post shows how to calculate depreciation, tax rates, taxable income, NOPAT, net cash flow, NPV & IRR, WACC

\$2.49