Sample Assignment for Finance Assignment Help

Following problems.
Look at week 4:
Guillermo Furniture Store :

1. Optimal WACC
2. Multiple valuation techniques in reducing risks
3. NPV of future cash flows for each alternative These are all numbers.

Week 6:
Final Financial Recommendation for Guillermo Furniture Store Scenario : Create a pro forma cash flow budget for next 2 years.

Capital Budgets

• Calculate the cost of capital.
• Apply techniques used in capital budgeting decisions.
• Analyze a capital project’s present value based on expected future net cash flows.

2. Individual Assignment:

Guillermo Furniture Store Analysis

• Resources: The Guillermo Furniture Store Scenario for this assignment
• Write a paper in no more than 750 words that focuses on the analysis of different alternatives available to Guillermo. Include a sensitivity analysis.
• Determine the optimal WACC and discuss the use of multiple valuation techniques in reducing risks.
• Calculate NPV of future cash flows for each of the alternatives.
• Format your paper according to APA standards.

Term Financing

• Outline a method for managing capital structure.
• Evaluate the effect of DIVIDEND policy on stock price.
• Explain the types and main features of long-term debt.
• Compare and contrast leasing with debt/equity finance.

Financial Planning

• Analyze the effect of price setting on capital budgeting.
• Explain the methods, pitfalls and benefits of capital rationing.
• Create a financial plan.

Guillermo's Furniture Store Scenario
Mexico is a beautiful vacation spot, it is also a large furniture manufacturing location in North America. Guillermo Navallez made furniture for years near his Sonoran home. The area had a good supply of timber for the variety of tables and chairs produced by his company. Labor was also relatively inexpensive. In addition, he priced his handcrafted products at a slight premium for the quality they represented. Overall, life was good for Guillermo.
All of that was true until late in the 1990s when two forces combined to cause a large dent in his business. First, a new competitor from overseas entered the furniture market. Using a high-tech approach, this foreign competition provided furniture to exact specifications and did so with rock-bottom prices. Second, the sleepy communities in Sonora woke up. One of the largest retailers in the nation’s headquarters was just a few miles down the road and its influence had expanded considerably. With inexpensive housing, mild weather, beautiful scenery, un-congested roads, a new International Airport and plenty of development, an influx of people and jobs raised the cost of labor substantially. Guillermo watched his profit margins shrink as prices fell and costs rose.

After doing some research on his competition to see how they are handling these changes, it is clear that many of them are consolidating into larger organizations by merger or acquisition. Being independent, Guillermo does not relish the idea of being acquired by a larger competitor and then retired as the new company squeezes every peso it could out of the overhead costs. Guillermo also is not looking to expand his management responsibilities by acquiring another organization either; that could affect his time with his family in ways that he will not enjoy.

Guillermo then spent some time looking at the foreign competition and their high-tech solution. Essentially, their production utilizes a computer controlled laser lathe to produce exact cuts in the wood. Highly automated, the plant in Norway uses very little labor as robots even perform the precise movement and assembly functions. The cost of the technology is immense, as is the reduction in the labor needed for production. In addition, the production can move between products quickly and it runs on a 24-hour basis, as the shift-differentials are more than offset by the reduction in labor. Converting his production to this model would be expensive, but he saw how he could also decrease dramatically his production costs.

When talking to some of his distributors about their wants, he had another idea that appealed to him. A second competitor, currently operating only in Norway, has been looking for channels to distribute in North America. This second potential rival, however, did not operate furniture outlets favoring instead to rely on chain distributors. Perhaps Guillermo could coordinate his existing distributor network and essentially become a representative for this other manufacturer. While he may retain some of the high end custom work, he could move his company from primarily manufacturing to primarily distribution.

Guillermo also has a patented process for creating a coating for his furniture. In producing this product, the process first creates a common flame-retardant and upon further processing, the coating is complete and stain resistant. There is market for the flame retardant, but not as much of a market for the finished coating. There is another product that Guillermo could buy to apply to his furniture as well that would add the same amount of value for the furniture.