Question

please expaine

ars with an accumulated portfolio valus that must be invested at the end of each an annual rate of return of 6% 3. A man plans to retire in 35 years with a (a) Calculate the amount that must 35 years, assuming an annual n=35 EVA1500,000 PMT2 FVA 1) ed portfolio value of $1,500,000. the end of each year for the next i..ou [13460.8 (b) Apply the financial function command (with each numerical value reported in correct sequence) that would solve this problem. = PMT (.06. 35, 0,1500000) 4. A woman expects to receive $80,000 in 12 years. (a) Assuming an annual rate of return of 4.75%, compounded monthly, calculate the value of this investment now, FV: 80,000 80,000 con PV: n: 12 2 12.0475 (45292.9 (b) Apply the financial function command (with each in correct sequence) that would solve this pro ntil chion command (with each numerical value reported vould solve this problem. = Pv1.00396, 144, 0, 10000)

Answer 1

05 January 2019 Saturday. WK 01 (005-360) o solo 3 (a) future value of Annuit where funt de [.] fra = future value of Annuity A= Amount to be contributed 8= Rate of return a fool n= won af yrs. invested 15.09.800 - Ax 11.00)3517 1500 oso = A x 0.06 7.6861 - 1 0:06 9 A = $13460 8 (6) & Commond to be used in excel = PMT (rute, aper, Pv, FV) - PMI (0.06, 35, 0, 1500,oos) 4 (a) Po= fr (1+rgh 8 Pu= fu= = Present Value futuoe value Rate of interest montly 4075 lo 12. - Pu= 80,000 (1+0.003958) 194 0.003958 Pu- $45292. go = No. of years / Period z 12x12 - 144 (b) Command to be used in excel - pv (rate, nper, pont, fu) - pv (onow3958, 144,0, 801009) January VS M L T 1 2 3 20 14 15 16 17 27 28 29 30 31 F 4 18 2019 G C to U la h ạ 5 6 7 8 9 10 11 12 19 20 21 22 23 24