Hi Guys

I have a problem, and am not too good in excel ... and am not a
financial wizard so please be patient :-)

The file I am working with is available 'here'
(http://www.jacqdar.com.au/bits/AMORTIZE2.xls)

(1) I need to work out the value of 2 years worth of interest on a loan
- details would be

Loan = 30,180.00
interest = 14.90% pa (calculated daily)
term of loan would be 60 months

I am currently using an ammortisation speadsheet which calculates the
interest per month etc ... at this time I simply highlight and
calculate the interest which would be two years worth ...

the problem is this calculation varies from the bank interest
calculations (although the repayments are the same and the total
interest payable amounts are the same)

The banks calculations are said to be done on the basis that the
minimum monthly repayment is met and there are no additional fees
thrown in ... so I cant understand the difference ...

(2) In addition to the above question, but working on the same loan,
traditionally amortisation tables calculate the amount of the
repayments, the interest component and the principal component ... some
include a column where you can factor in additional repayments on a row
by row basis (like the one I am referring to) the table assumes that
the payment is made on the due date ...

what I would like to be able to do is
(a) insert the actual payment dates
(b) if no payment is recorded for that period, automatically insert
an overdue fee


Any and all help greatly appreciated.

MTIA

Darrin


--
dwe
------------------------------------------------------------------------
dwe's Profile: http://www.excelforum.com/member.php...o&userid=27914
View this thread: http://www.excelforum.com/showthread...hreadid=490382