Question: Please use excel. Please use the format thats in the second photo, Same colors as well. Thank you This second photo is only a sample.

Please use excel. Please use excel. Please use the format thats in the second photo,

Same colors as well. Thank you This second photo is only a

Please use the format thats in the second photo, Same colors as well. Thank you

This second photo is only a sample.

just structure the answer the same way as the second photo

Date Assigned: Friday, February 22, 2019 Date Due: Wednesday, February 27, 2019 before class. No late homework will be accepted. . Please notice that all work must be shown in a professional way with attention to detail .No credit will be given for incomplete or disorderly work . Please use a cover letter stating your name, course number, date due, and homework number .Unstapled homework will not be collected as this is part of the assignment .All work must be individual with emphasis on numerical accuracy as shown in class 1. Exercise One: Suppose you want to start your own business in 10 years, and you plan to invest $3,600 quarterly in an interest bearing account with an annual interest rate of 3.85% to reach that goal. Given this aforementioned investment strategy, (a) how much money will you have then? (b) If you decide to reinvest your funds at maturity for an additional 4 years, under monthly compounding, and an annual interest rate of 2.25%. How much money will you have at the end of the reinvestment process? 2. Exercise Two: As part of saving for your daughter's future college expenses strategy you plan to save $2,500 quarterly in an interest bearing account with an annual interest rate of 4.75%. If you anticipate her to start college 16 years from today, (a) how much money will you have then? (b) Suppose she receives a full scholarship, if you decide to reinvest your funds at maturity for an additional 4 years (for her younger brother's college education expenses), under monthly compounding and an annual interest rate of 3.25%. How much money will you have at the end of the reinvestment process? 3. Exercise Three: As part of your early retirement planning, you plan to save $2,500 monthly in an interest bearing account with an annual interest rate of 3.75%. (a) If you plan to retire in 30 years, how much money will you have then for retirement? (b) If you decide to reinvest your funds at maturity for an additional 4 years, under daily compounding, and an annual interest rate of 2.25%. How much money will you have at the end of the reinvestment process? Problem I Present Value of an Annuity Payment Time Annual Interest Rate Payment Frequency Periodic Intcest Rat Total Number of Payments 18620 PV(Annuity) PV functiern 18,620.134 Payment Time Annual Interest Rate Payment Frequency Porok Interest Rate Total Number of Payments PV (Annuity) PV function 37,627.19 Problem 2 Present Value of an Annuity Time Payment Frequency Periodis Intcest Rate Total Number of Payments PV (Annuity) PV function 17.069 084.032 uture Value of an Annuity Payment Time Annual Intereat Rate Payment Frequency Total Numbf Payments FV 01 Source Problem4 Future Value of an Ainuity Payment Tine Ansual Interest Kate Payment Frequency Periodis Inst Rat Total Numler of Payment FV $1,088,74 Source

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!