Template library
4 templates in this category.
Personal Finance & LoansBond Valuation Calculator
Calculate bond yields, prices, and valuations with semiannual interest payment analysis.
- Yield to maturity calculator
- Yield to call calculator
- Bond price valuation model
advanced.xlsx
Personal Finance & LoansConvertible Bonds Valuation Calculator
Calculate fair value and conversion metrics for convertible bond investments with par and call value analysis.
- Par value calculation
- Call/sale value comparison
- Conversion value analysis
advanced.xlsx
Personal Finance & LoansMarkowitz Portfolio Optimization Model
Optimize investment portfolios using Markowitz theory to balance risk and return across assets.
- Historical price series tracking for multiple assets
- Covariance matrix calculation from time-series data
- Efficient frontier visualization with charts
advanced.xlsx
Personal Finance & LoansStock Valuation Models Calculator
Calculate stock prices using variable, constant, and zero growth models plus expected returns.
- Three valuation models (variable, constant, zero growth)
- Expected return calculation for common stock
- NPV analysis integration
advanced.xlsx