Originally published: 19/04/2018 15:18
Publication number: ELQ-17577-1
View all versions & Certificate
Publication number: ELQ-17577-1
View all versions & Certificate
Bond Yield Calculator Excel Model
Automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.
Business Spreadsheets offers you this Best Practice for free!
download for free
Add to bookmarks
Further information
Calculate payment schedules and yield to maturity for bonds
Fixed interest investments
Investments that are not fixed interest in nature
Reviews
4.5 / 5 (12 votes)- 75%
- 8%
- 8%
- 8%
- -
Write a review
People using this Best Practice also downloaded
Debt / Loan Calculation Excel Template
Calculates key debt metrics including instalment, interest expense, interest rate sensitivity and impact of prepayments654Discussadd_shopping_cart$10.00by Projectify
Risk Premium Formula: Calculator (with Excel Template)
Calculator in Excel and formula in PDF to allow you to work out risk premium.454Discussadd_shopping_cartLoan Amortization Excel Calculator
Loan Amortization Calculator Excel Template will identify a monthly loan repayment schedule plan.334Discussadd_shopping_cartfreeby Someka
2013 Round 1: Acquisition Financing
Excel training/competition modeling challenge from the 2013 Financial Modeling World Championships135Discussadd_shopping_cartfreeby ModelOff
Modeling A Debt Schedule
A lesson on modelling a debt schedule in a financial model.412Discussfreeby Paul Pignataro
Interest Rate Excel Converter
This is an instantly downloadable Excel sheet to help you convert between different interest rates.466Discussadd_shopping_cartfreeby Matthew Bernath
Capitalizing Leases - Webcast
Learn how to treat leases as a financial expense instead of an operating expense330Discussadd_shopping_cartfreeby Aswath Damodaran
Debt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities618Discussadd_shopping_cart$35.00Modelling Assets - Spark Financial Model
This video covers modelling assets within the Spark Financial Model.50Discussfreeby David Liu
Total Debt/Loan Composition Analysis Excel Tool
Highly versatile Excel tool for analysing composition of debt facilities & finacial impact of changes to facilities249Discussadd_shopping_cart$35.00
More Best Practices from Business Spreadsheets
Project Management with Automated Schedule Optimization
The Excel project management solution facilitates the creation of project plans and automated monitoring of progress.542Discussadd_shopping_cart$26.00by Business Spreadsheets
Business Valuation Excel Model with Pro-Forma Financial Statements
The business valuation model provides an accurate and robust financial reporting structure to value proposed investments860Discussadd_shopping_cart$26.00Multivariate Regression Analysis Excel Model with Forecasting
The Excel multivariate regression analysis performs multiple linear regression analysis for forecasting and prediction.762Discussadd_shopping_cart$19.00Portfolio Optimization for Asset Allocation and Rebalancing
The Excel portfolio optimization model combines asset allocation and technical analysis to maximize investment returns.1,551Discussadd_shopping_cart$26.00Financial Portfolio Tracking and Valuation Excel Model Template
Excel portfolio tracking and valuation allows the ongoing tracking of the performance of financial investment portfolios708Discussadd_shopping_cart$22.00Real Options Valuation and Analysis Excel Model
The Excel real options valuation and analysis provides quantification of embedded value in investment strategies.631Discussadd_shopping_cart$26.00Customer Invoicing and Inventory Management Excel Model
A complete business invoicing system with product/service, customer and inventory management.860Discussadd_shopping_cart$26.00Business Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.2,1723add_shopping_cartProject Planning and Management Excel Model
Project management and planning model with Gantt chart scheduling and Earned Value Analysis698Discussadd_shopping_cartOptimal Hedging Calculation Excel Model
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.1,550Discussadd_shopping_cartTechnical Analysis Excel Template with Trading Strategy Back Testing
The technical analysis template provides analysis for SMA, ROC, MACD, RSI and Bollinger Band indicators5,2947add_shopping_cartCustomer Invoicing System Excel Model
Customer Invoicing and Inventory Management solution with management of customer information and product details.1,397Discussadd_shopping_cart
Any questions on Bond Yield Calculator Excel Model?
The user community and author are here to help. Go ahead!
