Mark is trying to decide if he should attend college or not. Part of his decision will be based on the return on investment of college. He estimates costs to attend Texas Tech for 4 years including room and board are $20,000 per year. He also assumes tuition costs will rise by 3.5% per year. How much is a 4-year degree going to cost Mark? $92,183.27 $84,298.86 $7,231,158.87 $1,314,002.83

Mark is trying to decide if he should attend college or not. Part of his decision will be based on the return on investment of college. He estimates costs to attend Texas Tech for 4 years including room and board are $20,000 per year. He also assumes tuition costs will rise by 3.5% per year. How much is a 4-year degree going to cost Mark? $92,183.27 $84,298.86 $7,231,158.87 $1,314,002.83

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Michiko and Saul are planning to attend the same university next year. The university estimates tuition, books, fees, and living costs to be 12,000 per year. Michikos father has agreed to give her the 12,000 she needs to attend the university. Saul has obtained a job at the university that will pay him 14,000 per year. After discussing their respective arrangements, Michiko figures that Saul will be better off than she will. What, if anything, is wrong with Michikos thinking?
John is trying to decide if he should attend college or not. Part of his decision will be based on the return on investment of college. He estimates that the cost to attend Texas Tech, including room and board, is $24,044 per year. He also assumes costs will rise by 6% per year. How much is a 4-year degree going to cost, John? N 4 I/Y PV 0 PMT FV
Perry is a freshman. He estimates that the cost of tuition, books, room and board, transportation, and other incidentals will be $21,000 this year. He expects these costs to rise about $1500 each year while he is in college. If it will take him 5 years to earn his BS, what is the present cost of his degree at an interest rate of 4%? If he earns an extra $15,000 annually for 40 years, what is the present worth of his degree?
Jenny Jenks has researched the financial pros and cons of entering into a 1-year MBA program at her state university. The tuition and needed books for a master's program will have an upfront cost of $51,000. If she enrolls in an MBA program, Jenny will quit her current job, which pays $50,000 per year after taxes (for simplicity, treat any lost earnings as part of the upfront cost). On average, a person with an MBA degree earns an extra $21,000 per year (after taxes) over a business career of 39 years. Jenny believes that her opportunity cost of capital is 5.3%. Given herestimates, find the net present value (NPV) of entering this MBA program. Are the benefits of further education worth the associated costs? The net present value (NPV) of entering this MBA program is Are the benefits of further education worth the associated costs?
The Jeffersons have asked you what would be needed to fund the children’s future college costs. Assume each child will begin college at age 18 and graduate in four years. Assume current costs are $24,000 per year and are expected to increase by 5% per year and investments earn 7%. A. Assuming no existing assets are dedicated to college, what is the annual savings amount required to fund the children’s education? The Jeffersons’ goal is to have an amount at the beginning of the freshman year for each child that is sufficient to fund a serial payment covering the $24,000 of current costs of college adjusted for inflation for each of the four years of college. Please include your calculator keystroke inputs [PV, I/YR, N, FV, and PMT (if needed)] for each step of this calculation. Also include whether any PMTs are in the end mode or the begin mode. B. What would you say to the Jeffersons about their education funding situation? Write a script of a single paragraph as if you…
Gabe and Sarah would like to begin saving for their children's college education. They would like to know the amount of college funds that would be necessary on day one of college to pay for all tuition costs for each child. The current tuition at the university is $25,000. The couple is comfortable assuming an annual rate of return of 6% on their college investment savings program. They anticipate that each child will begin college at age 18 and attend for four years. The Consumer Price Index (CPI) is expected to be 3% and the expected college inflation rate is 5% per year.
Your friend is considering investing in a two-year MBA program. Tuition costs will be $60,000 for two years while living expenses will be $25,000 per year. She has $10,000 in savings, which she can spend on her education, and will need to borrow the rest from her bank. Her annual loan repayment will be $10,500. she currently works as an analyst and makes $60,000 a year; after she gets her degree she hopes to work as a manager for $150,000 a year. How should your friend formulate her problem? What are her all projected costs ? Suggest alternatives to your friend to reduce the uncertainty associated with finding a high-income job to pay off her loan Select a criterion for discriminating among alternatives, and use it to advise your friend on which course of action to pursue Attempt to analyze and compare the alternatives in view of at least one criterion in addition to cost What should your friend do based on the information you and she have generated?
Risk is planning to attend a two-year university. The list below shows the estimated costs for one year. His family devised a periodic savings plan that will have a total value of $29,000 by the time Rick will begin college. Rick also earned a scholarship that will pay for the first year. With the scholarship and his family's contribution, for how many years of college will be paid: Round to the nearest tenth. Two-Year University Estimated Costs Tuition and Fees. $5,650.00 Room and Board. $2,970.00 Books and Supplies $1,400.00 Personal Expenses. $2,100.00 a about 2.1 years b about 2.4 years c about 3.2 years d about 3.4 years
Your five-year old daughter has just announced that she would like to attend college. Your best guess is that it will cost approximately $25,000 per year for four years in tuition, books, rent, etc. for her to attend State College 12 years from now (first payment beginning on year 13). You believe that you can earn a rate of 9% on investment to meet this goal. a. If you were to invest a lump sum today in hopes of covering your daughter’s college costs, how much would you have to invest? b. If you now decided to invest annually instead, how much would you have to invest every year? (investment every year, years 1-12) c. You just learned of a $10,000 inheritance and plan to invest it in your daughter’s college fund (inheritance is available today at time 0). Given this new source of funds how much do you have to invest every year? d. Create a combo box that will switch provide the user with 5 different inheritance amounts ($8,000, $9,000, $10,000, $11,000 and $12,000)
Your son has come to you for advice. He is about to enter college and has two options open to him. His first option is to study pharmacy. If he does this, his pharmacy study would cost him $30,000 a year for sevenyears. Having obtained this, he would work for two years to save money for graduate school: in the first year he would earn $40,000, in the second year he would earn $50,000. He would then go to geta MBA, which will cost $45,000 a year for two years. After that he will be fully qualified and can earn $100,000 per year for 30 years.His other alternative is to study accounting. If he does this, he would pay $35,000 a year for four years and then he would earn $50,000 per year for 37years. The effort involved in the two careers is the same, so he isonly interested in the earnings the jobs. provide. All earnings and costs are paid at the end of the year. What advice would you give him,if the market interest rate is 6percent?
Your son has come to you for advice. He is about to enter college and has two options open to him. His first option is to study pharmacy. If he does this, his pharmacy study would cost him $30,000 a year for sevenyears. Having obtained this, he would work for two years to save money for graduate school: in the first year he would earn $40,000, in the second year he would earn $50,000. He would then go to geta MBA, which will cost $45,000 a year for two years. After that he will be fully qualified and can earn $100,000 per year for 30 years.His other alternative is to study accounting. If he does this, he would pay $35,000 a year for four years and then he would earn $50,000 per year for 37years. The effort involved in the two careers is the same, so he isonly interested in the earnings the jobs. provide. All earnings and costs are paid at the end of the year. What advice would you give him,if the market interest rate is 6percent? (Note: This question is worth more)a.Tell him to choose…
If the price of attending Big Benefits University is $8,000 a year for tuition, fees, books, and and $25,000 in foregone earnings, what is the marginal cost of attending, if it takes you 5 years to graduate, and you assume a 3% annual inflation rate? If the average college graduate makes $38,000 more every year than the average high school graduate, what is the cumulative marginal benefit of a college education if the average college graduate works for 40 years, assuming a 3% inflation rate? c.In this scenario does it make sense to go to college, explain your answer.