View Single Post
  #2  
Old April 18th, 2009, 07:34 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
 
Posts: 3,722
Default loan to value function?

=(AR1+AS1)/AE1


"KenWagnerRealtor" wrote:

Hi,

I'm a bit rusty on excel functions.

1st Loan $ is AR1
2nd Loan $ is AS1
Sale Value is AE1

and mathematically LTV = (1st+2nd)/Sale in a percentage format.