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.) (1,734) c. The internal rate of return is between what two whole discount rates (e.g. between 10% and 11%, between 11% and 12%, between 12% and 13%, between 13% and 14%, etc.)? Net present value The internal rate of return is between and d. Reset the discount rate to 18%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minimum salvage value required to generate a positive present value

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
icon
Concept explainers
Topic Video
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 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.)
A
1 Chapter 14: Applying Excel
2
3
Data
4 Example E
5
6 Working capital needed
7 Overhaul of equipment in four years
8
009
10
11
12
13
Cost of equipment needed
Salvage value of the equipment in five years
Annual revenues and costs:
Sales revenues
Cost of goods sold
Out-of-pocket operating costs
Discount rate
Net present value
S
The internal rate of ratum is between
$
$
and
$
$
$
$
$
B
310,000
50,000
25,000
30,000
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.)
(1.734)
c. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12 %, between 12%
and 13%, between 13% and 14%, etc.)?
435,000
265,000
с
70,000
18 %
d. Reset the discount rate to 18 % . Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a
positive net present value?
Minimum salvage value required to generate a positive 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 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) A 1 Chapter 14: Applying Excel 2 3 Data 4 Example E 5 6 Working capital needed 7 Overhaul of equipment in four years 8 009 10 11 12 13 Cost of equipment needed Salvage value of the equipment in five years Annual revenues and costs: Sales revenues Cost of goods sold Out-of-pocket operating costs Discount rate Net present value S The internal rate of ratum is between $ $ and $ $ $ $ $ B 310,000 50,000 25,000 30,000 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.) (1.734) c. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12 %, between 12% and 13%, between 13% and 14%, etc.)? 435,000 265,000 с 70,000 18 % d. Reset the discount rate to 18 % . Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minimum salvage value required to generate a positive present value
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 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