Currently, Teewinot sells 1,500,000 per year, but they expect demand to increase by 10% each year...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Currently, Teewinot sells 1,500,000 per year, but they expect demand to increase by 10% each year for the next 4 years then drop down to 3% growth in volume for the remaining life of the machine. Teewinot's cost of capital is 12% and their tax rate is 33%. Construct a dynamic financial model in excel that will answer for the following questions: 1) Noting the current annual volume of sales is 1,500,000 cans, what is the NPV of the canning machine project? Would you accept or reject this project? 2) Use the Goal Seek function in excel to calculate the break-even point in volume that would cause the brewery to reject the canning machine project (assume the same growth rates as previous example). 3) Calculate the IRR on this project, assuming the current growth rates of 10% for the first 4 years then falling to 3% growth rate. Create a data table to show the IRR of the project for the following scenarios (see Chap 24 for Data Tables): a. instead of a 10% growth rate for the first 4 years, the company expects 5% growth rate for first 4 years, then 3% rate b. The company expects 8% growth rate for first 4 years, then 3% rate c. The Company expects 12% growth rate first 4 years, the 3% rate 4) If you were Teewinot's CFO, would you choose to take on this project? Include a few paragraphs explaining your decision. Include the major assumptions in this model and potential risks for making this decision. Currently, Teewinot sells 1,500,000 per year, but they expect demand to increase by 10% each year for the next 4 years then drop down to 3% growth in volume for the remaining life of the machine. Teewinot's cost of capital is 12% and their tax rate is 33%. Construct a dynamic financial model in excel that will answer for the following questions: 1) Noting the current annual volume of sales is 1,500,000 cans, what is the NPV of the canning machine project? Would you accept or reject this project? 2) Use the Goal Seek function in excel to calculate the break-even point in volume that would cause the brewery to reject the canning machine project (assume the same growth rates as previous example). 3) Calculate the IRR on this project, assuming the current growth rates of 10% for the first 4 years then falling to 3% growth rate. Create a data table to show the IRR of the project for the following scenarios (see Chap 24 for Data Tables): a. instead of a 10% growth rate for the first 4 years, the company expects 5% growth rate for first 4 years, then 3% rate b. The company expects 8% growth rate for first 4 years, then 3% rate c. The Company expects 12% growth rate first 4 years, the 3% rate 4) If you were Teewinot's CFO, would you choose to take on this project? Include a few paragraphs explaining your decision. Include the major assumptions in this model and potential risks for making this decision.
Expert Answer:
Answer rating: 100% (QA)
To answer the questions we need to build a dynamic financial model in Excel to calculate the Net Present Value NPV Internal Rate of Return IRR and breakeven point for Teewinots canning machine project ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Teewinot Brewing is rapidly expanding craft brewery. Currently Teewinot sells beverages in bottles and cans. The brewery does not currently own the necessary equipment to package its own beer into...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Inventory Ratio Calculations Dell Technologies reported the following data for 2018 and 2019 (in millions): Inventory February 3, 2017 $ 2,538 February 2, 2018 2,678 February 1, 2019 3,649 Cost of...
-
What is the first step in the writing process for a persuasive message, and why is this step important?
-
(a) What length should a tube closed at one end have on a day when the air temperature, is 22.0C, if its fundamental frequency is to be 128 Hz (C below middle C)? (b) What is the frequency of its...
-
Palanquin Auto is a national pre-owned car retailer that offers an online marketplace for customers interested in purchasing a preowned automobile. In an effort to reduce price negotiation, Palanquin...
-
Consider the following LP problem: MAX: 4X1 + 2X2 Subject to: 2X1 + 4X2 20 3X1 + 5X2 15 X1, X2 0 a. Use slack variables to rewrite this problem so that all its constraints are equal to...
-
What is a plan on how you intend to be successful in future semesters. The plan should be a source of motivation to do well in college, both professionally and personally. Include tips that you can...
-
The state of Kentucky filed a tax lien against Panbowl Energy, claiming unpaid taxes. Six months later, Panbowl bought a powerful drill from Whayne Supply, making a down payment of $11,500 and...
-
Franco is an exchange student from Italy studying at a university in Australia. He bought a bicycle when he arrived so he could easily travel around the campus and to his accommodation. He met with...
-
Compute the horizontal force P required to prevent the 900 lb block, shown below from sliding down the plane. The coefficient of friction between the block and the plane is 0.20. W = 900 lb 35 ASSI 35
-
You are the office manager for Dr. Jones. He comes to you with a new Cigna contract that he just received in the mail. He is not sure he will be able to increase the number of employees that he...
-
Assume that Farmer Jan and Rancher Jean have the same amount of resources and identical technologies. Farmer Jan can produce 2 pounds of meat or 4 pounds of potatoes or any combination. Rancher Jean...
-
How would you describe your self-image? Which aspects of your self-concept would you like to change? Do you basically like yourself? Are you more self-confident in some situations than in others? Are...
-
Briefly describe the importance of trust,collegiality,fairness and accountability in research collaborations. Explanation and conclusion please
-
What is the critical path for the project?
-
In Problem use absolute value on a graphing calculator to find the area between the curve and the x axis over the given interval. Find answers to two decimal places. y = x 3 ln x; 0.1 x 3.1
-
Using Exhibit 12-9 as a guide, compare C&C Sports performance to the industry averages. What particular observations and recommendations do you have for George Douglas, president of C&CSports? 2011...
-
Herzog Industries sells two electrical components with the following characteristics. Fixed costs for the company are $200,000 per year. Required a. How many units of each product must Herzog...
-
First State Bank offers a wide range of banking services, including checking accounts, certificates of deposit, loans, credit cards, and safety deposit boxes. Bank managers know that customer...
-
Why are none of the bulbs in Figure 31. 24 lit? Data from Figure 31. 24 Figure 31.24 (1) (iii) NNN
-
In Figure 31. 25, identify the energy conversions that occur between points \(A\) and \(B, B\) and \(\mathrm{C}, \mathrm{C}\) and \(\mathrm{D}\), and \(\mathrm{D}\) and \(\mathrm{A}\). Data from...
-
In Figure 31. 26, bulb B is brighter than bulb C, which in turn is brighter than bulb A. Rank, largest first, \((a)\) the magnitudes of the potential differences across the bulbs, \((b)\) the...
Study smarter with the SolutionInn App