Joe Schmoe, a Texas A&M graduate, was tasked with coding an VBA function with the following properties. The function: $*$ Is named Calc$\_$Rate $*$ Accepts three arguments and returns a rate $*$ The first argument stores an annual rate $($APR$)*$ The second argument stores a $\text{'}$m$\text{'}$ value to indicate compounding frequency $*$ The third argument stores an indicator $*$ The function computes then returns a rate based on the following logic: If the indicator is the letter E$,$ then the function should return the Effective Annual Rate $($EAR$)=(1+$ APR $/$ m$)^$ m $-1$ If the indicator is the letter P$,$ then the function should return the periodic rate $=$ APR $/$ m If the indicator is other than the letter E or P$,$ then the function should return the numeric error code $-9\mathrm{.}99\%$ HOWEVER, Joe has created the function code $($listed in column J but the code is NOT working correctly. Your tasks are: $1.$ Insert a module in the VBA editor. $2.$ Copy the code from column J $($J$3$:J$12)$ and paste into the code window in the module you just inserted in the VBA editor $3.$ In the VBA editor, correct the function code so that it executes without error AND completes the tasks as specified above. $4.$ Once the code is corrected, call the Calc$\_$Rate function from cell E$27$ and pass in the exam information in cells B$27,$ C$27,$ and D$27$ as relative cell arguments separated by commas. $5.$ Copy the function call from cell E$27$ to E$28$:E$296.$ Copy your subroutine code from the VBA editor and paste the code starting in cell B$32.7.$ Copy $($from the worksheet area starting in cell B$32)$ and paste into column G$,$ lines of code that match the description provided in column F$.$