Question about Microsoft Excel for PC

Excel Loan to Value function format

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

Posted by on

• kenwagnerrea Apr 18, 2009

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)

×

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Master

=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

• Shane Russell Apr 19, 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

shanerussellgmailcom

where is @ and is a dot ie .

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)
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

How do you subtract on Excel

EXCEL view the operation as a function fX and you enter it like this: =MINUS(H21,H22) This will show up in the cell and on the function bar above the column letters. The cell number would have a value in it. In this example H21 would have the value 10,and H22 would have the value 5. The formula would reside say in H23 and would show the result of the operation as 5.
10
5
5 (Formula in cell is as shown above)

Sep 19, 2017 | Excel Computers & Internet

In Excel adding positive and negative numbers

Yes,

1. Select the column. (click on top of the column it will select)
2. Right Click and select Format Cells.
3. Select Currency in Category then press OK
Now just type your Numbers i.e. 571 for \$571 and -650 for -\$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

What is the loan to value ratio?

The loan to value ratio is thesize of the loan against the value of the property. A good example from Wikipedia is, "a mortgage loan in which the purchaser has made a downpayment of 20% has a loan to value ratio of 80%"

Aug 08, 2013 | Finance

Excel formula

Dalenh,
in Excel this problem dosent come normally if we set cell format to general type.
However, if you want, you can try following :-

=value(Cell1)-value(cell2)

Zulfikar Ali
09899780221

Nov 02, 2008 | Microsoft Computers & Internet

Present value of a loan

The present value of any future monthly (?) stream of payments stretching some 24 years into the future takes into account the time value of money and depends on the interest rate assumed to apply for each month throughout those 24 years.

There are formulae to calc this for an equal monthly payment and a constant interest rate, over the term but for a variable interest rate you need a spreadsheet.

In the simple case of zero interest assumed throughout the term, present value = current principal balance, but for any positive interest rate, the total present value of the future payment stream is less than the current principal balance.

Oct 06, 2008 | Texas Instruments TI-30XA Calculator

Help with simple excel calculations

Hello.

For cell B1 you can use this (without the quotes) "=A1"

Then for cell A2 and down you don't need a formula, but for B2 you can use this formula. "=(B1+A2)" Then click on that cell and drag the mouse down for as many cells as you want this formula to include and press Control and F keys to fill the formula down the column.

For your second formula, you would type 100 into D1 and in D2 you would use the formula "=D1-E1" (again, no quotes).

Feel free to let me know if you need any more clarification or if I missed something!

Jun 10, 2008 | Microsoft Excel for PC

When I enter a formula in a cell with the the insert functon device, it does not calculate itself, but shows as text

Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

Excel 2002 formula

Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Dec 03, 2007 | Computers & Internet

Getting the excel formula

Suppose the value for \$ is stored in cell A3. Your formula would look like this: =(A3+A3*0.25)*1.5

The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.

Nov 15, 2007 | Computers & Internet

Emi using excel

The function in Excel for calculating EMI is not EMI but PMT. It requires minimum three arguments. They are 1. Rate of interest (Rate), 2. Number of periods (Nper) and 3. Value of loan or present value (Pv) in that order, that is, PMT (Rate, Nper, Pv) If you want to find EMI for 1 lakh at 10% annual interest for 10 years you enter the following in one of the cells: = pmt(10%/12, 10*12, 100000)

Borrowed from http://www.hindu.com/pp/2004/02/28/stories/2004022800160500.htm

Oct 13, 2007 | Microsoft Office Standard for PC

Related Topics:

498 people viewed this question

Level 3 Expert

Level 3 Expert