Question

Case: Investment Proposals for Ontario Coffee Home

It is January 1, 2019. You are a Senior Analyst at Ontario Coffee Home (OCH), one of the leading coffee chains and wholesaler of coffee/bakery products in Ontario. The CEO of Ontario Coffee Home, Jerry Donovan, has reached out to you to draft a report to evaluate two investment proposals.

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.

Investment Proposals

Jerry Donovan, CEO of OCH, wants you to evaluate two investment proposals that the company is considering:

1. The purchase of a coffee roaster plant in Cuba.

2. The re-development of coffee shops to accommodate the selling of frozen yogurt.

Mr. Donovan reminds you that only relevant costs and revenues should be considered. “Relevant costs have to be occurring in the future,” explained Mr. Donovan. “And have to differ 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 each investment proposal are included below. Mr. Donovan wants you to recommend if OCH should invest in one, both, or none of the investment proposals.

Required Return

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

Investment in Roasted Coffee Plant

Mr. Donovan is considering purchasing a coffee plant in Cuba where labour is cheap and there are proximal coffee farms to help lower transportation costs.

The acquisition price of the plant is $6M, which includes roasting equipment that originally cost $14M when it was purchased 8 years ago. Some of the equipment is on its last legs, so an additional $2M of equipment has to be purchased. The roaster plant currently has $2M of available tax shield left, excluding any tax shield related to the equipment to be purchased.

The direct materials and direct labour used to manufacture these products are 8% and 7% of sales, respectively. The actual roasting processing costs are approximately 17% of sales. These costs as a percentage of sales are expected to remain consistent over the time horizon. The plant also requires two managers with fixed salaries of $50,000 each per year. Insurance for the plant and equipment is $40,000 per year.

Other incremental manufacturing overhead costs (property taxes, maintenance, security, etc.) excluding depreciation are estimated to be $75,000 annually. Wages are expected to increase with inflation (estimated to be 2%) over the time period, while other fixed costs are expected to remain steady.

Transportation 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. Donovan 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. Donovan wants to see if the project will reach profitability after 5 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. Donovan 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.

Redevelopment of Coffee Shops

Mr. Donovan also wants you to evaluate the potential of developing several hundred stores into new store models with frozen yogurt services. Five hundred 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 five hundred stores have average annual rent of $36,000 each. Mr. Donovan wants you to evaluate the profitability of this investment after a seven-year period using the investment criteria of NPV.

only this is the question

there is no additional information available.

Answer 1

According to chto :- P. Noi le you » Jan 1, 2019 i a Senior Analyst at Ontario Coffee Home (OCH), one of the leading Coffee chains and wholesale 의 Coffee........ * Project → Redevelopment of coffee shop :- Total Panvestment & 80,000 eachi Store 50 x $80,000 40 m & profit after tare $ 30,000 each stole x 500 Stores = 500 ► 15 m loss from each Store $ 15,000 x 500 $ 7.5m Net profit (PAT) or Cash flow - $ 15m -$ 7.5m pay back period $ 7.5m Total investment Profit after tax $ 40m $7.5m 5. 33 years

$ 7.5m NPV (net present value) :- P. No.a Cash in flow after tax pv of operating Cach inflows for 7 years $ 7.5m x PVAF 7 years 7% $ 7.5m x0.699 $ 4.665 m NPV $ 4.665 m project purchase of Coffee roaster plant :- Sales $1.1m x $ 3.25 $ 35, 75,000 less : Cost goods sold of Dixect material sy. $ 2,86,000 Dislect labour $2,50,250 actual rosting process (17 %) $6,07,750 Solary ($ 50,000 x3) $ 1,00,000 Insurance $ 40,000 overhoad $ 75,000 variable transporatation $3,13,920 lay. of revenue nue $ 1,67,9920

P.No.3 $ 19,02,050 tess: Tax 954 $ 4,75,500 Proft after tax $ 14,26,560.00 $8m pay back period $ 1.4am 5.63 years Nov Cash flow after tax $ 1, 42, 6560 Pv of operating Cash inflows for 5 years $ 14,26,560 x PVAF 5 years 7% $ 14,26,560 X 0, 712 $ 1,01, 5710.72 :. Nov $ 1.2 m Coffee shop, revenue Note :- Project redevelopment of genclated So this projected accepted. please, give much is a positive vola.....