This assignment has three parts. Submit them in a spreadsheet. Part 1: Create a
ID: 1185060 • Letter: T
Question
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.
Explanation / Answer
VVKGupta can you email the excel file with the answer?
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.