You own a local delivery business. You have done well over time, but you have older equipment. Your delivery truck is paid off, but it has been averaging $$5,000$ in expenses $($between gas, repairs, etc.$)$ each month. Your brother is a mechanic, and he says he can keep it running and you don't need a new truck. Currently, that truck is responsible for $$15,000$ of REVENUE per month,

However, you want to buy a new truck. You have found a truck that you like that costs $$220,000.$ You estimate that your new truck will reduce monthly gas and repair expenditures to $$2,000.$ You also believe that due to the new truck being in the shop less, your new REVENUE would be $$16,000$ per month.

You can get a loan for the truck at $7\%$ interest ANNUAL percentage rate. It requires a $10,000$ down payment in month $1.$ Use the $=$PMT function to determine the monthly payment. Ensure that you are properly accounting for the interest rate and the number of periods.

Use the Excel file provided to build a model that includes all of this information.

Calculate the Monthly income under each scenario, the incremental difference in the investment per month, and over time, and the NPV of each choice $($truck$/$no truck$).$