Using the estimates in Problem and repeated spreadsheet solution of the capital budgeting problem for budget limits ranging from b = $5000 to b = $25,000, develop a spreadsheet chart that plots b versus the value of Z. Use the PW method to evaluate four independent projects. Select as many as three of the four projects. The MARR is 12% per year, and up to $16,000 in capital investment funds areavailable.

Project Investment, S-5000 Life, years -8,000 9,000 -10,000 Year NCF Estimates, $ per Year 1000 1700 2400 3000 3800 500 500 500 500 10,500 5000 5000 2000 17,000