Create a spreadsheet table that… Show more This assignment has three parts. Submit them in a spreadsheet. Part 1: Create a spreadsheet table that shows for a particular Compounding Frequency and Annual Percentage Rates (APRs) for 12% to 1%, the corresponding Periodic Interest Rate (PIR) and Effective Annual Rate (EAR). Use the format as shown below. A manual change in the Compounding Frequency in the box above the table should cause the PIR and EAR columns in the table to automatically change for all of the APRs of 12% to 1%. Compounding Frequency ? Times Per year APR PIR EAR 12% 11% 10% 9% 8% 7% 6% 5% 4% 3% 2% 1% Part 2: Create a second spreadsheet table that shows for a particular APR and the Compounding Frequencies shown in the table below, the PIR and EAR. Use the format as shown below. A change in the APR in the box above the table should automatically change the PIR and EAR values in the table below it. APR ? Compounding Frequency PIR EAR 1 4 12 52 Part 3: Create a third spreadsheet table that shows for a particular EAR and the Compounding Frequencies in the table, the corresponding PIRs and APRs. Use the format as shown below. A change in the EAR in the box above the table should automatically change the PIR and APR values in the table below it. EAR Compounding Frequency PIR APR 1 4 12 52 Grading for Assignment 3 will be performed by substituting several numbers for the boxes above each table. Therefore the values that you submit for Compounding Frequency in Part 1, APR in Part 2, and the EAR Part 3 can be any value you choose. If you want, enter compounding frequency of 2 for part 1, APR of 6% for part 2 and EAR of 8% for part 3, but understand that the three tables should automatically update for any values. The primary purpose of this assignment is to gain insight into the relationships between the number of compounding periods, PIRs, APRs and EARs. Note that if you are using Excel 2003, the Nominal and Effect functions may not be available to you. The equivalent equations are in this week%u2019s content. Either functions or equations are acceptable. • Show less