Reply to thread

Message: [QUOTE="Norman Harker, post: 3296920"] Hi Bob! By all means deduct the amount of the loan to get the cost net of principal repayment as opposed to the total of repayments. What you regard as the cost at future dates depends upon whether or not you are only looking forwards or whether you are looking both forwards and backwards. If looking forwards only, you compare the future payments with the outstanding balance of the loan. The complicating factor would be where the set up costs were rolled into the loan. There are different approaches to handling that but I suppose I'd tend towards a ratio approach adopting as the ratio the commencing loan / fees ratio. -- Regards Norman Harker MVP (Excel) Sydney, Australia [email]njharker@optusnet.com.au[/email] Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. [/QUOTE]