NO use of excel - solve by hand using PV of annuity formula

Your life is changing rapidly. You are still in your first semester of the MBA program at Cal Poly, and you have met some very nice people. But there are big changes on the horizon your significant other is pregnant and the baby is due around the first week of July, 2021! Of course, your little pride-and-joy is going to be cute AND smart. After much consultation, your significant other and you have decided that you want to send the little one t o a private college (when the time comes). Private colleges are very expensive. A recent survey estimates the current cost to be around $37,820 for one year. This costs covers tuition, fees, room, and board, and is based on an elite, private, four-year school in the Northeast of the United States. The cost is for the 2020-2021 school year. You expect these costs to increase by 3.9% per year over the foreseeable future (approximately the same rate as inflation.) Your child will most likely begin school eighteen (18) years after birth. Schools tend to demand payments upfront. Assume the cost of the whole first-year tuition is due in July 2039. The whole second-year tuition is due in July 2040, etc. You expect to invest your money in a manner that returns 7.50% per year over the foreseeable future. You want to start saving soon. In fact, you plan to invest money every year. To be precise, you will put away money once a year, every July, starting when the baby is born, and ending in July, 2038.

A. Suppose you want to save the same amount each year (in nominal dollars). How much will you have to save so that there is enough money to send your child to college?

B. In the first part of this problem, you calculated the nominal amount saved each year. Of course, in real terms, the value of these amounts gets less and less over time due toinflation. Suppose you want to save the same real amount each year. How much will youhave to save so that there is enough money to send your child to college? Please writedown how much you will save each year in real dollars. Also provide the actual payments(in nominal dollars) made each year.