Question

In: Finance

You wish to know the current price of a security. The security makes payments of $44,744.72...

You wish to know the current price of a security. The security makes payments of $44,744.72 once every month for a period of 41 years.  
If the approriate interest rate is 7.34%, then how much should this security cost?

How do I solve this, step by step on how you get the interest rates and years and then what is the formula that would be used in excel

Solutions

Expert Solution

then how much should this security cost using excel

=PV(rate,nper,pmt,fv)

=PV(7.34%/12,41*12,-44744.72,0)

=6951095.14


Related Solutions

You know you will receive $1,450 each month in Social Security payments in retirement. Assuming you...
You know you will receive $1,450 each month in Social Security payments in retirement. Assuming you will get benefits for 30 years and a real interest rate of 3%, what are those payments worth to you today?
You wish to invest and the options are as follows: Stock A Potential price 10.35 Current...
You wish to invest and the options are as follows: Stock A Potential price 10.35 Current Price 5.35 Potential price 5.35 Potential price 3.35 Stock B Potential price 3.35 Current Price 5.35 Potential price 5.35 Potential price 10.35 Suppose you buy 2 shares of Stock A. 1. What is your expected return? 2. What is the standard deviation of possible returns?
You wish to invest and the options are as follows: Stock A Potential price 10.35 Current...
You wish to invest and the options are as follows: Stock A Potential price 10.35 Current Price 5.35 Potential price 5.35 Potential price 3.35 Stock B Potential price 3.35 Current Price 5.35 Potential price 5.35 Potential price 10.35 Suppose you buy 2 shares of Stock B. 1. What is your expected return? 2. What is the standard deviation of possible returns?
1) Suppose a security has a current price of $15.00, and Investor A expects the security...
1) Suppose a security has a current price of $15.00, and Investor A expects the security price to increase by 10% in one year with 60% probability or decrease by 5% in one year with 40% probability. Investor B agrees with Investor A’s values of the future prices but feels that the likelihood of either future price occurring is 50%. Assuming a 3% annual risk-free rate, what is the price of a one-year call option that has a strike price...
A security will make payments of $25 per month, plus $1000 at maturity. The price of...
A security will make payments of $25 per month, plus $1000 at maturity. The price of this security is $2000. Which of the following is true? If the time to maturity is 7 years then the effective rate is 10.52%% If the time to maturity is 4 years then the effective rate is 10.52% If the time to maturity is 7 years then the effective rate is 10.05% If the time to maturity is 4 years then the yield to...
What is the price of a monthly bond (makes payments monthly) that has 20 years to...
What is the price of a monthly bond (makes payments monthly) that has 20 years to maturity, a coupon rate of 12.00%, and a face value of $1,000 if your required rate of return is an APR of 18.00% with quarterly compounding?
The current market price of a security is $50, the security's expected return is 15%, the...
The current market price of a security is $50, the security's expected return is 15%, the riskless rate of interest is 2%, and the market risk premium is 8%. What is the beta of the security? What is the covariance of returns on this security with the returns on the market portfolio? What will be the security's price, if the covariance of its rate of return with the market portfolio doubles? How is your result consistent with our understanding that...
The current market price of a security is $50, the security's expected return is 15%, the...
The current market price of a security is $50, the security's expected return is 15%, the riskless rate of interest is 2%, and the market risk premium is 8%. What is the beta of the security? What is the covariance of returns on this security with the returns on the market portfolio? What will be the security's price, if the covariance of its rate of return with the market portfolio doubles? How is your result consistent with our understanding that...
You would like to borrow $300,000.00 to finance a home. You wish to make monthly payments...
You would like to borrow $300,000.00 to finance a home. You wish to make monthly payments for 15 years. If the annual interest rate (APR) is quoted at 5.3%. What will the monthly payments be?
You would like to borrow $200,000.00 to finance a home. You wish to make monthly payments...
You would like to borrow $200,000.00 to finance a home. You wish to make monthly payments for 15 years. If the annual interest rate (APR) is quoted at 8.4%. What will the monthly payments be? Refinance the loan after you have made 84 payments. First what is remaining balance that is owed. Second If the new interest rate (APR) is 4% and n will be based on the remaining time period of the original loan what will be the new...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT