2. The company is considering a project involving the purchase of hew equi he following: Use Exhibit 148-1 and Exhibit 148-2. (Use appropriate factor(s) from the B 1 Chapter 14: Applying Excel 2 3. Data Example E 310,000 Cost of equipment needed Working capital needed Overhaul of equipment in four years 5. 6. %24 20,000 %24 30,000 7. 35,000 Salvage value of the equipment in five years 9. Annual revenues and costs 415.000 10 Sales revenues 270,000 11 Cost of goods sold 55,000 12 Out-of-pocket operating costs 16 % 13 Discount rate a What is the net present value of the project? (Negative amount should be indicat Factor to 3 decimals and round all other intermediate calculations to nearest whol Net present value %24

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
2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match
the following: Use Exhibit 148-1 and Exhibit 148-2. (Use appropriate factor(s) from the tables provided.)
A
Chapter 14: Applying Excel
3.
Data
4.
Example E
5.
Cost of equipment needed
310,000
6.
Working capital needed
20,000
7.
Overhaul of equipment in four years
2$
30,000
8.
Salvage value of the equipment in five years
35,000
9.
Annual revenues and costs:
415.000
10
Sales revenues
270,000
11
Cost of goods sold
%24
55,000
12
Out-of-pocket operating costs
16 %
13 Discount rate
a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value
factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.)
Net present value
Transcribed Image Text:2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit 148-1 and Exhibit 148-2. (Use appropriate factor(s) from the tables provided.) A Chapter 14: Applying Excel 3. Data 4. Example E 5. Cost of equipment needed 310,000 6. Working capital needed 20,000 7. Overhaul of equipment in four years 2$ 30,000 8. Salvage value of the equipment in five years 35,000 9. Annual revenues and costs: 415.000 10 Sales revenues 270,000 11 Cost of goods sold %24 55,000 12 Out-of-pocket operating costs 16 % 13 Discount rate a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) Net present value
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 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
  • SEE MORE 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