+1 (347) 474-1028 info@essayparlour.com

Create a spreadsheet table that… Show more This assignment

Paper help Economics Create a spreadsheet table that… Show more This assignment

Economics

Create a spreadsheet table that… Show more This assignment

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

Order Now

Ready to try a high quality writing service? Get a discount here