Company Background Middle River Automotive, LLC (MRA) is a company that was established in 2017 with...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Company Background Middle River Automotive, LLC (MRA) is a company that was established in 2017 with the goal of designing, developing, manufacturing, and selling both hybrid and fully electric cars and light trucks. The company's corporate and design headquarters are in Baltimore, MD. In 2018, the company acquired several decommissioned assembly plants in nearby Middle River, MD, previously owned by Martin Marietta, Corp., an aerospace manufacturing company later acquired by Lockheed Martin. MRA has spent the past 18 months renovating and updating these facilities in anticipation of using them to manufacture electric vehicles. The cost of these renovations thus far has been approximately $1 billion. Scenario It is 2021 and MRA management is currently evaluating a proposal to move forward with plans to manufacture its first light pickup truck, the fully electric Pegasus EVX. The company has already conducted extensive research into both the manufacturing and marketing of this new vehicle and has developed the following estimates: ● ● The company expects that, upon the commencement of production, this new project will have an 8-year life. If the project moves forward, a further $250 million investment in Property, Plant, & Equipment will be required immediately. This capital expenditure will be depreciated using the straight-line method to a salvage value of $0 over an 8-year depreciable life. If given the green light, it will take one year to finish preparing the manufacturing facility, install the new equipment, and hire and train employees. Production and deliveries will commence during year 2 and run for 8 total years. Though operations will not have commenced in Year 1, the company will begin to recognize any depreciation expense in Year 1. ● If given the green light, it will take one year to finish preparing the manufacturing facility, install the new equipment, and hire and train employees. Production and deliveries will commence during year 2 and run for 8 total years. Though operations will not have commenced in Year 1, the company will begin to recognize any depreciation expense in Year 1. The company expects to deliver 50,000 vehicles in the first year of production. The company expects the number of units delivered to increase by 25% in Year 2, 15% in year 3, with sales growth to fall by 5% each year thereafter for the remainder of the project's life. The company has estimated that the average selling price for the Pegasus will be $40,000 in its first year. The company estimates that after this, the average selling price will fall by 2% per year as competition increases and consumers are presented with increasing options in the electric vehicle market. The company expects gross margin to be 5% in the first year of production, 10% in Year 2, and 20% every year thereafter. Gross margin can be calculated as: Year of Vehicle Operations Deliveries 1 2 3 4 5 6 Gross Margin A summary of these baseline forecasts is provided below: 7 8 Some further assumptions: 50,000 62,500 71,875 79,063 = 83,016 83,016 78,865 70,979 Revenue - COGS Revenue YOY Delivery Average Growth Selling Price $ 40,000 25% $ 39,200 15% $ 38,416 10% $ 37,648 5% $ 36,895 $ 36,157 0% -5% $ 35,434 -10% $ 34,725 YOY Price Change -2% -2% -2% -2% -2% -2% -2% Average Gross Margin 5% 10% 20% 20% 20% 20% 20% 20% • The company expects operating expenses (SG&A) of $100 million per year, beginning in Year 1, and continuing for the life of the project. . In addition, the company expects an additional $100 million investment in Research & Development in Year 1 in order to finalize the design of the vehicle and its groundbreaking battery technology. After Year 1, the company expects R&D expenses of $25 million per year for the remainder of the project. • Furthermore, the company anticipates having to spend $40 million on marketing in Year 1, in advance of the launch of the Pegasus. Marketing expenses are expected to fall by 10% per year after Year 1. Some further assumptions: • The company expects operating expenses (SG&A) of $100 million per year, beginning in Year 1, and continuing for the life of the project. • In addition, the company expects an additional $100 million investment in Research & Development in Year 1 in order to finalize the design of the vehicle and its groundbreaking battery technology. After Year 1, the company expects R&D expenses of $25 million per year for the remainder of the project. • Furthermore, the company anticipates having to spend $40 million on marketing in Year 1, in advance of the launch of the Pegasus. Marketing expenses are expected to fall by 10% per year after Year 1. • Final assembly of the Pegasus will take place in the Pershing Assembly Building. MRA currently leases a portion of this building to a third party for $25 million annually. If the Pegasus project moves forward, this third party will need to relocate its operations immediately and will no longer lease the space from Year 1 onward. • Though the company is fully depreciating its equipment over 8 years, it has also estimated that it will likely be able to sell some of this equipment at the end of the project's life. You anticipate that the equipment could be sold for $60 million at the end of the project's life. • The company expects that the vast majority of its sales will be to new customers making the transition from traditional, gas-powered vehicles. However, they also expect that some sales of the Pegasus will be to customers who may have been planning on purchasing other MRA vehicles, such as their hybrid SUV launched last year. The company has determined that 10% of its annual Pegasus sales will fall into this category. Other vehicles manufactured by MRA have an average selling price of $35,000 and are produced at an average gross margin of 20%. • For accounting purposes, except for any investment in CapEx, which will be recognized immediately (T=0), all revenues, expenses, and cash flows will be recognized at the end of the year during which they take place. • An additional investment in inventory will need to be made in Year 1 in the amount of $50 million. This inventory will be maintained for the duration of the project's life and will be drawn down to $0 upon the termination of the project. Deliverable You are to prepare an incremental earnings and free cash flow forecast based on these assumptions. Middle Rive Automotive uses a cost of capital of 12% when evaluating new projects. Its marginal corporate tax rate is 21%. When completing your incremental FCF forecast and answering the following questions, please provide all dollar amounts in thousands of $USD. Meaning, for example, that if a certain raw value of $100 million, it would be represented in your spreadsheet as $100,000 (in effect, 100,000 thousand dollars). In addition to providing an incremental free cash flow forecast, please answer the following questions: 1. What is the NPV of this project using the base-case assumptions presented above? 2. Based on input from the marketing department, MRA has concerns about the uncertainty In addition to providing an incremental free cash flow forecast, please answer the following questions: 1. What is the NPV of this project using the base-case assumptions presented above? 2. Based on input from the marketing department, MRA has concerns about the uncertainty surrounding the first year's sales figures. Holding all other assumptions constant, including YOY sales growth estimates, what is the NPV of the Pegasus project if first year sales are 10% greater than anticipated? What is the NPV if first year sales fall 10% short of our base- case estimates? What is the NPV break-even level of first year sales? 3. In order to meet sales growth, MRA is aware that it may need to lower the price of the Pegasus in order to incentivize customers to choose their product over a competitor's. Management is fairly confident that it will be able to achieve the $40,000 average selling price forecast for year 1 of operations. However, they would like you to take a look at how the project's value is impacted if they need to be more aggressive in pricing the Pegasus beyond Year 1. What is the NPV of the Pegasus project if, after Year 1, the average selling price falls by 4% per year, instead of the 2% per year drop incorporated into our base-case assumptions. What is the NPV break-even level of YoY drop in average selling price beyond Year 1. Again, hold all other assumptions constant. 4. MRA anticipates gross margin to increase from 5% in Year 1 of production to 20% by Year 3 of production due to efficiency gains in production processes as well as lower production costs. However, there is some concern that these estimates are too optimistic. Holding our gross margin estimates constant in the first 2 years of operations, what is the NPV break-even level of gross margin that must be achieved by Year 3 of operations and maintained for the remainder of the project's life. 5. In order to incentivize investment in "green" industry, the government has made additions to the corporate tax code that it hopes will encourage investment in these types of companies. Recently-passed legislation allows investments in electric vehicle production to utilize and benefit from an accelerated depreciation schedule. This legislation allows 50% of the cost of any capex investment to be depreciated in its first year (Year 1). The remaining 50% will depreciated evenly over the original assumed depreciab life. What is the NPV of the Pegasus project using these updated depreciation assumptions? Despite this recently passed tax legislation, MRA still plans on using straight-line depreciation for all of its accounting. Which depreciation method should you utilize in your FCF and NPV analysis? 6. What is the IRR of this project? Provide your answer to 1 decimal place (0.1%). Company Background Middle River Automotive, LLC (MRA) is a company that was established in 2017 with the goal of designing, developing, manufacturing, and selling both hybrid and fully electric cars and light trucks. The company's corporate and design headquarters are in Baltimore, MD. In 2018, the company acquired several decommissioned assembly plants in nearby Middle River, MD, previously owned by Martin Marietta, Corp., an aerospace manufacturing company later acquired by Lockheed Martin. MRA has spent the past 18 months renovating and updating these facilities in anticipation of using them to manufacture electric vehicles. The cost of these renovations thus far has been approximately $1 billion. Scenario It is 2021 and MRA management is currently evaluating a proposal to move forward with plans to manufacture its first light pickup truck, the fully electric Pegasus EVX. The company has already conducted extensive research into both the manufacturing and marketing of this new vehicle and has developed the following estimates: ● ● The company expects that, upon the commencement of production, this new project will have an 8-year life. If the project moves forward, a further $250 million investment in Property, Plant, & Equipment will be required immediately. This capital expenditure will be depreciated using the straight-line method to a salvage value of $0 over an 8-year depreciable life. If given the green light, it will take one year to finish preparing the manufacturing facility, install the new equipment, and hire and train employees. Production and deliveries will commence during year 2 and run for 8 total years. Though operations will not have commenced in Year 1, the company will begin to recognize any depreciation expense in Year 1. ● If given the green light, it will take one year to finish preparing the manufacturing facility, install the new equipment, and hire and train employees. Production and deliveries will commence during year 2 and run for 8 total years. Though operations will not have commenced in Year 1, the company will begin to recognize any depreciation expense in Year 1. The company expects to deliver 50,000 vehicles in the first year of production. The company expects the number of units delivered to increase by 25% in Year 2, 15% in year 3, with sales growth to fall by 5% each year thereafter for the remainder of the project's life. The company has estimated that the average selling price for the Pegasus will be $40,000 in its first year. The company estimates that after this, the average selling price will fall by 2% per year as competition increases and consumers are presented with increasing options in the electric vehicle market. The company expects gross margin to be 5% in the first year of production, 10% in Year 2, and 20% every year thereafter. Gross margin can be calculated as: Year of Vehicle Operations Deliveries 1 2 3 4 5 6 Gross Margin A summary of these baseline forecasts is provided below: 7 8 Some further assumptions: 50,000 62,500 71,875 79,063 = 83,016 83,016 78,865 70,979 Revenue - COGS Revenue YOY Delivery Average Growth Selling Price $ 40,000 25% $ 39,200 15% $ 38,416 10% $ 37,648 5% $ 36,895 $ 36,157 0% -5% $ 35,434 -10% $ 34,725 YOY Price Change -2% -2% -2% -2% -2% -2% -2% Average Gross Margin 5% 10% 20% 20% 20% 20% 20% 20% • The company expects operating expenses (SG&A) of $100 million per year, beginning in Year 1, and continuing for the life of the project. . In addition, the company expects an additional $100 million investment in Research & Development in Year 1 in order to finalize the design of the vehicle and its groundbreaking battery technology. After Year 1, the company expects R&D expenses of $25 million per year for the remainder of the project. • Furthermore, the company anticipates having to spend $40 million on marketing in Year 1, in advance of the launch of the Pegasus. Marketing expenses are expected to fall by 10% per year after Year 1. Some further assumptions: • The company expects operating expenses (SG&A) of $100 million per year, beginning in Year 1, and continuing for the life of the project. • In addition, the company expects an additional $100 million investment in Research & Development in Year 1 in order to finalize the design of the vehicle and its groundbreaking battery technology. After Year 1, the company expects R&D expenses of $25 million per year for the remainder of the project. • Furthermore, the company anticipates having to spend $40 million on marketing in Year 1, in advance of the launch of the Pegasus. Marketing expenses are expected to fall by 10% per year after Year 1. • Final assembly of the Pegasus will take place in the Pershing Assembly Building. MRA currently leases a portion of this building to a third party for $25 million annually. If the Pegasus project moves forward, this third party will need to relocate its operations immediately and will no longer lease the space from Year 1 onward. • Though the company is fully depreciating its equipment over 8 years, it has also estimated that it will likely be able to sell some of this equipment at the end of the project's life. You anticipate that the equipment could be sold for $60 million at the end of the project's life. • The company expects that the vast majority of its sales will be to new customers making the transition from traditional, gas-powered vehicles. However, they also expect that some sales of the Pegasus will be to customers who may have been planning on purchasing other MRA vehicles, such as their hybrid SUV launched last year. The company has determined that 10% of its annual Pegasus sales will fall into this category. Other vehicles manufactured by MRA have an average selling price of $35,000 and are produced at an average gross margin of 20%. • For accounting purposes, except for any investment in CapEx, which will be recognized immediately (T=0), all revenues, expenses, and cash flows will be recognized at the end of the year during which they take place. • An additional investment in inventory will need to be made in Year 1 in the amount of $50 million. This inventory will be maintained for the duration of the project's life and will be drawn down to $0 upon the termination of the project. Deliverable You are to prepare an incremental earnings and free cash flow forecast based on these assumptions. Middle Rive Automotive uses a cost of capital of 12% when evaluating new projects. Its marginal corporate tax rate is 21%. When completing your incremental FCF forecast and answering the following questions, please provide all dollar amounts in thousands of $USD. Meaning, for example, that if a certain raw value of $100 million, it would be represented in your spreadsheet as $100,000 (in effect, 100,000 thousand dollars). In addition to providing an incremental free cash flow forecast, please answer the following questions: 1. What is the NPV of this project using the base-case assumptions presented above? 2. Based on input from the marketing department, MRA has concerns about the uncertainty In addition to providing an incremental free cash flow forecast, please answer the following questions: 1. What is the NPV of this project using the base-case assumptions presented above? 2. Based on input from the marketing department, MRA has concerns about the uncertainty surrounding the first year's sales figures. Holding all other assumptions constant, including YOY sales growth estimates, what is the NPV of the Pegasus project if first year sales are 10% greater than anticipated? What is the NPV if first year sales fall 10% short of our base- case estimates? What is the NPV break-even level of first year sales? 3. In order to meet sales growth, MRA is aware that it may need to lower the price of the Pegasus in order to incentivize customers to choose their product over a competitor's. Management is fairly confident that it will be able to achieve the $40,000 average selling price forecast for year 1 of operations. However, they would like you to take a look at how the project's value is impacted if they need to be more aggressive in pricing the Pegasus beyond Year 1. What is the NPV of the Pegasus project if, after Year 1, the average selling price falls by 4% per year, instead of the 2% per year drop incorporated into our base-case assumptions. What is the NPV break-even level of YoY drop in average selling price beyond Year 1. Again, hold all other assumptions constant. 4. MRA anticipates gross margin to increase from 5% in Year 1 of production to 20% by Year 3 of production due to efficiency gains in production processes as well as lower production costs. However, there is some concern that these estimates are too optimistic. Holding our gross margin estimates constant in the first 2 years of operations, what is the NPV break-even level of gross margin that must be achieved by Year 3 of operations and maintained for the remainder of the project's life. 5. In order to incentivize investment in "green" industry, the government has made additions to the corporate tax code that it hopes will encourage investment in these types of companies. Recently-passed legislation allows investments in electric vehicle production to utilize and benefit from an accelerated depreciation schedule. This legislation allows 50% of the cost of any capex investment to be depreciated in its first year (Year 1). The remaining 50% will depreciated evenly over the original assumed depreciab life. What is the NPV of the Pegasus project using these updated depreciation assumptions? Despite this recently passed tax legislation, MRA still plans on using straight-line depreciation for all of its accounting. Which depreciation method should you utilize in your FCF and NPV analysis? 6. What is the IRR of this project? Provide your answer to 1 decimal place (0.1%).
Expert Answer:
Answer rating: 100% (QA)
ANSWER 1 What is the NPV of this project using the basecase assumptions presented above The NPV of this project is 9435856 2 Based on input from the marketing department MRA has concerns about the unc... View the full answer
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
A major airport has been redesigned, with the goal of reducing flight delays. The delays (in minutes) for random samples of flights before and after the upgrade are available in MyStatLab. Create...
-
A major airport has been redesigned with the goal of reducing flight delays. The delays (in minutes) for random samples of flights before and after the upgrade are recorded. Is there evidence, at the...
-
Hoskins & Sells is a partnership that was established in March 20X6. If a partner decides to leave the partnership, the value of her or his partnership share will be determined by the net book value...
-
In April 2016, Vanessa bought 100 shares in Entagon plc at a cost of 5 per share. The company went into liquidation and Vanessa received a first distribution of 40p per share in July 2020. The shares...
-
Below is selected information from Tripe Corp: Which of the following is correct concerning changes at Tripe Corp. from Year 1 to Year 2? RNOA ROCE A) Increased Increased B) Increased Decreased C)...
-
Developing an organizational chart is an important task for business strategists. Organizational charts must be regularly evaluated and modified to accommodate current market conditions and...
-
Eco-efficiency provides necessary but not sufficient indicators of environmental performance. What is environmental performance? Provide an example of another type of information that is important...
-
Lemontree Rentals, Inc.'s, unadjusted and adusted trial balances at june 30, 2016, follow. Requirements 1. Make the adjusting entries that account for the differences between the two trial balances....
-
4. The position of a point on a line is given by the equation s(t) = t - 6t + 9t - 4, where s is measured in metres and t in seconds. (2 marks each) a. What is the velocity of the point after 2...
-
The most recent financial statements for Crosby, Incorporated, follow. Interest expense will remain constant, the tax rate and the dividend payout rate will also remain constant. Costs, other...
-
High and Low Cultural Context: Scenario: "There are two students and each wants to confront his or her instructor about a grade. One student is located in the United States and the other student is...
-
Of all cancer cases around the world in 2012, 13% had lung cancer, 11.9% had breast cancer, 9.7% had colorectal cancer, 7.9% had prostate cancer, 6.8% had stomach cancer, and 50.7% had other types of...
-
What sources of capital do you have? Are you willing to take on a home equity loan? Use your personal credit cards? How much of a nest egg do you need to feel comfortable pursuing a new venture?
-
What fiduciary duty do you have with your current employer? Does your proposed new venture rely on proprietary information belonging to your previous employer? Are you materially interfering with...
-
What social problems are of particular interest to you?
-
Who are your entrepreneurial role models? Can you foster any of them into mentors?
-
Using one of the queries you created in BITS from previous assignments, create a report. You will need to use a different font, include a logo; ensure that your report "looks good" (using appropriate...
-
Refer to the information from Exercise 22-19. Use the information to determine the (1) Weighted average contribution margin , (2) Break-even point in units, and (3) Number of units of each product...
-
The auditors of Letron Inc. have set an overall materiality level of $900,000 and a performance materiality level of $800,000 for the current year audit, 20X2. They used the same materiality levels...
-
Taylor, a PA, has been engaged to audit the financial statements of University Books Incorporated. University Books maintains a large, revolving cash fund exclusively for the purpose of buying used...
-
What is a practice inspection, and what roles does it play in the quality control self-regulation of the profession?
-
What is thermodynamics?
-
Explain the scope and limitations of thermodynamics.
-
An astronaut weighs \(800 \mathrm{~N}\) on the earth's surface where the acceleration of gravity is \(g=9.83 \mathrm{~m} / \mathrm{s}^{2}\). The mass and the radius of the moon are \(7.4 \times...
Study smarter with the SolutionInn App