Finding the down payment

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:37 PM GMT


we are working on a spreadsheet that has the selling price, loan term, interest rates, % required for a down payment. Now we have to sue vlookup in order to find the down payment, amount to be financed, and the monthly payment. I understand how to find all of them the old fashion way as they say, but I don't understnad how to do the so called: =vlookup what am I suppose to be using in all these so called formulas? I am confused.


I have created sample files for you, Click or Copy and paste the below link in web browser to download the Example file.

Scroll the mouse button to the bottom of the website and click Download

The File Name is: Vlookup Detailed

Have a look in the below link to know more about Vlookup and how to use it.


©2024 eLuminary LLC. All rights reserved.