Difference between revisions of "Calculate Bond Yield in Excel"
m (importing article from wikihow) |
m (Text replacement - "== Video ==" to "") |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
A bond yield calculator, capable of accurately tracking the current yield, the yield to maturity, and the yield to call of a given bond, can be assembled in a Microsoft Excel spread sheet. Once created, the desired data will automatically appear in designated cells when the required input values are entered. This article provides step-by-step instructions on how to create a bond yield calculator in an Excel spreadsheet. | A bond yield calculator, capable of accurately tracking the current yield, the yield to maturity, and the yield to call of a given bond, can be assembled in a Microsoft Excel spread sheet. Once created, the desired data will automatically appear in designated cells when the required input values are entered. This article provides step-by-step instructions on how to create a bond yield calculator in an Excel spreadsheet. | ||
| − | [[Category:Microsoft Excel]] | + | [[Category: Microsoft Excel]] |
== Steps == | == Steps == | ||
| Line 31: | Line 31: | ||
#Cross-reference the results of the input values. If the formulas have been entered correctly, the following results will appear in column B, under the Bond Yield Calculations heading. The Current Yield should be 6.0%. The Yield to Maturity should read 6.0%, and the Yield to Call should read 9.90%. If the values in the bond yield calculator match the figures listed above, the formulas have been entered correctly. If the values do not match, double check that the formulas have been entered correctly. | #Cross-reference the results of the input values. If the formulas have been entered correctly, the following results will appear in column B, under the Bond Yield Calculations heading. The Current Yield should be 6.0%. The Yield to Maturity should read 6.0%, and the Yield to Call should read 9.90%. If the values in the bond yield calculator match the figures listed above, the formulas have been entered correctly. If the values do not match, double check that the formulas have been entered correctly. | ||
| − | + | ||
| − | + | ||
== Related Articles == | == Related Articles == | ||
