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.

Spotless Car Wash is considering a new project whose data are shown

\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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!