Question: Please provide detailed step - by - step, explanations for Excel: The WSJ article states that the post - college beginning ( median ) salary

Please provide detailed step-by-step, explanations for Excel:
The WSJ article states that the post-college beginning (median) salary was $60,000, while the post-high school salary was $36,000. Assume that a student going to college will go full time and not early money for the first four years, and that a salary will start in Year 5. Conversely, a high school graduate will earn a salary starting one year from now. Also, assume that post college salaries will grow 4% per year while high school salaries will grow 3% per year. (Historically, it has been confirmed that college earners have a greater growth rate in earnings.) Further, assume that the cost of college is the average given in the article ($8,000 for tuition and fees and $11,000 for room and board per year for four years at a public university). Also, assume that the four years of costs will be financed at a 5.5% student loan rate for 10 years, and the total on student loan will accumulate interest-free; loan payments (with interest) will begin in Year 5 and end after 10 payments.Complete all the cells in yellow by adding the correct formula. You are given selected answers in some yellow cells to check your formulas. Be sure to use cell referencing to the green cells so that the inputs in the the green cells can be changed, and that these changes will automatically be updated in the worksheet. The cumulative net advantage of college is the accumulation of the Net Advantage of College column. The PV of the net advantage (40 years) is based on the PV of the Net College Advantage column, assuming a 3% discount rate because of inflation (cell B55). Complete the mini case template with the correct formulas and data in the yellow cells that displays the correct numbers.
Net Advantage
 Please provide detailed step-by-step, explanations for Excel: The WSJ article states

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!