Question
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
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:
- For both projects compute the projects net present value.
- For both projects compute the projects internal rate of return, to the nearest percentage.
- What is the profitability index for each project? Explain what these indices mean.
- For both projects compute the projects payback period.
- What would be the payback period for both projects if instead the annual cash flows for each project were estimated to be:
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 |
6. For both projects compute the simple rate of return.
7. Should the company accept the project? Why or why not?
Answer questions 5-7 with work please.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started