Question

In: Finance

I am planning to invest $1,000 at the end of each month to my daughter’s college...

I am planning to invest $1,000 at the end of each month to my daughter’s college (starting at the end of this month) fund that earns a 12% annual rate of return compounded monthly. Assuming that she starts college in exactly 5 years and she will spend 4 years in college, how much tuition can she afford to pay at the beginning of each of her 4 years in college? (Round to nearest dollar)

Select one:

a. $24,008

b. $24,205

c. $26,888

d. $27,275

e. None of the above.

Expert Solution

Calculating Future Value of Deposit at the start of college,

Using TVM Calculation,

FV = [PV = 0, PMT = 1,000, N = 60, I = 0.12/12]

FV = $81,669.67

Now,

EAR = (1 + 0.12/12)¹² - 1 = 12.68%

Calculating Annual Payment,

Using TVM Calculation,

PMT = BEG[PV = 81,669.67, FV = 0, N = 4, I = 0.1268]

PMT = $24,205

Annual Payment = $24,205

jeff jeffy answered 2 years ago

I am planning to invest $1,000 at the end of each month to my daughters college...

I am planning to invest $1,000 at the end of each month to my daughters college (starting at the end of this month) fund that earns a 12% annual rate of return compunded montly. Assuming that she starts college in exactly 5 years and she will spend 4 years in college, how much tuition can she afford to pay at the beginning of each of her 4 years in college?

My name is Donna. I am a college student studying to be an English teacher. I...

My name is Donna. I am a college student studying to be an English teacher. I dislike inflation, my degree is costing me more than i had anticipated. Good thing that I am a senior, tuition when I started three years ago was 20% less. Maybe I should get my masters but that would put me unto more debt. Why do we have so much inflation? I work part time as a server and have a low fixed rate loan...

Ms. Early Saver has decided to invest $1,000 at the end of each year for the...

Ms. Early Saver has decided to invest $1,000 at the end of each year for the next 10 years, then she will just let the amount compound for 25 additional years. Her brother, Late Saver, has a different investment program: He will invest nothing for the next 10 years but will invest $1,000 per year (at the end of each year) for the following 25 years. If we assume a 3% percent rate of return, compounded annually, which investment program...

If I am looking to maximize my investment as an investor and the company I am...

If I am looking to maximize my investment as an investor and the company I am looking at has a low or unstable payout schedule, what would be the point of investing?

you invest 2500 in your child's college fund at the end of each year for the...

you invest 2500 in your child's college fund at the end of each year for the next 12 years. at that time your kid will withdraw equal amounts at the end of the next four years. what is the annual withdrawal amount if the appropriate interest rate is 8%?

Working with Python. I am trying to make my code go through each subject in my...

Working with Python. I am trying to make my code go through each subject in my sample size and request something about it. For example, I have my code request from the user to input a sample size N. If I said sample size was 5 for example, I want the code to ask the user the following: "Enter age of subject 1" "Enter age of subject 2" "Enter age of subject 3" "Enter age of subject 4" "Enter age...

Suppose you invest $150 at the end of each month for 6 years into an account...

Suppose you invest $150 at the end of each month for 6 years into an account earning 6% annual interest compounded monthly. After 6 years, you leave the money, without making additional deposits, in the account for another 26 years. How much will you have in the end? How would I solve this using the "TI-84 plus Tvm solver"?

If you invest $200 at the end of each month for five years and you earn...

If you invest $200 at the end of each month for five years and you earn 9% interest compounded monthly, how much will you have accumulated at the end of the fifth year?

Sylvia plans to invest $ 350 into her RRSP at the end of each month. What...

Sylvia plans to invest $ 350 into her RRSP at the end of each month. What will be the value of RRSP in 25 years if the RRSP earns 4.7% compounded monthly?

Consider two investments: Invest $1000 and receive $110 at the end of each month for the...

Consider two investments: Invest $1000 and receive $110 at the end of each month for the next 10 months. Invest $1200 and receives $130 at the end of each month for the next 10 months. If this were your money, and you want to earn at least 12% interest on your money, which investment would you make, if any? What nominal interest rate do you earn on each investment? (show all equations)