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
Travel Budget
136
0
Travel expenses make up an important and material part of a company’s budget. This template built on the highest professional financial modeling…
HR Analytics and Dashboard
864
0
This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and…
Startup Cap Table
1,515
136
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
1,612
3
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
1,828
142
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
1,545
10
This file contains magazine-quality charts in Excel to illustrate variances between budgeted and actual figures.  Professionally designed charts in business…
See All