From: me
Date: October 22, 2008 12:17:28 AM PDT
To: you
Subject: Amortization schedule
Amortization schedule for 360.0000 payments of 2098.43 against a starting principal of 350000.00 at an interest rate of 0.5000% per period.
Payments are credited at the end of each period.
PeriodInterestPrincipalBalance
1220883.134298.03345701.97
2420618.044563.12341138.85
3620336.594844.57336294.28
4820037.795143.37331150.91
6019720.565460.60325690.31
7219383.755797.41319892.90
8419026.196154.97313737.93
9618646.566534.60307203.33
10818243.526937.64300265.69
12017815.627365.54292900.15
13217361.337819.83285080.32
14416879.018302.15276778.17
15616366.968814.20267963.97
16815823.319357.85258606.12
18015246.159935.01248671.11
19214633.3710547.79238123.32
20413982.8011198.36226924.96
21613292.1211889.04215035.92
22812558.8212622.34202413.58
24011780.3013400.86189012.72
25210953.7614227.40174785.32
26410076.2515104.91159680.41
2769144.6016036.56143643.85
2888155.5117025.65126618.20
3007105.3918075.77108542.43
3125990.5219190.6489351.79
3244806.8820374.2868977.51
3363550.2421630.9247346.59
3482216.0822965.0824381.51
360799.6524381.51-0.00
(prepared by Calc-12E v2.0.RC4)
From: me
Date: October 22, 2008 10:59:20 PM PDT
To: you
Subject: Net Present Value (formatted for Swiss/French preferences)
The net present value of 7 cash flows at an interest rate of 13.50% per period is 907.77.
CFRepeatAmount
0.001.00-79'000.00
1.001.0014'000.00
2.001.0011'000.00
3.003.0010'000.00
4.001.009'100.00
5.002.009'000.00
6.001.004'500.00
7.001.00100'000.00
(prepared by Calc-12E v2.0.RC4)
From: me
Date: October 22, 2008 11:12:38 PM PDT
To: you
Subject: Simple Interest calculation (formatted for India)
Accrued interest on a 360 day basis: -1,34,16,666.67
Accrued interest on a 365 day basis: -1,32,32,876.71
Total, interest plus principal: -71,34,16,666.67
(prepared by Calc-12E v2.0.RC4)