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 Model for Bank
1,373
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
1,670
2
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
1,859
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,187
55
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)
1,337
108
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…
Ratio Analysis of Financial Statement (Auto Calculation)
2,327
109
Ratio analysis is the comparison of line items in the financial statements of a business. Ratio analysis is used to…
See All