Part IV

Lazy Q Ranches, one of the largest ranching consortiums in the world, is considering two projects. The first project, building a resort on one of its ranches in Montana and the other is to expand into Argentina and raise racehorses. The analysis is being done assuming a 10 year life for both projects. Lazy Q has a corporate tax rate of 25%, a required rate of return of 12% on projects and has a weighted average cost of capital of 8%. Details of the two options are provided as follows:

Resort Project:

The resort project would require a $20,500,000 investment. At the end of ten years, some of the equipment would have a salvage value of $300,000. The project would require additional working capital $450,000 in the form of an increase in the minimum balance required by their bank and this working capital would be released at the end of the project. The project would provide estimated net income each year as follows:

Sales............................................................... .......................... $6,500,000

Less variable expenses................................... 4,275,000

Contribution margin...................................... ............. $2,225,000

Less fixed expenses:

Fixed expenses*................................. ............................ $1,115,000

Net income.................................................... ................. $1,110,000

*Depreciation is 8% of fixed expenses

RaceHorse Project:

The racehorse project would require a $10,875,000 investment. At the start of the project current buildings that are on the land being purchased to create the new facilities will be torn down and sold for scrap wood for $198,000. At the end of ten years, some of the equipment would have a salvage value of $80,000. The project would require additional working capital $200,000 in the form of an increase in the minimum balance required by their bank and this working capital would be released at the end of the project. The project would provide estimated net income each year as follows:

Sales............................................................... .................. $4,125,000

Less variable expenses................................... 1,900,000

Contribution margin...................................... ............. $2,225,000

Less fixed expenses:

Fixed expenses*................................. $ 775,000

Net income.................................................... ................ $1,450,000

*Depreciation is 10% of fixed expenses

Required:

1. For both projects compute the projects net present value.
2. For both projects compute the projects internal rate of return, to the nearest percentage.
3. What is the profitability index for each project? Explain what these indices mean.
4. For both projects compute the projects payback period.
5. What would be the payback period for both projects if instead the annual cash flows for each project were estimated to be:
6. For both projects compute the simple rate of return.
7. Should the company accept the project? Why or why not?

Year	Resort Project Cash Flows	Racehorse Project Cash Flows
1	6,000,000	4,000,000
2	6,150,000	4,000,000
3	6,250,000	4,120,000
4	6,300,000	4,150,000
5	6,250,000	4,150,000
6	6,225,000	4,200,000
7	6,500,000	4,250,000
8	6,450,000	4,300,000
9	6,400,000	4,350,000
10	6,200,000	4,400,000