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
Before bid see the task then file, I have an existing file. In file there is fee receipt and fee receipt Siblings sheet. the receipt is only showing latest payment which is done on Fees pay sheet, I want to view all pervious receipt of the students.