This blog is about new ideas which give us new methods and new theorems as the tools to break complex problems in all fields such as Strategic Management, Engineering, Financial Management and so on and finally to solve these problems in the real world in which there is the balance of the cost and the time.
A Model for Analysis of Bond Valuation By Using Microsoft Excel plus VBA
Monday, April 14, 2025
Friday, April 11, 2025
Monday, April 7, 2025
Saturday, April 5, 2025
Wednesday, April 2, 2025
Tuesday, April 1, 2025
Sunday, March 30, 2025
Friday, March 28, 2025
Thursday, March 27, 2025
Tuesday, March 25, 2025
Saturday, March 22, 2025
Wednesday, March 19, 2025
Tuesday, March 18, 2025
Monday, March 10, 2025
Sunday, March 2, 2025
Saturday, February 22, 2025
Thursday, February 20, 2025
Tuesday, February 11, 2025
Tuesday, January 21, 2025
A Simulation Model for Analysis of Bond Valuation
A bond is a type of asset in which a government or a company
issues these securities as a long-term debt to borrow money from institutional
investors (banks) or the public sector.
This model's goal is to examine a bond's value using seven
independent variables: the bond's current price (bond value), year-to-date
(YTM), coupon rate, year, month, day, and time period (n).
This model analyzes seven independent variables
non-concurrently while simultaneously solving an algorithm of an equation with
three independent variables and producing the maximum and minimum of this
function for a specified domain and range.
Finding the YTM (return rate) for a current price equal to
bond value without the need for trial and error is one of the most important
uses of this approach.