You have two 8-years old twin children, and you anticipate that when they will turn 18 (exactly 10 years from now) they will need $500,000 to cover living and tuition college expenses. Suppose that the discount rate is 10%. 1. If you want to meet this negative cash flow only with current savings, how much would you need to set aside right now? 2. Suppose, instead, that want to meet this negative cash flow only saving a constant amount at the end of each year, for the next 10 years. What is the amount you should set aside each year?

You have two 8-years old twin children, and you anticipate that when they will turn 18 (exactly 10 years from now) they will need $500,000 to cover living and tuition college expenses. Suppose that the discount rate is 10%. 1. If you want to meet this negative cash flow only with current savings, how much would you need to set aside right now? 2. Suppose, instead, that want to meet this negative cash flow only saving a constant amount at the end of each year, for the next 10 years. What is the amount you should set aside each year?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter2: Using Financial Statements And Budgets

Section: Chapter Questions

Problem 6FPE

See similar textbooks

Similar questions

d. If, instead, you decide to withdraw $170000 per year in retirement (again with the first withdrawal one year after retiring), how many years will it take until you exhaust your savings? (Use trial-and-error, a financial calculator: solve for "N", or Excel: function NPER) e. Assuming the most you can afford to save is $1500 per year, but you want to retire with 1000000 in your investment account, how high of a return do you need to earn on your investments? (Use trial-and-error, a financial calculator: solve for the interest rate, or Excel: function RATE) *round to two decimal places for d) and e)*
5. Suppose you want to invest for the college expenses of your children, which you estimate to be $200,000. Moreover, you have access to a risk-free savings account that pays an annual interest of 4%, compounded annually. If you anticipate needing the amount in 20 years, how much do you need to invest now in the savings account (You do not plan to withdraw from the account or add more before the 20 years)? a. $75,377.90 b. $84,531.78 c. $91,277.39 d. $110.735.15
If you are saving the same amount each month in order to buy a new sports car when the new models are released, which of the following will help you determine the savings needed? A. future value of one dollar ($1) B. present value of one dollar ($1) C. future value of an ordinary annuity D. present value of an ordinary annuity
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…
(Quantitative Question) Suppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthday, starting with her first birthday till her 18th birthday. Suppose college tuition, books, fees, and other costs average $12400 per year today. Assume that college costs continue to increase an average of 4.8% per year and that the interest earned on the savings account is 7.9% per year. How much money will the couple's first baby need to have available at age 18 to pay for all four years of her college (assuming that college costs for the year are incurred at the beginning of the year)? Write the answer both in the space provided and on the empty pages on which you will also show your work (Including timelines).
You are considering a safe investment opportunity that requires a $1,450 investment today, and will pay $950 two years from now and another $710 five years from now. a. What is the IRR of this investment? b. If you are choosing between this investment and putting your money in a safe bank account that pays an EAR of 5% per year for any horizon, can you make the decision by simply comparing this EAR with the IRR of the investment? Explain. a. What is the IRR of this investment? The IRR of this investment is %. (Round to two decimal places.)
Use Excel to solve the following problem. Assume that you are 39 years old planning for your future retirement at age 65. You think that you will be comfortable living on the proceeds from a $1,000,000 401K Retirement Account.a. If your investments grow at an average rate of 6% annually how much must you invest monthly to achieve your projected retirement fund total by the time you retire in 26 years?b. Assuming that when you do retire, you will re-direct your $1,000,000 investment portfolio into less volatile and more secure mutual funds. You expect that, invested in these sources, your portfolio will securely earn 4.5% annually. Based on your assumptions and the normal life expectancy of an American male or female (I determined this to be 81 years old), without consuming any of your principal, how much money will you have on a monthly basis to support your life?(I have worked this problem out on my own, I just want to be sure I applied the formulas and concepts correctly.)
4. Suppose you make an annual contribution of BD100 each year to a college education fund for a niece. She is 4 years old now, and you will start next year and make the last deposit when she is 18. The fund is a money market account earning 6.5%/year. What will it be worth immediately after the last deposit? You may also set up spreadsheet solution
You are considering a safe investment opportunity that requires a $780 investment today, and will pay $870 two years from now and another $640 five years from now. a. What is the IRR of this investment? b. If you are choosing between this investment and putting your money in a safe bank account that pays an EAR of 5% per year for any horizon, can you make the decision by simply comparing this EAR with the IRR of the investment? Explain.
Your brother needs a $5,000 loan to go to college. Because of his poverty, he will pay nothing for the next four years. Five years from today he will begin paying you $2,500 a year for the next 4 years. The first payment occurs 5 years from today, and the total of the four payments will be $10,000. Create a cash flow diagram, assuming no inflation. If your MARR is 8%, then is this an acceptable investment? Show why.
You decide to set up a college fund for your 10-year-old child and plan to make annual deposits into the account each year on your child’s birthday. Because “other things” consistently use more of your money than anticipated, your deposits are actually somewhat erratic. One year even resulted in a withdrawal. The account earns 5% per year. Solve, a. How much is in the account immediately after the deposit on your child’s 18th birthday? b. How much would you have needed to deposit on each birthday to accumulate the same total if you had started on your child’s 10th birthday and made equal annual deposits with no withdrawals? c. How much would you have needed to deposit on each birthday to accumulate the same total if you had started on your child’s 1st birthdayand made equal annual deposits with no withdrawals?
You are considering a safe investment opportunity that requires a $1,080 investment today, and will pay $710 two years from now and another $610 five years from now. a. What is the IRR of this investment? b. If you are choosing between this investment and putting your money in a safe bank account that pays an EAR of 5% per year for any horizon, can you make the decision by simply comparing this EAR with the IRR of the investment? Explain. a. What is the IRR of this investment? The IRR of this investment is _____________%. (Round to two decimal places.)