PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT - SPRING 2021 Company Background PakMax...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT - SPRING 2021 Company Background PakMax Inc. (the "Company") is a global packaging and material handling equipment company with manufacturing, sales and service facilities throughout North America, Europe, and Asia. It is developing a new packaging machine ("PakMax 2.0") that will replace industry legacy packaging machinery and targets companies in the food and beverage sector. The PakMax 2.0 will streamline the packaging function of customer operations which will reduce costs and increase production efficiency. Company management has estimated that the overall market for PakMax 2.0 could be about 15,000 units. Management research indicates that competitors are also developing similar types of machines. PAKMAX 2.0 The machine is a high-speed sorting, labeling, packing and material handling machine. It maximizes the accuracy of the packaging and labeling operation. Its key features consist of: Easily adaptable to various food and beverage manufacturers' product packaging designs Constructed of light weight and durable components which make it easy to move locations within a production facility A robotic system that is built for high-speed operations Low energy usage Can operate at maximum efficiency with minimal downtime for maintenance Low operating costs Packaging Equipment Market Overview The packaging equipment market is set to grow from its current market value of more than $40 billion to more than $50 billion by 2025, according to a new research report. The growing adoption of automation in several industrial sectors is driving growth. Technological advances provide several advantages to industries using these products in packaging applications. For instance, smart sensors offer fault detection, data collection, mobile connectivity, and remote monitoring, boosting efficiency in processes and operations performed in factories. Industries using traditional packaging equipment are focusing on substituting legacy machinery with new innovative equipment to enable mass production. PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT-SPRING 2021 Demand for packaging equipment is primarily driven by the development of energy-efficient equipment, increasing adoption of automated packaging machines and consumer demand for personal care goods. Growing demand for packaging robots from several end-use industries is also a key factor in the packaging machinery market. These machines play a key role in ensuring product safety throughout the value chain. Equipment manufacturers are emphasizing solutions that have minimal environmental impact. High costs associated with the development and installation of packaging equipment is restricting market growth. Small companies cannot afford to purchase these machines, forcing them to implement manual packaging techniques over automated systems, leading to adoption of an equipment rental business model. In addition, increasing maintenance costs are further hindering industry demand. Periodic maintenance and checks need to be performed to ensure proper operation of the equipment. The food and beverage industry accounted for more than 60% of packaging machinery market share in 2019. The packaging equipment market has witnessed growing demand for new machinery from developing markets due to the increase in spending on a wide range of processed and ready-to-go food and beverage products. To satisfy demand, several major companies operating in the food and beverage industry are looking to expand in untapped markets by building new plants and purchasing new machinery. In addition, with changing consumer preferences, food and beverage companies are expected to introduce a range of new products that require innovative or newer packaging machinery. Packaged Food & Beverage Industry Consumer preferences reflect products with bold flavors and meal-replacing snacks. In addition, health and wellness products, particularly in the form of immunity-boosting foods, are also on consumers' minds. Consumers are looking for nutrition-packed foods. Plant-based meats in the form of burgers and chicken nuggets will also continue to rise in favor with consumers, as well as dairy milk substitutes from almonds, soy beans, cashews, coconuts and more which have caused disruption in the traditional dairy market. Consumers continue to demand an increase for healthier, quality frozen food products to accommodate changing lifestyles, particularly for the maturing millennial generation who are now balancing building a healthy family and career. Consumers are focusing more on "clean eating" and have a strong interest in not only what a product is but how it is made and by whom. Transparency into how food is made and where will be key for food businesses. With today's instant access to information, if consumers can't understand or find out where and how a product is made and what's in it, they'll be more inclined to leave it behind in search of alternative products made by companies that have a genuine commitment to sustainability and improving the environment. Consumers will continue to demand to know more about the foods they eat. Food safety is now costing the food and beverage industry billions each year. It will be more important than ever for the industry to pinpoint safety issues immediately. Food companies will need to be mindful of waste reduction as consumers demand sustainable, transparent production and packaging in the products they purchase. Regenerative, upcycling, biodiverse and organic farming and food PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT - SPRING 2021 production will also continue to rise per consumer demand; speed-to-market, quality control and safety must all be a part of this process. Project Details The following are the assumptions developed by the PakMax Production and Sales & Marketing Departments (the "Project Team"). Development Expenditures (Period 0) Years 1-8 The following are the expected expenses and capital expenditures: Manufacturing expenses for ten test machines - $4,000,000 (tax deductible) Engineering including salaries and wages of $2,275,000 (tax deductible) The Project Team determined to evaluate the PakMax 2.0 over an eight-year life. However, it believes its economic life could be longer but concluded eight years would be conservative in evaluating the economics of the project. The Project Team has developed the following forecast assumptions. Other General and administrative expenses $550,000 (tax deductible) Capital expenditures for the needed manufacturing equipment $12,400,000 $4,250,000 of equipment to be depreciated under 5-year MACRS $8,150,000 of equipment to be depreciated under 3-year MACRS MACRS table is supplied PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT-SPRING 2021 > Expenses to transport the PakMax 2.0 to ten test customer locations and to install them for testing $35,000 per machine (tax deductible) Sales and marketing expenses of $2,600,000 Initial working capital investment of $625,000 I Pricing per unit is as follows: o $750,000 per unit O $35,000 annual maintenance agreement. It is assumed this agreement will be purchased in the year of the purchase of the unit only, as future renewals are uncertain. Therefore, the analysis should not include any potential revenue from these contracts after the year of the respective purchase. Marginal O Both are expected to have annual price increases of 3% per year O Number of units sold: Year 1 40 Working capital assumptions At the end of year 8 it is estimated the equipment can be sold for 20% of its original cost As noted above the initial working capital investment is $625,000 End of year working capital is projected to be 2.5% of the current year's revenue At the end of year 8 the working capital accounts will be zero Year N 86636 6*** OOONO DAWN- O Direct material expense per unit is expected to be $390,000 in year one and will increase 3% per year o Manufacturing labor expense: Direct labor full-time-equivalents (FTE) of 2.0 per machine at a cost of $62,500 per FTE Indirect labor FTE 2.5 per machine at a cost of $49,500 per FTE Labor costs will increase at 3.0% annually O Direct overhead will be 3.0% of total revenue of each year O Indirect overhead will be 2.0% of total revenue of each year O Sales and marketing expenses will be 7.5% of total revenue in year 1 decreasing .75% each year thereafter (i.e. 7.5% -.75% = 6.75% for year 2, 6.75% - .75% = 6.0% for year 3) O General and administrative expenses will be 3.0% of total revenue of each year Year 2-85 Year 3-130 Year 4 - 150 Year 5 - 175 Year 6-150 Year 7 - 125 I Year 8-100 tax rate - 24% Required rates of return: Table A-1. Financial Planning & Analysis Department You are have been assigned to the Project Team to develop a capital project analysis which will be part of the presentation made to the Company's capital projects committee to obtain approval in order to move forward with development of PakMax 2.0. O Cost savings projects - 9% Product line extensions - 11% o New products - 13% PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT - SPRING 2021 a financial analyst in the Company's financial planning and analysis department. You The committee requires a written report (Word document 2 page maximum) with supporting Excel analyses which should include: Overview of the project Key factors Preparation model in Excel 3-year 33.33% 44.45 7.41 NPV and IRR analyses The following three sensitivity analyses need to be performed: 1. At what direct material cost per unit does the NPV equal zero (use "Goal Seek" under "Data", "What-if", "Goal Seek") 2. If the working capital assumption increases from 2.5% to 3.0%, what is the impact on NPV/IRR Explanation of your results and recommend whether to accept or reject the project and outline any risks/opportunities associated with the project that could impact the NPV/IRR MACRS Depreciation rates in the packaging equipment market and packaged food & beverage industry of a dynamic (i.e. formulas should be linked to assumptions) project forecast 3. What if the sales price per unit is $760,000 instead of $750,000, what is the impact on NPV/IRR 09 OF ONDE KAN 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period 10-year 10.00% 18.00 14.40 5-year 20.00% 32.00 19.20 11.52 11.52 5.76 7-year 14.29% 24.49 12.49 8.93 8.92 8.93 4.46 11.52 9.22 7.37 6.55 6.55 6.56 6.55 3.28 15-year 5.00% 9.50 8.55 7.70 6.93 6.23 5.90 5.90 5.91 5.90 5.91 5.90 5.91 5.90 5.91 2.95 20-year 3.750% 7.219 6.677 5.713 5.285 4.888 4.522 4.462 4.461 4.462 4,462 4,461 4.462 4.461 4.462 4.462 4,461 2.231 PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT - SPRING 2021 Company Background PakMax Inc. (the "Company") is a global packaging and material handling equipment company with manufacturing, sales and service facilities throughout North America, Europe, and Asia. It is developing a new packaging machine ("PakMax 2.0") that will replace industry legacy packaging machinery and targets companies in the food and beverage sector. The PakMax 2.0 will streamline the packaging function of customer operations which will reduce costs and increase production efficiency. Company management has estimated that the overall market for PakMax 2.0 could be about 15,000 units. Management research indicates that competitors are also developing similar types of machines. PAKMAX 2.0 The machine is a high-speed sorting, labeling, packing and material handling machine. It maximizes the accuracy of the packaging and labeling operation. Its key features consist of: Easily adaptable to various food and beverage manufacturers' product packaging designs Constructed of light weight and durable components which make it easy to move locations within a production facility A robotic system that is built for high-speed operations Low energy usage Can operate at maximum efficiency with minimal downtime for maintenance Low operating costs Packaging Equipment Market Overview The packaging equipment market is set to grow from its current market value of more than $40 billion to more than $50 billion by 2025, according to a new research report. The growing adoption of automation in several industrial sectors is driving growth. Technological advances provide several advantages to industries using these products in packaging applications. For instance, smart sensors offer fault detection, data collection, mobile connectivity, and remote monitoring, boosting efficiency in processes and operations performed in factories. Industries using traditional packaging equipment are focusing on substituting legacy machinery with new innovative equipment to enable mass production. PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT-SPRING 2021 Demand for packaging equipment is primarily driven by the development of energy-efficient equipment, increasing adoption of automated packaging machines and consumer demand for personal care goods. Growing demand for packaging robots from several end-use industries is also a key factor in the packaging machinery market. These machines play a key role in ensuring product safety throughout the value chain. Equipment manufacturers are emphasizing solutions that have minimal environmental impact. High costs associated with the development and installation of packaging equipment is restricting market growth. Small companies cannot afford to purchase these machines, forcing them to implement manual packaging techniques over automated systems, leading to adoption of an equipment rental business model. In addition, increasing maintenance costs are further hindering industry demand. Periodic maintenance and checks need to be performed to ensure proper operation of the equipment. The food and beverage industry accounted for more than 60% of packaging machinery market share in 2019. The packaging equipment market has witnessed growing demand for new machinery from developing markets due to the increase in spending on a wide range of processed and ready-to-go food and beverage products. To satisfy demand, several major companies operating in the food and beverage industry are looking to expand in untapped markets by building new plants and purchasing new machinery. In addition, with changing consumer preferences, food and beverage companies are expected to introduce a range of new products that require innovative or newer packaging machinery. Packaged Food & Beverage Industry Consumer preferences reflect products with bold flavors and meal-replacing snacks. In addition, health and wellness products, particularly in the form of immunity-boosting foods, are also on consumers' minds. Consumers are looking for nutrition-packed foods. Plant-based meats in the form of burgers and chicken nuggets will also continue to rise in favor with consumers, as well as dairy milk substitutes from almonds, soy beans, cashews, coconuts and more which have caused disruption in the traditional dairy market. Consumers continue to demand an increase for healthier, quality frozen food products to accommodate changing lifestyles, particularly for the maturing millennial generation who are now balancing building a healthy family and career. Consumers are focusing more on "clean eating" and have a strong interest in not only what a product is but how it is made and by whom. Transparency into how food is made and where will be key for food businesses. With today's instant access to information, if consumers can't understand or find out where and how a product is made and what's in it, they'll be more inclined to leave it behind in search of alternative products made by companies that have a genuine commitment to sustainability and improving the environment. Consumers will continue to demand to know more about the foods they eat. Food safety is now costing the food and beverage industry billions each year. It will be more important than ever for the industry to pinpoint safety issues immediately. Food companies will need to be mindful of waste reduction as consumers demand sustainable, transparent production and packaging in the products they purchase. Regenerative, upcycling, biodiverse and organic farming and food PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT - SPRING 2021 production will also continue to rise per consumer demand; speed-to-market, quality control and safety must all be a part of this process. Project Details The following are the assumptions developed by the PakMax Production and Sales & Marketing Departments (the "Project Team"). Development Expenditures (Period 0) Years 1-8 The following are the expected expenses and capital expenditures: Manufacturing expenses for ten test machines - $4,000,000 (tax deductible) Engineering including salaries and wages of $2,275,000 (tax deductible) The Project Team determined to evaluate the PakMax 2.0 over an eight-year life. However, it believes its economic life could be longer but concluded eight years would be conservative in evaluating the economics of the project. The Project Team has developed the following forecast assumptions. Other General and administrative expenses $550,000 (tax deductible) Capital expenditures for the needed manufacturing equipment $12,400,000 $4,250,000 of equipment to be depreciated under 5-year MACRS $8,150,000 of equipment to be depreciated under 3-year MACRS MACRS table is supplied PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT-SPRING 2021 > Expenses to transport the PakMax 2.0 to ten test customer locations and to install them for testing $35,000 per machine (tax deductible) Sales and marketing expenses of $2,600,000 Initial working capital investment of $625,000 I Pricing per unit is as follows: o $750,000 per unit O $35,000 annual maintenance agreement. It is assumed this agreement will be purchased in the year of the purchase of the unit only, as future renewals are uncertain. Therefore, the analysis should not include any potential revenue from these contracts after the year of the respective purchase. Marginal O Both are expected to have annual price increases of 3% per year O Number of units sold: Year 1 40 Working capital assumptions At the end of year 8 it is estimated the equipment can be sold for 20% of its original cost As noted above the initial working capital investment is $625,000 End of year working capital is projected to be 2.5% of the current year's revenue At the end of year 8 the working capital accounts will be zero Year N 86636 6*** OOONO DAWN- O Direct material expense per unit is expected to be $390,000 in year one and will increase 3% per year o Manufacturing labor expense: Direct labor full-time-equivalents (FTE) of 2.0 per machine at a cost of $62,500 per FTE Indirect labor FTE 2.5 per machine at a cost of $49,500 per FTE Labor costs will increase at 3.0% annually O Direct overhead will be 3.0% of total revenue of each year O Indirect overhead will be 2.0% of total revenue of each year O Sales and marketing expenses will be 7.5% of total revenue in year 1 decreasing .75% each year thereafter (i.e. 7.5% -.75% = 6.75% for year 2, 6.75% - .75% = 6.0% for year 3) O General and administrative expenses will be 3.0% of total revenue of each year Year 2-85 Year 3-130 Year 4 - 150 Year 5 - 175 Year 6-150 Year 7 - 125 I Year 8-100 tax rate - 24% Required rates of return: Table A-1. Financial Planning & Analysis Department You are have been assigned to the Project Team to develop a capital project analysis which will be part of the presentation made to the Company's capital projects committee to obtain approval in order to move forward with development of PakMax 2.0. O Cost savings projects - 9% Product line extensions - 11% o New products - 13% PAKMAX INC. - CAPITAL PROJECT ANALYSIS FIN 3504 CASE ASSIGNMENT - SPRING 2021 a financial analyst in the Company's financial planning and analysis department. You The committee requires a written report (Word document 2 page maximum) with supporting Excel analyses which should include: Overview of the project Key factors Preparation model in Excel 3-year 33.33% 44.45 7.41 NPV and IRR analyses The following three sensitivity analyses need to be performed: 1. At what direct material cost per unit does the NPV equal zero (use "Goal Seek" under "Data", "What-if", "Goal Seek") 2. If the working capital assumption increases from 2.5% to 3.0%, what is the impact on NPV/IRR Explanation of your results and recommend whether to accept or reject the project and outline any risks/opportunities associated with the project that could impact the NPV/IRR MACRS Depreciation rates in the packaging equipment market and packaged food & beverage industry of a dynamic (i.e. formulas should be linked to assumptions) project forecast 3. What if the sales price per unit is $760,000 instead of $750,000, what is the impact on NPV/IRR 09 OF ONDE KAN 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period 10-year 10.00% 18.00 14.40 5-year 20.00% 32.00 19.20 11.52 11.52 5.76 7-year 14.29% 24.49 12.49 8.93 8.92 8.93 4.46 11.52 9.22 7.37 6.55 6.55 6.56 6.55 3.28 15-year 5.00% 9.50 8.55 7.70 6.93 6.23 5.90 5.90 5.91 5.90 5.91 5.90 5.91 5.90 5.91 2.95 20-year 3.750% 7.219 6.677 5.713 5.285 4.888 4.522 4.462 4.461 4.462 4,462 4,461 4.462 4.461 4.462 4.462 4,461 2.231
Expert Answer:
Answer rating: 100% (QA)
1 Sensitivity Analysis 1 Direct Material Cost per Unit Direct Material Cost per Unit Net Cash Flow NCF Discounted Cash Flow DCF 400000 2000000 1818182 410000 1900000 1727893 420000 1800000 1652630 430... View the full answer
Related Book For
Financial Reporting And Analysis
ISBN: 9781260247848
8th Edition
Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer
Posted Date:
Students also viewed these finance questions
-
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...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
In programming challenge 8 of chapter 3, you created an application that converts celsius temperatures to fahrenheit. recall that the formula for performing this conversion isf = 1.8 * c + 32in the...
-
1. What do you think is the difference in philosophy between the two? 2. How does the life cycle theory enter the discussion? 3. Based on the original interview with Richard and Monica and this one,...
-
Two steamrollers begin \(100 \mathrm{~m}\) apart and head toward each other, each at a constant speed of \(1.00 \mathrm{~m} / \mathrm{s}\). At the same instant, a fly that travels at a constant speed...
-
Identify and describe the two primary no-fault grounds for divorce.
-
Suppose on January 1 you prepaid apartment rent of $5,700 for the full year. Requirement 1. At July 31, what are your two account balances for this situation?
-
A sphere of 10 N is hanged as shown in figure. Find tension in the rope and reaction of wall. Wall- T R- 10 N String Sphere 60 120 R 90 10 N Free body diagram
-
Most businesses sell several products at varying prices. The products often have different unit variable costs. Thus, the total profit and the breakeven point depend on the proportions in which the...
-
Section 4 10. Suppose Amy works in the advertisement sales office of the local cable station, Amy successfully sells an advertisement to 65% of her contacts. Suppose Amy has enough time to contact...
-
If you ask senior corporate executives whether their firms stock prices are overvalued, undervalued, or fairly valued, which do you think would be the most common response? What does this have to do...
-
In theory and in practice, which method is better, NPV or IRR?
-
If a firm has to sell new shares of stock to the public to raise the financing necessary to invest in a project with a small positive NPV, should it do it?
-
List three policy rules that the Fed might follow. Which of these would you advocate? Why?
-
In the neoclassical model of business fixed investment, under what conditions will firms find it profitable to add to their capital stock?
-
a) An item of plant and equipment was purchased on 1 April 20X1 for R100,000. At the date of acquisition its expected useful economic life was ten years. Depreciation was provided on a straight line...
-
Let X be a random variable taking on values a1, a2, . . . , pr with probabilities p1, p2, . . . , pr and with E(X) = μ. Define the spread of X as follows: This, like the standard deviation, is a...
-
On January 1, 20X1, Seven Wonders Inc. signed a five-year noncancelable lease with Moss Company. The lease calls for five payments of $277,409.44 to be made at the end of each year. The leased asset...
-
On January 1, 20X1, Brooks Energy issued $200 million of 15-year, floating rate debentures at par value. The debentures pay interest on June 30 and December 31 of each year. The floating interest...
-
The following information is available from Sand Corporations accounting records for the year ended December 31, 20X1: Cash received from customers ............................. $870,000 Rent...
-
Which of the following is not a constituent of a cells proteome? a. An enzyme b. A cytoskeletal protein c. A transport protein in the plasma membrane d. An mRNA
-
A gene is a segment of DNA that contains the information to produce a functional product. The functional product of most genes is a. DNA. b. mRNA. c. a polypeptide. d. none of the above.
-
The direct result of the process of transcription is the synthesis of a. DNA. b. RNA. c. a polypeptide. d. all of the above.
Study smarter with the SolutionInn App