Using a spreadsheet to calculate yield to maturity what is, Ask an Expert

Finance

Using a Spreadsheet to Calculate Yield to Maturity. What is the yield to maturity on the following bonds; all have a maturity of 10 years, a face value of $1,000, and a coupon rate of 9 percent (paid semiannually). The bonds' current market values are

$945.50, $987.50, $1,090.00, and $1,225.875, respectively. Answers: Market Value $945.50; YTM = 9.87% $987.50; YTM = 9.19% $1,090.00; YTM = 7.69% $1,225.875; YTM = 5.97% I already know the answers to these problems and I can easily calculate them using the

Texas Instruments BA II PLUS Financial Calculator. However, I do not know how to get the above answers using Microsoft EXCEL 2010. Can you do a spread sheet using the above information in the problem stem and then explain in detail each step of how you enter

the information in EXCEL and then what drop down menu and keys in Microsoft EXCEL 2010 to press to get the final Yield to Maturity for each of the different bond values listed above?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M91359735
Price:- $40

Guranteed 36 Hours Delivery, In Price:- $40

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Question - in an article on edmunds website called

Question - In an article on Edmunds website called "Strategies for Smart Car Buying," Philip Reed highlights the need to focus on resale value. After 3 years, some cars are worth 55% of their original value, some only 20 ...

When when is it appropriate to use the wac as the discount

When when is it appropriate to use the wac as the discount rate in capital budgeting

What would be examples of valid selection methods used by

What would be examples of valid selection methods used by the human resource department to ensure selecting the appropriate candidate for a job.

Ebeneezer scrooge jasper currently manages a 500000

Ebeneezer Scrooge Jasper currently manages a $500,000 portfolio. He is expecting to receive an additional $250,000 from a new client. The existing portfolio has a required return of 10.75 percent. The risk-free rate is 4 ...

Walmart has issued a dividend for the past five years in

Walmart has issued a dividend for the past five years. In 2013 it issued a $1.00 dividend. This year it is expected to issue a $1.50 annual dividend. Please calculate the rate the dividend has grown (two decimals please)

Mae has a financial document return of 010 per year over

Mae has a financial document return of 0.10 per year over the next 30 years. She has wants to invest in Stocks 1, 2, and 3, with 25 percent in Stock 1, 50 percent in Stock 2, and 25 percent in Stock 3. If Stocks 1 and 2 ...

The veggie hut has net income of 26611 total equity of

The Veggie Hut has net income of $26611, total equity of $101668, and total assets of $168714. The retention ratio is 0.11. What is the internal growth rate? Input your answer as a decimal rounded to 4 places (i.e., 1% = ...

Industries recently commissioned management consultants to

Industries recently commissioned management consultants to estimate an appropriate rate for investment projects with the same risk as the firm. Unfortunately, part of the report was lost, and you have been asked to calcu ...

For any normal distribution 68 percent of the observations

For any normal distribution, 68 percent of the observations should fall within plus or minus one standard deviation of the mean. This means 68 percent of annual Tbill returns should fall within 1.3% and 6.9%.

The required rate of return on a certain bond changes from

The required rate of return on a certain bond changes from 12 percent to 8 percent, causing the price of the bond to change from $900 to $1,100. Determine the bond's price elasticity.

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert