route217
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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