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 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.)? The internal rate of return is between and % d. Reset the discount rate to 14 %. 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
Net Present Value
Net present value is the most important concept of finance. It is used to evaluate the investment and financing decisions that involve cash flows occurring over multiple periods. The difference between the present value of cash inflow and cash outflow is termed as net present value (NPV). It is used for capital budgeting and investment planning. It is also used to compare similar investment alternatives.
Investment Decision
The term investment refers to allocating money with the intention of getting positive returns in the future period. For example, an asset would be acquired with the motive of generating income by selling the asset when there is a price increase.
Factors That Complicate Capital Investment Analysis
Capital investment analysis is a way of the budgeting process that companies and the government use to evaluate the profitability of the investment that has been done for the long term. This can include the evaluation of fixed assets such as machinery, equipment, etc.
Capital Budgeting
Capital budgeting is a decision-making process whereby long-term investments is evaluated and selected based on whether such investment is worth pursuing in future or not. It plays an important role in financial decision-making as it impacts the profitability of the business in the long term. The benefits of capital budgeting may be in the form of increased revenue or reduction in cost. The capital budgeting decisions include replacing or rebuilding of the fixed assets, addition of an asset. These long-term investment decisions involve a large number of funds and are irreversible because the market for the second-hand asset may be difficult to find and will have an effect over long-time spam. A right decision can yield favorable returns on the other hand a wrong decision may have an effect on the sustainability of the firm. Capital budgeting helps businesses to understand risks that are involved in undertaking capital investment. It also enables them to choose the option which generates the best return by applying the various capital budgeting techniques.
![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 14B-2. (Use appropriate factor(s) from the tables provided.)
Required information
The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14-8 in the
text.
1
2
3
Data
4 Example E
10
11
A
Chapter 14: Applying Excel
5 Cost of equipment needed
6
Working capital needed
7
Overhaul of equipment in four years
8
Salvage value of the equipment in five years
9
Annual revenues and costs:
12
13
Sales revenues
Cost of goods sold
Out-of-pocket operating costs
Discount rate
$
$
$
$
$
$
$
B
110,000
45,000
15,000
20,000
385,000
270,000
80,000
с
14 %](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F977a48e7-1063-4328-a6f9-e232b06958b3%2F422154ab-72f9-4282-a537-1b19b337ea63%2F9owzp6h_processed.jpeg&w=3840&q=75)
![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 14B-2. (Use appropriate factor(s) from the tables provided.)
Required information
The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14-8 in the
text.
1
2
3
Data
4 Example E
10
11
A
Chapter 14: Applying Excel
5 Cost of equipment needed
6
Working capital needed
7
Overhaul of equipment in four years
8
Salvage value of the equipment in five years
9
Annual revenues and costs:
12
13
Sales revenues
Cost of goods sold
Out-of-pocket operating costs
Discount rate
$
$
$
$
$
$
$
B
110,000
45,000
15,000
20,000
385,000
270,000
80,000
с
14 %](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F977a48e7-1063-4328-a6f9-e232b06958b3%2F422154ab-72f9-4282-a537-1b19b337ea63%2Fwka0e3i_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 5 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)