Find the following values for a lump sum assuming annual compounding: (can you provide formulas for Excel?)
The present value of $500 invested at 8 percent for five years assuming quarterly compounding
The future value of $500 invested at 8 percent for five years assuming quarterly compounding
What is the effective annual rate (EAR) if the stated rate is 8 percent and compounding occurs semiannually? Quarterly?