Madetaylor Inc. manufactures financial calculators. The company is deciding whether to introduce a new calculator. This calculator will sell for $140. The company feels that sales will be 18,000, 25,000, 24,000, 24,000, and 22,000 units annually for five years. Variable costs will be 20% of sales, and fixed costs are $500,000 annually. The firm hired a marketing team to analyze the product's viability, and the marketing analysis cost $500,000. The company plans to manufacture and store the calculators in a vacant warehouse. Based on a recent appraisal, the warehouse and the property are worth $4 million after tax. If the company does not sell the property today, it will sell it five years from today at the currently appraised value. This project will require an injection of net working capital at the onset of the project, $850,000. The firm recovers the net working capital at the end of the project. The firm must purchase equipment for $6,000,000 to produce the new calculators. The equipment has a 5-year life and is depreciated using the MACRS method (20%, 32%, 19.2%, 11.52%, 11.52%). At the end of the project, the anticipated salvage value is 0. Surprisingly the firm can sell the machine at the end of the project for $1,000,000. The firm requires a 7% return on its investment and has a tax rate of 21%.   A) Calculate the sunk cost of the project. (Enter a positive value and round to the nearest dollar)   B) Calculate the opportunity cost of the project. (Enter a positive value and round to the nearest dollar   C) Calculate the net working capital injection at the beginning of the project. (Enter a positive value and round to the nearest dollar)   D) Calculate the book value of the machine at the end of year 5. (Round to two decimals)   E) Calculate the depreciation expense at the end of year 2. (Round to two decimals)   Please answer in excel :)

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

Madetaylor Inc. manufactures financial calculators. The company is deciding whether to introduce a new calculator. This calculator will sell for $140. The company feels that sales will be 18,000, 25,000, 24,000, 24,000, and 22,000 units annually for five years. Variable costs will be 20% of sales, and fixed costs are $500,000 annually. The firm hired a marketing team to analyze the product's viability, and the marketing analysis cost $500,000. The company plans to manufacture and store the calculators in a vacant warehouse. Based on a recent appraisal, the warehouse and the property are worth $4 million after tax. If the company does not sell the property today, it will sell it five years from today at the currently appraised value. This project will require an injection of net working capital at the onset of the project, $850,000. The firm recovers the net working capital at the end of the project. The firm must purchase equipment for $6,000,000 to produce the new calculators. The equipment has a 5-year life and is depreciated using the MACRS method (20%, 32%, 19.2%, 11.52%, 11.52%). At the end of the project, the anticipated salvage value is 0. Surprisingly the firm can sell the machine at the end of the project for $1,000,000. The firm requires a 7% return on its investment and has a tax rate of 21%.

 

A) Calculate the sunk cost of the project. (Enter a positive value and round to the nearest dollar)

 

B) Calculate the opportunity cost of the project. (Enter a positive value and round to the nearest dollar

 

C) Calculate the net working capital injection at the beginning of the project. (Enter a positive value and round to the nearest dollar)

 

D) Calculate the book value of the machine at the end of year 5. (Round to two decimals)

 

E) Calculate the depreciation expense at the end of year 2. (Round to two decimals)

 

Please answer in excel :)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar 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