Question about Microsoft Excel for PC

1 Answer

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)

×

Ad

1 Answer

  • 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
  • 432 Answers

=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
    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


×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

10 Answers

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
b6298df.gif 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

2 Answers

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

1 Answer

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

1 Answer

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

1 Answer

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

2 Answers

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

2 Answers

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

1 Answer

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

1 Answer

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

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

498 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2889 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18409 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...