You are setting up the shown ONE-WAY data table to calculate the NPV of a hotel project at various rates of return (8.25% to 12.5%). What range would you highlight before selecting: Data What-if Analysis Data Table

Question 51 options:

	B15:C32
	C14:C32
	B14:B32
	B14:C32

Discount Rate 10.5% Rate \begin{tabular}{rlr} & $ & 358 \\ \hline 8.25% & $ & 29,826 \\ \hline 8.50% & $ & 26,357 \\ 8.75% & $ & 22,939 \\ \hline 9.00% & $ & 19,570 \\ \hline 9.25% & $ & 16,251 \\ \hline 9.50% & $ & 12,979 \\ \hline 9.75% & $ & 9,755 \\ \hline 10.00% & $ & 6,577 \\ \hline 10.25% & $ & 3,445 \\ \hline 10.50% & $ & 358 \\ \hline 10.75% & $ & (2,685) \\ \hline 11.00% & $ & (5,685) \\ \hline 11.25% & $ & (8,643) \\ \hline 11.50% & $ & (11,559) \\ \hline 11.75% & $ & (14,433) \\ \hline 12.00% & $ & (17,267) \\ \hline 12.25% & $ & (20,062) \\ \hline 12.50% & $ & (22,817) \end{tabular}