Question: How do I enter in the future values and percentage of tuition saved for monthly payments with the information that is given? I am not
How do I enter in the future values and percentage of tuition saved for monthly payments with the information that is given? I am not sure with information goes where when it comes to the future values and how to figure out the percentage of tuition saved for monthly payments.

IMPORTANT NOTE THIS IS NOT A MINDTAP BASED PROJECT. YOU WILL BE SUBMITTING YOUR PROJECT DOCUMENTS IN THE ASSESSMENTSbASSIGNMENTS AREA OF OIL BRIG HTSPACE AND DESCRIBED BELOW. Jacob and Sophie's dream for their recently born daughter, Emily, is that one day she will attend their alma mater, Purdue University. For the next 13 years, they plan to make monthly payment deposits to a 529 College Savings Plan at a local bank. The account pays 5.25% annual interest, compounded monthly. Create a worksheet forlocob and Sophia that uses a nancial function to show the future value (Fit) of their investment and a formula to determine the percentage of the coiiege's tuition saved. Jacob and Sophia have supplied the following information: - lOut of state annual tuition {amount they are trying to save] 2 $52,000 per year 9 Annual Rate = 5.25% 9 Number of years for which they will make monthly payments 2 18 I Monthly payment = $425 I Percentage of tuition saved = FV ,l 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 IIralue andI percentage of tuition soyedfor monthly payments from 51?.5 to $175, in $50 increments. Unlock the rate, monthly payment and years. Protect the workbook so that the user can select only unlocked cells
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
