NPV and IRR Calculator Modelo Essentials
Calculate net present value and internal rate of return for investment projects. Enter cash flows and a discount rate to evaluate potential investments.
O Que Está Incluído
- Dashboard with NPV and IRR results displaying the net present value, internal rate of return, and payback period
- Cash flow entry by period with columns for year, description, cash inflow, cash outflow, and net cash flow
- Discount rate input field that adjusts the NPV calculation to reflect your required rate of return on the investment
- Automatic NPV calculation using Excel NPV formula applied to the net cash flow series at the specified discount rate
- IRR computation with color-coded input cells (yellow) and auto-calculated investment evaluation metrics (blue)
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- Dashboard with NPV and IRR results displaying the net present value, internal rate of return, and payback period
- Cash flow entry by period with columns for year, description, cash inflow, cash outflow, and net cash flow
- Discount rate input field that adjusts the NPV calculation to reflect your required rate of return on the investment
- Automatic NPV calculation using Excel NPV formula applied to the net cash flow series at the specified discount rate
- Compare até 3 investimento projects lado a lado com independent fluxo de caixa projeções
- Cada project tem a dedicado aba com 15-ano fluxo de caixa tabela, discount factors, present valores, e acumulativo PV
- Painel com portfólio KPIs: melhor NPV, project count, total invested, e um resumo tabela com Accept/Reject decisions
- Comparação aba classificando todos projects by NPV, período de payback, e índice de rentabilidade
- Análise de sensibilidade mostrando NPV, índice de rentabilidade, e Accept/Reject at 9 different taxas de desconto por projeto
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha de NPV and IRR Calculator
Enter cash flows
List each period cash flow - the initial investment (negative) and subsequent inflows and outflows by year.
Set the discount rate
Enter your required rate of return or cost of capital. The NPV calculation uses this rate to discount future cash flows.
Review NPV
The dashboard shows the net present value. A positive NPV indicates the investment returns more than the required rate.
Check IRR
The internal rate of return shows the actual return rate implied by the cash flows. Compare it to your discount rate.
Criadas com Claude AI. Aperfeiçoadas por nós.
Usamos Claude AI para criar cada planilha, após uma pesquisa aprofundada. Depois, nossa equipe entra em ação. Refinamos o layout, testamos exaustivamente cada fórmula, corrigimos casos extremos e polimos o design até que pareça algo que nós mesmos usaríamos. A IA nos leva 80% do caminho. Os últimos 20% são puro julgamento humano.
Perguntas Frequentes
What does a positive NPV mean?
A positive NPV means the investment projected returns exceed your required rate of return. The higher the NPV, the more value the project adds.
How does IRR compare to the discount rate?
If IRR exceeds the discount rate, the investment clears your return threshold. If IRR is below the discount rate, the project does not meet your requirement.
What discount rate should I use?
Use your cost of capital, required return, or opportunity cost - the rate you could earn on an alternative investment of similar risk.
Can I enter monthly cash flows?
The template is set up for annual periods. For monthly cash flows, change the period labels and use a monthly discount rate (annual rate divided by 12).
Como abrir no Google Sheets?
Envie o arquivo .xlsx para o Google Drive e abra com o Google Sheets. Todas as fórmulas e formatações serão preservadas.
Mais modelos Essentials de Investing & Trading
Procurando planilhas premium?
Nossas planilhas pagas incluem painéis avançados com várias abas, gráficos nativos do Excel e atualizações contínuas.