+ Reply to Thread
Results 1 to 2 of 2

Car Leasing Equity Calculation Help

  1. #1
    Registered User
    Join Date
    12-05-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    16

    Car Leasing Equity Calculation Help

    Hi All, Im sure this isnt all that tough- but im stumped.

    I have attached a workbook. Basically, what I need to do is populate the column "assumed value". In order to do this, I created three tables at the far right of the worksheet. I labeled the vehicles model and year, and then placed values based on mileage assumptions. I used broad groupings because i couldnt figure out any easier way (figured 10k miles per year). What i'd like to do is have the workbook recognize the model, year and assumed mileage (highlighted the columns yellow- H is what I need, I, J, K is the data im using) and produce an assumed value based on this. Any help would be greatly appreciated. Thanks in advance!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Car Leasing Equity Calculation Help

    Glh222, Good evening.

    Initially I must advise you that there are many numeric fields with values in text format.
    This creates serious problems of data consistency and research.

    I fix two rows of your spreadsheet to introduce you to my suggestion to solve your question.
    I hope you can use this hint.

    With a New Table I suggest you this formula:

    H2 -->
    =HLOOKUP(K2,$Z$12:$AF$15,MATCH(I2&"-"&J2,$Z$11:$AF$11,0),TRUE)

    Take a look at your example with this formula implemented:
    30-09-2015_LeasePort_NoNames-OK.xls

    Is that what you're looking for?
    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marcílio Lobão

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cost of equity
    By peach3379 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-03-2014, 05:53 PM
  2. Equity Screening via Relative Value Calculation with Many Indexes
    By YuraB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2012, 09:53 AM
  3. Leasing Upfront payment Question
    By Kelly1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2012, 02:25 PM
  4. Help with this equity calculator, please !
    By Mr.Nob0OOdy in forum Excel General
    Replies: 3
    Last Post: 06-20-2012, 11:37 AM
  5. Replies: 3
    Last Post: 06-02-2012, 07:50 PM
  6. Home Equity Loan
    By scantor145 in forum Excel General
    Replies: 1
    Last Post: 01-10-2012, 01:24 PM
  7. [SOLVED] Equity buildup calculation
    By JimDandy in forum Excel Formulas & Functions
    Replies: 39
    Last Post: 09-06-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1