Thomson Media is considering some new equipment whose data are shown below. The equipment has a 3-year tax life and would be fully depreciated by the straight-line method over 3 years, but it would have a positive pre-tax salvage value at the end of Year 3, when the project would be closed down. Also, some new working capital would be required, but it would be recovered at the end of the project's life. Revenues and other operating costs are expected to be constant over the project's 3-year life. What is the project's NPV? WACC Net investment in fixed assets (depreciable basis) Required new working capital Straight-line deprec. rate Sales revenues, each year Operating costs (excl. deprec.), each year Expected pretax salvage value Tax rate 10.0% $70,000 $10,000 33.333% $75,000 $30,000 $5,000 35.0%

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

Ef 336.

Thomson Media is considering some new equipment whose data are shown below. The equipment has a 3-year tax life and would be
fully depreciated by the straight-line method over 3 years, but it would have a positive pre-tax salvage value at the end of Year 3, when
the project would be closed down. Also, some new working capital would be required, but it would be recovered at the end of the
project's life. Revenues and other operating costs are expected to be constant over the project's 3-year life.
What is the project's NPV?
WACC
Net investment in fixed assets (depreciable basis)
Required new working capital
Straight-line deprec. rate
Sales revenues, each year
Operating costs (excl. deprec.), each year
Expected pretax salvage value
Tax rate
10.0%
$70,000
$10,000
33.333%
$75,000
$30,000
$5,000
35.0%
Please solve using Excel and please show the formulas in excel. Thank you.
Transcribed Image Text:Thomson Media is considering some new equipment whose data are shown below. The equipment has a 3-year tax life and would be fully depreciated by the straight-line method over 3 years, but it would have a positive pre-tax salvage value at the end of Year 3, when the project would be closed down. Also, some new working capital would be required, but it would be recovered at the end of the project's life. Revenues and other operating costs are expected to be constant over the project's 3-year life. What is the project's NPV? WACC Net investment in fixed assets (depreciable basis) Required new working capital Straight-line deprec. rate Sales revenues, each year Operating costs (excl. deprec.), each year Expected pretax salvage value Tax rate 10.0% $70,000 $10,000 33.333% $75,000 $30,000 $5,000 35.0% Please solve using Excel and please show the formulas in excel. Thank you.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

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