You are considering buying a new SUV for your late-night beer delivery service. The SUV will cost $25,000, with a salvage value of $5,750 after five years. The vehicle will be used to travel 30,000 miles per year. You expect to have a yearly income of $100,000 based on the business plan. On average, the SUV yields 21 miles per gallon and fuel price is estimated at $0.65 per liter. Other O&M costs associated with the business total $40,000 per year including labor, repairs, insurance, etc. Your company’s MARR is 18%. Use a five year planning horizon.
Using the Data Table functionality in Excel construct a table that varies the value of the number of miles traveled per month from -100% to 100% in increments of 10% and print it out.