Fermé

EXCEL - calculating dates - property values - results

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.

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

Voir plus : what does a data entry person do, math rate, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, how can i expert in excel, expert with excel, excel wiz, excel expert 2016, combined result, chat with excel expert, chat excel expert, calculate factors of a number, be expert in excel, be an expert in excel, accumulate information, become expert excel modeler, vba excel expert, money excel expert, excel expert financial models, microsoft excel expert montreal, toronto excel expert job

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

N° du projet : #9490521

26 freelance ont fait une offre moyenne de 35 $ pour ce travail

80 $ 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

84 $ USD en 2 jours
(55 Commentaires)
6.2
84 $ USD en 1 jour
(81 Commentaires)
5.7
34 $ USD en 2 jours
(139 Commentaires)
5.8
P0L

A proposal has not yet been provided

30 $ 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

105 $ 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

25 $ 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.

30 $ USD en 1 jour
(27 Commentaires)
4.2
35 $ 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

30 $ 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

30 $ USD en 1 jour
(1 Commentaire)
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

30 $ USD en 1 jour
(1 Commentaire)
1.0
Wongeka

A proposal has not yet been provided

35 $ USD en 1 jour
(0 Commentaires)
0.0
28 $ USD en 1 jour
(0 Commentaires)
0.0
urskapovse34

A proposal has not yet been provided

25 $ USD en 1 jour
(0 Commentaires)
0.0
DavidMendezR

A proposal has not yet been provided

30 $ USD en 1 jour
(0 Commentaires)
0.0
BenedictNeelu20

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

25 $ USD en 2 jours
(0 Commentaires)
0.0
45 $ 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?

30 $ USD en 2 jours
(0 Commentaires)
0.0
puturitha

i am excellent with excel gede

30 $ USD en 3 jours
(0 Commentaires)
0.0