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

excel

Seasonality and Trend Forecast with Regression in Excel

In our last article, we discussed Seasonality in Financial Modeling and Analysis. We went over an example Excel model of calculating a forecast with seasonality indexes. Today we will use regression analysis in Excel to forecast a data set with both seasonality and trend. Let’s look at the quarterly sales Read more…

By Dobromir Dikov, 6 months4 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, 7 months4 months ago

Forecast Sales Performance and Seasonality

We are approaching the second half of the year, and before we know it, it will be the time of year to start working on our projections for next year and the company’s annual budget. There are many complex and detailed models that we can utilize to forecast the sales Read more…

By Dobromir Dikov, 7 months3 months ago

Calculate Value in Use under IAS 36

The core underlying principle of IAS 36 Impairment of Assets is that an asset’s carrying value in the financial statements of the company should not exceed the highest amount the business can recover through its use or sale. The standard applies to all assets for which there are no impairment Read more…

By Dobromir Dikov, 9 months4 months ago

Introduction to Probability Distributions in Financial Modeling

In one of our recent articles, we looked into how to set up and run Monte Carlo Simulations in Excel. And we looked at some of the most common probability distributions, which we can apply to illustrate the uncertainty of our model’s variables. When we work on a financial model, Read more…

By Dobromir Dikov, 9 months4 months ago

Rolling Forecasts in Financial Planning

Let’s start by looking at why businesses need rolling forecasts. When running a business, we need to have a full view of what’s happening so that we can make the proper decisions. The best way to achieve this is to implement a budgeting and planning process. We create an expected Read more…

By Dobromir Dikov, 9 months4 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 months4 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 months4 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 months4 months ago

Using the Net Present Value (NPV) in Financial Analysis

The Net Present Value (NPV) is a profitability measure we use to figure out the present value of all expected future cash flows a project or investment will generate, including the initial capital we invest. It shows us the difference between the current value of cash inflows and outflows over Read more…

By Dobromir Dikov, 10 months4 months ago

Posts navigation

Previous 1 2 3 … 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