Question: In excel terms please!! (Use cells A6 to C17 from the given information to complete this question. You answer this question. The OCF must be

In excel terms please!!
(Use cells A6 to C17 from the given information to complete this question. You answer this question. The OCF must be calculated using the depreciation tax sl Output area: a. Depreciation per year Accounting break-even DOL b. Base OCF Base NPV OCF at new quantity NPV at new quantity DNPV/DQ Change in NPV for given quantity change c. OCF DOCF/DVC Change in NPV for given VC change \begin{tabular}{|r|} \hline$105,625 \\ \hline \\ \hline \\ \hline($845,000.00) \\ \hline$276,737.50 \\ \hline$276,737.50 \\ \hline($276,737.50) \\ \hline \end{tabular} (Use cells A6 to C17 from the given information to complete this question. You answer this question. The OCF must be calculated using the depreciation tax sl Output area: a. Depreciation per year Accounting break-even DOL b. Base OCF Base NPV OCF at new quantity NPV at new quantity DNPV/DQ Change in NPV for given quantity change c. OCF DOCF/DVC Change in NPV for given VC change \begin{tabular}{|r|} \hline$105,625 \\ \hline \\ \hline \\ \hline($845,000.00) \\ \hline$276,737.50 \\ \hline$276,737.50 \\ \hline($276,737.50) \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
