I don’t know how make this formula in Excel somebody can help with this homework. Thank you!Part

I don’t know how make this formula in Excel somebody can help with this homework. Thank you!Part

I don’t know how make this formula in Excel somebody can help with this homework. Thank you!

Part

a)

The amount of annual investment can be calculated with the use of PMT (Payment) function/formula of EXCEL. The function/formula for PMT is PMT(Rate,Nper,PV,FV) where Rate = Interest Rate (here, Rate of Return on Mutual Funds), Nper = Period, PV = Present Value (if any) and FV = Future Value (here, Lump Sum Amount Desired at Retirement).

_____

Here, Rate = 10%, Nper = 65 – 23 = 42, PV = 0 and FV = \$2,000,000

Using these values in the above function/formula for PMT, we get,

Amount to be Invested Annually = PMT(10%,42,0,2000000) = \$3,719.98

Bella will have to invest an amount of \$3719.98 annually to achieve the desired lump sum amount of \$2,000,000.

_____

Part b)

Using the same PMT function/formula as specified in Part a) we can arrive at the amount of monthly investment.

Here, Rate = 10%/12, Nper = (65 – 23)*12 = 42*12 = 504, PV = 0 and FV = \$2,000,000

Using these values in the above function/formula for PMT, we get,

Amount to be Invested Monthly = PMT(10%/12,504,0,2000000) = \$258.25

Bella will have to invest an amount of \$258.25 on a monthly basis to achieve the desired lump sum amount of \$2,000,000.

Are you overwhelmed by your class schedule and need help completing this assignment? You deserve the best professional and plagiarism-free writing services. Allow us to take the weight off your shoulders by clicking this button.

Tutor_Charles

Rating: 4.9/5    Reviews 377

Success rate 97%

Completed projects: 545

I am an experienced writer offering professional services across diverse fields. I provide quality work with strict adherence to the deadline.

Tutor_Dr. Edith

Rating: 4.8/5    Reviews 381

Success rate 99%

Completed projects: 490

I am an experienced writer with great research and analytical skills. Original quality paper and on-time delivery are guaranteed. Let's do this!

Tutor_Dr.Judy

Rating: 4.7/5    Reviews 316

Success rate 99%

Completed projects: 398

I am a professional writer with more than 8 years of experience. My mission is to provide you with high-quality paper in a timely fashion.

Tutor_Ian

Rating: 4.8/5    Reviews 371

Success rate 98%

Completed projects: 432

Hi, I deliver quality papers on time following all the instructions provided. Client's satisfaction is my priority. Welcome for plagiarism-free papers.

Tutor_Prof. Allan

Rating: 4.8/5    Reviews 400

Success rate 98%

Completed projects: 487

With over half a decade of academic experience, I'm committed both to efficiency and punctuality. If it's quality you're looking for, then I'm here to provide!

Tutor_Prof. Gabie

Rating: 4.9/5    Reviews 447

Success rate 96%

Completed projects: 546

A quality-driven, skilled writer with over 5 years of experience in various disciplines. I deliver plagiarism-free papers and content of impeccable quality, always original and always before the deadline!

Tutor_Sarah

Rating: 4.9/5    Reviews 427

Success rate 99%

Completed projects: 567

I have been a full-time freelance researcher and writer for a period of over 6 years. I have successfully completed over 1000 projects and assignments. I have had a good professional relationship with my clients. Try me today!

Tutor_Stella

Rating: 4.9/5    Reviews 305

Success rate 97%

Completed projects: 404

I am a proficient writer with knowledge across a wide range of academic disciplines. I guarantee quality, timely and original content.

Tutor_SylviaYoung

Rating: /5    Reviews 419

Success rate 98%

Completed projects: 506

Hi, count on me to deliver quality and exemplary papers. I will pay attention to all your instructions, and meet all your expectations.