plz show ur work thx!!! (15 points) Diane has just turned 19 and also completed
ID: 2641481 • Letter: P
Question
plz show ur work thx!!!
(15 points) Diane has just turned 19 and also completed high school. She is wondering about the value of a college education. She is pretty good with numbers, and driven by financial considerations only. so she sits down to calculate whether it is worth the large sum of money involved. She knows that her first year tuition will be $13,000, due at the beginning of the year (that is, right away). Based on historical trends she estimates that tuition will rise at 5% per year for the 4 years she is in school. She also estimates that her living expense above and beyond tuition will be $8,000 per year (assume this occurs at the end of the year) for the first year and will increase $500 each year thereafter to keep up with inflation. She does not plan to work at all while attending school. Were she to forgo college she would be able to make $23,000 per year out of high school and expects that to grow 3% annually. With the college degree, she estimates that she will earn $47,000 per year out of college, again with annual 3% increases in salary. Either way, she plans to work until 64 (she begins college right away). The interest/discount rate is 8%. What is the NPV of her college education? (Note: All cash flows except tuition payments occur at the end of the year.) $513,289.82 $107,785.74 $110,171.52 $111,480.05Explanation / Answer
So total NPV of education =NPV of Earning after education -NPV of Opportunity cost - NPV of education expenses - NPV of living expenses
'=591985-405504-28822.06-49873
PV calculated by formula PV= Cash flow/ (1+Discount)^N (N is number of years from present)
Tution Total NPV 49873 Years lapsed from 19th birthday FV NPV 0 13000 13000 1 13650 12639 2 14333 12288 3 15049 11946Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.