Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The consulting company Johnson Smith & King (JSK) is in that never-ending budgeting phase of the year. Realizing that they couldn' defer a technology update
The consulting company Johnson Smith \& King (JSK) is in that never-ending budgeting phase of the year. Realizing that they couldn' defer a technology update any longer, the managers plan to replace all of the computers in the office. The old computers will be sold for market value. When the new computers reach the end of their useful lives, they will be sold as well. The cost of the combined new computers and annual software updates should be more than covered by efficiency gains and increased volume of sales-at least that's what the managers are expecting. Information related to this investment is as follows. Calculate the NPV of this investment. (Round present value factor calculations to 5 decimal places, eg, 1.25124 and final answer to 2 decimal places eg. 5, 125.36. Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses eg. (45).) NPV \$ Based on this NPV amount, is the IRR higher or lower than 5% ? The IRR than 5% Attempts: 0 of 2 used Calculate the IRR for this investment. (Round answer to 2 decimal places, eg. 15.25\%.) Attempts: 0 of 2 used Determine the simple payback period using (1) before-tax cash flows and (2) after-tax cash flows. (Round answers to 2 decimal places, eg 15.25.) Determine the discounted payback period using after-tax cash flows. (Round present value factor calculations to 5 decimal places, eg. 125124 and final onower to 2 decimal placeseg. 5,125.36 ) Discounted payback period Attempts: 0 of 2 used Find the ARR. (Round answer to 1 decimal place, eg. 15.2\%.) Calculate the profitability index for this investment. (Round answer to 2 decimal places, e.g. 15.25.) Profitability index TABLE 7.1 Puture Valine of 1 (Fature Value of a Single Sum) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{14}{|c|}{ Future value of a single sum (FV)= Present value (1+R)N} \\ \hline (i) Periods & 2% & 2%% & 3% & 4% & 5% & 6% & 8% & 9% & 10% & 11% & 12% & 15% & (n) Periods \\ \hline 1 & 1.02000 & 1.02500 & 1.08000 & 1.04000 & 1.05000 & 1.06000 & 1.08000 & 1.09000 & 1.10000 & 1.11000 & 1.12000 & 1,15000 & 1 \\ \hline 2 & 1.04040 & 1.05063 & 1.06090 & 1.08160 & 1.10250 & 1.12360 & 1.16640 & 1.18810 & 1.21000 & 1.23210 & 1.25440 & 1.32250 & 2 \\ \hline 3 & 1.06121 & 1.07689 & 1.09279 & 1.12486 & 1.15763 & 1.19102 & 1.25971 & 1.29503 & 1.33100 & 1.36763 & 1.40493 & 1.52088 & 3 \\ \hline 4 & 1.08248 & 1.10381 & 1.12551 & 1.16986 & 1.21551 & 1.26248 & 1.36049 & 1,41158 & 1,46410 & 1.51807 & 1.57352 & L.74901 & 4 \\ \hline 3 & 1.10408 & 1.13141 & 1.15927 & 1.21665 & 1.27628 & 1.33823 & 1.46933 & 1.53862 & 1.61051 & 1.68506 & 1.76234 & 201136 & 5 \\ \hline 6 & 1.12616 & 1.15969 & 1.19405 & 1.26532 & 1.34010 & 1.41852 & 1.58687 & 1.67710 & 1.77156 & 1.87041 & 1.97382 & 2.31306 & 6 \\ \hline 7 & 1.14869 & 1.18869 & 1.22987 & 1.31593 & 1.40710 & 1.50363 & 1.71382 & 1.82804 & 1.94872 & 2.07616 & 2.21068 & 2.66002 & 7 \\ \hline 8 & 1.17166 & 1.21840 & 1.26677 & 1.36857 & 1.47746 & 1.59385 & 1.85093 & 1.99256 & 2.14359 & 2.30454 & 2.47596 & 3.05902 & 8 \\ \hline 9 & 1.19509 & 1.24886 & 1.30477 & 1.42331 & 1.55133 & 1.68948 & 1.99900 & 2.17189 & 2.35795 & 2.55803 & 2.77308 & 3.51788 & 9 \\ \hline 10 & 1.21899 & 1.28008 & 1.34392 & 1.48024 & 1.62889 & 1.79085 & 2.15892 & 2.36736 & 2.59374 & 2.83942 & 3.10585 & 4.04556 & 10 \\ \hline Hi. & 1.24557 & 1.31209 & 1.38423 & 1.53945 & 1.71034 & 1.89830 & 2.33164 & 2.58043 & 2.85312 & 3.15176 & 3.47855 & 4.65239 & 11 \\ \hline 12 & 1.26824 & 1.34489 & 1.42576 & 1.60103 & 1.79586 & 2.01220 & 2.51817 & 2.81267 & 3.13843 & 3.49845 & 3.89598 & 5.35025 & 12 \\ \hline 13 & 1.29361 & 1.37851 & 1.46853 & 1. 66507 & 1.88565 & 2.13293 & 2.71962 & 3.06581 & 3.45227 & 3.88328 & 4.36349 & 6.15279 & 13 \\ \hline 14 & 1.31948 & 1.41297 & 1.51259 & 1.73168 & 1.97993 & 2.26090 & 2,93719 & 3.34173 & 3.79750 & 4.31044 & 4.88711 & 7.07571 & 14 \\ \hline 15 & 1.34587 & 1.44830 & 1.55797 & 1.80094 & 2.07893 & 2.39656 & 3.17217 & 3.64248 & 4.17725 & 4.78459 & 5.47357 & 8.13706 & 15 \\ \hline 16 & 1.37279 & 1.48451 & 1.60471 & 1.87298 & 2.18287 & 2.54035 & 3.42594 & 3.97031 & 4.59497 & 5.31089 & 6.13039 & 9.35762 & 16 \\ \hline 17 & 1,40024 & 1.52162 & 1.65285 & 1.94790 & 2.29202 & 2.69277 & 3.70002 & 4.32763 & 5.05447 & 5.89509 & 6.86604 & 10.76126 & 17 \\ \hline \end{tabular} (PV)=nvNFuturevalue
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started