Complete the excel...zoom if necessary.
Table A Annual Operating costs for the Conway and Its Crew Wages Vacation and sickness benefits Social security payments Life insurance Commissary supplies Repairs and maintenance Fuel Miscellaneous service and supplies Total $110,200 1,880 2,400 1,800 15,420 24,400 34,500 12,550 $203,150 23 $115,000 CONWAY DATA Age in years Requires immediate rehabilitation If rehab, 20 more years of useful life Book value Market value of Conway if sold in 1950 Fair (book) value of spare parts Market value of spare parts Adjusted rehab cost with spare parts Dismantle/scrapping cost offset by value of parts Operating costs per year $39,500 $25,000 $43,500 $30,000 $71,500 0 $203,150 Table B Annual Operating costs for a Diesel-Powered Boat Wages for a 13-person crew Vacation and sickness benefits Social security payments Life insurance Commissary supplies Repairs and maintenance Fuel Miscellaneous service and supplies Total $ 77,300 1,320 1,680 1,170 10,020 21,700 28,800 14,650 $156,640 "Excluding possible major overhaul of diesel engines $325,000 $265,000 $75,000 25 DIESEL DATA Price Value of hull Basic parts inventory (enough for 3 boats) Useful life in years Scrap or rehab at cost of new boat Overhaul every 10 years Market value of hull at year 20 Book value of hull at year 20 Market value of parts at year 20 Book value of parts at year 20 Operating costs per year $60,000 $32,500 $53,000 $37,500 $15,000 $156,640 Replace the Conway with a dieselpowered boat or Rehab $115,000 NSV SP.(SP-BV'T NSV-Net Salvage Value SP Market value BV-Book value $39.500 CONWAY DATA Age in years Requires immediate rehabilitation If rehab, 20 more years of useful life Book value Market value of Conway if sold in 1950 Fair (book) value of spare parts Market value of spare parts Adjusted rehab cost with spare parts Dismantle/sorapping cost offset by value of Operating costs per year $25,000 $43.500 $30,000 $71,500 $203,150 $325.000 $265.000 $75,000 DIESEL DATA Price Value of hull Basic parts inventory enough for 3 boats) Useful life in years Scrap or rehabt cost of new boat Overhaul every 10 years Market value of hull year 20 Book value of hull year 20 Market value of parts at year 20 Book value of parts at year 20 Operating costs per year $80.000 $32.500 55.000 $37500 $15,000 $156,640 0 | 1 | 2 | 3 | 4 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 1 19 1 20 OPTION 2: REHAB THE CONWAY Rehabilitation cost Operating costs Depreciation of Conway Depreciation of Rehab Depreciation of spare parts Cash Flows TAX Add back depreciation Table A Annual Operating costs for the Conway and Its Crew Wages Vacation and sickness benefits Social security payments Life insurance Commissary supplies Repairs and maintenance Fuel Miscellaneous service and supplies Total $110,200 1,880 2,400 1,800 15,420 24,400 34,500 12,550 $203,150 23 $115,000 CONWAY DATA Age in years Requires immediate rehabilitation If rehab, 20 more years of useful life Book value Market value of Conway if sold in 1950 Fair (book) value of spare parts Market value of spare parts Adjusted rehab cost with spare parts Dismantle/scrapping cost offset by value of parts Operating costs per year $39,500 $25,000 $43,500 $30,000 $71,500 0 $203,150 Table B Annual Operating costs for a Diesel-Powered Boat Wages for a 13-person crew Vacation and sickness benefits Social security payments Life insurance Commissary supplies Repairs and maintenance Fuel Miscellaneous service and supplies Total $ 77,300 1,320 1,680 1,170 10,020 21,700 28,800 14,650 $156,640 "Excluding possible major overhaul of diesel engines $325,000 $265,000 $75,000 25 DIESEL DATA Price Value of hull Basic parts inventory (enough for 3 boats) Useful life in years Scrap or rehab at cost of new boat Overhaul every 10 years Market value of hull at year 20 Book value of hull at year 20 Market value of parts at year 20 Book value of parts at year 20 Operating costs per year $60,000 $32,500 $53,000 $37,500 $15,000 $156,640 Replace the Conway with a dieselpowered boat or Rehab $115,000 NSV SP.(SP-BV'T NSV-Net Salvage Value SP Market value BV-Book value $39.500 CONWAY DATA Age in years Requires immediate rehabilitation If rehab, 20 more years of useful life Book value Market value of Conway if sold in 1950 Fair (book) value of spare parts Market value of spare parts Adjusted rehab cost with spare parts Dismantle/sorapping cost offset by value of Operating costs per year $25,000 $43.500 $30,000 $71,500 $203,150 $325.000 $265.000 $75,000 DIESEL DATA Price Value of hull Basic parts inventory enough for 3 boats) Useful life in years Scrap or rehabt cost of new boat Overhaul every 10 years Market value of hull year 20 Book value of hull year 20 Market value of parts at year 20 Book value of parts at year 20 Operating costs per year $80.000 $32.500 55.000 $37500 $15,000 $156,640 0 | 1 | 2 | 3 | 4 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 1 19 1 20 OPTION 2: REHAB THE CONWAY Rehabilitation cost Operating costs Depreciation of Conway Depreciation of Rehab Depreciation of spare parts Cash Flows TAX Add back depreciation
