should be equal. You should submit your excel file that provides solutions and explanations. 1. Find the present value of $40,000 you expect to receive 20 years from now using an annual discount rate of 6.5%. Write out the formula and use the power key, check with the finance functions. Show Work Formula Answer Spreadsheet fn A. Discounted yearly: B. Discounted quarterly: C. Discounted monthly