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%

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter11: Depreciation, Depletion, Impairment, And Disposal
Section: Chapter Questions
Problem 5C: The following two statements concern depreciation: 1. Because our plant was shut down for part of...
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
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning