Twins Kate and Allie will be going to college in 15 years. Their parents have decided...

Twins Kate and Allie will be going to college in 15 years. Their parents have decided that Dad will start a savings fund for Kate. He will deposit $2,000 into an account the first of each year. That account earns 7% and interest is compounded annually. Their mother will also deposit $2,000 into an account for Allie, but she is going to make those deposits at the end of each quarter and the account pays 7.5% compounded quarterly. Who will have more in her college fund? EXCEL function: Input: Results:

Solutions

Expert Solution

Hence, Allie would be having more in her college fund.

Formulae

Formulae as above

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Your parents will retire in 15 years. They currently have$250,000 saved, and they think they...

Your parents will retire in 15 years. They currently have $250,000 saved, and they think they will need $1,550,000 at retirement. What annual interest rate must they earn to reach their goal, assuming they don't save any additional funds? Round your answer to two decimal places.What is the present value of a security that will pay $26,000 in 20 years if securities of equal risk pay 6% annually? Do not round intermediate calculations. Round your answer to the nearest cent.If...

Twins Silvia and Lynette are now 6 years old. Time has flown for parents Brett and...

Twins Silvia and Lynette are now 6 years old. Time has flown for parents Brett and Brenna. Raising twins is an adventure for sure. While identical in appearance at birth, the twins have always had unique personalities, and now they're developing into their own little people. Silvia, who seemed to grow on air for a good chunk of her toddler years, is now the taller of the two, while Lynette is the one with the smaller appetite at the moment....

Mr. Johnson, much to his parents’ dismay, has decided to quit college and to become a...

Mr. Johnson, much to his parents’ dismay, has decided to quit college and to become a professional skateboarder. In order to bring attention to himself, Mr. Johnson decided to film himself performing a trick and then to submit it to a cable channel program featuring various ‘daredevils’. Mr. Johnson planned to ride a stair railing at the local strip mall. Unfortunately the trick failed and Mr. Johnson suffered fractures in his frontal bone as well as several facial bones making...

Marty and Jean are married and have 4-year-old twins. Jean is going to school full-time for...

Marty and Jean are married and have 4-year-old twins. Jean is going to school full-time for 8 months of the year, and Marty earns $45,400. The twins are in day care so Jean can go to school while Marty is at work. The cost of day care is $8,600. What is their child and dependent care credit?

During four years of college, twins Molly and Marty each expect to receive gifts from grandparents...

During four years of college, twins Molly and Marty each expect to receive gifts from grandparents at $1000, $2000, $3000, and $4000 for Year 1, 2, 3 and 4, respectively. Each twin plans to save all of the funds in a money market fund expected to return 2% per year. What is the NPV (net present value) of the planned gifts for each twin?

In a sample of 331 Americans, 15% decided to not go to college do so because...

In a sample of 331 Americans, 15% decided to not go to college do so because they cannot afford it. (a) Suppose we wanted the margin of error for the 90% confidence level to be at most 1.5%. How large of a survey would you recommend? (Do not use the estimate of p given by the sample.) (b) Suppose we wanted the margin of error for the 90% confidence level to be at most 1.5%. How large of a survey...

A college believes that 22% of aoolication to that school have parents who have remarried. How...

A college believes that 22% of aoolication to that school have parents who have remarried. How large a sample is needed to estimate the true poroportion of students who have parents who have remarried to within 3% with 95% confidence.

Mike is currently 10 years old and his parents are planning the finance of his college...

Mike is currently 10 years old and his parents are planning the finance of his college expenses. They will set up a bank account and deposit $X one year from today and will deposit 4% more each subsequent year. The last deposit will be 11 years from today. College expenses of $40,000 will occur 8, 9, 10, and 11 years from today. What is X if all the deposits exactly pay for Mike’s college expenses? Assume the effective annual interest...

(a)Your parents are giving you $300 a month for 6 years while you are in college....

(a)Your parents are giving you $300 a month for 6 years while you are in college. At a 0.583 percent monthly discount rate, what are these payments worth to you when you first start college? (b)You are scheduled to receive annual payments of $11,000 for each of the next 22 years. Your discount rate is 8 percent. What is the difference in the present value if you receive these payments at the beginning of each year rather than at the...

Your parents are giving you $150 a month for 5 years while you are in college....

Your parents are giving you $150 a month for 5 years while you are in college. At a 6 percent discount rate, what are these payments worth to you when you first start college? I am doing every step right in my financial calculator, getting 8,886.60. I don't understand why.

Subjects