5. (2 marks) Assume the total cost of a university education will be $300,000 when your...
Assume the total cost of a college education will be $285,000 when your child enters college in 22 years. You presently have $35,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child's college education?
Assume the total cost of a college education will be $360,000 when your child enters college in 15 years. You presently have $58,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child's college education? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Annual rate
Assume the total cost of a college education will be $325,000 when your child enters college in 16 years. You presently have $40,000 to invest and do not plan to invest anything further. What annual rate of interest must you earn on your investment to cover the entire cost of your child's college education? 13.99 percent 11.08 percent 10.40 percent 12.65 percent 14.62 percent
11 Calculating Interest Rates. Assume the total cost of a college education will be $250,000 when your child enters college in 18 years. You presently have $25,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child's college education? Calculating the Number of Periods. At 10 percent interest, how long does it take to double your money? To quadruple it? 12
Assume the total cost of a university education will be $210,000 when your child enters university in 8 years. You presently have $180,000 to invest. What annual rate of interest (APR) must you earn, if the interest is compounded monthly? Enter your answer as a percentage. Do not include the percentage sign in your answer. Enter your response below rounded to two decimal places.
Assume the total cost of a college education will be $250,000 when your child enters college in 17 years. You presently have $59,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child’s college education? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Homework. Calculating Rate 12 Assume that total cost of collage education will be * 2,80.000 dollar when your child enters collage in 18 years p you presently have $ 45,oo to inwest, what annual tate of interest must you earn on your investment to cover the cost of your child's College education? Data: Fiv - 230.000 PV 45.000 A 18 (280.000 i = ? 45.000 i= (6,2) To - 1 2 = 1 1067 - 1 C2 = 0,067 Calculating...
Assume the total cost of a college education will be $365,000 when your child enters college in 18 years. You presently have $59,000 to invest.Required:What annual rate of interest must you earn on your investment to cover the cost of your child’s college education? (Do not include the percent sign (%). Round youranswer to 2 decimal places (e.g., 32.16).)
Let’s assume that you’re preparing for your (future) child (or grandchild)’s college education. 20 years later from now, your (future) child will go to college. Currently you’re considering two colleges for your (future) child (or grandchild). The following is the list of universities I assigned to each of you. Student University 1 University 2 Holliday, Carshawn B Harvard University Vanderbilt University Estimate future costs of two colleges for your (future) child (or grandchild) and calculate needed annual savings for two...
Answer the following problems using an Excel spreadsheet. All calculations MUST use Excel's Time Value of Money Functions (demonstrated in class) as well as cell references to receive FULL credit. Make sure to set up the data for each problem so you can "point" to the appropriate values in your formulas. Each problem is worth 20 points. This assignment must be completed INDIVIDUALLY. THIS IS NOT A GROUP ASSIGNMENT. The file you submit in CANVAS must be one that YOU...