Link to home
Start Free TrialLog in
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Tricky loan rate question

Hi Experts using excel 2010

Do not have a clue how to do this either using excel only or an element of vba mixed in...

See attached 3 files
Portfolios.csv contains details of a number of portfolios including their country and currency
Loans.csv contains a list of home loans contained in those portfolios

Ratings.csv lists the potential credit ratings that a portfolio may have and the probability that a loan may default

How would you create an interface that allows a user to specify a percentage change in house prices for each country in the example below.

 

GB

-5.12

US

-4.34

FR

-3.87

DE

-1.23

SG

-5.5

GR

-5.68
loans.csv
portfolios.csv
ratings.csv
SOLUTION
Avatar of Mike in IT
Mike in IT
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of d-glitch
d-glitch
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jonian Noxha
Jonian Noxha

Data collection can't ensure quality borrowers with using proxies https://buy.fineproxy.org/eng/proxy-trial.html to get access to the website while you are not a resident of the country . Sometimes you are more convinced to give loan with weaker documents and tend to reject solid one appearing as per documents. Personal interactions help use your 6th sense which no supercomputer can give some recommendations and reviews. More the experience it would be easier. Person taking interview must be more relaxed so as to make interactions reveal insight and not mere rituals