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.
by Business SpreadsheetsPurpose built models for financial analysis
Business Spreadsheets offers you this business tool 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
People using this tool also downloaded
Debt / Loan Calculation Excel Template
Calculates key dloan metrics including instalment, interest expense, interest rate sensitivity and impact of prepayments58 remove_red_eyeDiscussfreeby ProjectifyRisk Premium Formula: Calculator (with Excel Template)
Calculator in Excel and formula in PDF to allow you to work out risk premium.275 remove_red_eyeDiscuss2013 Round 1: Acquisition Financing
Excel training/competition modeling challenge from the 2013 Financial Modeling World Championships25 remove_red_eyeDiscussfreeby MODELOFFModeling A Debt Schedule
A lesson on modelling a debt schedule in a financial model.152 remove_red_eyeDiscussBurn Rate Calculator
This burn rate calculator will help you work out when your business will run out of money.233 remove_red_eyeDiscussfreeby Commerce BankCalculator to Determine the Capacitor kVAR
Calculator is Excel used to determine the capacitor kVAR needed to improve PF of a single load/entire power system.324 remove_red_eyeDiscussfreeby Square DEstimating the Value of Financial Flexibility
Calculate the value of financial flexibility173 remove_red_eyeDiscussIntegrated Financial Statements
Excel financial model for integrated financial statements.469 remove_red_eyeDiscuss$49.00by Mahender K. PunhaniPowerful and Customizable Debt Module Excel Model
Powerful, highly customization and free debt calculations module.334 remove_red_eyeDiscuss$19.00by Alex MartyanovWACC (Weighted Average Cost of Capital) Excel calculator
The calculator uses the following basic formula to calculate WACC (Weighted Average Cost of Capital).910 remove_red_eyeDiscuss
More tools 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.276 remove_red_eyeDiscuss$26.00by Business SpreadsheetsBusiness Valuation Excel Model with Pro-Forma Financial Statements
The business valuation model provides an accurate and robust financial reporting structure to value proposed investments236 remove_red_eyeDiscuss$26.00by Business SpreadsheetsMultivariate Regression Analysis Excel Model with Forecasting
The Excel multivariate regression analysis performs multiple linear regression analysis for forecasting and prediction.104 remove_red_eyeDiscuss$19.00by Business SpreadsheetsProject Management with Automated Schedule Optimization
The Excel project management solution facilitates the creation of project plans and automated monitoring of progress.141 remove_red_eyeDiscuss$26.00by Business SpreadsheetsFinancial Portfolio Tracking and Valuation Excel Model Template
Excel portfolio tracking and valuation allows the ongoing tracking of the performance of financial investment portfolios221 remove_red_eyeDiscuss$22.00by Business SpreadsheetsCustomer Invoicing and Inventory Management Excel Model
A complete business invoicing system with product/service, customer and inventory management.201 remove_red_eyeDiscuss$26.00by Business SpreadsheetsReal Options Valuation and Analysis Excel Model
The Excel real options valuation and analysis provides quantification of embedded value in investment strategies.99 remove_red_eyeDiscuss$26.00by Business SpreadsheetsBusiness Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.965 remove_red_eyeDiscussTechnical Analysis Excel Template with Trading Strategy Back Testing
The technical analysis template provides analysis for SMA, ROC, MACD, RSI and Bollinger Band indicators908 remove_red_eyeDiscussProject Planning and Management Excel Model
Project management and planning model with Gantt chart scheduling and Earned Value Analysis211 remove_red_eyeDiscussCustomer Invoicing System Excel Model
Customer Invoicing and Inventory Management solution with management of customer information and product details.409 remove_red_eyeDiscussOptimal Hedging Calculation Excel Model
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.318 remove_red_eyeDiscuss
Any questions on Bond Yield Calculator Excel Model?
The user community and author are here to help. Go ahead!
