Question

Trace plans to retire in 3 years with $518,000 in his account. If he receives payments...

Trace plans to retire in 3 years with $518,000 in his account. If he receives payments of $123,400 per year and he receives his first $123,400 payment in 3 years and his last $123,400 payment in 7 years, then what is the expected annual return for his account? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Using excel Rate function to derive the rate as in image attached.

Nper = 5 (Years 3 to 7)

PV = -518000

PMT = 123400

Type = Beginning of period

Find Rate as 9.60%

Answer = 0.0960

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Celeste just borrowed 31,500 dollars. She plans to repay this loan by making equal quarterly payments...
Celeste just borrowed 31,500 dollars. She plans to repay this loan by making equal quarterly payments of 1718.3 dollars for 24 quarters. If she makes her first quarterly payment later today, then what is the quarterly interest rate on the loan? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.
1) Celeste just borrowed 30,000 dollars. She plans to repay this loan by making equal quarterly...
1) Celeste just borrowed 30,000 dollars. She plans to repay this loan by making equal quarterly payments of 2,458.16 dollars for 15 quarters. If she makes her first quarterly payment later today, then what is the quarterly interest rate on the loan? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. 2) A trampoline park is worth 255,011 dollars. It is expected to produce equal monthly cash...
Chaz owns investment A and 1 share of stock B. The total value of his holdings...
Chaz owns investment A and 1 share of stock B. The total value of his holdings is $350. Stock B is expected to be priced at $90.32 in 2 years, is expected to pay dividends of $12.32 in 1 year and $15.93 in 2 years, and has an annual expected return of 9.60 percent. Investment A has an expected return of R and is expected to pay $63 per year for a finite number of years such that its first...
Gwen plans to retire in 3 years with $426,000 in her account, which has an annual...
Gwen plans to retire in 3 years with $426,000 in her account, which has an annual return of 6.29 percent. If she receives annual payments of X, with her first payment of X received in 4 years and her last payment of X received in 9 years, then what is X, the amount of each payment?
Bob has nothing in his retirement account. However, he plans to save 8,000 per years in...
Bob has nothing in his retirement account. However, he plans to save 8,000 per years in his retirement account for each of the next 17 years. His first contribution to his retirement account is expected in 1year, Bob expects to earn 6.3% per year in his retirement account. Bob plans to retire in 17 years immediately after making his last 8,000 contribution to his retirement account. In his retirement, Bob plans to withdraw 35,000 per year for as long as...
4. A. A stock had returns of 21.70% (1 year ago), 2.40% (2 years ago), X...
4. A. A stock had returns of 21.70% (1 year ago), 2.40% (2 years ago), X (3 years ago), and ‑14.60% (4 years ago) in each of the past 4 years. Over the past 4 years, the geometric average annual return for the stock was 2.85%. Three years ago, inflation was 3.62% and the risk-free rate was 4.47%. What was the real return for the stock 3 years ago?  Answer as a rate in decimal format so that 12.34% would be...
Norma has one share of stock and one bond. The total value of the two securities...
Norma has one share of stock and one bond. The total value of the two securities is 1,321.7 dollars. The stock pays annual dividends. The next dividend is expected to be 4.55 dollars and paid in one year. In two years, the dividend is expected to be 8.18 dollars and the stock is expected to be priced at 102.07 dollars. The stock has an expected return of 14 percent per year. The bond has a coupon rate of 10.9 percent...
39. Celeste just borrowed 34,200 dollars. She plans to repay this loan by making equal quarterly...
39. Celeste just borrowed 34,200 dollars. She plans to repay this loan by making equal quarterly payments of 1,897.65 dollars for 24 quarters. If she makes her first quarterly payment later today, then what is the quarterly interest rate on the loan? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.
9. A. If the market premium is 9.65 percent, the risk-free rate is 3.88 percent, the...
9. A. If the market premium is 9.65 percent, the risk-free rate is 3.88 percent, the inflation rate is 2.63 percent, and Middlefield Motors common stock has a beta of 0.58, then what is the expected return for Middlefield Motors stock? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. B. If the expected return on the market is 14.36 percent, inflation is 2.74 percent, the market...
Siri plans to retire in 5 years with 441,000 dollars in her account, which has an...
Siri plans to retire in 5 years with 441,000 dollars in her account, which has an annual return of 15.69 percent. If she receives annual payments of X, with her first payment of X received in 5 years and her last payment of X received in 8 years, then what is X, the amount of each payment?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT