Welcome to our website!
Cart 0

Big4WallStreet Finance Blog — excel

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.

Read more →


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.

Read more →


LEVERAGED BUYOUT ANALYSIS

Excel Financial Model Financial Modeling LBO Leveraged Buy Out Model

A leveraged buyout is the acquisition of a company using a significant amount of borrowed funds to pay for the purchase price of the company.

Read more →


Financial Modeling 101

#financial modeling corporate finance equity research excel investement banking model

Definition of financial modeling

A financial model is an excel spreadsheet that projects the 3 financial statements of a business into the future. The three financial statements are the income statement, balance sheet, cash flow statement which are based historical data and expected value drivers.

Read more →