Tools for students and seminar attendees:
Present Value and Future Value of $1 & Annuity over n Periods
(for manual calculations) ![]()
|
In Finance - having 4 out of 5 variables, you can always solve for the 5th.
This spreadsheet is a template to assist you.
This spreadsheet is a template to assist you.

pv_fv_pmt_i_n.xlsx |
An itemized loan amortization schedule.

loan_amortization_schedule.xlsx |
Three different methods to review the compounding of interest over time.

compounding.xlsx |
Methods to review the discounting of interest over time may be found
here:
here:

discounting.xlsx |
Break-even calculator:

breakeven_methods.xls |
A cash budget template can be found here:

simple_cash_budget_example.xlsx |
Tools to compare two projects can be found here
(also useful (NPV) Net Present Value & (IRR) Internal Rate of Return):
(also useful (NPV) Net Present Value & (IRR) Internal Rate of Return):

project_compare_npv_irr.xlsx |