Question

Mackmyra Whisky AB needs additional funds for further expansion. The problem with their business of producing and sellin...

Mackmyra Whisky AB needs additional funds for further expansion. The problem with their business of producing and selling whisky is a long cash conversion cycle, which means that cash comes in only 9, 12 or 15 years after production due to the long storage time of the whisky in oak barrels.

Mackmyra AB considers to take a loan of 30 million SEK for the expansion at a borrowing rate of 3%. However, Mackmyra's new CFO, a former JIBS student, proposes to sell 30-liter whisky barrels in advance to customers right after production. (Customers would take care themselves regarding the storage of their whisky barrels for some years until the whisky is bottlened and ready for consumption.) However, the price of a freshly distilled whisky barrel (called a zero-year barrel) is lower than those of 9, 12 or 15 years old barrels. The CFO estimates that Mackmyra could sell the zero-year barrel at a price of 17750 kr. Currently, 9-year barrels are sold at a price of 25000 kr, 12-year barrels are sold at a price of 28500 kr and 15-year barrels are sold at a price of 31000 kr. (For the sake of simplicity, we assume that there won't be price changes for the barrels in the coming years.)

a.) Calculate the NPV of this proposal. Assumption: From three produced whisky barrels, one is sold as 9-year, one is sold as 12-year, and the third one is sold as a 15-year barrel.

(Hint: assume that selling three zero-year barrels implies to loose the income from selling them as 9-, 12-, and 15-year barrel later on.)

b.) At which price of the zero-year barrel is Mackmyra indifferent between taking a loan or selling the zero-year barrels? (or to put it differently, at which price of the zero-year barrel do we have a break-even?)

c.) Consider now the perspective of an investor who is interested to buy zero-year barrels at a price of 17750 kr. What is the IRR of buying three zero-year barrels and keeping them until 9, 12 and 15 years respectively, and to sell them in those years at the prices stated above? (We assume again that prices do not change and that the investor has no storage costs.)

d) If the investor has an opportunity cost of capital of 3%, should she buy the zero-year barrel at a price of 17750 kr?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part (a)

Let's assume Mackmyra sells 3 barrels of the zero-year barrel at a price of 17750 kr. He / she therefore loses the opportunity to sell at a future date,1 barrel each of 9-year barrels at a price of 25000 kr, 12-year barrels at a price of 28500 kr and 15-year barrels at a price of 31000 kr.

So, the cash flows will look like as shown below in the table. Please be guided by the second column in the table titled “Linkage” to understand the mathematics. That explains the mathematics behind each row. The last row highlighted in yellow is your answer. Figures in parenthesis mean negative values. All financials below are in KR.

Year, N Linkage 0 9 12 15
Sale of 3 barrels of Zero year A = 17750 x 3      53,250
Opportunity loss B = 1 x Price of each       (25,000)       (28,500)        (31,000)
Net cash flows C = A + B      53,250       (25,000)       (28,500)        (31,000)
Discount rate R 3%
Discount factor DF = (1 + R)-N      1.0000         0.7664         0.7014         0.6419
PV of cash flows PV = DF x C      53,250       (19,160)       (19,989)        (19,898)
NPV Sum of all PV      (5,797)

Hence, NPV of the proposal is - 5,797 Kr.

Part (b)

Let P be the break even price. From the table above, PV of future cash flows are = -19,160 - 19,989 - 19,898 (I have highlighted these values in the bold in the table above) = - 59,047.

Hence, we need to solve the equation: NPV = 3 x P - 59,047 = 0

Hence, P = 59,047 / 3 =  19,682.49 KR per barrel

Part (c)

The IRR calculation is shown below. I have produced the snapshot from my model. The last row highlighted in yellow is your answer. In the adjacent cell highlighted i blue, I have shown the excel formula used the yellow colored cell to get the output.

X Cash flows (53,250) 187 Year 188 0 189 1 10 190 2 0 191 0 192 4 0 193 194 6 195 7 10 196 8 0 25,000 197 198 10 199 11 0 28,

IRR = 3.89%

Part (d)

IRR = 3.89% > opportunity cost of capital of 3%, she should buy the zero-year barrel at a price of 17750 kr.

