DUB company is considering a new 3-year expansion project that requires an initial fixed asset investment of $2.29 million. The fixed asset falls into the 3-year MACRS class. The project is estimated to generate $1,810,000 in annual sales, with costs of $700,000. The project requires an initial investment in net working capital of $450,000, and the fixed asset will have a market value of $480,000 at the end of the project. a. If the tax rate is 25 percent, what is the project’s Year 0 net cash flow? Year 1? Year 2? Year 3? (Do not round intermediate calculations) b. If the required return is 12%, what is the projects NPV? Please use excel and show equations.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter10: Capital Budgeting: Decision Criteria And Real Option
Section10.A: Mutually Exclusive Investments Having Unequal Lives
Problem 2P
icon
Related questions
icon
Concept explainers
Topic Video
Question

DUB company is considering a new 3-year expansion project that requires an initial fixed asset investment of $2.29 million. The fixed asset falls into the 3-year MACRS class. The project is estimated to generate $1,810,000 in annual sales, with costs of $700,000. The project requires an initial investment in net working capital of $450,000, and the fixed asset will have a market value of $480,000 at the end of the project.

a. If the tax rate is 25 percent, what is the project’s Year 0 net cash flow? Year 1? Year 2? Year 3? (Do not round intermediate calculations)

b. If the required return is 12%, what is the projects NPV?

Please use excel and show equations.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning