Question: please help my homework. my initial amount: 2019 deposits per month: 202 annual percentage rage: %9 you are free to define currency How much will
please help my homework. my initial amount: 2019 deposits per month: 202 annual percentage rage: %9 you are free to define currency How much will the account grow if it earns at APR per year compounded yearly (15 pts), quarterly (15 pts), monthly (15 pts), weekly (20 pts)? if is it possible, can you create an excel word file? Problem #1: (35 pts) The effective ANNUAL rate can be found using the EFFECT function in Excel *=EFFECT(nominal_rate, npery) where npery is the number of compounding periods per year. Please create the Excel table in Figure 5.2 at page 67. (each column from C to His 7 points) And PV 110000 1000 51000 510000 10000 Compouding tegung of compounding you April 5.000.0000 50000360000 60000 Home per periode penger period 6000 6000 6000 Every EFFECT G-00003613645 100% EN EFFECT6433) FM 11000 1100101111061690FVICTRICHO N of compounding on in a Ending are lunghe owner berada 510.000 310016785107351001851 BOSCREE.CO Figure 52. Finding Future Value for Various Compounding Frequencies Problem #2: (65 pts) Suppose that you want to open a saving account in a private bank and deposit "some" equal amounts PER MONTH FOR A YEAR. BY USING YOUR STUDENT ID, please state 1-initial amount, 2-deposits per month and 3-number of interest periods and 4- interest rate per month with respect to following rules: 1. Initial amount is the last 4-digits of your student ID [You are free to define the currency) 2. Deposits per month is the second 3-digits of your student ID (Assume the same currency with initial amount) 3. APR is the last digit of your student ID of your student ID ends with zero, please assume arbitrarily any positive value between 1-10 for your APR)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
