This assignment has three parts. Submit them in a spreadsheet. Part 1: Create

    0

    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.

    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. 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.

                                                                                                                                      Order Now