A small business is buying a delivery van to serve a four-year contract. The inputs are in B1:B7 and the contract's cash flows in rows 20 to 24. Each answer goes in column B next to its question.
Keep the periods consistent: the loan and savings are monthly, the contract is yearly. Show payments and totals as positive numbers by putting a minus in the right place. Answers within half a cent count.