Thread
:
loan to value function?
View Single Post
#
2
April 18th, 2009, 07:34 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,722
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.
Teethless mama
View Public Profile
View message headers
Find all posts by Teethless mama
Find all threads started by Teethless mama