Present value calculations The present value or "PV function" in Excel is used to calculate the current value of future payments. Consider this example: Suppose your uncle sends you a $10,000 certificate of deposit in your name which will earn 4% interest for the investment period. Under the terms of his gift, you can withdraw the funds after 4 years on the day of your graduation. Use Excel functions to calculate the value of the amount your uncle deposited today to have $10,000 after you graduate. (Note: The certificate of deposit calculates and pays any earned interest at the beginning of each year.)
+3
Answers (1)
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Present value calculations The present value or "PV function" in Excel is used to calculate the current value of future payments. Consider ...” in 📘 Business if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.