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
Cap Table with Investor Returns and Charts
29
0
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Array Formulas in Excel
527
54
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
Price Position Analysis
1,206
1
Every business needs to know how the prices of its products or services stand against the competition. Comparing prices of…
Inventory Analysis and Management
1,079
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
1,489
2
This set of tools, methods and techniques will help you calculate and depict variances. A special focus is made on…
Measuring and Modelling Seasonality
1,330
0
Many businesses are affected by seasonal demand changes. They cause their revenues, expenses, inventory and resource requirements change through the…
See All