Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please complete the excel portion Obj. 3, 4 The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer
please complete the excel portion
Obj. 3, 4 The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $490,000. The estimated net cash flows from each project are as follows: The committee has selected a rate of 12% for purposes of net present value analysis. It also estimates that the residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's residual value would be $180,000. 1. For each project, compute the net present value. Use the present value of an annuity table appearing in Exhibit 5 of this chapter. Ignore the unequal lives of the projects. Answer: Check Figure: Servers, $11,105 2. For each project, compute the net present value, assuming that the office expansion is adjusted to a four-year life for purposes of analysis. Use the present value table appearing in Exhibit 2 of this chapter. 3. 2 Prepare a report to the investment committee, providing your advice on the relative merits of the two projects. Net Present Value Analysis Office Expansion: Annual net cash flow (at the end of each of 6 years) Present value of an annuity of $1 at 12% for 6 yoars (Exh. 5) Present value of annual net cash flows Amount to be invested Net present value Server Uparade: Annual net cash flow (at the end of each of 4 years) Present value of an annuly of $1 at 12% for 4 years (Exh. 5) Present value of annual net cash flows Amount to be invested Net present value Net Present Value Analysis Present Value of Net Cash Flow Year 1 Year 2 Year 3 Year 4 Year 4 (resid. valuo) \begin{tabular}{l} Present \\ Value of \\ 51 at 12% \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Total \begin{tabular}{|c|} \hline \multicolumn{1}{|c|}{ Net C. } \\ \hline OthiceExparsion \\ \hline$125,000 \\ \hline 125,000 \\ \hline 125,000 \\ \hline 125,000 \\ \hline \end{tabular} \begin{tabular}{|r|} \multicolumn{2}{|c|}{ServerUpgrade} \\ \hline$165,000 \\ \hline 165,000 \\ \hline 165,000 \\ \hline 165,000 \\ \hline \end{tabular} Amount to bo invested Net present value \begin{tabular}{|} \hline OtficeExpansion \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{2}{|c|}{ServerUpgrade} \\ \hline$7.500 \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} [Key essay answer here] Pr, 26(12)-5A 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