O 1 2 Initial Step Van Models investment GMC Utilimaster Freightliner D D 5 GMC $ 54,257 Morgan Olson $ 79,730 3 Requirements 1 $ 62,756 $ 48,135 SSSS A B Salvage value (A) 10,000 5,000 5,000 10,000 Cash (B) Revenues expenses 52,500 36,000 45,000 75,000 31,500 21,600 27,000 45,000 (D) Depreciation 52,756 43,135 49,257 69,730 Initial investment Under 50,000 50.000 co900 (E)Operating income Salvage value: The controller has determined that the salvage values are: Initial investment Over 60,000 Salvage value 10,000 5,000 Under 60,000 Write a conditional IF statement to calculate the salvage value of each vehicle. (Hint: Write the IF statement for the first vehicle, then copy and paste to the remaining vehicles.) Revenues are higher for the more expenive trucks, as they are larger. Calculate revenues as follows: 21,000 14,400 18,000 30,000 Customers/year 12,000 15.900 (F) Taxes Income after tax (G) Average sale/customer 3.00 21,000 (H) Depreciation shield Revenue 36,000 (1) After tax cash flow

Write a conditional If statement to calculate the solvage value of each vehicle. (Hintt Write the if statement for the first vehicle, then com and paste to the remaining vehicles.) Aevenues are higher for the more expenive trucks, as they are larget. Cakulate revenues as followw