Work all the problems with a calculator (or spreadsheet) using the algebra equations and confirm your answer using the finance function available in your spreadsheet. Show your work for the algebra equation, the spreadsheet function confirmation is based on you printing out and including documentation that you did it. The answers from both methods should be equal (within a small rounding error). 1. Find the present value of $35,000 you expect to receive 20 years from now using a discount rate of 9%. Write out the formula and use the power key, check with the finance functions. Show Work Fromula Answer Spreadsheet fn A. Discounted yearly: B. Discounted quarterly: C. Discounted monthly: 2. You are considering an investment which pays you $180,000.00 seven years from now (nothing in between). Currently, similar risk investments are earning 7.5% compounded twice per year. What should you pay for the investment now? Show algebraic work, and confirm using the spreadsheet finance function