ABC Inc.: Financial Analysis

707 Words2 Pages

Assuming that you've just been hired as a financial analyst of ABC Inc., a Texas company specializing in mid-sized to create high fashion clothing. Since no one in this company is familiar with the basics of a financial plan, you have been asked to prepare a brief report that the CEO of the company can use to achieve at least a rudimentary understanding of the topic. To start, Collected some documents on the subject outside and use these documents to draw up a list of appropriate questions to be answered. In fact, one of the possible methods for the use of paper forms and answer questions. Now the question was drafted, you must develop the answers. Suppose a stock has performed below cost. Value Exercise is profitable if you choose to make …show more content…

P is the current price of the stock. N (d1) is the area under the normal distribution corresponding to (d1). X is the strike price. RRF is the risk ratio. t is time to mature. N (d2) is the area under the normal distribution corresponding to (d2). s, or sigma, is the volatility of stock prices, as measured by standard deviation. Looking at these equations we see that first you have to solve d1 and d2 before you can assess your options. This model is widely used by traders and the options are often considered the standard for option pricing. Many handheld computers and computer programs have this formula in permanent storage. Now we use Excel to write a "program", if you want, for models Black-Scholes valuation in Excel. At this point, we have all the inputs necessary for the resolution of the value of the call option. We will use the formula for V from above to find out the value. Complications arise only when entering N (d1) and N (d2). Remember, this is the area under the normal distribution. Fortunately, Excel is equipped with a function that can determine the cumulative probability of a normal distribution. This function is in the list of statistical functions, such as "NORMSDIST". For both N (d1) and N (d2), we will follow the same procedures for the use of this function in the formula

More about ABC Inc.: Financial Analysis

Open Document