Using the estimates in Problem and repeated spreadsheet solution of the capital budgeting problem for budget limits

Question:

Using the estimates in Problem and repeated spreadsheet solution of the 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 is 12% per year, and up to $16,000 in capital investment funds areavailable.

MARR
Minimum Acceptable Rate of Return (MARR), or hurdle rate is the minimum rate of return on a project a manager or company is willing to accept before starting a project, given its risk and the opportunity cost of forgoing other... Capital Budgeting
Capital budgeting is a practice or method of analyzing investment decisions in capital expenditure, which is incurred at a point of time but benefits are yielded in future usually after one year or more, and incurred to obtain or improve the...