Kardi Teknomo
Kardi Teknomo Kardi Teknomo Kardi Teknomo
   
 
Research
Publications
Tutorials
Resume
Personal
Resources
Contact

 

Visit Tutorials below:
Adaptive Learning from Histogram
Adjacency matrix
Analytic Hierarchy Process (AHP)
ArcGIS tutorial
Arithmetic Mean
Bayes Theorem
Bootstrap Sampling
Bray Curtis Distance
Break Even Point
Chebyshev Distance
City Block Distance
Conditional Probability
Continued Fraction
Data Analysis from Questionnaire
Data Revival from Statistics
Decimal to Rational
Decision tree
Difference equations
Digital Root
Discriminant analysis
Divisibility
Eigen Value using Excel
Euclidean Distance
Euler Integration
Euler Number
Excel Iteration
Excel Macro
Excel Tutorial
Feasibility Study
Financial Analysis
Generalized Inverse
Generalized Mean
Geometric Mean
Ginger Bread Man and Chaos
Graph Theory
Growth Model
Hamming Distance
Harmonic Mean
Hierarchical Clustering
Independent Events
Incident matrix
Jaccard Coefficient
Kernel basis function
Kernel Regression
k-Means clustering
K Nearest Neighbor
LAN Connections Switch
Learning from data
Lehmer Mean
Linear Algebra
Logarithm Rules
Mahalanobis Distance
Market Basket Analysis
Mean Absolute Deviation
Mean and Average
Mean, median, mode
Minkowski Distance
Minkowski Mean
Monte Carlo Simulation
Multi Agent System
Multicriteria decision making
Mutivariate Distance
Newton Raphson
Non-Linear Transformation
Normalization Index
Normalized Rank
Ordinary Differential Equation
Page Rank
Palindrome
PI
Power rules
Prime Factor
Prime Number
Q Learning
Quadratic Function
Queueing Theory
Rank Reversal
Recursive Statistics
Regression Model
Reinforcement Learning
Root of Polynomial
Runge-Kutta
Scenario Analysis
Sierpinski gasket
Sieve of Erastosthenes
Similarity and Distance
Solving System Equation
Standard deviation
String Distance
Summation Tricks
Support Vector Machines
System dynamic
Time Average
Tower of Hanoi
Variance
Vedic Square
Visual Basic (VB) tutorial
What If Analysis

Financial Analysis

By Kardi Teknomo, PhD.

<Previous | Next | Content >

Time is money, people said. Upon loading the personal finance software you just purchased, it probably becomes apparent that time is money. If you put your money in the bank, you gain interest. If you borrow money from the bank or money lender, you need to pay interest. If you have $10,000 at the beginning of this year, you put in the bank that will give you 1% interest per year; you will get $10,100 at the beginning of next year. This means that your money now has bigger value than the same amount of money in the future.

The tutorial below contains the summary of most useful financial analysis.


Let is the amount of money you have at present and is the amount of money you have in the future. Let be the interest rate per year and is the total number of year you invested your money.

 

If you invest your money for a year, you have

If you invest your money for 2 years, you have

If you invest your money for years, you have compounding formula

 

(1)

 

Of course if you already get the money that you invested years ago at the same rate of interest, you can also calculate how much you money was before by discounting formula:

 

(2)

 

Suppose you know the amount of money at present and future, and you want to know how much the interest rate is, you may use this formula

 

(3)

 

If you would like to know the periods (how many years) you need to wait to get a certain amount in the future, the following formula may help:

 

(4)

 

 

Suppose you want to take some loan to the bank or money lender for your project or to buy car or house. You receive your loan now and then you need to pay the principal of the loan plus interest for years. Starting from next year, you need to pay amount of money every year. How much your annuity payment is? Formula below may help you:

 

(5)

 

 

Some insurance company may ask you to pay every year certain amount of money for years and in the future they will give you big amount of money .

 

(6)

For the project that you or developers or government do, at least you need to calculate whether that project is feasible financially and economically. Since the value of money is changing over time, we need the same basis to make the calculation equivalent. You may convert all the money as present value, or as future value, or as annuity. MS Excel functions for financial analysis below are the discrete compounding factor table converter below to help you.

Table Summary of Financial Converter

Given

Find

Formula

MS Excel Function 3)

, ,

=-FV ( , ,0, )

 

, ,

=-PV ( , ,0, )

, ,

2)

=-PV ( , , )

, ,

2)

=-PMT ( , , )

, ,

2)

 

1)

=-FV ( , , )

 

 

 

=-FV ( , , ,0,1)

, ,

2)

 

1)

=-PMT ( , ,0, )

 

 

 

=-PMT ( , ,0, , 1)

Note:

  1. Annuity is computed for payment at the beginning of the year
  2. Annuity is computed for payment at the end of the year
  3. MS Excel automatically put negative value for loan. Thus to make it positive, we put negative in the beginning of the formula.

 

<Previous | Next | Content >

 

 

This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi (2006) Tutorial on Feasibility Study. http://people.revoledu.com/kardi/tutorial/What-If-Analysis/index.html


 

 

 
© 2006 Kardi Teknomo. All Rights Reserved.
Designed by CNV Media