Guillermo Financial Analysis
Guillermo Financial Analysis
FIN571/University of Phoenix
June 11, 2012
Beatrice Jones
Guillermo Financial Analysis
Mr. Navallez, the owner of Guillermo Furniture is faced with the task of making changes in an attempt to bring the business back to a profitable position. Currently the store is in a difficult position financially. The arrival of the new competitor from oversees has caused a negative shift in the financial condition of Guillermo Furniture Store. To properly assess which option the owner should pursue, Mr. Navallez would need to research the; sensitivity analysis, net present value and weighted average cost of capital for each option. This paper will briefly discuss capital budgeting and the three possible options; keep current set up, become a broker or evolve to high-tech. It is essential that Guillermo Furniture Store choose the best option to gain a competitive advantage in the industry.
To decide if a project is worth pursuing or investing in, the firm uses capital budgeting. According to the text, “Capital budgeting is fundamental because a firm is essentially defined by its assets and the products and services those assets produce.” (Emery, Finnerty, & Stowe, 2007, p.187). The investment of the project is classified by the type of benefit to company and the size of the project. This project requires the firm to evaluate the current project, broker and high tech investment according to the NPV and sensitivity to investment.
Net present value of future cash flows
There are different types of capital budgeting techniques which include: simple payback, discounted payback, NPV (net present value), and IRR (internal rate of return). The expected number of years required to recover the original investment by Guillermo Furniture Store is considers the simple pay back period. This would mean how much time the company would need to compensate the initial investment should they choose to pursue the broker or high tech project options.
A break-even discount rate is when the IRR has a inflow of cash equal to the outflow of cash and makes the NPV of the investment = 0. The rate of reinvestment for cash flows is the internal rate of return (IRR), while the excess of cash flows at a defined period of time in the industry is the NPV.
The cumulative cash flow of Guillermo Furniture Store is currently at t = 0 and the initial cost is -$7,000,000. At Year one the cumulative cash flow includes the previous cumulative cash flow of that year plus $500. In years two, four and five the cash outlay increases by $700,000. The decision rule for the NPV versus the IRR is: if the cash flows are discounted and k1 and the NPV is positive then the firm should accept the project. However if the cash flows are discounted and the NPV is negative this means that IRR