An Example of Data Analysis in the Calculus Using Microsoft Excel

 

An Illustration of Data Analysis in the Financial Management Domain Using Microsoft Excel

 

A Predictive Model to Discover the Relationship among Stocks, Forex, and Commodities: Application of DEMATEL Method

 

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.

A Template for Income statement simulation model

 

A Template for Discounted Cash Flow Analysis (DCF) plus Monte Carlo Method to Analyze Share Price of a Company