Question

Life Planning Using TVM: Please show how you obtained the answer, so I can have a...

Life Planning Using TVM: Please show how you obtained the answer, so I can have a better understanding. 1. You want to buy a $250,000 house 5 years from now. If you have no money to begin with, how much do you need to save at the end of each year to have 20% of the$250,000 purchase price? You plan to invest your savings with your broker who will allocate it into various asset classes. You hope to earn 8% on your money for the next 5 years. How much do you need to save at the end of each year? How does this change if you can only earn 6% return.

Homework Answers

Answer #1


Using 8% return on savings the years payment (PMT): $8,522.82

Using financial calculator BA II Plus - Input details:

#

FV = Future Value = -2500000*20% =

-$50,000.00

PV = Present Value =

$0.00

I/Y = Rate / Frequency =

8.000000

N = Total number of periods = Number of years x frequency =

5

CPT > PMT = Payment = Saving per year =

$8,522.82

Using 6% return on savings the years payment (PMT): $8,869.82

Using financial calculator BA II Plus - Input details:

#

FV = Future Value = -2500000*20% =

-$50,000.00

PV = Present Value =

$0.00

I/Y = Rate / Frequency =

6.000000

N = Total number of periods = Number of years x frequency =

5

CPT > PMT = Payment = Saving per year

$8,869.82

At 6% we have to save more.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Q 1 answer the problem A-F a You have $100 to invest. You can buy a...
Q 1 answer the problem A-F a You have $100 to invest. You can buy a 3 year CD that pays 7% interest a year. What is the vaue of the CD at the end of the 3 years b You want to put money in the stock market todayto pay for your child's college costs. She will be going to to college in 18 years and you want to have $250,000 saved by then. You expect to earn 8%...
Assume that you plan to retire in 30 years and hope to have $1.5 million in...
Assume that you plan to retire in 30 years and hope to have $1.5 million in savings when you retire. If you can earn 6% annually on your investments, how much do you need to save each year? If you are instead able to earn 8% annually, how much do you need to save each year? In either case, if you divide the annual amount by 12 and save that amount each month, will your final result be more or...
PLEASE SHOW ALL WORK. Thanks! How much will you have when you retire if you save...
PLEASE SHOW ALL WORK. Thanks! How much will you have when you retire if you save $8,000 each year for 45 years? Your average return will be 8%. Would you rather get $20,000 today or $2,000 at the end of each year for 15 years? Your opportunity cost of capital is 8%. Would you rather get $15,000 in 10 years or 1,000 at the end of each year for 10 years? Your opportunity cost of capital is 12%. If you...
9)As part of you financial planning and to supplement your retirement, you decided to save $3,000...
9)As part of you financial planning and to supplement your retirement, you decided to save $3,000 at the end of each year for 30 years, how much money you will have in your account if you can earn 10% ? 10) Referring to question number 9, Assume that you deposited the money at the beginning of the year, how much money you would find in your account in the 30 years? *need steps**
Take control of your life. How much do you need to save for retirement at age...
Take control of your life. How much do you need to save for retirement at age 67 today on a monthly basis. If you started 10 years ago, how much would you have had to save on a monthly basis? How many years until you retire? How many months until you retire? Assume you will earn 6% return on your savings. Assume you will need $500,000 to retire. How much do you need to save monthly to reach this goal?...
3c3. You need to accumulate $75,706 for your son's education. You have decided to place equal...
3c3. You need to accumulate $75,706 for your son's education. You have decided to place equal year-end deposits in a savings account for the next 5 years. The savings account pays 14.25 percent per year, compounded annually. How much will each annual payment be? Round the answer to two decimal places. 3b3. You plan to buy a house in 13 years. You want to save money for a down payment on the new house. You are able to place $323...
  Amy and Vince want to save ​$5,000 so that they can take a trip to Europe...
  Amy and Vince want to save ​$5,000 so that they can take a trip to Europe in four years. How much must they save each month to have the money they need if they can get 5​%, compounded​ monthly, on their​ savings?
You want to buy a house in 15 years that costs $300,000 now. Inflation is 3%....
You want to buy a house in 15 years that costs $300,000 now. Inflation is 3%. How much do you need to save each year to be able to buy the house (for cash, without a mortgage,) if you can earn 6% (compounded annually) on your savings? (Answer to the nearest cent.) How do I solve this in excel?
You are trying to decide how much to save for retirement. Assume you plan to save...
You are trying to decide how much to save for retirement. Assume you plan to save $ 5,500 per year with the first investment made one year from now. You think you can earn 12.0​% per year on your investments and you plan to retire in 38 ​years, immediately after making your last 5,500 investment. a. How much will you have in your retirement account on the day you​ retire? b.​ If, instead of investing $5,500 per​ year, you wanted...
Please use Excel to answer the following TVM questions. You can use this spreadsheet to set...
Please use Excel to answer the following TVM questions. You can use this spreadsheet to set up your calculations if you so desire. Unless indicated otherwise, assume that all of the problems are ordinary annuities (payment made at the end of the period).        Part 4 I need $1,000,000 in 20 years if I am going to retire (Fat Chance!!) I currently have $100,000 saved for my retirement (I wish!!). A slick Wallstreet investment expert with the last name of Madoff...