Overview

After the cash flow for each period is calculated, the present value (PV) of each one is achieved by discounting its future value (see Formula) at a periodic rate of return (the rate of return dictated by the market). NPV is the sum of all the discounted future cash flows.

 

Input:

Investment (Cost)

Discount Rate

Starting (Date of Invest)

Ending (Date of Invest)

Number fo Year

Once Input is fillup, it automatically calculates the NPV and IRR values.

Reviews Add a review
No reviews yet

More From MD. FAZLA RABBE SARDER

Browse our top rated business templates. See All
3 Statement Financial Model Analysis with an Interactive Dashboard
250
1
3 Statement Financial Model Analysis with an Interactive Dashboard: This excel model allows you to calculate Return on Common Equity…
3 Statement Model for Bank
2,157
1
A 3 statement model template connects the income statement, balance sheet, and cash flow statement into one dynamically linked financial model.
3 Statement for Bank and Financial Institution with Analysis
2,471
3
A 3 statement model template connects the Income statement, Balance sheet (Financial Position), and Cash flow statement into one dynamically…
Key Ratio Analysis with Financial Statement
2,694
164
Corporate finance ratios are quantitative measures that are used to assess businesses. These ratios are used by financial analysts, equity…
Installment Calculator (Annuity)
1,865
91
An annuity is a series of payments made at equal intervals. Examples of annuities are regular deposits to a savings account, monthly home mortgage payments, monthly insurance payments, and…
Amortization Schedule (Automatic)
2,106
165
An amortization calculator is used to determine the periodic payment amount due on a loan (typically a mortgage), based on the amortization process. The amortization repayment…
See All