Difference between revisions of "Calculate Bond Yield in Excel"
m (Text replacement - "Microsoft Excel" to "Microsoft Excel") |
m (Text replacement - "== Video ==" to "") |
||
| (3 intermediate revisions by the same user not shown) | |||
| 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 == | ||
