Question: Spotless Car Wash is considering a new project whose data are shown below. The equipment to be used has a 3-year tax life, would be
Spotless Car Wash is considering a new project whose data are shown below. The equipment to be used has a 3-year tax life, would be depreciated on a straight-line basis over the project's 3-year life, and would have a zero salvage value after Year 3. No new working capital would be required. Revenues and other operating costs will be constant over the project's life, and this is just one of the firm's many projects, so any losses on it can be used to offset profits in other units. If the number of cars washed declines by 40% from the expected level, by how much would the project's NPV decline? PLEASE SHOW EXCEL FUNCTIONS SO I CAN LEARN.

\begin{tabular}{l|r} \hline WACC & 7.00% \\ \hline Net investment cost & $60,000 \\ \hline (depreciable basis) & \\ \hline Number of cars washed & 2,800 \\ \hline Average price per car & $25.00 \\ \hline Fixed op. cost (excl. deprec.) & $7,500 \\ \hline Variable op. cost/unit (i.e., VC & $5.500 \\ \hline per car washed) & \\ \hline Annual depreciation & $20,000 \\ \hline Tax rate & 30.00% \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
