# EXCEL - calculating dates - property values - results

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.

Compétences : Comptabilité, Saisie de Données, Traitement de Données, Excel

Concernant l'employeur :
( 3 commentaires ) ny, United States

Nº du projet : #9490521

## 26 freelance font une offre moyenne de \$35 pour ce travail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(223 Commentaires)
7.4
kamrananjum1

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(55 Commentaires)
6.2
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(81 Commentaires)
5.7
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(139 Commentaires)
5.8
P0L

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(63 Commentaires)
5.7
saeedyasir

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
4.2
rajafaizan

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(29 Commentaires)
4.5
renesontiongson

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(27 Commentaires)
4.2
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.1
andreareggio

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
1.7
vroux

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.9
deepakjbokaria

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.0
Wongeka

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
urskapovse34

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
DavidMendezR

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
BenedictNeelu20

Hi, please let me know. I will do the job for you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
luivel

What's the frequency that the interest is compounded. Are the duration and increase in value weighted differently for scoring?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
puturitha

i am excellent with excel gede

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0