PLEASE ANSWER IN EXCEL FUNCTIONS USING THE EXCEL SPREADSHEETS, FOR EXAMPLE =SUM(A1:A3)
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & HOME & & INS & ERT & PAGE LAYOU & FORI & MULAS & DA & & REVIEW & VIEW & & & Sign I & a \\ \hline & & Arial & & & =1 & 12AA & & % & & 1711 & & & & ab & & \\ \hline & ard & B & I & U. & \begin{tabular}{l} Font \\ Font \end{tabular} & & Alignment & Number & \begin{tabular}{l} Con \\ Form \end{tabular} & \begin{tabular}{l} ditional \\ atting \end{tabular} & \begin{tabular}{l} Format as \\ Table - S \\ Styles \end{tabular} & \begin{tabular}{l} Cell \\ Styles \end{tabular} & Cells & Editing & & ^ \\ \hline C3 & & & v & & x & fx & The Sloan C & Corporatio & on is & rying tc & o choose be & betwee & the foll & wing tw & utually & v \\ \hline 4 & A & B & & & c & & & D & E & & F & G & H & I & J & \\ \hline 1 & & & & & & & & & & & & & & & & \\ \hline 2 & & & & & & & & & & & & & & & & \\ \hline 3 & & & \begin{tabular}{l} The \\ des \\ pro \end{tabular} & \begin{tabular}{l} Slo \\ sign \\ ject? \end{tabular} & \begin{tabular}{l} an C \\ projec \\ Wha \end{tabular} & \begin{tabular}{l} orporation i \\ cts. If the re \\ at is the NP \end{tabular} & \begin{tabular}{l} is trying to \\ quired ret \\ V for each \end{tabular} & \begin{tabular}{l} choose \\ turn is 10 \\ project \end{tabular} & \begin{tabular}{l} bet \\ 0 pe \\ t? \end{tabular} & \begin{tabular}{l} Neen t \\ rcent, \end{tabular} & \begin{tabular}{l} the followi \\ what is th \end{tabular} & \begin{tabular}{l} wing t \\ the pro \end{tabular} & \begin{tabular}{l} o mut \\ itabilit \end{tabular} & \begin{tabular}{l} ally exc \\ index \end{tabular} & \begin{tabular}{l} ive \\ each \end{tabular} & \\ \hline 4 & & & & & & & & & & & & & & & & \\ \hline 5 & & & & & & & & & & & & & & & & \\ \hline 6 & & & Anr & nual & cash & flows: & & I & & & II & & & & & \\ \hline 7 & & & Yea & ar0 & & & $ & (51,000 & & $ & (14,400) & & & & & \\ \hline 8 & & & Yea & ar1 & & & $ & 24,800 & & $ & 7,800 & & & & & \\ \hline 9 & & & Yea & ar 2 & & & $ & 24,800 & & $ & 7,800 & & & & & \\ \hline 10 & & & Yea & ar 3 & & & $ & 24,800 & & $ & 7,800 & & & & & \\ \hline 11 & & & & & & & & & & & & & & & & \\ \hline 12 & & & Re & quire & d retc & urn & & & & & 10% & & & & & \\ \hline 13 & & & & & & & & & & & & & & & & \\ \hline 14 & & & & & & & & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l||} \hline 15 & \begin{tabular}{l} Complete the following analysis. Do not hard code values in your calculations. You \\ must use the built-in Excel function to answer this question. \end{tabular} \\ \hline 16 & Profitability index (I) \\ \hline 17 & Profitability index (II) \\ \hline 18 & & & \\ \hline 19 & NPV (I) & & \\ \hline 20 & NPV (II) & & \\ \hline 21 & & & & \\ \hline 22 & & & & \\ \hline 23 & & & & \\ \hline 24 & & & \\ \hline 25 & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & HOME & & INS & ERT & PAGE LAYOU & FORI & MULAS & DA & & REVIEW & VIEW & & & Sign I & a \\ \hline & & Arial & & & =1 & 12AA & & % & & 1711 & & & & ab & & \\ \hline & ard & B & I & U. & \begin{tabular}{l} Font \\ Font \end{tabular} & & Alignment & Number & \begin{tabular}{l} Con \\ Form \end{tabular} & \begin{tabular}{l} ditional \\ atting \end{tabular} & \begin{tabular}{l} Format as \\ Table - S \\ Styles \end{tabular} & \begin{tabular}{l} Cell \\ Styles \end{tabular} & Cells & Editing & & ^ \\ \hline C3 & & & v & & x & fx & The Sloan C & Corporatio & on is & rying tc & o choose be & betwee & the foll & wing tw & utually & v \\ \hline 4 & A & B & & & c & & & D & E & & F & G & H & I & J & \\ \hline 1 & & & & & & & & & & & & & & & & \\ \hline 2 & & & & & & & & & & & & & & & & \\ \hline 3 & & & \begin{tabular}{l} The \\ des \\ pro \end{tabular} & \begin{tabular}{l} Slo \\ sign \\ ject? \end{tabular} & \begin{tabular}{l} an C \\ projec \\ Wha \end{tabular} & \begin{tabular}{l} orporation i \\ cts. If the re \\ at is the NP \end{tabular} & \begin{tabular}{l} is trying to \\ quired ret \\ V for each \end{tabular} & \begin{tabular}{l} choose \\ turn is 10 \\ project \end{tabular} & \begin{tabular}{l} bet \\ 0 pe \\ t? \end{tabular} & \begin{tabular}{l} Neen t \\ rcent, \end{tabular} & \begin{tabular}{l} the followi \\ what is th \end{tabular} & \begin{tabular}{l} wing t \\ the pro \end{tabular} & \begin{tabular}{l} o mut \\ itabilit \end{tabular} & \begin{tabular}{l} ally exc \\ index \end{tabular} & \begin{tabular}{l} ive \\ each \end{tabular} & \\ \hline 4 & & & & & & & & & & & & & & & & \\ \hline 5 & & & & & & & & & & & & & & & & \\ \hline 6 & & & Anr & nual & cash & flows: & & I & & & II & & & & & \\ \hline 7 & & & Yea & ar0 & & & $ & (51,000 & & $ & (14,400) & & & & & \\ \hline 8 & & & Yea & ar1 & & & $ & 24,800 & & $ & 7,800 & & & & & \\ \hline 9 & & & Yea & ar 2 & & & $ & 24,800 & & $ & 7,800 & & & & & \\ \hline 10 & & & Yea & ar 3 & & & $ & 24,800 & & $ & 7,800 & & & & & \\ \hline 11 & & & & & & & & & & & & & & & & \\ \hline 12 & & & Re & quire & d retc & urn & & & & & 10% & & & & & \\ \hline 13 & & & & & & & & & & & & & & & & \\ \hline 14 & & & & & & & & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l||} \hline 15 & \begin{tabular}{l} Complete the following analysis. Do not hard code values in your calculations. You \\ must use the built-in Excel function to answer this question. \end{tabular} \\ \hline 16 & Profitability index (I) \\ \hline 17 & Profitability index (II) \\ \hline 18 & & & \\ \hline 19 & NPV (I) & & \\ \hline 20 & NPV (II) & & \\ \hline 21 & & & & \\ \hline 22 & & & & \\ \hline 23 & & & & \\ \hline 24 & & & \\ \hline 25 & & & & \\ \hline \end{tabular}
