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

Question

Question

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

business finance

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

C6 A-RATE(C1,C2,C3,-C4,C5) 1 NPER 2 PMT 3 PV 4 FV 5 TYPE 6 RATE 7 Total No.of Payments Payment per period Present Value Futur

Add a comment

Answer 2

Similar Homework Help Questions

If you bought a stock for $53 dollars and could sell it 16 years later for...

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-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is...
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
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? (Enter your answer as a whole percentage (e.g. .35 should be entered as 35).) What is Penny's return on stock ownership % ?

Calculate the following time value of money problems using Microsoft® Excel®: 1. If we place $8,592.00...

Calculate the following time value of money problems using Microsoft® Excel®: 1. If we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years? 2. What is the present value of $992 to be received in 13.5 years from today if our discount rate is 3.5 percent? 3. If you bought a stock for $45 dollars and could sell it fifteen years later for three times what you...
3. If you buy a stock at $32 and sell it 4 years later at $45,...

3. If you buy a stock at $32 and sell it 4 years later at $45, what is your annual HPY? (5) 4. Bonus: If the stock in Problem #3 paid an annual dividend of $1, what would be the rate of return? (5)
3. If you buy a stock at $32 and sell it 4 years later at $45,...

3. If you buy a stock at $32 and sell it 4 years later at $45, what is your annual HPY? (5)

Today you sell your stock fund for $32,092. You bought it 5 years ago and otherwise...

Today you sell your stock fund for $32,092. You bought it 5 years ago and otherwise the account has been left alone. The stocks have earned a 13% annual rate of return. How much did you buy the stock for?
Suppose you bought stock for $1,000 and sold it for $1,800 five year later. You paid...

Suppose you bought stock for $1,000 and sold it for $1,800 five year later. You paid 28% capital gain tax. What was your after-tax rate of return?
Mr. Dow bought 100 shares of stock at $29 per share. Three years later, he sold...

Mr. Dow bought 100 shares of stock at $29 per share. Three years later, he sold the stock for $35 per share. What is his annual rate of return? Use Appendix B for an approximate answer, but calculate your final answer using the financial calculator method

20. You buy a stock for $55 today, and sell the stock one year later for...

20. You buy a stock for $55 today, and sell the stock one year later for $54, during which time a $2 dividend is paid. What is your nominal return on this stock? Bonus (+1): If inflation is 3%, what is your real rate of return (Change in purchasing power)?

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

Homework Answers

Add Answer to:
If you bought a stock for $45 dollars and could sell it fifteen years later for...

Post as a guest

Earn Coins

If you bought a stock for $53 dollars and could sell it 16 years later for...

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...

Calculate the following time value of money problems using Microsoft® Excel®: 1. If we place $8,592.00...

3. If you buy a stock at $32 and sell it 4 years later at $45,...

3. If you buy a stock at $32 and sell it 4 years later at $45,...

Today you sell your stock fund for $32,092. You bought it 5 years ago and otherwise...

Suppose you bought stock for $1,000 and sold it for $1,800 five year later. You paid...

Mr. Dow bought 100 shares of stock at $29 per share. Three years later, he sold...

20. You buy a stock for $55 today, and sell the stock one year later for...

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

Homework Answers

Add Answer to: If you bought a stock for $45 dollars and could sell it fifteen years later for...

Post as a guest

Earn Coins

Add Answer to:
If you bought a stock for $45 dollars and could sell it fifteen years later for...