Closed

Portfolio Analysis

Portfolio by Credit Score and loan Yield with Calculated Annual Income

I have an monthly file of loan accounts with credit scores and interest rates. I need a dashboard/pivot table of the 6 scores % of total, number, calculated the yield for each score and the monthly income generated for 14 loan types.

I need a workbook that i can paste my data and run the calculation each month

Skills: Excel, Excel Macros, Excel VB Capabilities

About the Client:
( 0 reviews ) Saint Martinville, United States

Project ID: #33780794

25 freelancers are bidding on average $153 for this job

(272 Reviews)
8.1
(471 Reviews)
7.7
(155 Reviews)
7.5
(42 Reviews)
6.7
(192 Reviews)
6.8
(152 Reviews)
6.0
PERPETUAL0

Hello there i can share my previous analysis projects in excel and you can rate it by ur self regards ILYASS

$200 USD in 2 days
(127 Reviews)
5.7
(23 Reviews)
5.3
(29 Reviews)
5.5
(49 Reviews)
5.4
(35 Reviews)
4.9
abatsis

Hello, I am a PhD Industrial Engineer and have experience in data science,and can work on projects in the following fields: Data Modeling, Data Analysis, Flow Chars, ERD Diagrams, Data Entry, IoT, Industrial IoT, Power More

$250 USD in 7 days
(18 Reviews)
4.3
(20 Reviews)
4.0
Nsarker1242

Hi, I am an associate degree professional in essays and dissertations with skills as well as Excel, Excel VBA. Excel macro program, data analysis with CSV. I'm interested to hear more about the project. If you award me More

$100 USD in 1 day
(3 Reviews)
3.7
SIBTEHASSANBUTT

Hi there, I have read your project entitled “ Portfolio Analysis ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using excel and other data visualization platforms. I have alrea More

$65 USD in 1 day
(9 Reviews)
3.6
(8 Reviews)
3.0
(1 Review)
2.4
AbhishekEG

I have years of experience in this field. I already have same project (Ready made). I will give it to you. please check and let me know if you need any modification. please contact me over chat for further discuss

$50 USD in 7 days
(1 Review)
1.6
(0 Reviews)
0.3
(0 Reviews)
0.0