I just need a formula for a loan to value.
Sale Value is Column AE1.
1st Loan $ is Column AR1.
2nd Loan $ is Column AS1.
I just need to total the loans and divide by the sold price, but my excel is a bit rusty.
Thanks, Ken
=SUM(Cell1,Cell2,Cell3)/sold_price
Where Cell1, Cell2 and Cell3 are the cell references for the 1st, 2nd and 3rd loan fields and the sold price is the field reference for the cell that has the value for the sold price in it.
Posted on Apr 18, 2009
I would like to have a column (AW) sum the numbers in column AR and AS and divide that sum by the numbers in column AE.
In Column AW
=SUM(AR#,AS#)/AE#
Where # is the cell number so if your rows for this info starts on cell number 4 then if you do the above forumula in the AW3 cell
Then at the bottom of the AW3 cell there is a tiny box that you can use to drag the formula down all the way to the bottom of where all the values end ( assuming it will be cell 54000 or somewhere around there )
This will apply the formula above to all the relevant cells in the AW Column and will reference all the cells that are in the corresponding colum cells you referenced originally ( obviously it will increment the cell references by 1 for every row you drag it down by so when you drag it down the AW column it will be something like
=SUM(AR4,AS4)/AE4
=SUM(AR5,AS5)/AE5
=SUM(AR5,AS5)/AE5
etc
This would provide me a total of the 2 loans, divided by the sale price that when expressed in % would be a Loan to Value.
I have about 45,000 properties to assess the LTV %.
If thats not what you mean then drop me an email to
shanerussell
where
with an example spreadsheet with example data that covers a few rows and about 10 rows or so just so its a simplistic example and explain in the email reffering to the example spreadsheet
×
Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!
Posted on Jan 02, 2017
Sep 19, 2017 | Excel Computers & Internet
Apr 02, 2008 | Computers & Internet
Aug 08, 2013 | Finance
Nov 02, 2008 | Microsoft Computers & Internet
Oct 06, 2008 | Texas Instruments TI-30XA Calculator
Jun 10, 2008 | Microsoft Excel for PC
Dec 03, 2007 | Microsoft Excel for PC
Dec 03, 2007 | Computers & Internet
Nov 15, 2007 | Computers & Internet
Oct 13, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
498 people viewed this question
Usually answered in minutes!
That didn't quite work for me.
I would like to have a column (AW) sum the numbers in column AR and AS and divide that sum by the numbers in column AE.
This would provide me a total of the 2 loans, divided by the sale price that when expressed in % would be a Loan to Value.
I have about 45,000 properties to assess the LTV %.
IF excel actually allowed mathematical expression it would be
LTV = (1st loan $ + 2nd loan $) / Sale Value = AW
= (AR+AS)/AE = AW
Failing that ability, I can make it a 2 step of just
Loan Tl = (1st+2nd) = AW
AR+AS
then
LTV = AW/AE = AX
(Tl Loan divided by Sale Value)
×