Investment Proposals for Orio Coffee House Daniel Jackson, CEO of OCH, has approached you to work on 2 investment proposals that the company is considering: 1. Buying coffee roaster plant in Mexico. 2. The Reconstruction of coffee shops to add the selling of yogurt. Mr. Daniel reminds you to consider only relevant expense and income. “Relevant costs have to be occurring in the future,”He said. “And have to be unique from the status quo. For example, if we choose to buy the roaster plant, it is only the incremental revenue and costs related to the purchase that should be considered. We also need to take into account the opportunity cost associated with the alternatives.” More details on both of investment proposal is written below. Mr. Daniel wants you to recommend after evaluation, if OCH should invest in one, both, or none of the investment proposals. Required Return Mr. Daniel wants you to use 7% as the discount rate (i.e., the required return). First Proposal of Investment in Roasted Coffee Plant Mr. Daniel is considering investing in a coffee plant in Mexico where you can get cheap labor and there are proximal coffee farms that can decrease transportation costs. The cost of acquisition of the plant is $7Million, which covers roasting equipment that originally cost $14Million when it was purchased 8 years ago. Some of the equipment is obsolete and need to be discarded, so an additional $2Million of equipment has to be purchased. The roaster plant currently has $2Million of available tax shield left, excluding any tax shield related to the equipment to be purchased. The raw materials and direct labour used for manufacturing these products are 8% and 7% of sales, respectively. The processing costs for roasting are approximately 17% of total sales. All of these costs as a percentage of sales are expected to remain constant over the time horizon. The plant also needs2 managers with fixed salaries of $50,000 each per year. Insurance cost for the plant and equipment is $40,000 per year. Additional incremental production overhead costs (property taxes, maintenance, security, etc.) excluding depreciation are estimated as $75000 yearly. Wages are expected to rise with inflation (estimated to be 2%) over the time period, while other fixed costs are expected to remain steady. Transportation related variable costs (gas, variable overhead, etc.) are estimated to be 12% of revenue, and include transportation of raw materials to the roaster and finished products to the port for delivery to OCH coffeehouses. The roasted coffee plant is expected to produce 1.1M pounds of coffee for the first two years, with production dipping by 100,000 pounds per year after this due to lower productivity from the deteriorating equipment. Each pound of roasted coffee can be sold at $3.25 per pound (either to retail cafes, franchise cafes, or to wholesale partners), with the price expected to rise with inflation over time. Each pound of coffee can make 30 cups of coffee that can sell at an average retail price of $4.00 per cup. Mr. Daniel has stressed that the profitability of the plant base has to be looked at on a stand-alone basis, i.e., from the sales from the plant to buyers, not from retail cafés to customers. Mr. Daniel wants to evaluate if project will be profitable after5 years, as significant reinvestment will be needed after five years to keep the plant operational, so he wants you to evaluate the return on investment in that period using the investment criteria of payback period, NPV, and IRR. The following table will help in the calculations of the tax shield for the new equipment: Class CCA Rate Description 43 30% Machine and equipment to manufacture and process goods for sale   Tax Shield Formula:     Assume no salvage value when calculating the tax shield, and that the half-year rule applies for Class 43. The tax rate Mr. Daniel wants you to utilize is 25%. When calculating the tax shield, the present value should be in the same period as the initial investment (Year 0), which also means that deprecation (i.e., CCA) should not be taken from the cash flows in subsequent years since their tax shelter effects are already accounted for in the tax shield.   Reconstruction of Coffee Shops to add yogurt services- IT IS IN THE IMAGE BELOW Requirements are in the image below! I need the excel file for the whole solution.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Investment Proposals for Orio Coffee House

Daniel Jackson, CEO of OCH, has approached you to work on 2 investment proposals that the company is considering:

1. Buying coffee roaster plant in Mexico.
2. The Reconstruction of coffee shops to add the selling of yogurt.

Mr. Daniel reminds you to consider only relevant expense and income. “Relevant costs have to be occurring in the future,”He said. “And have to be unique from the status quo. For example, if we choose to buy the roaster plant, it is only the incremental revenue and costs related to the purchase that should be considered. We also need to take into account the opportunity cost associated with the alternatives.”

More details on both of investment proposal is written below. Mr. Daniel wants you to recommend after evaluation, if OCH should invest in one, both, or none of the investment proposals.

Required Return

Mr. Daniel wants you to use 7% as the discount rate (i.e., the required return).

First Proposal of Investment in Roasted Coffee Plant

Mr. Daniel is considering investing in a coffee plant in Mexico where you can get cheap labor and there are proximal coffee farms that can decrease transportation costs.

The cost of acquisition of the plant is $7Million, which covers roasting equipment that originally cost $14Million when it was purchased 8 years ago. Some of the equipment is obsolete and need to be discarded, so an additional $2Million of equipment has to be purchased. The roaster plant currently has $2Million of available tax shield left, excluding any tax shield related to the equipment to be purchased.

The raw materials and direct labour used for manufacturing these products are 8% and 7% of sales, respectively. The processing costs for roasting are approximately 17% of total sales. All of these costs as a percentage of sales are expected to remain constant over the time horizon. The plant also needs2 managers with fixed salaries of $50,000 each per year. Insurance cost for the plant and equipment is $40,000 per year.

Additional incremental production overhead costs (property taxes, maintenance, security, etc.) excluding depreciation are estimated as $75000 yearly. Wages are expected to rise with inflation (estimated to be 2%) over the time period, while other fixed costs are expected to remain steady.

