The Milk 4 All Company is considering branching into the ice-cream business. It will need a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Milk 4 All Company is considering branching into the ice-cream business. It will need a machine costing $1,000,000 to produce the ice cream. The machine will be depreciated over ten years to zero salvage value. However, the ice-cream project is expected to last for only five years, so that at the end of the project the machine will be sold for its market value. The sale price of the machine at the end of five years will be uniformly distributed with a minimum value of $300,000 and a maximum value of $500,000. If the market value is less than the book value, the company will claim a loss on the difference. Sales in year I follow the triangular distribution with a minimum value of $2,000,000, a most likely value of $3,000,000 and a maximum value of $7,000,000. Thereafter, sales in year t, S₁, are related to sales in the previous year, Si-1, by the equation S, 750,000+ 0.875*S-1 + e where e, is normally distributed with mean 0 and standard deviation 150,000. In each year, manufacturing costs as a percentage of sales have a pert distribution with a minimum value of 70 percent, a maximum value of 95 percent, and a most likely value of 85 percent. Fixed cash cost (rent) is expected to be $100,000 in the first year. Thereafter the fixed cash cost is expected to grow at the expected inflation rate at 4 percent a year. The project will require an initial investment of $300,000 in net working capital. From year 1 onwards, the project requires net working capital level to equal to 10 percent of that year's projected sales. (Note: since there is an initial investment in working capital, you only need to determine the net change from year to year. Assume that you can recover your working capital investment at the end of the project.) Profits are subject to a 30 percent tax rate. The Milk 4 All Company is profitable enough so that any losses at the project level translate to a tax deduction at the corporate level. In other words, negative tax at the project level is a possible scenario. The cost of capital is 14 percent. The risk free rate is equal to 6%. Perform a simulation in answering the following questions. You need to submit: a. An Executive summary that describes the analysis you performed and the results you obtained in answer to the questions below. b. An appendix with supporting evidence (Printout of cash flow model, Output Summary, Tornado Diagram, etc.) c. An electronic copy of the spreadsheet work. Questions a) Assume that sales in year 1 follow the triangular distribution with a minimum value of $2,000,000, a most likely value of $3,000,000 and a maximum value of $7,000,000. Calculate the probability that year 1 sales will be between $4,000,000 and $6,000,000. b) Given that manufacturing costs as a percentage of sales have a pert distribution with a minimum value of 70 percent, a maximum value of 95 percent, and a most likely value of 85 percent, calculate the probability that manufacturing cost as a percentage of sales is greater than 75% and the probability that manufacturing cost as a percentage of sales is less than 90%. c) Calculate the average NPV of the project over 1000 iterations. What is the 95% confidence interval for the NPV? How many iterations would be required to narrow this confidence in half? d) What is the value at risk (VAR) for this project? What is the probability of having a negative NPV? e) Use a tornado diagram to rank the uncertain variables in terms of their influence on the NPV. f) What are your observations/recommendations about the project? For example, explain what (if anything) you could do to increase the average NPV of the project. The Milk 4 All Company is considering branching into the ice-cream business. It will need a machine costing $1,000,000 to produce the ice cream. The machine will be depreciated over ten years to zero salvage value. However, the ice-cream project is expected to last for only five years, so that at the end of the project the machine will be sold for its market value. The sale price of the machine at the end of five years will be uniformly distributed with a minimum value of $300,000 and a maximum value of $500,000. If the market value is less than the book value, the company will claim a loss on the difference. Sales in year I follow the triangular distribution with a minimum value of $2,000,000, a most likely value of $3,000,000 and a maximum value of $7,000,000. Thereafter, sales in year t, S₁, are related to sales in the previous year, Si-1, by the equation S, 750,000+ 0.875*S-1 + e where e, is normally distributed with mean 0 and standard deviation 150,000. In each year, manufacturing costs as a percentage of sales have a pert distribution with a minimum value of 70 percent, a maximum value of 95 percent, and a most likely value of 85 percent. Fixed cash cost (rent) is expected to be $100,000 in the first year. Thereafter the fixed cash cost is expected to grow at the expected inflation rate at 4 percent a year. The project will require an initial investment of $300,000 in net working capital. From year 1 onwards, the project requires net working capital level to equal to 10 percent of that year's projected sales. (Note: since there is an initial investment in working capital, you only need to determine the net change from year to year. Assume that you can recover your working capital investment at the end of the project.) Profits are subject to a 30 percent tax rate. The Milk 4 All Company is profitable enough so that any losses at the project level translate to a tax deduction at the corporate level. In other words, negative tax at the project level is a possible scenario. The cost of capital is 14 percent. The risk free rate is equal to 6%. Perform a simulation in answering the following questions. You need to submit: a. An Executive summary that describes the analysis you performed and the results you obtained in answer to the questions below. b. An appendix with supporting evidence (Printout of cash flow model, Output Summary, Tornado Diagram, etc.) c. An electronic copy of the spreadsheet work. Questions a) Assume that sales in year 1 follow the triangular distribution with a minimum value of $2,000,000, a most likely value of $3,000,000 and a maximum value of $7,000,000. Calculate the probability that year 1 sales will be between $4,000,000 and $6,000,000. b) Given that manufacturing costs as a percentage of sales have a pert distribution with a minimum value of 70 percent, a maximum value of 95 percent, and a most likely value of 85 percent, calculate the probability that manufacturing cost as a percentage of sales is greater than 75% and the probability that manufacturing cost as a percentage of sales is less than 90%. c) Calculate the average NPV of the project over 1000 iterations. What is the 95% confidence interval for the NPV? How many iterations would be required to narrow this confidence in half? d) What is the value at risk (VAR) for this project? What is the probability of having a negative NPV? e) Use a tornado diagram to rank the uncertain variables in terms of their influence on the NPV. f) What are your observations/recommendations about the project? For example, explain what (if anything) you could do to increase the average NPV of the project.
Expert Answer:
Answer rating: 100% (QA)
I EXECUTIVE SUMMARY Overview The Milk 4 All Company is considering branching into the icecream business From the all information given we prefer to build a financial model to analyze the model and mak... View the full answer
Related Book For
Engineering Economy
ISBN: 978-0132554909
15th edition
Authors: William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Posted Date:
Students also viewed these accounting questions
-
The Ultra-Cool Ice Cream Company wants to ensure that all its products are prepared with precision to produce a consistent taste. Periodically, a sample of ice cream is removed from the processing...
-
Yum Ice Cream is a family-owned business, loved by local people for their creative ice cream recipes that provide 52 flavour options. The owner wants to grow the business further by attending a...
-
The Chocolate Ice Cream Company and the Vanilla Ice Cream Company have agreed to merge and form Fudge Swirl Consolidated. Both companies are exactly alike except that they are located in different...
-
When not cooking for Cody and Lucky, Don works part-time as a logistics expert. Don needs to optimize the shipment of plastic plates from the Plants in Miami, St. Louis, and Cleveland to the...
-
After you have given your boss your information in Problem 9.33, he considers how accurate you have been in the past when you have made such assessments. In fact, he decides you are somewhat...
-
The Maynard Company has projected the following quarterly sales amounts for the coming year: a. Accounts receivable at the beginning of the year are $240. Maynard has a 45-day collection period....
-
Numerically solve the nonlinear pendulum problem using the EulerCromer Method for a pendulum with length \(L=0.5 \mathrm{~m}\) using initial angles of \(\theta_{0}=10^{\circ}\), and...
-
Goldberg Apparel Company uses a job order cost system. The following data summarize the operations related to production for March: a. Materials purchased on account, $233,000. b. Materials...
-
Marble Construction estimates that its WACC is 8% if equitycomes from retained earnings. However, if the company issues newstock to raise new equity, it estimates that its WACC will rise to8.8%. Th 2...
-
Here are simplified financial statements for Phone Corporation in 2020: INCOME STATEMENT (Figures in $ millions) Net sales Cost of goods sold Other expenses Depreciation Earnings before interest and...
-
13. What give immunoglobulins their recognizable 'Y' or 'T' shape? A) The disulfide bonds B) The salt linkages C) The arrangement of four polypeptide chains D) The glycoproteins structure 14. What do...
-
When organizations hire from within the talent can come from the pool of talent that is located within. The employees know the organization and can quickly make the adjustment to a new role armed...
-
Which one of the following items is typically an example of an indirect cost of a cost object? Question 6 options: refundable sales tax on direct materials manufacturing plant electricity direct...
-
Evaluate the expression 5 x ^ 0 - y ^ 1 if x = 3 and y = 9
-
a . Let I ( t ) be the total annual income ( in billions of dollars ) of all households at t years since 2 0 0 0 . Find a linear equation of I.
-
When in a Leadership/ management role, why is it important to develop public speaking skills.
-
We have had historically low interest rates in the United States for several years now. Comment on the effect this has on borrowers, lenders, savers, and retirees. Has this made a difference in the...
-
Should U.S. antidumping laws be stated in terms of average total costs or average variable costs?
-
The longer a loan schedule lasts, the more interest you will pay. To illustrate a $20,000-car-loan at 9% APR (compounded monthly) for three years (36 monthly payments) will incur total interest of...
-
The American Pharmaceutical Company (APC) has a policy that all capital investments must have a four-year or less discounted payback period in order to be considered for funding. The MARR at APC is...
-
For the following table, assume a MARR of 15% per year and a useful life for each alternative is eight years which equals the study period. The rank-order of alternatives from least capital...
-
\(-6,-3,10,1,4\) Plot the integers on the same number line.
-
\(-3,-10,7,2\) Plot the integers on the same number line.
-
Identify all integers in the following list: \(-9.2,13,-1, \sqrt{47}, \frac{\sqrt{3}}{2}, 567,-300\).
Study smarter with the SolutionInn App