Question

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 5.5%. The study period needs to be exactly 8 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years.Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).

Fig: 1