LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default loan to value function?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to calculate average loan period of a 5 year loan Jayant Excel Worksheet Functions 2 March 25th 08 11:47 PM
is there any way of using a function for loan emi calculation? Ritu[_2_] Excel Worksheet Functions 1 May 10th 07 05:37 AM
Loan Compound Interest Function BOBODD Excel Worksheet Functions 2 September 19th 06 09:01 AM
biweekly payments on a loan using Pmt function Payment Function Excel Discussion (Misc queries) 1 August 7th 06 09:35 PM
loan amortization template with loan start date AND first payment Lisa W Excel Discussion (Misc queries) 0 January 30th 06 10:27 PM


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"