Sure, here are the steps to calculate the present value of the annuity using a financial calculator or Excel:
1. For a financial calculator:
- Input N = 15 (total number of payments)
- Input I/Y = 7 (annual interest rate)
- Input PMT = -500 (negative because it's an outflow)
- Press the PV button to calculate the present value, which should be $3,717
2. For Excel:
- Use the following formula: =PV(7%, 15, -500)
- The result should be $3,717
I hope this helps!