How to seasonal forecast with formulas in Excel

How to seasonal forecast with formulas in Excel

Big or small, all business operations need forecasting. Forecasting can be either qualitative or quantitative. In the end, you should estimate future incomes and expenses to draw up a budget. Since each business sector and the company have their own dynamics, there is...
Function: RRI

Function: RRI

The Excel RRI function is a Financial function that calculates and returns the equivalent interest rate for the growth of an investment. When given a present value, a future value, and the number of periods for an investment, you can calculate the rate of return for...
Function: RATE

Function: RATE

The Excel RATE function is a Financial formula that calculates and returns the interest rate for a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel RATE function and also go over some tips and error...
Function: FV

Function: FV

The FV Excel function is a Financial formula that calculates and returns the future value of a loan or an investment, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel FV function and also go over some tips and...
Function: NPER

Function: NPER

The NPER function is a Financial formula that calculates and returns the number of repayment periods of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel NPER function and also go over some tips and error...
Function: PMT

Function: PMT

The PMT is a Financial function that calculates and returns the repayment amount of a loan based on constant payments and a constant interest rate. This formula is commonly used in amortization schedule Excel models. In this guide, we’re going to show you how to use...
Basics of Financial Modeling in Excel

Basics of Financial Modeling in Excel

Wikipedia defines financial modeling as “the task of building an abstract representation (a model) of a real world financial situation.” Many of these financial models are built in Excel. In this article, I will outline the basic principles of financial modeling in...