Will you show your work/equations in excel.

Matt and Debra Pearson live in an upscale neighborhood in Orem, Utah. Matt is a partner in the family owned automotive painting business. Debra stays home with their son, Brady, who is four. After visiting with their financial planner, the couple became concerned that they were spending too much and not putting enough funds aside for Brady's future educational needs. Matt earns $100,000 per year, but with the rising costs of education, they are concerned. Matt is an alumni of the Stanford University with tuition and book expenses of approximately $22,000 per year today. Debra graduated from Utah Valley University. The expense for tuition and books there is currently estimated at about $7,000 per year. When Brady turns 18, the couple wishes to send him to one of these two exceptional universities. They have a slight preference for Utah Valley University. The problem, however, is that with the rate at which tuition is increasing the Pearson's are not sure they can save enough money and they have decided they do not want to borrow to pay for Brady's education. Assume the tuition at both universities will increase at an annual rate of 4% from now until Brady finishes college. Living expenses are currently estimated at $12,500 per year at both schools. This expense is expected to grow at only 2.5% per year. Further assume that Pearson's can deposit their money into a growth oriented mutual fund at the Salt Lake City based mutual fund company which has historically earned 10% per annum. The couple wishes to save by having a pre-determined amount automatically withdrawn from their bank account at the end each month. They plan to contribute from now until Brady starts college. When Brady starts college, at the beginning of his freshman year, they will stop making contributions. They want to have enough in their account to cover all four years of college expenses when Brady starts college. Assume that the funds in the account will continue to earn a return while he is in college. They will make annual withdrawals from the account to cover both tuition and living expenses for Brady at the beginning of his freshman, sophomore, junior, and senior years. When the withdrawal for the senior year is made the account balance will be zero. What amount will be needed in the account when Brady starts his freshman year if he attends Stanford? What amount if he attends UVU? How much money will Matt and Debra have to deposit at the end of each month to allow Brady to attend Stanford? How much money will have to be deposited per month to allow Brady to attend Utah Valley University? Assume that Matt and Debra stop making deposits when Brady starts college. The Pearson's are concerned that given the current market situation the mutual fund will only earn 8% per year. If the return is only 8% how much will be needed in the account when Brady starts college and how much will have to be deposited per month for Brady to have sufficient funds to attend each school? Matt and Debra Pearson live in an upscale neighborhood in Orem, Utah. Matt is a partner in the family owned automotive painting business. Debra stays home with their son, Brady, who is four. After visiting with their financial planner, the couple became concerned that they were spending too much and not putting enough funds aside for Brady's future educational needs. Matt earns $100,000 per year, but with the rising costs of education, they are concerned. Matt is an alumni of the Stanford University with tuition and book expenses of approximately $22,000 per year today. Debra graduated from Utah Valley University. The expense for tuition and books there is currently estimated at about $7,000 per year. When Brady turns 18, the couple wishes to send him to one of these two exceptional universities. They have a slight preference for Utah Valley University. The problem, however, is that with the rate at which tuition is increasing the Pearson's are not sure they can save enough money and they have decided they do not want to borrow to pay for Brady's education. Assume the tuition at both universities will increase at an annual rate of 4% from now until Brady finishes college. Living expenses are currently estimated at $12,500 per year at both schools. This expense is expected to grow at only 2.5% per year. Further assume that Pearson's can deposit their money into a growth oriented mutual fund at the Salt Lake City based mutual fund company which has historically earned 10% per annum. The couple wishes to save by having a pre-determined amount automatically withdrawn from their bank account at the end each month. They plan to contribute from now until Brady starts college. When Brady starts college, at the beginning of his freshman year, they will stop making contributions. They want to have enough in their account to cover all four years of college expenses when Brady starts college. Assume that the funds in the account will continue to earn a return while he is in college. They will make annual withdrawals from the account to cover both tuition and living expenses for Brady at the beginning of his freshman, sophomore, junior, and senior years. When the withdrawal for the senior year is made the account balance will be zero. What amount will be needed in the account when Brady starts his freshman year if he attends Stanford? What amount if he attends UVU? How much money will Matt and Debra have to deposit at the end of each month to allow Brady to attend Stanford? How much money will have to be deposited per month to allow Brady to attend Utah Valley University? Assume that Matt and Debra stop making deposits when Brady starts college. The Pearson's are concerned that given the current market situation the mutual fund will only earn 8% per year. If the return is only 8% how much will be needed in the account when Brady starts college and how much will have to be deposited per month for Brady to have sufficient funds to attend each school