Using Excel

For the second part of the Exam, develop an Excel spreadsheet with clearly marked sections to answer each of the following questions using the appropriate formula's, and submit your spreadsheet clearly identified regarding who it is coming from as file submission for this Exam. Calculation question 1. (5) Assume you have 100,000 right now invested at 7.2% annual interest. 1) Program in the rule of 72 approximation formula to reveal approximately what will it be worth 30 years from now, then 2) program in the appropriate precise finance formula to reveal exactly what it will be worth 30 years from now. Calculation question 2. (6) Assume you just received an inheritance of $150,000, and would like to invest it for your retirement 40 years from now. You have found an investment that will earn a return equivalent to 9% annual rate compounded monthly. Ignoring taxes, etc, how much will you have at the end of 40 years