Data: Cost of new equipment Expected life of equipment in years Salvage Value Life Production Annual production or purchase needs Number of workers needed Annual hours to be worked per employee Earnings per hour for employees Health Benefits - % of Wages Cost of Direct Materials Variable Manufacturing Overhead Costs Unit Cost to Purchase Batteries Required rate of return Таx rate Make Purchase Cost to Produce Annual cost of direct material: Need - Cost direct material for of 3,000 Batteries Annual cost of direct labor for new employees: Wages Health benefits Total wages and benefits Other variable production costs Total annual production costs Annual Cost to Purchase Batteries Part 1 Cash Flows Over the Life of the Project Before Tax Тах After Tax Item Annual cash savings Tax savings due to depreciation Amount Effect Amount Total after-tax annual cash flow Part 2 Payback Period years

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
100%

Elon Motors produces electric automobiles. In recent years, they have been making all components of the cars, excluding the batteries for each vehicle. The company's leadership team has been considering the ways to reduce the cost of producing its cars. They have considered various options and believe that they could reduce the cost of each car if they produce the car batteries instead of purchasing them from their current vendor, Avari Battery Company.

Currently, the cost of each battery is $325 per unit. The company feels that they could greatly reduce the cost if the production team makes each battery. However, to produce these batteries, the company will need to purchase specialized equipment that costs $1,570,000. However, this equipment will have a useful life of 12 years and is expected to have a salvage value of $70,000 at the end of that time.

Currently, the company purchases 3,000 batteries per year, and the company expects that the production will remain the same for the coming 12-year period. To make the batteries, the company expects that they will need to purchase direct materials at a cost of $125 per battery produced. In addition, the company will need to employ three production workers to make the batteries. The workers likely work 2,080 hours per year and make $25 per hour. In addition, health benefits will amount to 20% of the workers' annual wages. In addition, variable manufacturing overhead costs are estimated to be $25 per unit.

Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted. The company's cost of capital (hurdle rate) has been determined to be 10% for all new projects, and the current tax rate of 30% is anticipated to remain unchanged. The pricing for the company's products as well as number of units sold will not be affected by this decision. The straight-line depreciation method would be used if the new equipment is purchased.

Part 3 Accounting Rate of Return
Accounting income as result of decreased costs
Annual cash savings
Less depreciation
Before tax income
Tax at Current Rate
After tax income
Accounting Rate of Return
Part 4 Net Present Value
Before Tax
After Tax
PV
Present
Item
Year
Amount
Tax %
Amount
Factor
Value
Cost of machine
Annual cash savings
Tax savings due to depreciation
Disposal value
1-12
1-12
12
Net Present Value
Part 5 Internal Rate of Return and Modified Internal Rate of Return
After Tax
Item
Year
Amount
Cost of machine
Year 1 inflow
Year 2 inflow
Year 3 inflow
Year 4 inflow
Year 5 inflow
5
Year 6 7nflow
6
Year 7 inflow
7
Year 8 inflow
8
Year 9 inflow
9
Year 10 inflow
10
Year 11 inflow
11
Year 12 inflow
12
Internal Rate of Return
Modified Internal Rate of Return
Net Present Value
012 34
Transcribed Image Text:Part 3 Accounting Rate of Return Accounting income as result of decreased costs Annual cash savings Less depreciation Before tax income Tax at Current Rate After tax income Accounting Rate of Return Part 4 Net Present Value Before Tax After Tax PV Present Item Year Amount Tax % Amount Factor Value Cost of machine Annual cash savings Tax savings due to depreciation Disposal value 1-12 1-12 12 Net Present Value Part 5 Internal Rate of Return and Modified Internal Rate of Return After Tax Item Year Amount Cost of machine Year 1 inflow Year 2 inflow Year 3 inflow Year 4 inflow Year 5 inflow 5 Year 6 7nflow 6 Year 7 inflow 7 Year 8 inflow 8 Year 9 inflow 9 Year 10 inflow 10 Year 11 inflow 11 Year 12 inflow 12 Internal Rate of Return Modified Internal Rate of Return Net Present Value 012 34
Data:
Cost of new equipment
Expected life of equipment in years
Salvage Value
Life Production
Annual production or purchase needs
Number of workers needed
Annual hours to be worked per employee
Earnings per hour for employees
Health Benefits - % of Wages
Cost of Direct Materials
Variable Manufacturing Overhead Costs
Unit Cost to Purchase Batteries
Required rate of return
Таx rate
Make
Purchase
Cost to Produce
Annual cost of direct material:
Need - Cost direct material for of 3,000 Batteries
Annual cost of direct labor for new employees:
Wages
Health benefits
Total wages and benefits
Other variable production costs
Total annual production costs
Annual Cost to Purchase Batteries
Part 1 Cash Flows Over the Life of the Project
Before Tax
Таx
After Tax
Item
Amount
Effect
Amount
Annual cash savings
Tax savings due to depreciation
Total after-tax annual cash flow
Part 2 Payback Period
years
Transcribed Image Text:Data: Cost of new equipment Expected life of equipment in years Salvage Value Life Production Annual production or purchase needs Number of workers needed Annual hours to be worked per employee Earnings per hour for employees Health Benefits - % of Wages Cost of Direct Materials Variable Manufacturing Overhead Costs Unit Cost to Purchase Batteries Required rate of return Таx rate Make Purchase Cost to Produce Annual cost of direct material: Need - Cost direct material for of 3,000 Batteries Annual cost of direct labor for new employees: Wages Health benefits Total wages and benefits Other variable production costs Total annual production costs Annual Cost to Purchase Batteries Part 1 Cash Flows Over the Life of the Project Before Tax Таx After Tax Item Amount Effect Amount Annual cash savings Tax savings due to depreciation Total after-tax annual cash flow Part 2 Payback Period years
Expert Solution
Step 1

Note: This post has several subparts. The first three viz.

  • the cost to produce
  • cash flows over the life of the project
  • payback period

have been computed below.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 7 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education