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.
26 freelance font une offre moyenne de $35 pour ce travail
Hi, I can help you with this one. I have more than 10 years of professional experience in Microsoft Packages. Please share some more details for quality work. Please also consider this bid as provisional one as i Plus
Dear client We are a professional team of business plan writers, excel experts, and accounting software professionals having worked upon various excel and project management tasks in. We can use Excel and PS Project t Plus
Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely Plus
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
Hello! I'm an expert in Excel and can handle very easily spreadsheets, formulas, create calculation sheets, etc. I have former experience as Financial Analyst in companies such as P&G and also Microsoft certificatio Plus
I'm pretty sure I can handle the calc, but I am not quite following what you would like to compare. If you would send me a message and maybe answer some questions or explain it slightly differently I could try to work Plus
I have a 4 years of working in Excel and therefore I can manage the data on excel as per client requirement. I have done MBA in Finance from International Management Institute, Kolkata. I have also done Chartered Acco Plus
What's the frequency that the interest is compounded. Are the duration and increase in value weighted differently for scoring?