Transportation related variable costs (gas, variable overhead, etc.) are estimated to be 12% of revenue, and include transportation of raw materials to the roaster and finished products to the port for delivery to OCH coffeehouses.

The roasted coffee plant is expected to produce 1.1M pounds of coffee for the first two years, with production dipping by 100,000 pounds per year after this due to lower productivity from the deteriorating equipment. Each pound of roasted coffee can be sold at $3.25 per pound (either to retail cafes, franchise cafes, or to wholesale partners), with the price expected to rise with inflation over time. Each pound of coffee can make 30 cups of coffee that can sell at an average retail price of $4.00 per cup. Mr. Daniel has stressed that the profitability of the plant base has to be looked at on a stand-alone basis, i.e., from the sales from the plant to buyers, not from retail cafés to customers.

Mr. Daniel wants to evaluate if project will be profitable after5 years, as significant reinvestment will be needed after five years to keep the plant operational, so he wants you to evaluate the return on investment in that period using the investment criteria of payback period, NPV, and IRR. The following table will help in the calculations of the tax shield for the new equipment:

Class

CCA Rate

Description

43

30%

Machine and equipment to manufacture and process goods for sale

 

Tax Shield Formula:

 

 

Assume no salvage value when calculating the tax shield, and that the half-year rule applies for Class 43. The tax rate Mr. Daniel wants you to utilize is 25%. When calculating the tax shield, the present value should be in the same period as the initial investment (Year 0), which also means that deprecation (i.e., CCA) should not be taken from the cash flows in subsequent years since their tax shelter effects are already accounted for in the tax shield.

 

Reconstruction of Coffee Shops to add yogurt services- IT IS IN THE IMAGE BELOW

Requirements are in the image below!

I need the excel file for the whole solution.

6:56
ull
Back
Financecase
Tax Shield Formula:
Assume no salvage value when calculating the tax shield, and
that the half-year rule applies for Class 43. The tax rate Mr.
Daniel wants you to utilize is 25%. When calculating the tax
shield, the present value should be in the same period as the
initial investment (Year 0), which also means that deprecation
(i.e., CCA) should not be taken from the cash flows in
subsequent years since their tax shelter effects are already
accounted for in the tax shield.
Reconstruction of Coffee Shops to add yogurt services
Mr. Daniel also ask you to evaluate the potential of
developing several hundred stores into new store models with
frozen yogurt services. 500 stores have been selected as
candidates for development. It will cost $80,000 to convert
each store, including modifications to refrigeration equipment,
with these costs being capitalized with a 6% applicable CCA
rate. The average modified coffee shop is expected to generate
an additional $30,000 in after-tax cash flow every year.
However, OCH is also estimated to lose about $15,000 in
annual after-tax cash flow from these cafés due to yogurt sales
cannibalizing existing coffee shops. In other words, some
customers who normally would have purchased coffee would
instead purchase yogurt.
The 500 stores have average annual rent of $36,000 each. Mr.
Daniel wants you to evaluate the profitability of this
investment after a seven-year period using the investment
criteria of NPV.
Requirements
1. Identify which revenues and costs are relevant to your analysis,
and which costs are irrelevant. Summarize all the information
that will be required for each investment proposal, including
describing the proposal and identifying the time horizon for
each proposal evaluation.
2.Calculate the after-tax cash flows during the life of each of
the projects.
3.Utilizing the after-tax cash flows from question 2, evaluate
each investment proposal utilizing the following criteria
(unless directed otherwise):
a. Payback
b. NPV
4. Clearly indicate whether any of the above criteria support
each of the project proposals, and what the company should
ultimately decide to do.
Transcribed Image Text:6:56 ull Back Financecase Tax Shield Formula: Assume no salvage value when calculating the tax shield, and that the half-year rule applies for Class 43. The tax rate Mr. Daniel wants you to utilize is 25%. When calculating the tax shield, the present value should be in the same period as the initial investment (Year 0), which also means that deprecation (i.e., CCA) should not be taken from the cash flows in subsequent years since their tax shelter effects are already accounted for in the tax shield. Reconstruction of Coffee Shops to add yogurt services Mr. Daniel also ask you to evaluate the potential of developing several hundred stores into new store models with frozen yogurt services. 500 stores have been selected as candidates for development. It will cost $80,000 to convert each store, including modifications to refrigeration equipment, with these costs being capitalized with a 6% applicable CCA rate. The average modified coffee shop is expected to generate an additional $30,000 in after-tax cash flow every year. However, OCH is also estimated to lose about $15,000 in annual after-tax cash flow from these cafés due to yogurt sales cannibalizing existing coffee shops. In other words, some customers who normally would have purchased coffee would instead purchase yogurt. The 500 stores have average annual rent of $36,000 each. Mr. Daniel wants you to evaluate the profitability of this investment after a seven-year period using the investment criteria of NPV. Requirements 1. Identify which revenues and costs are relevant to your analysis, and which costs are irrelevant. Summarize all the information that will be required for each investment proposal, including describing the proposal and identifying the time horizon for each proposal evaluation. 2.Calculate the after-tax cash flows during the life of each of the projects. 3.Utilizing the after-tax cash flows from question 2, evaluate each investment proposal utilizing the following criteria (unless directed otherwise): a. Payback b. NPV 4. Clearly indicate whether any of the above criteria support each of the project proposals, and what the company should ultimately decide to do.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Relevant cost analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education