“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

how to find the actual loan amount in PV excel formulas

Solved by X. Y. in 17 mins

I need to fill out G12:G14 in tab "Lender Loan Tape Summary". I need to calculate the % of: total loan amount (col. P, "Historical Loan Tapes"), in the most frequent states (G9:G11), divided by the total loan amount. This needs to be referenced by Lender in cell B4 of "Lender Loan Tape Summary" tab. % of (loans originated in these states/total originated volume by lender)

Solved by B. C. in 24 mins

What fx formula do i use to calculate the loan amount outstanding after a certain period

Solved by O. J. in 28 mins

Calculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function you use. Cells C20C67 in the "Payment" column are populated with the payment amount from cell C15. [34 points]

Solved by S. Q. in 25 mins

I want to know about the formula for the rate of the loan amount with monthly payment in exact period, not calculate per year

Solved by A. J. in 28 mins