Question: please answer all begin{tabular}{|c|c|c|c|c|} hline 3 & A & & B & C hline 1 & Chapter 14: Applying Excel & & &



\begin{tabular}{|c|c|c|c|c|} \hline 3 & A & & B & C \\ \hline 1 & Chapter 14: Applying Excel & & & \\ \hline 2 & divis & & & \\ \hline 3 & Data & & & \\ \hline 4 & Example E & & & \\ \hline 5 & Cost of equipment needed & 5 & 350,000 & \\ \hline 6 & Working capital neoded & 5 & 60,000 & \\ \hline 7 & Overhaul of equipment in four years & 5 & 30.000 & \\ \hline 8 & Salvage value of the equipment in five years & 5 & 25,000 & \\ \hline 9 & Annual revenues and costs & E & & \\ \hline 10 & Sales revenues & 5 & 425,000 & \\ \hline 11 & Cont of goods sold & 5 & 235,000 & \\ \hline 12 & Out-of-pocket operating costs & 5 & 85.000 & \\ \hline 13 & Discount rate & & 13 & % \\ \hline \end{tabular} a. What is the net present value of the project? (Negotive amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate colculations to nearest whole dollar.) 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)? 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? Required information The Chapter 14 form worksheet is to be used to create your own worksheet version of Example E and Exhibit 148 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 Exhibit 148-1 and Exhibit 148-2 (Use oppropriote foctor(s) from the tables provided.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
