You have been accepted into college. The college guarantees that your tuition will not increase for...

You have been accepted into college. The college guarantees that your tuition will not increase for the four years you attend college. The first $10,000 tuition payment is due in six months. After that, the same payment is due every six months until you have made eight payments. The college offers a bank account that allows you to withdraw money every six months and has a fixed APR of 4% (semiannual) guaranteed to remain the same over the next four years. How much money must you deposit today if you intend to make no further deposits and would like to make all the tuition payments from this account, leaving the account empty when the last payment is made?

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.

jeff jeffy answered 1 month ago

Next > < Previous

Related Solutions

Your son has been accepted into college. This college guarantees that your son's tuition will not...

Your son has been accepted into college. This college guarantees that your son's tuition will not increase for the four years he attends college. The first $11,000 tuition payment is due in six months. After that, the same payment is due every six months until you have made a total of eight payments. The college offers a bank account that allows you to withdraw money every six months and has a fixed APR of 6% (semiannual) guaranteed to remain the...

10. Tuition Increase At one college, the tuition for a full-time student is $8000 per semester....

10. Tuition Increase At one college, the tuition for a full-time student is $8000 per semester. It has1 been announced that the tuition will increase by 3 percent each year for the next 5 years. Write a program with a loop that displays the projected semester tuition amount for the next 5 years.

You are planning to save for your retirement in 35 years and the college tuition for...

You are planning to save for your retirement in 35 years and the college tuition for your two children. Your current monthly salary is $9,000 per month and you expect your salary to keep pace with inflation. You expect inflation to be a 3.5 percent EAR for the rest of your life. You plan to deposit 12 percent of your salary each month into a retirement account. Additionally, your employer will deposit 4 percent of your salary into the account....

You have just been accepted to nursing school. As a requirement, you have to have a...

You have just been accepted to nursing school. As a requirement, you have to have a tuberculosis (TB) test as well as a hepatitis B recombinant vaccine. The nurse who administers the TB skin test explains that if significant swelling occurs around the injection site, you will need to have chest x-rays to determine if you are infected with Mycobacterium tuberculosis. On the morning of the second day after the skin test, you awake to find your arm red and...

You have just been accepted to nursing school. As a requirement, you have to have a...

(TCO 5) You have been accepted into a prestigious private university in Illinois for your doctoral...

(TCO 5) You have been accepted into a prestigious private university in Illinois for your doctoral program. Congratulations! Since no one from this school has ever graduated in only 4 years, you anticipate that you will need to make 11 semi-annual tuition payments of $35,000 each with the first cash flow 6 months from today. If you choose to discount these cash flows at an annual rate of 8%, what is the present value cost of tuition to attend your...

You have been accepted as a Junior Project Manager at Super IT Pty. Ltd. Your first...

You have been accepted as a Junior Project Manager at Super IT Pty. Ltd. Your first task assigned by the Senior Project Manager is to select and prioritise the best mobile application project in response to COVID-19 and the second task assigned is to write the Project Scope of the chosen project. These candidate projects include: Gaming or entertainment application for COVID-19 isolated patients.  Mobile applications in support of contact tracing for COVID-19.  Mobile application information to provide...

You have been accepted as a Junior Project Manager at Super IT Pty. Ltd. Your first...

You have been accepted as a Junior Project Manager at Super IT Pty. Ltd. Your first task assigned by the Senior Project Manager is to select and prioritise the best mobile application project in response to COVID-19 and the second task assigned is to write the Project Scope of the chosen project. These candidate projects include:  Gaming or entertainment application for COVID-19 isolated patients.  Mobile applications in support of contact tracing for COVID-19.  Mobile application information to...

You have been accepted as a Junior Project Manager at Super IT Pty. Ltd. Your first...

You have been accepted as a Junior Project Manager at Super IT Pty. Ltd. Your first task assigned by the Senior Project Manager is to select and prioritise the best mobile application project in response to COVID-19 and the second task assigned is to write the Project Scope of the chosen project. These candidate projects include:  Gaming or entertainment application for COVID-19 isolated patients.  Mobile applications in support of contact tracing for COVID-19.  Mobile application information to...

You just graduated college with your Bachelors Degree and accepted a job offer at your dream...

You just graduated college with your Bachelors Degree and accepted a job offer at your dream company. You decided to celebrate by purchasing the vehicle of your dreams. Pictured is a Dodge Challenger HellCat see picture above for $58,995). You have a 720 credit score, therefore you were able to get a 5% interest rate on a 7 year loan. You will be making monthly payments. Using Excel, prepare a professional amortization schedule for the entire 7 years. It must...

Subjects