Use the Excel Formula Coach to find the present value loan amount you can afford based on a set monthly payment. Excel provides a very useful formula to price bonds. PV 412 512 0 15000 Therefore if an investment has a stated annual interest rate of 4 compounded monthly and returns 15000 after 5 years the present value of the investment can be calculated as follows.
Use the Excel Formula Coach to find the present value loan amount you can afford based on a set monthly payment.
Rate required argument The interest rate per compounding period. Summary The Excel PV function is a financial function that returns the present value of an investment. PV 412 512 0 15000 which returns the result -1228505. PVrate nper pmt fv type.