Question
If you bought a stock for $53 dollars and could sell it 16 years later for three times what you originally paid. What was your return on owning this stock?

PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A PICTURE FOR AN EXAMPLE!

Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Present Value = $53

Future Value = 3(53) = $159

Time Period = 16 years

Using TVM Calculation,

I = [PV = -53, FV = 159, PMT = 0, N = 16] (PMT = 0, as there is no payment in between)

I = 0.0711

So,

Return Rate = 7.11%

Please "Like" if you find this useful and comment if you have any doubts.

Add a comment
Know the answer?
Add Answer to:
If you bought a stock for $53 dollars and could sell it 16 years later for...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • What is the present value of $929 to be received in 13.5 years from today if...

    What is the present value of $929 to be received in 13.5 years from today if our discount rate is 3.5 percent? PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A PICTURE FOR AN EXAMPLE! Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is compounded at the end of each period only....

  • 1. If we place $7,654 in a savings account paying 7.5 percent interest compounded annually, how...

    1. If we place $7,654 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 8.5 years? PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A PICTURE FOR AN EXAMPLE! Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is compounded at the end of...

  • If you bought a stock for $45 dollars and could sell it fifteen years later for...

    If you bought a stock for $45 dollars and could sell it fifteen years later for three times what you originally paid. What was your return on owning this stock? Future Value (FV) 135 Present Value (PV) 45 Number of years (n) 15 Answer- I need this answered using the Insert Function and please show the functions of each cell

  • 17. Which formula in B5 will allow you to determine how many years it will take...

    17. Which formula in B5 will allow you to determine how many years it will take to quadruple your savings at 11% compounded quarterly? a)NPER(B3/B4,0.-BI,B2)/B4 b) NPER(B3/B4,0-B1,B2) c)NPER(B3 B4,0-BI,B2/B4 d)NPER(B3/B4,0-B2,B1) B4 Present Value 2 Future Value 3 Interest Rate 4 Compounding Frequency 5 Number of Years s 3,000 12,000 11% 18. What solution would you get in cell B36? 3s Variable 4 Variable2 35 Variable 3 36 a) 3.333333 b) 1462.96 c) 123.703 d) -2453.85 e) 7606629.6 833 834-835 833/834...

  • You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

    You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...

  • Project: Assume that you are 18 years old and you would like to have $10000001000000 in...

    Project: Assume that you are 18 years old and you would like to have $10000001000000 in your account by the time you are 6060 years old. A list of various savings accounts was compiled in your Excel file. Calculate the required initial (present value) deposit to the savings accounts based on the interest rates in column C compounded based on the values in column D. Choose the savings account id (column A) that requires the minimum initial investment. When you...

  • You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...

    You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000 per year for 30 years? To help you in your decision, estimate the present value of the second option assuming constant annual interest rates of 6%, 8%, and 10%. Expound on your decision within a text box. (You may use the built-in PV function within Excel) Loans: where: and, interest due at the end of each month A = payment P = principal (amount...

  • 12-3. Assume that you are about to sell property (a vacant parcel of real estate) you...

    12-3. Assume that you are about to sell property (a vacant parcel of real estate) you own but otherwise have no use for. The net-of-sales-commission selling price for the property is $470,000. You are willing to finance this transaction over a 16-year period and have told the buyer that you expect a 15% pretax return on the transaction. The buyer has asked you for a payment schedule under several alternatives. Required: 1. What will be your periodic cash receipt, to...

  • Find the Future Value of $2,000 invested to earn 15% annually 10 years from today. Please...

    Find the Future Value of $2,000 invested to earn 15% annually 10 years from today. Please fill out this table: INPUTS NPER RATE PMT PV (Negative #) FV TYPE ANSWER

  • If Penny bought a stock for $80 dollars and could sell it 15 years later for...

    If Penny bought a stock for $80 dollars and could sell it 15 years later for 4 times what she originally paid, what is Penny's return on owning this stock

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT