Overview

In this post we will look at:

a) Extending or shortening time schedules

b) Modelling interest expense

c) Planning orders, deliveries and payments

d) Calculating rental revenue

e) Calculating timing flags for fractional periods

f) Determining beginning, ending and average foreign exchange.

g) Transforming a monthly or quarterly report into annual.

h) Grouping and summing up lists with dates.

i) Miscellaneous formulae

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Inventory Analysis and Management
348
0
In this publication I will discuss how to analyze inventory, communicate findings of your analysis and make practical use of…
Price-Volume-Mix Analysis
537
1
This set of tools, methods and techniques will help you calculate and depict variances. A special focus is made on…
Measuring and Modelling Seasonality
611
0
Many businesses are affected by seasonal demand changes. They cause their revenues, expenses, inventory and resource requirements change through the…
Interim Budgeting (Reforecasting)
782
1
Virtually every company develops its annual budgets. The budgets are compiled before the beginning of the financial year of a…
Profit Distribution and Carried Interest Waterfall
798
1
This template describes real-world mechanisms of distributing profits between project participants. It starts with modeling a distribution to a preferred…
Descriptive statistics for grouped (weighted) data
1,233
100
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
See All