Consider the investment decision in Exercise 14.48. What qualitative factors might be critical to evaluating this decision? If the lowest-cost alternative is $70,000 and if the discount rate is 8 percent, what monetary value of the qualitative factors would make the project financially viable? 0°09 SHbTdz ISBAL BUILD YOUR OWN SPREADSHEET. Build an Excel spreadsheet to comp\te a discount rate of 10 percent per year for each requirement.

Required Present value of $(6,000) now Present value of $2,500 one year from now Present value of $3,000 two years from now a

c

e. Present value of $2,000 four years from now A Ver”

f. Net present value of (a)—

(e) using the SUM function porte g. Net present value of (a)—

(e) using the NPV function Ze b

d. Present value of $2,500 three years from now h. Internal rate of return of (a)—

(e) using the IRR function