Horizon Water Beds was originally founded 20 years ago when owner Glen Fisher started making water...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Horizon Water Beds was originally founded 20 years ago when owner Glen Fisher started making water beds but has since expanded to all bedroom furnishings. The company is considering expanding operations to include manufacturing sofas and love seats. They have spent $50,000 to produce prototypes for several potential designs, they also have an old factory that they used to use to manufacture the waterbeds. Glenn figures that he can use the vacant factory to produce the new product lines. The factory is currently valued at $1,000,000. Glenn estimates that he can sell each sofa for $950 and each love seat for $650. While the cost per unit to produce each will be $600 for the sofas and $500 for each love seat, which includes the cost of materials and the cost of labor. Glen estimates that the cost per unit will increase by 3% per year while he will only be able to increase the price per unit by 2% per year. Fixed costs would include additionally utilities of $50,000. In order to produce the new product lines the company must invest in $1,000,000 in new equipment, which will be depreciated using the 5 years MACRS schedule. The project has a 6 year life at which time the equipment can be salvaged for $50,000 and the factory can be sold for $1,000,000. Net working capital will be 20% of the next years sales. Glen estimates that he will be able to sell 900 sofas and 1000 love seats, in year one and the units sold will increase by 10% each year for both sofas and love seats. The tax rate is 21% and the relevant discount rate is 13%. 1. What is the baseline NPV and IRR? 2. What is the NPVs sensitivity to the Sofa Price? 3. What is the NPVs sensitivity to Sofa Units sold? Copy the Baseline Proforma you just made and create a best- and worst-case scenario. Worst case: There is not as much demand as Glen had previously hoped. Units sold in year one are only 450 for the Sofa and 500 for the Love Seat, and only increase at 5% each year. Additionally, prices do not increase. Everything else is the same as the baseline case. 4. What is the NPV and IRR? Best Case: Demand is much higher than expected. Units sold are 1500 for the Sofa and 1800 for the Love Seat in year one. Everything else is the same as the baseline case. 5. What is the NPV and IRR? If there is a 50% chance that the baseline happens, a 30% chance of the worst case, and a 20% chance of the best case scenario. 6. What is the expected NPV? Now assume that if the worst case scenario does indeed happen Glen has the option to sell the factory for $1,000,000 and the equipment for $500,000 at the end of year 2(so there are sales in year 2). 7. What is the NPV of the worst case with the option? 8. What is the expected overall NPV (updating your answer to question 6 to include the value of the option)? Horizon Water Beds was originally founded 20 years ago when owner Glen Fisher started making water beds but has since expanded to all bedroom furnishings. The company is considering expanding operations to include manufacturing sofas and love seats. They have spent $50,000 to produce prototypes for several potential designs, they also have an old factory that they used to use to manufacture the waterbeds. Glenn figures that he can use the vacant factory to produce the new product lines. The factory is currently valued at $1,000,000. Glenn estimates that he can sell each sofa for $950 and each love seat for $650. While the cost per unit to produce each will be $600 for the sofas and $500 for each love seat, which includes the cost of materials and the cost of labor. Glen estimates that the cost per unit will increase by 3% per year while he will only be able to increase the price per unit by 2% per year. Fixed costs would include additionally utilities of $50,000. In order to produce the new product lines the company must invest in $1,000,000 in new equipment, which will be depreciated using the 5 years MACRS schedule. The project has a 6 year life at which time the equipment can be salvaged for $50,000 and the factory can be sold for $1,000,000. Net working capital will be 20% of the next years sales. Glen estimates that he will be able to sell 900 sofas and 1000 love seats, in year one and the units sold will increase by 10% each year for both sofas and love seats. The tax rate is 21% and the relevant discount rate is 13%. 1. What is the baseline NPV and IRR? 2. What is the NPVs sensitivity to the Sofa Price? 3. What is the NPVs sensitivity to Sofa Units sold? Copy the Baseline Proforma you just made and create a best- and worst-case scenario. Worst case: There is not as much demand as Glen had previously hoped. Units sold in year one are only 450 for the Sofa and 500 for the Love Seat, and only increase at 5% each year. Additionally, prices do not increase. Everything else is the same as the baseline case. 4. What is the NPV and IRR? Best Case: Demand is much higher than expected. Units sold are 1500 for the Sofa and 1800 for the Love Seat in year one. Everything else is the same as the baseline case. 5. What is the NPV and IRR? If there is a 50% chance that the baseline happens, a 30% chance of the worst case, and a 20% chance of the best case scenario. 6. What is the expected NPV? Now assume that if the worst case scenario does indeed happen Glen has the option to sell the factory for $1,000,000 and the equipment for $500,000 at the end of year 2(so there are sales in year 2). 7. What is the NPV of the worst case with the option? 8. What is the expected overall NPV (updating your answer to question 6 to include the value of the option)?
Expert Answer:
Answer rating: 100% (QA)
Solution Baseline NPV and IRR The baseline NPV of the project can be calculated using the following formula NPV CFt 1rt where CFt is the cash flow at time t and r is the discount rate Using the given ... View the full answer
Related Book For
Financial Accounting and Reporting a Global Perspective
ISBN: 978-1408076866
4th edition
Authors: Michel Lebas, Herve Stolowy, Yuan Ding
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Which statement does NOT reflect a way that journals require authors to disclose potential or actual conflicts of interest? Group of answer choices Require researcher's Federal tax statements Require...
-
What can be said about the energy of the environments of deposition of clay-sized particles?
-
Suppose Canadians decide to save more of their incomes. If banks lend this extra saving to businesses, which use the funds to build new factories, how might this lead to faster growth in...
-
Part of a circuit is shown in Figure P23.21. a. What is the current through the \(3.0 \Omega\) resistor? b. What is the value of the current \(I\) ? 2.00 ww 3.0 A 3.0 ww FIGURE P23.21
-
(Accounting Numbers and the Environment) Hardly a day goes by without an article appearing on the crises affecting many of our financial institutions in the United States. It is estimated that the...
-
the owner of a small clothing store is examining expenses related to the workers comp insurance for the 5 employees of the store. The job classification fund rate for retail is determined to be $2...
-
a. Johnson plans to use the preceding ratios as the starting point for discussions with RR's operating team. Based on the data, does RR seem to be following a relaxed, moderate, or restricted current...
-
Write down the procedure used to find the dead time of Geiger Muller Tube.
-
Consider this scenario, a discussion question said that the United States could produce five televisions per hour of labor and China could produce three televisions per hour of labor and asked if the...
-
Consider a compensation contract using quotas: a firm pays its manager a low wage if output is below a target value and a high wage if output meets or exceeds the target level. For instance, paying...
-
1) The Swiss chocolatier Lderach makes scrumptious dark chocolate almond bars and they have a number of stores in New York City. Suppose the market for chocolate almond bars is in equilibrium, and...
-
Ron wants to have enough life insurance on his spouse's life, so that if she died while his kids were still dependent, the remaining family would have the funds to provide a $49,000 annual income for...
-
A family is aiming to save 21000 by the end of 2028. At the end of 2022 they had 14000 on their savings account. How much should they save annually, at the end of each year from 2022 to 2027 to reach...
-
Consider a market in which two firms sell their identical outputs. The demand function is p=100 2.q. The cost functions of the two firms are C, =2.91, C2=5q2. (a) Find the Cournot equilibrium. What...
-
The comparative statements of financial position of Menachem NV at the beginning and end of the year 2019 appear below. Net income of ¬34,000 was reported, and dividends of ¬23,000 were paid...
-
Tippett Company acquired new machine tools for ten million CU. Their aggregate predicted useful lives is four years and their predicted aggregate residual value is one million CU. Depreciation...
-
Below are excerpts from Notes to consolidated financial statements of four companies reporting movements in provisions. Stora Enso (Finland IFRS Source: Annual report 2011 Production of paper)...
-
The French group Club Mditerrane is an active service provider in the leisure and hospitality field with, in particular, its rich network of all-inclusive resort hotels and villages. The statements...
-
Under an evolutionary classification system, species are grouped together based on (a) their shared similarities. (b) how closely related they are to one another. (c) their position in a hierarchy...
-
What criteria are used to classify species in the Linnaean system?
-
The scientific name of a species (a) consists of two parts, the family name and the species name. (b) is always underlined. (c) is always in Latin. (d) includes only the species name.
Study smarter with the SolutionInn App