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
2013 Round 1: Acquisition Financing
Excel training/competition modeling challenge from the 2013 Financial Modeling World Championships201Discussadd_shopping_cartDebt / Loan Calculation Excel Template
Calculates key debt metrics including instalment, interest expense, interest rate sensitivity and impact of prepayments800Discussadd_shopping_cart$20.00
by Projectify
Risk Premium Formula: Calculator (with Excel Template)
Calculator in Excel and formula in PDF to allow you to work out risk premium.506Discussadd_shopping_cartLoan Amortization Excel Calculator
Loan Amortization Calculator Excel Template will identify a monthly loan repayment schedule plan.452Discussadd_shopping_cartfree
by Someka
Modeling A Debt Schedule
A lesson on modelling a debt schedule in a financial model.473Discussfree
by Paul Pignataro
Multiple Debt Calculator Model
Calculate your debt schedule for all of your loans at once87Discussadd_shopping_cartfree
by AZ Finserv
An Introduction to Leverage Analysis
A quick and informative video on leverage analysis.176DiscussCapitalizing Leases - Webcast
Learn how to treat leases as a financial expense instead of an operating expense440Discussadd_shopping_cartfree
by Aswath Damodaran
Debt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities889Discussadd_shopping_cart$35.00
by Projectify
Modelling Assets - Spark Financial Model
This video covers modelling assets within the Spark Financial Model.66Discussfree
by David Liu
More Best Practices from Business Spreadsheets
Portfolio Optimization for Asset Allocation and Rebalancing
The Excel portfolio optimization model combines asset allocation and technical analysis to maximize investment returns.2,2234add_shopping_cart$26.00
by Business Spreadsheets
Project Management with Automated Schedule Optimization
The Excel project management solution facilitates the creation of project plans and automated monitoring of progress.656Discussadd_shopping_cart$26.00
by 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 investments1,081Discussadd_shopping_cart$26.00
by Business Spreadsheets
Multivariate Regression Analysis Excel Model with Forecasting
The Excel multivariate regression analysis performs multiple linear regression analysis for forecasting and prediction.1,192Discussadd_shopping_cart$19.00
by Business Spreadsheets
Financial Portfolio Tracking and Valuation Excel Model Template
Excel portfolio tracking and valuation allows the ongoing tracking of the performance of financial investment portfolios900Discussadd_shopping_cart$22.00
by Business Spreadsheets
Real Options Valuation and Analysis Excel Model
The Excel real options valuation and analysis provides quantification of embedded value in investment strategies.838Discussadd_shopping_cart$26.00
by Business Spreadsheets
Customer Invoicing and Inventory Management Excel Model
A complete business invoicing system with product/service, customer and inventory management.1,307Discussadd_shopping_cart$26.00
by Business Spreadsheets
Business Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.2,4123add_shopping_cartProject Planning and Management Excel Model
Project management and planning model with Gantt chart scheduling and Earned Value Analysis811Discussadd_shopping_cartOptimal Hedging Calculation Excel Model
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.2,224Discussadd_shopping_cartTechnical Analysis Excel Template with Trading Strategy Back Testing
The technical analysis template provides analysis for SMA, ROC, MACD, RSI and Bollinger Band indicators7,1917add_shopping_cartCustomer Invoicing System Excel Model
Customer Invoicing and Inventory Management solution with management of customer information and product details.1,617Discussadd_shopping_cart
Any questions on Bond Yield Calculator Excel Model?
The user community and author are here to help. Go ahead!
