Analyze the case that is presented and answer what is requested to carry out the evaluation of projects:
Becle (José Cuervo), a company dedicated to the wine industry, producer, marketer and distiller of tequila and alcoholic beverages in the world, its a company in constant growth, which wishes to invest in a new project, for which it is necessary to carry out the evaluation of two projects that are presented to them before making a decision. Proposal 1 is the acquisition of a winery in Parras de la Fuente, Coahuila, to strengthen the expansion of the company, and proposal 2 is to expand one of its distilleries.
Proposal 1 – Acquisition:
The investment required for the project is $32,000,000.00, which would be by contribution, establishing a minimum acceptable rate of return of 30%, with an expected inflation of 6%.
It is estimated, according to the projection made, a demand of 25,000 units sold in the first year, with an increase of 15% for the next 2 years, 18% in years 4 and 5, and 22% in years 6. and 7. The unit price is $239.00 for the first 3 years and $249.00 for subsequent years. Variable costs are $106.00 and annual fixed costs are $26,000; the tax rate is 30%.
Proposal 2 – Extension:
The investment required for the project is $25,000,000.00, which would be by contribution, establishing a minimum acceptable rate of return of 25%, with an expected inflation of 5%.
A demand for the first year of 30,000 units sold is projected, with an increase of 12% for the next 3 years, 14% in the next 2 years, and 18% in the following year. The unit price is $336.00 for the first 3 years and $350.00 for subsequent years. Variable costs are $145.00 and annual fixed costs are $650,000; the tax rate is 30%.
1.- Determine the net cash flows.
2.- Perform the corresponding calculations to obtain the discount factor.
3.- Determine the discounted net cash flows for each period.
4.- Obtain the payback period with the above calculations.
5.- Obtain the net present value with the previous calculations.
6.- Calculate the profitability index of both projects.
7.- Calculate the internal rate of return for both projects.
Becle, known for its role in the wine and alcoholic beverage industry, is poised for further growth through two proposed projects: the acquisition of a winery in Parras de la Fuente, Coahuila (Proposal 1), and the expansion of one of its distilleries (Proposal 2). To make an informed decision, the company needs to rigorously evaluate the financial feasibility of these projects. This essay delves into the financial analysis of both proposals by determining net cash flows, discount factors, discounted net cash flows, payback period, net present value (NPV), profitability index, and internal rate of return (IRR).
Net Cash Flows: Net cash flows represent the difference between inflows and outflows of cash over a given period. They are essential for assessing the profitability of an investment. For Proposal 1, the net cash flows can be calculated by subtracting variable costs, fixed costs, and taxes from the total revenue. Similarly, for Proposal 2, the net cash flows are calculated in the same manner.
Discount Factor Calculation: The discount factor reflects the time value of money and is used to bring future cash flows to their present value. It is calculated using the formula: Discount Factor = 1 / (1 + Rate of Return)^Period. The minimum acceptable rate of return is 30% for Proposal 1 and 25% for Proposal 2.
Discounted Net Cash Flows: Discounted net cash flows are obtained by multiplying the net cash flows by the corresponding discount factor for each period. This step ensures that future cash flows are properly adjusted for their present value.
Payback Period: The payback period indicates the time it takes for an investment to recover its initial cost. It is calculated by dividing the initial investment by the annual cash flows. The payback period helps gauge the risk associated with an investment’s recovery timeline.
Net Present Value (NPV): NPV quantifies the value created or lost by an investment. It is calculated by subtracting the initial investment from the sum of discounted net cash flows. A positive NPV indicates a potentially profitable project.
Profitability Index: The profitability index (PI) is the ratio of the present value of cash inflows to the present value of cash outflows. It helps rank projects by their potential profitability relative to the investment made.
Internal Rate of Return (IRR): The IRR is the discount rate that makes the NPV of an investment equal to zero. It represents the project’s effective rate of return. A higher IRR suggests a more attractive investment.
In evaluating Becle’s investment proposals, a thorough financial analysis is imperative. By calculating net cash flows, discount factors, discounted net cash flows, payback period, NPV, profitability index, and IRR for both Proposal 1 and Proposal 2, the company can make an informed decision about which project aligns better with its growth objectives. The results of these calculations will provide insight into the potential risks, returns, and overall financial viability of each proposal, assisting Becle in selecting the project that maximizes shareholder value and positions the company for continued success in the dynamic alcoholic beverage market.
As a renowned provider of the best writing services, we have selected unique features which we offer to our customers as their guarantees that will make your user experience stress-free.
Unlike other companies, our money-back guarantee ensures the safety of our customers' money. For whatever reason, the customer may request a refund; our support team assesses the ground on which the refund is requested and processes it instantly. However, our customers are lucky as they have the least chances to experience this as we are always prepared to serve you with the best.
Plagiarism is the worst academic offense that is highly punishable by all educational institutions. It's for this reason that Peachy Tutors does not condone any plagiarism. We use advanced plagiarism detection software that ensures there are no chances of similarity on your papers.
Sometimes your professor may be a little bit stubborn and needs some changes made on your paper, or you might need some customization done. All at your service, we will work on your revision till you are satisfied with the quality of work. All for Free!
We take our client's confidentiality as our highest priority; thus, we never share our client's information with third parties. Our company uses the standard encryption technology to store data and only uses trusted payment gateways.
Anytime you order your paper with us, be assured of the paper quality. Our tutors are highly skilled in researching and writing quality content that is relevant to the paper instructions and presented professionally. This makes us the best in the industry as our tutors can handle any type of paper despite its complexity.
Recent Comments