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
Due Diligence Tools and Methods
306
1
A prospective investor is concerned about the target’s: 1. Quality of earnings 2. Adequacy of working capital 3. Unrecorded or…
Van Westendorp’s Pricing Method
498
0
Introduced in 1976, this method has now become one of the most popular approaches to perform pricing analysis. The method…
Cap Table with Investor Returns and Charts
758
2
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Array Formulas in Excel
1,565
194
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
Price Position Analysis
2,159
2
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,846
0
In this publication I will discuss how to analyze inventory, communicate findings of your analysis and make practical use of…
See All