Big4WallStreet Finance Blog
Options and Real Options
American option binomial tree Black and Scholes call option distressed company European option excel excel model financial model net present value option to abandon option to delay option to expand options put option real option real options
The “what if” dimension means that in case the new idea works out well, then the company might have significant value; otherwise, it will not.
For example, considering a mining company, in case explorations are successful, then the company will be valuable; if on the other hand explorations are not successful then the company might not even be surviving.
This is exactly how options work and we can use the same option pricing theory to value such real-world cases.
Dynamic Arrays in Excel
Dynamic Dynamic Arrays Excel Range Names
Overview
Dynamic Arrays in Microsoft Excel is a game changer. To make it simple Dynamic Arrays (“DA”) allow you to work with multiple values at the same time.
This major change is expected to change the design and construction of excel models.
MERGERS AND ACQUISITIONS ANALYSIS
accretion Acquisitions Buyer dilution Financial Modeling investement banking Investment M&A Mergers model Seller synergies Transaction valuation
Overview A merger is the combination of two businesses, while an acquisition is the purchase of the ownership of one business by another. Mergers & Acquisitions models (M&A) involve analysis for scenarios in which one company (the Buyer) proposes to offer cash or its own shares in order to purchase the shares of another company (the Seller or the Target). Reasons for M&As M&A may increase the value for the buyer by creating an important value driver known as Synergies (ways to increase profit / earnings through an acquisition), among other reasons. Various reasons can lead to an M&A transaction:...
LEVERAGED BUYOUT ANALYSIS
Excel Financial Model Financial Modeling LBO Leveraged Buy Out Model
Management Accounting (Part 2)
accounting cost accounting cost per unit costs fixed costs management accounting semi variable costs variable costs