Magnimetrics
  • Home
  • Features
  • About
  • Team
  • Blog
  • Get in Touch
  • Survey
  • Online Courses
    • FREE Intro to Google Data Studio
    • FREE Introduction to Excel
    • Budget Modeling in Excel

analysis

Understanding the Gordon Growth Model for Stock Valuation

Understanding the Gordon Growth Model for Stock Valuation The Gordon Growth Model (GGM) is a method for the valuation of stocks. Investors use it to determine the relationship between value and return. The model uses the Net Present Value (NPV) of future dividends to calculate assets’ intrinsic value. It’s the Read more…

By Dobromir Dikov, 1 month1 month ago

Vacation Days and Unused Paid Leave Accrual

When a company hires employees, they provide it with services. In turn, the company, as their employer, reimburses their time spent with a remuneration package. This usually consists mostly of a salary but can include various other benefits, some of which may be mandated by law or local legislation. One Read more…

By Dobromir Dikov, 3 months3 months ago

Accounts Receivable Aging Report in Excel

The Receivables Aging (or Ageing, if you prefer British English) report is a tool that lists all unpaid customer balances by pre-defined date ranges (buckets). It shows the relationship between open invoices and their due dates. It is the primary tool to determine overdue balances for collection. It’s useful for Read more…

By Dobromir Dikov, 4 months3 months ago

Hypothesis Testing for Complete Beginners

Gathering data in itself is meaningless unless we can analyze it and draw powerful insights. What makes data interesting is the ability to evaluate and interpret it. Hypothesis testing refers to a term in statistics where we, as the analysts, evaluate an assumption related to a data set parameter. Based Read more…

By Dobromir Dikov, 4 months3 months ago

Understand the Market Value of Equity

The Market Value of Equity of the company, also known as Market Capitalization, is the total monetary value of the firm’s equity. We calculate it as the current stock price multiplied by the number of outstanding shares. Therefore the MVE continually changes, as these two values are quite volatile. Analysts Read more…

By Dobromir Dikov, 5 months3 months ago

Introduction to Seasonality in Financial Analysis and Modeling

Seasonality is a characteristic of time-series where the data has predictable and somewhat regular fluctuations that repeat year over year. It is safe to assume that any pattern of data changes over one-year periods represents seasonality. It is usually driven by weather or commercial seasons. We have to differentiate the Read more…

By Dobromir Dikov, 6 months3 months ago

Consolidation of Financial Statements: A Brief Introduction

In finance terms, consolidation refers to the incorporation of the financial statements of all subsidiaries into the financial statements of the parent company. Consolidation of financial statements requires the parent company to integrate and combine all its financials to create a standard-form income statement, balance sheet, and cash flow statement, Read more…

By Dobromir Dikov, 7 months3 months ago

Weighted Average Cost of Capital (WACC) Case Study: Amazon (AMZN)

With a reach in e-commerce, cloud computing, digital streaming, and artificial intelligence, Amazon is now one of the largest corporations in the world. Analysts often refer to it as one of the most influential economic forces in the world. Alongside Google, Microsoft, and Apple, Amazon is considered one of the Read more…

By Dobromir Dikov, 9 months3 months ago

Value Chain Analysis Break-down

The primary purpose of any business is to produce goods or provide services in a way that they have a higher value for the customers than the original cost for the firm. Companies engage in numerous activities while converting inputs to outputs. Porter’s Value Chain helps us create a clear Read more…

By Dobromir Dikov, 10 months3 months ago

Opportunity Cost in Financial Modeling and Analysis

Introduction Opportunity cost represents the benefits the business misses out on when picking between alternatives. When we have two desirable options, the benefit from the one not chosen is our opportunity cost. These costs are usually the result of bottlenecks in business processes. Therefore, finance professionals use Opportunity Cost analysis Read more…

By Dobromir Dikov, 10 months3 months ago

Posts navigation

1 2 … 5 Next
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

  • Home
  • Features
  • About Magnimetrics
  • Meet the Team
  • Get in Touch
  • Survey
  • Privacy Policy
  • Blog
  • Excel Downloads
Magnimetrics is made in Plovdiv, Bulgaria.
Hestia | Powered by WordPress