A small production company has estimated its sales, and sales price over the next five years...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A small production company has estimated its sales, and sales price over the next five years as: 2 1200 $95.00 $52.00 3 1400 $92.00 $54.00 1 Sales 1000 Sales Price $100.00 Variable Costs $50.00 Fixed costs are $20,000 up to 1,250 units produced, and $25,000 above that. There is an investment of $50,000 mainly for training and reorganizing some of the production layout. The company will be using existing equipment that has already been fully depreciated. The small company has a flat tax rate of 29%. The owner, after reflecting his cost of capital, investment opportunities, and the risks of the project has decided that the Minimum Acceptable Rate of Return (MARR) should be 15%. Below is the base case with no uncertainty: 5 1400 $89.00 $55.00 1400 $90.00 $55.00 INCOME STATEMENT Revenues Fixed Costs Variable Costs EBT Taxes Net Income CASH FLOW STATEMENT NI Investment Net Cash Flow MARR $ (50,000.0 0) $ (50,000.0 0) 15% $ NPV 16,371.74 1 S $ 100,000.0 0 $ 20,000.00 $ 50,000.00 $ 30,000.00 $ 8,700.00 $ 21,300.00 2S $ 9,164.00 $ 3 $ $ 21,300.00 22,436.00 $ 4 $ 126,000.0 0 114,000.0 128,800.0 0 0 $ $ 20,000.00 25,000.00 $ $ 62,400.00 75,600.00 77,000.00 77,000.00 $ $ $ $ 31,600.00 28,200.00 24,000.00 22,600.00 $ $ $ $ 8,178.00 6,554.00 $ $ 22,436.00 20,022.00 16,046.00 $ 25,000.00 $ 5 6,960.00 $ 17,040.00 $ 124,600.0 0 $ 25,000.00 $ $ $ $ 20,022.00 17,040.00 16,046.00 $ $ $ $ $ 21,300.00 22,436.00 20,022.00 17,040.00 16,046.00 Uncertainty: Being a new business line, there is a high degree of uncertainty with the values that are compiled. The owner feels that there is a 20% chance that production/sales estimates might be as much as 10% too high, and 20% chance that they will be 10% too low. There is also some uncertainty tied to the variable costs of the project. Based on the nature of the industry, he is quite sure that these costs will not be any lower than forecasted, but, there is a 20% chance that the costs may increase by up to 8%. His present estimates of the product price are based largely on expected increases in the competition that this industry will experience, and the pressures that will be imposed on the price as the supply of goods starts meeting demand. Depending on how much demand may increase in the market, and the extent to which supply is increased, conditions of over, or under supply may arise. The owner estimates that there is a 20% chance that a condition of oversupply will be generated in which case sales prices in years 3, 4, and 5 will decrease by 4%, 6%, and 8% respectively. Similarly, there is a 20% chance that a condition of undersupply may arise in which case the sales price will most likely increase by 4%, 6%, and 8% in years 3, 4, and 5 respectively. Analysis: Conduct a sensitivity analysis with the information provided. 1) Develop a cash flow similar to the one below which shows simulated year one data (yours will differ). Develop all 5 years of data, based upon the above variations, and calculate the NPV. Cash Flow Revenues Fixed Costs Variable Costs EBT Taxes Net Income Cash Flow Net Income Investment Net Cash Flow $(50,000.00) $(50,000.00) 1 $ 94,282.00 $ 20,000.00 $ 51,153.00 $ 23,129.00 $ 6,707.41 $ 16,421.59 15% $6,423.51 $ 16,421.59 $ 16,421.59 2 3 4 MARR NPV 2) Develop summary statistics of at least 30 instances that reflect how often and how profitable this venture may be. 3) Under what specific conditions is this an unattractive venture? 4) What risk mitigation or management strategies might the owner consider in trying to ensure the venture remains profitable? 5 A small production company has estimated its sales, and sales price over the next five years as: 2 1200 $95.00 $52.00 3 1400 $92.00 $54.00 1 Sales 1000 Sales Price $100.00 Variable Costs $50.00 Fixed costs are $20,000 up to 1,250 units produced, and $25,000 above that. There is an investment of $50,000 mainly for training and reorganizing some of the production layout. The company will be using existing equipment that has already been fully depreciated. The small company has a flat tax rate of 29%. The owner, after reflecting his cost of capital, investment opportunities, and the risks of the project has decided that the Minimum Acceptable Rate of Return (MARR) should be 15%. Below is the base case with no uncertainty: 5 1400 $89.00 $55.00 1400 $90.00 $55.00 INCOME STATEMENT Revenues Fixed Costs Variable Costs EBT Taxes Net Income CASH FLOW STATEMENT NI Investment Net Cash Flow MARR $ (50,000.0 0) $ (50,000.0 0) 15% $ NPV 16,371.74 1 S $ 100,000.0 0 $ 20,000.00 $ 50,000.00 $ 30,000.00 $ 8,700.00 $ 21,300.00 2S $ 9,164.00 $ 3 $ $ 21,300.00 22,436.00 $ 4 $ 126,000.0 0 114,000.0 128,800.0 0 0 $ $ 20,000.00 25,000.00 $ $ 62,400.00 75,600.00 77,000.00 77,000.00 $ $ $ $ 31,600.00 28,200.00 24,000.00 22,600.00 $ $ $ $ 8,178.00 6,554.00 $ $ 22,436.00 20,022.00 16,046.00 $ 25,000.00 $ 5 6,960.00 $ 17,040.00 $ 124,600.0 0 $ 25,000.00 $ $ $ $ 20,022.00 17,040.00 16,046.00 $ $ $ $ $ 21,300.00 22,436.00 20,022.00 17,040.00 16,046.00 Uncertainty: Being a new business line, there is a high degree of uncertainty with the values that are compiled. The owner feels that there is a 20% chance that production/sales estimates might be as much as 10% too high, and 20% chance that they will be 10% too low. There is also some uncertainty tied to the variable costs of the project. Based on the nature of the industry, he is quite sure that these costs will not be any lower than forecasted, but, there is a 20% chance that the costs may increase by up to 8%. His present estimates of the product price are based largely on expected increases in the competition that this industry will experience, and the pressures that will be imposed on the price as the supply of goods starts meeting demand. Depending on how much demand may increase in the market, and the extent to which supply is increased, conditions of over, or under supply may arise. The owner estimates that there is a 20% chance that a condition of oversupply will be generated in which case sales prices in years 3, 4, and 5 will decrease by 4%, 6%, and 8% respectively. Similarly, there is a 20% chance that a condition of undersupply may arise in which case the sales price will most likely increase by 4%, 6%, and 8% in years 3, 4, and 5 respectively. Analysis: Conduct a sensitivity analysis with the information provided. 1) Develop a cash flow similar to the one below which shows simulated year one data (yours will differ). Develop all 5 years of data, based upon the above variations, and calculate the NPV. Cash Flow Revenues Fixed Costs Variable Costs EBT Taxes Net Income Cash Flow Net Income Investment Net Cash Flow $(50,000.00) $(50,000.00) 1 $ 94,282.00 $ 20,000.00 $ 51,153.00 $ 23,129.00 $ 6,707.41 $ 16,421.59 15% $6,423.51 $ 16,421.59 $ 16,421.59 2 3 4 MARR NPV 2) Develop summary statistics of at least 30 instances that reflect how often and how profitable this venture may be. 3) Under what specific conditions is this an unattractive venture? 4) What risk mitigation or management strategies might the owner consider in trying to ensure the venture remains profitable? 5
Expert Answer:
Answer rating: 100% (QA)
To conduct a sensitivity analysis based on the provided information lets calculate the cash flows for each year incorporating the variations and uncertainties mentioned Well also calculate the net pre... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-0133400694
1st canadian edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford, David A. Stangeland, Andras Marosi
Posted Date:
Students also viewed these finance questions
-
1. Based on the information provided in the case below, what is the key strategic goal for Tim Hortons as of August 2014? It would be a year of dramatic change for Tim Hortons Inc. On August 26,...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
A Canadian packaging company wished to extend its activities in the area of convenience foods. It had pinpointed one particular area where it could supply pizza boxes to half a dozen chains of pizza...
-
Discuss the role of value-added options in advertising planning.
-
A vessel of volume 22.4 dm ' contains 1.5 mol H2 and 2.5 mol N2 at 273.15 K. Calculate (a) The mole fractions of each component, (b) Their partial pressures, and (c) Their total pressure.
-
If \(10 \mathrm{~J}\) of magnetic potential energy is stored in a \(5.0-\mathrm{H}\) inductor, what is the current in the inductor?
-
My Web Wholesalers, a small company in Maine, used the Internet to do business around the country. It made offers on its Web site but did not distribute e-mails to customers who did not request...
-
6. To a ground observer the block C is moving with v, and the block A with v. B is moving with v relative to C as shown in the figure. Identify the correct statement. (a) V-V =Vo (b)= A C B (c) V+V =...
-
(a) Mention the core factors that have influenced the service quality in banks. (b) What are the various factors that drive innovations in products and services? Services are undeniably performances...
-
What are the arithmetic operators?
-
(a) If accounts payable are 40,000 and purchases are 240,000, what is the accounts payable/purchases ratio? (b) How many days does the business take on average to pay its creditors?
-
What is social software? Give two examples.
-
The Milham Theatre Club has been in existence for a number of years. Members pay an annual subscription of 15 which entitles them to join trips to professional productions at a reduced rate. On 1...
-
Burden PLC has an authorised capital of 500,000 ordinary shares of 0.50 each. (a) At the end of its financial year, 31 May 2012, the following balances appeared in the companys books: The companys...
-
The owner of a small machine shop has just lost one of his largest customers. The solution to his problem, he says, is to fire three machinists to balance his workforce with his current level of...
-
The Thomas Corporation was organized on Jan. 1, 2020. On Dec. 31, 2021, the corporation lost most of its inventory in a warehouse fire before the year-end count of inventory was to take place. just...
-
Why can bond covenants reduce a firm's borrowing costs?
-
How do firms manage interest rate risk?
-
What does beta () tell us?
-
A company issues $1,000,000 face value of 10-year bonds on January 1, 2015 when the market interest rate on bonds of comparable risk and terms is 5%. Th e bonds pay 6% interest annually on December...
-
Midland Brands issues three-year bonds dated January 1, 2015 with a face value of $5,000,000. Th e market interest rate on bonds of comparable risk and term is 3%. If the bonds pay 2.5% annually on...
-
A company redeems \($1\),000,000 face value bonds with a carrying value of \($990\),000. If the call price is 104 the company will: A . reduce bonds payable by \($1\),000,000. B . recognize a loss on...
Study smarter with the SolutionInn App