Net Price Case Study

Order Description Week 2 Assignment - Net Price Case Study There are two parts for this week?s assignment: Part 1 Select two colleges that you are familiar with or would like to know more about. One should be a private 4 year college and the other a 4 year public school from within the state you reside in (if you live outside the US chose any state college). Using the following scenarios below, go onto each of the school?s website you have selected and locate their net price calculator and complete the questions. (Sometimes they hide it so you may need to use Google to find it) When you have your final results, answer the questions listed below. Note: Please use only the information provided below. Depending on the college will depend on whether the school has used the 9 question federal requirement or if they have customized the Net Price Calculator, which may include very detailed questions. Family #1: Mom is divorced who and has three children. The oldest will graduate from high school and wants to attend college. The family lives in an apartment. Mom does not receive any child support. Parent Information: Income (AGI) ? $30,000 Untaxed income (401 contribution) ? 0 Taxes paid ? 0 Cash, savings and checking - $100 No investments or assets Rents does not own a home Other: 4 in family, 1 in college Student Information: Earnings - $2,000 Cash, savings and checking - $0 Wants to major in Journalism Wants to live on campus, has a GPA of 3.5 and his SAT scores are 1550 Family # 2: Married couple with two children. Both parents work and try hard to save for college for both their children. Student has a part time job, but works very few hours. They own a home. Parent Information: Income ? $135,000 (AGI) Untaxed income (401 contribution) ? $10,000 Taxes paid - $18,000 Cash, savings and checking - $2,000 Total parent investments (529 Plans) - $30,000 No other investments Home Equity Value: Current market value ? $295,000 Mortgage - $225,000 Other: 4 in family, 1 in college Student Information: Income ? $2,000 Cash, savings and checking - $1,000 Wants to major in engineering Wants to live on campus, has a GPA of 3.8 and his SAT scores are 1850 Complete the following questions and share your results on the Discussion Board: How easy was it to locate the net price calculator on the school?s website? Which type of calculator did they use? Federal ? (9 questions) Customized ? Will ask additional questions beyond the federal requirement What were the results? Loans Work- Study Grants Do you think this is a true indicator of the net price for which the family might have to pay? What other costs may not be considered? How would you counselor your families on using this tool? Part II Using the budget worksheet that has been provided for you (College Cost Comparison.xlsPreview the documentView in a new window), research all the costs (tuition, fees, room & board, health insurance, lab fees, etc.) that you can find related to the colleges you selected. Enter the information onto the spreadsheet (from cell 11 to 25 if applicable). There are formulas built in so the numbers should total on their own. You do not need to submit your results. The purpose of this part of the assignment is to have you research all the additional costs not seen by the family. Two school in Georgia one private and one public around Savannah Georgia area.