Cálculo do VPL, TIR, Lucratividade e Payback no Excel - Planilha Automatizada

In this video, you'll learn how to build an automated spreadsheet to calculate a project's financial indicators: Net Present Value (NPV), Internal Rate of Return (IRR), Profitability Rate, and Payback Period. This spreadsheet will work automatically! Therefore, if you change any parameter values, all indicators will be recalculated. Below are links to previous lessons: Net Present Value    • Valor Presente Líquido (VPL) - Teoria e Ex...   Internal Rate of Return (IRR) and Profitability Rate    • Taxa Interna de Retorno (TIR) e Índice de ...   Payback Period    • Tempo de Payback - Teoria + 2 Exemplos no ...   The file with the example data can be downloaded from the link below: http://aprendendogestao.com.br/wp-con...