Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what is the answer to part D? show all work EXHIBIT 14-8 The Net Present Value Method-An Extended Example Do-aert sull-2 Prosent Velve of en

what is the answer to part D? show all work image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
EXHIBIT 14-8 The Net Present Value Method-An Extended Example Do-aert sull-2 Prosent Velve of en Annulty of 31 in Ansers 21[10+21] a What is the net present value of the project? (Negotive omount should be indicated by o minus sign. Round your present volue foctor to 3 decimals and round all other intermediate calculations to nearest whole dollor.) Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example Eand Exhibat 14:-8 in the 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 Exhiba 148-1 and Exhibit 148-2 (Use oppropriate foctor(s) from the tables provided.) \begin{tabular}{|c|c|c|c|c|} \hline & A = & \multicolumn{2}{|c|}{BB} & C \\ \hline 1 & Chapter 14: Applying Excel & & & \\ \hline 2 & & & & \\ \hline 3 & Data & & & \\ \hline 4 & Example E & & & \\ \hline 5 & Cost of equipment needed & $ & 350,000 & \\ \hline 6 & Working capital needed & $ & 60,000 & \\ \hline 7 & Overhaul of equipment in four years & $ & 30,000 & \\ \hline 8 & Salvage value of the equipment in five years & $ & 25,000 & \\ \hline 9 & Annual revenues and costs: & & & \\ \hline 10 & Sales revenues & $ & 425,000 & \\ \hline 11 & Cost of goods sold & $ & 235,000 & \\ \hline 12 & Out-of-pocket operating costs & $ & 85,000 & \\ \hline 13 & Discount rate & & 13 & % \\ \hline \end{tabular} 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)? d. Reset the discount rate to 13%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

What is negotiation? What are its characteristics?

Answered: 1 week ago