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
471
0
A 3 statement model template connects the income statement, balance sheet, and cash flow statement into one dynamically linked financial model.
3 Statement for Banking and Financial Institution with Analysis
758
0
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
808
92
Corporate finance ratios are quantitative measures that are used to assess businesses. These ratios are used by financial analysts, equity…
Installment Calculator (Annuity)
480
32
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)
507
55
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)
1,333
106
Ratio analysis is the comparison of line items in the financial statements of a business. Ratio analysis is used to…
See All