What function returns the total present value of an investment with a fixed rate
|
The Present Value (PV) is an estimation of how much a future cash flow (or stream of cash flows) is worth right now. All future cash flows must be discounted to the present using an appropriate rate that reflects the expected rate of return (and risk profile) because of the “time value of money.” Show
 Table of Contents
How to Calculate Present Value (Step-by-Step)The present value (PV) concept is fundamental to corporate finance and valuation. The premise of the present value theory is based on the “time value of money”, which states that a dollar today is worth more than a dollar received in the future. Therefore, receiving cash today is preferable (and more valuable) than receiving the same amount at some point in the future. There are two primary reasons that support this theory:
How Cost of Capital Impacts Present Value (Discount Rate vs. PV)Since money received on the present date carries more value than the equivalent amount in the future, future cash flows must be discounted to the current date when thought about in “present terms.” Moreover, the size of the discount applied is contingent on the opportunity cost of capital (i.e. comparison to other investments with similar risk/return profiles). All future receipts of cash (and payments) are adjusted by a discount rate, with the post-reduction amount representing the present value (PV). Given a higher discount rate, the implied present value will be lower (and vice versa).
When estimating the intrinsic value of an asset, namely via the discounted cash flow (DCF) method, how much a company is worth is equal to the sum of the present value of all of the future free cash flows (FCFs) the company is expected to generate in the future. More specifically, the intrinsic value of a company is a function of its ability to generate future cash flows and the risk profile of the cash flows, i.e. the company’s value is equal to the sum of the discounted values of its future free cash flows (FCFs). Present Value Formula (PV)The present value (PV) formula discounts the future value (FV) of a cash flow received in the future to the estimated amount it would be worth today given its specific risk profile. The formula used to calculate the present value (PV) divides the future value of a future cash flow by one plus the discount rate raised to the number of periods, as shown below. Present Value (PV) = FV / (1 + r) ^ n Where:
PV of Loan Calculation Example in Simple TermsLet’s say you loaned a friend $10,000 and are attempting to determine how much to charge in interest. If your friend has promised to repay the entire borrowed amount in five years, how much is the $10,000 worth on the date the borrowed funds are returned? Assuming that the discount rate is 5.0% – the expected rate of return on comparable investments – the $10,000 in five years would be worth $7,835 today.
Present Value vs. Future Value: What is the Difference?The present value (PV) calculates how much a future cash flow is worth today, whereas the future value is how much a current cash flow will be worth on a future date based on a growth rate assumption. While the present value is used to determine how much interest (i.e. the rate of return) is needed to earn a sufficient return in the future, the future value is usually used to project the value of an investment in the future.
Present Value Calculator (PV) – Excel Model TemplateWe’ll now move to a modeling exercise, which you can access by filling out the form below. Submit Email provided Your Download is Ready Step 1. Simple Cash Flow AssumptionsSuppose we are calculating the present value (PV) of a future cash flow (FV) of $10,000. We’ll assume a discount rate of 12.0%, a time frame of 2 years, and a compounding frequency of one.
Step 2. PV of Future Cash Flows Calculation AnalysisUsing those assumptions, we arrive at a PV of $7,972 for the $10,000 future cash flow in two years.
Thus, the $10,000 cash flow in two years is worth $7,972 on the present date, with the downward adjustment attributable to the time value of money (TVM) concept. Step 3. Discounted Cash Flow (DCF) Exercise AssumptionsIn the next part, we’ll discount five years of free cash flows (FCFs). Starting off, the cash flow in Year 1 is $1,000, and the growth rate assumptions are shown below, along with the forecasted amounts.
Step 4. DCF Implied Valuation Analysis (Using “PV” Excel Function)If we assume a discount rate of 6.5%, the discounted FCFs can be calculated using the “PV” Excel function.
The sum of all the discounted FCFs amounts to $4,800, which is how much this five-year stream of cash flows is worth today. What function returns the total present value?Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when you borrow money, the loan amount is the present value to the lender.
What is NPV & IRR?What Are NPV and IRR? Net present value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. By contrast, the internal rate of return (IRR) is a calculation used to estimate the profitability of potential investments.
What is ROI formula?The most common is net income divided by the total cost of the investment, or ROI = Net income / Cost of investment x 100.
What does IRR stand for?The internal rate of return (IRR) is a metric used in financial analysis to estimate the profitability of potential investments. IRR is a discount rate that makes the net present value (NPV) of all cash flows equal to zero in a discounted cash flow analysis. IRR calculations rely on the same formula as NPV does.
|
