Your research into the cost of college at the three different types of schools listed below Part II: Bills and Expenses resulted in the following information. These figures represent the direct costs for a full-time student taking a load of 12 semester hours for one semester. Direct costs are those costs associated with tuition fees, room and board. 1. community college 2. state collegeluniversity, 3. private collegeluniversity Fees Room Board Tuition 1596 324 School Name 1. Northwest-Shoals Community College 2. University of Alabama 3. Samford University 5390 16624 400 475 4500 4725 2405 2555 Complete the following table for each of the three schools. School Name Total Annual Cost of Tuition/Fees Total Annual Cost of Room/Board Total Annual Cost 1. Northwest-Shoals Community College 2. University of Alabama 3. Samford University Answer the following questions based on the amount in the college fund account when compounded quarterly Show all work. For each school, determine if the account will cover tuition fees only for your entire college career. (Keep in mind that community Colleges are 2-year institutions.) 2. 3. For each 4-year institution, determine if the account will cover tuition/fees plus room/board for your entire college career 2. 3 Determine the minimum principal amount that Great-Aunt Mildred should have invested so that only your tuition/fees for all four years would be covered for the private institution Determine the minimum principal amount that Great-Aunt Mildred should have invested so that your tuition fees plus room/board for all four years would be covered for the private institution Part II: Annuity vs. Single Deposit Instead of making a single deposit on the day you were born, Great-Aunt Mildred decides to make annual deposits into an annuity every year on your birthday. Using the same interest rate as before, how much will she need to deposit each year on your birthday in order to cover the total cost of tuition fees plus room/board for four years at the private institution? Show all work below First Letter of Last Name AE F-J K- P-T U-Z Initial Investment $25,000 $30,000 $35,000 $40,000 $45,000 Interest Rate 5.5% 6.0% 6.5% 7.0% 7.59