PLEASE READ FIRST...
The OLDER the "Previous CLOSE" date is the HIGHER percentage total INCREASE will I need.
I need to calculate HIGHEST PERCENTAGE INCREASE taking these factors into consideration:
1. Difference in Previous CLOSE VS. TODAYS DATE = in years, months... or PERCENTAGE DIFFERENCE [high to low]
2. Difference in Previous VALUE VS. ACTUAL VALUE = in percentages...
3. Take both factors into consideration
4. (go back to number 1) - the bigger the gap between Previous CLOSE DATE and TODAYs DATE IS... the more of a percentage increase will I need because these properties accumulate interest at an average 2-5% rate
5. (go back to number 2) - the bigger the difference between Previous VALUE VS. ACTUAL VALUE - the bigger the percentage will be... now we need to calculate which is actually giving us a COMBINED highest percentage...
Does that make sense? Take a moment and think... Might need a MATH WIZ ON THIS!
FILE 1. CALLED (NEEDS RECALCULATED) - IS THE ONE THAT STARTS GIVING YOU AN IDEA WHAT I NEED
FILE 2. CALLED Sample Spreadsheet 1 - HAS JUST SOME DATA FIELDS YOU CAN USE TO DO THE SAME THING AS ON SPREADSHEET CALLED (NEEDS RECALCULATED)
To an expert in Excel... In excel, I have rows with when a reverse mortgage was created, to current date, old value to new value, also the difference... between the old value and new value = net... what i'm trying to calculate is if you take that information in equation - how do i calculate which data fields result in the biggest "margin" according to the difference in date and biggest difference in "NET"... X - Y = Z ... :)
Posted a project or excel spreadsheet as sample...s chat with any questions so i can describe this any better if I may... please do not claim project if you don't have ANY understanding at all. This might be pretty simple for the right person... it actually really is, just need someone with excessive EXCEL EXPERIENCE.