Guillermo Furniture Guillermo Has Three Research Paper

Open, View, and/or
Download this Document

Total Length: 1118 words ( 4 double-spaced pages)

Total Sources: 3

Page 1 of 4

The basic premise of IRR is that if the IRR is higher than the discount rate, the project will be profitable over its life, whereas if the IRR is lower, the project will not be profitable. The IRR calculation is normally done in Excel, but can be rendered as

The IRR for the patent coating option is 6.9%; for the automation technology it is 64.7%; for the brokerage option it is 11%.

The net present value (NPV) discounts the cash flows using the discount rate derived from the weighted-average cost of capital. This calculation utilizes all of the cash flows that are specific to the decision at hand, including the initial outlay, salvage value and all cash flows beyond the payback period. This makes the NPV the most complete of the capital budgeting techniques available to Guillermo. Although normally this calculation is completed in Excel, the formula is as follows:

For the patent coating scenario, the NPV is -$26,755; for the automation technology it is $955,065; and for the brokerage option it is $27,014. These results are consistent with the results for the IRR and the two payback period calculations.

Sensitivity Analysis

Before Guillermo proceeds, he will need to subject these calculations to a sensitivity analysis. By adjusting some of the key variables, Guillermo can better understand the degree to which the final numbers are sensitive to real world deviations from the expected figures. For example, if the discount rate increases as a result of these investments, it may change the NPV ranking of the different options, depending on the timing of certain cash flows. Taking a discount rate of 12%, the patent coating option would now have an NPV of -$59,430; the automation technology would now have an NPV of $804,982; and the brokerage option would now have an NPV of -$12,091.

Stuck Writing Your "Guillermo Furniture Guillermo Has Three" Research Paper?

View All Our Example Guillermo Furniture Guillermo Has Three Research Paper

Have A Custom Example Essay Written

The sensitivity analysis reveals therefore that the brokerage option's positive NPV is sensitive to changes in the discount rate. Should taking this option increase the cost of borrowing such that it raises the WACC or if the company issues equity to pay for the initial investment, thereby raising the cost of capital, this option would no longer be profitable.

Recommendation

In this situation, the automation technology option is clearly the strongest for Guillermo. It has the highest NPV and shortest payback period of any of the three options by far. The positive discounted net cash flows are strong enough that they withstand sensitivity analysis. For example, if the future cash flows from this option are about half of what is projected, at $100,000 per year, the project would still have a positive NPV of $341,766. This means that the project is sufficiently lucrative for Guillermo to explore. The other two projects are not robust enough to withstand challenges to the cash flow or discount rate assumptions. The three projects are mutually exclusive, so Guillermo must select only the one with the highest net present value. Thus, it is recommended that Guillermo must invest in the automation technology.

Conclusion

The value of capita budgeting techniques is that it allows a firm to understand the cash flow implications of investment decisions. When faced with multiple mutually exclusive options such as Guillermo was, these calculations can help the company make the best decision. The sensitivity analysis is a key element in the financial….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Guillermo Furniture Guillermo Has Three" (2010, October 30) Retrieved June 6, 2026, from
https://www.aceyourpaper.com/essays/guillermo-furniture-guillermo-three-7287

Latest MLA Format (8th edition)

Copy Reference
"Guillermo Furniture Guillermo Has Three" 30 October 2010. Web.6 June. 2026. <
https://www.aceyourpaper.com/essays/guillermo-furniture-guillermo-three-7287>

Latest Chicago Format (16th edition)

Copy Reference
"Guillermo Furniture Guillermo Has Three", 30 October 2010, Accessed.6 June. 2026,
https://www.aceyourpaper.com/essays/guillermo-furniture-guillermo-three-7287
   

Open, View, and/or
Download this Document
order custom essay example