Add a comment
Know the answer?
Add Answer to:
Mackmyra Whisky AB needs additional funds for further expansion. The problem with their business of producing and sellin...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Acme Corporation needs further capital injection for its ambitious growth plans. The Acme CFO is wary...

    Acme Corporation needs further capital injection for its ambitious growth plans. The Acme CFO is wary of the risk of high debt issuance, and will issue new shares through a rights offering for additional equity capital of $1,500,000. Question 1 (a) Calculate the current number of shares outstanding and the number of shares to be issued. (b) Calculate the theoretical ex-rights share price if all are exercised. (c) What is the value of the rights per share if all are...

  • Problem 7-19 Abandonment and Expansion ded We are examining a new project. We expect to sell...

    Problem 7-19 Abandonment and Expansion ded We are examining a new project. We expect to sell 5.100 units per year at $65 net cash flow aplece for the next 10 years. In other words, the annual operating cash flow is projected to be $65 5.100 = $331,500. The relevant discount rate is 15 percent, and the initial investment required is $1,500,000 After the first year, the project can be dismantled and sold for $1.220,000. Suppose you think it is likely...

  • 10) An investment will pay you 51 20 in one year and $200 in two years....

    10) An investment will pay you 51 20 in one year and $200 in two years. If the interest rate is 7%, what is the present value of these cash flows? A) $294.69 B) $286.84 C) $299.07 D) $320.00 10) 11). TU) A bank is negotiating a loan. The loan can either be paid off as a lump sum of $120,000 at the end of five years, or as equal annual payments at the end of each of the next...

  • You purchased 500 shares of XYZ stock for $41.80 a share. You have received a total...

    You purchased 500 shares of XYZ stock for $41.80 a share. You have received a total of $820 in dividends and $7,280 in proceeds from selling the shares. What is your capital gains yield on this stock? Select one: a. 3.99% b. 32.38% c. 3.92% d. 34.83% e. 38.76% A stock currently has $2 Earnings Per Shares (EPS). Analysts estimate EPS may grow at 25% per year over the next five years. The investor thinks the stock may sell for...

  • 10) An investment will pay you S120 in one year and $200 in two years. If...

    10) An investment will pay you S120 in one year and $200 in two years. If the interest rate is 7%, what is the present value of these cash flows? A) S294.69 B) $286.84 C) $299.07 D) $320.00 11. A bank is negotiating a loan. The loan can either be paid off as a lump sum of $120.000 at the end of five years, or as equal annual payments at the end of each of the next five years. If...

  • Process or Sell Product T is produced for $3.38 per pound. Product T can be sold wilthout additional processing for $4.16 per pound or processed further into Product U at an additional cost o...

    Process or Sell Product T is produced for $3.38 per pound. Product T can be sold wilthout additional processing for $4.16 per pound or processed further into Product U at an additional cost of $0.47 per pound. Product U can be sold for $4.5 per pound. Prepare a differential analysis dated November 15 on whether to sell T (Alternative 1) or process further into U (Alternative 2). If required, round your answers to the nearest whole dollar. For those boxes...

  • Rockinghouse Corp. management plans to issue seven-year zero coupon bonds. It has learned that these bonds...

    Rockinghouse Corp. management plans to issue seven-year zero coupon bonds. It has learned that these bonds will sell today at a price of $365.13. Assuming annual coupon payments, what is the yield to maturity on these bonds? (Round intermediate calculations to 4 decimal places, e.g. 1.2514 and final answer to 2 decimal places, e.g. 15.25%.) Electrolex, Inc., has four-year bonds outstanding that pay a coupon rate of 12.76 percent and make coupon payments semiannually. If these bonds are currently selling...

  • 1. Sell or Process Further Bunyon Lumber Company incurs a cost of $386 per hundred board...

    1. Sell or Process Further Bunyon Lumber Company incurs a cost of $386 per hundred board feet (hbf) in processing certain "rough-cut" lumber, which it sells for $540 per hbf. An alternative is to produce a "finished cut" at a total processing cost of $522 per hbf, which can be sold for $742 per hbf. Prepare a differential analysis dated August 9 on whether to sell rough-cut lumber (Alternative 1) or process further into finished-cut lumber (Alternative 2). For those...

  • The owners pete and peggy peterson have about 10,000 dollars invested in the business. Their desires...

    The owners pete and peggy peterson have about 10,000 dollars invested in the business. Their desires rate of return on this investment is 10 percent. what volume of business must be generated to reach this ROE (Rate of equity) goal. show in DOLLARS AND PIZZAS. both the question and information are in the photos 2. The owners, Pete and Peggy Peterson, have about $10,000 invested in the business. Their desired rate of return on this investment is 10 percent. What...

  • Hongren's Cost Accounting, chapter 9, problem 23E If the first two years, the company produced and...

    Hongren's Cost Accounting, chapter 9, problem 23E If the first two years, the company produced and sold the same number. Therefore no ending inventory. There was equal profit in both years. However, in the third year, production was the same as the first 2 years. However, sales was lower, 10%. We had ending inventory now. The profit was lower in amount. Would this make sense? Smart Safety, a three-year-old company, has been producing and selling a single type of bicycle...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT