How to make a vba for payback period from these case Cumulative Year Cash Flow Cash Flow

How to make a vba for payback period from these case

Transcribed Image Text:

Cumulative Year Cash Flow Cash Flow DF 12,00% PV NPV 50.677.130 IRR 15,20% 13,25% MIRR Payback Period Calculation Last Negative Cashflow Years Last Negative Cashflow Net Cashflow in Next Year Payback Period Year 4,21 Cumulative Year Cash Flow Cash Flow DF 12,00% PV NPV 50.677.130 IRR 15,20% 13,25% MIRR Payback Period Calculation Last Negative Cashflow Years Last Negative Cashflow Net Cashflow in Next Year Payback Period Year 4,21

Answer rating: 100% (QA)

To calculate the payback period using VBA Visual Basic for Applications in Excel you can follow thes... View the full answer