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
route217Asked:
Who is Participating?
 
d-glitchConnect With a Mentor Commented:
It isn't even clear that the available information (loans, credit ratings, and default rates) has any relationship to house prices.
What would be the goal, meaning, or point of a user specifying  -5.12% for Great Britan?
0
 
Mike in ITConnect With a Mentor IT System AdministratorCommented:
This looks more like a job that should be in Gigs.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.