Create a spreadshe

EBK CFIN
6th Edition
ISBN:9781337671743
Author:BESLEY
Publisher:BESLEY
Chapter10: Project Cash Flows And Risk
Section: Chapter Questions
Problem 4PROB
icon
Related questions
Question

Damon Corporation, a sports equipment manufacturer, has a machine currently in use that was originally purchased 3 years ago for $120,000.

The firm depreciates the machine under MACRS using a 5-year recovery period. Once removal and cleanup costs are taken into consideration, the expected net selling price for the present machine will be $70,000.

Damon can buy a new machine for a net price of $160,000 (including installation costs of $15,000).

The proposed machine will be depreciated under MACRS using a 5-year recovery period. If the firm acquires the new machine, its working capital needs will change—accounts receivable will increase $15,000, inventory will increase $19,000, and accounts payable will increase $16,000. Earnings before depreciation, interest, and taxes (EBDIT) for the present machine are expected to be $95,000 for each of the successive 5 years.

For the proposed machine, the expected EBDIT for each of the next 5 years are $105,000, $110,000, $120,000, $120,000, and $120,000, respectively. The corporate tax rate (T) for the firm is 40%. (Table 4.2 on page 117 contains the applicable MACRS depreciation percentages.)

 Damon expects to be able to liquidate the proposed machine at the end of its 5-year usable life for $24,000 (after paying removal and cleanup costs).

The present machine is expected to net $8,000 upon liquidation at the end of the same period. Damon expects to recover its net working capital investment upon termination of the project. The firm is subject to a tax rate of 40%.

TO DO Create a spreadsheet similar to Tables 11.1, 11.5, 11.7, and 11.9 to answer the following:

  1. Create a spreadsheet to calculate the terminal cash flow associated with the project.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
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
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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning