Question: IMPORTANT NOTE - THIS IS NOT A MINDTAP BASED PROJECT. YOU WILL BE SUBMITTING YOUR PROJECT DOCUMENTS IN THE ASSESSMENTS>ASSIGNMENTS AREA OF D2L BRIGHTSPACE AND

 IMPORTANT NOTE - THIS IS NOT A MINDTAP BASED PROJECT. YOU

WILL BE SUBMITTING YOUR PROJECT DOCUMENTS IN THE ASSESSMENTS>ASSIGNMENTS AREA OF D2L

IMPORTANT NOTE - THIS IS NOT A MINDTAP BASED PROJECT. YOU WILL BE SUBMITTING YOUR PROJECT DOCUMENTS IN THE ASSESSMENTS>ASSIGNMENTS AREA OF D2L BRIGHTSPACE AND DESCRIBED BELOW. Jacob and Sophia's dream for their recently born daughter, Emily, is that one day she will attend their alma mater, Purdue University. For the next 18 years, they plan to make a monthly deposit into a 529 College Savings Plan at a local bank. The account pays 5.25% annual interest, compounded monthly. Create a worksheet for Jacob and Sophia that uses a financial function to show the future value (FV) of their investment and a formula to determine the percentage of the college's tuition saved. Jacob and Sophia have supplied the following information: - Out of state annual tuition (amount they are trying to save) =$52,000 per year - Annual Rate =5.25% - Number of years for which they will make monthly deposits =18 - Monthly deposit =$425 - Percentage of tuition saved = FV / Tuition for four years Jacob and Sophia are not sure how much they will actually be able to save each month. Use the concepts and techniques presented in module 4 to create a data table that show the future value and percentage of tuition saved for monthly deposits from $175 to $775, in $50 increments. Unlock the rate, monthly deposit and years. Protect the workbook so that the user can select only unlocked cells. D2L Brightspace Assignment Folder Submission Instructions and Due Dates: 1. Review the above instructions for the Module 4 test project. Using the requirements document template on the following page or another format that you prefer, document the requirements for this workbook. Submit a Word document describing the project requirements to the "Module 4 Test Project Requirements" folder in D2L Brightspace under Assessments>Assignments by Thursday, Oct 5 at midnight. I will need to review and approve your requirements document before you will be able to submit your actual workbook to the appropriate assignments folder. I will check the assignments folder regularly and approve requirements documents ASAP so you can move ahead as quickly as possible. Once I review your requirements document, you will see another assignments folder in the Assessments>Assignments area of D2L Brightspace where you can submit the actual workbook once you have completed it. (More information on that in \#2.) 2. Once I have reviewed your requirements document as described in \# 1, you will see an assignments folder in D2L Brightspace under Assessments>Assignments called "Module 4 Test Project." There is a starting template attached to that assignments folder. Use that template as a starting point to complete the workbook as requested in the

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!