Question: Solve this problem using Excel and submit the Excel spreadsheet via Canvas. An aircraft hangar requires a new high-efficiency HVAC system for environmental control and

Solve this problem using Excel and submit the Excel spreadsheet via Canvas. An aircraft hangar requires a new high-efficiency HVAC system for environmental control and reducing heating and cooling expenses. Three alternative HVAC systems are available as follows: Capital Investment Annual Expenses Annual Savings Useful Life = Residual Value = Company's MARR = HVAC-1 $6,000,000 $80,000 $600,000 20 HVAC-2 $6,500,000 $60,000 $650,000 25 HVAC-3 $5,500,000 $40,000 $550,000 18 0 0 0 15% Using a cost-only present worth analysis recommend which HVAC system should be purchased and state your reason. (Note: You don't need to show the annual cash flow in the spreadsheet)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
