Big4WallStreet Finance Blog — Excel

Voyage estimation for Dry Cargo

March 03, 2023 • bunkers • costs • estimation • excel • freight • fuel • maritime • model • shipping • voyage

Voyage estimation for dry cargo is a complex task that requires careful consideration of all the factors involved. Voyage Estimation is the calculation of the profit or loss that a ship will make from a proposed voyage charter. It involves analyzing the costs of chartering the vessel, fuel, port charges, cargo loading and unloading fees, and other related expenses. The ship owner or charterer then compares the estimated cost of the voyage with the expected revenue from the charter to determine the potential return for the voyage. It involves estimating the cost, time and resources needed to complete a voyage from one port to another, considering any potential risks or delays along the way. To perform this task effectively, there are several steps that must be taken to accurately calculate these estimates...

Financial Ratios in Excel

July 06, 2021 • Asset Management Ratios • Debt Management Ratios • excel • excel model • financial analysis • financial ratios • financial statement analysis • Liquidity Ratios • Market Value Ratios • Profitability Ratios

Financial statement analysis is useful to anticipate future conditions and, most important, as a starting point for developing strategies that influence a company's future course of business.

An important step toward achieving these goals is to analyze the firm's financial ratios. Ratios are designed to highlight relationships between the financial statement accounts. These relationships begin to reveal how well a company is doing in its primary goal of creating value for its shareholders.

Options and Real Options

February 23, 2021 • 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

December 02, 2020 • 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.

LEVERAGED BUYOUT ANALYSIS

November 18, 2020 • 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.