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
Startup Cap Table
409
21
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cap Table with Investor Returns, Derivative Instruments and Charts
451
0
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cost-Volume-Profit (Breakeven) Analysis
636
50
Cost-Volume-Profit analysis is one of the fundamental types of analysis which deals with product profitability. It classifies the costs into…
“Budget-versus-Actual” Charts
498
1
This file contains magazine-quality charts in Excel to illustrate variances between budgeted and actual figures.  Professionally designed charts in business…
Due Diligence Tools and Methods
1,023
2
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
1,319
0
Introduced in 1976, this method has now become one of the most popular approaches to perform pricing analysis. The method…
See All