B5 Enter the loan amount.

B6 Enter the repayment period (month)

B7 Enter interest rate (year)

B8 Enter monthly repayment

C5 is the required loan amount? No data input is required.

C6 input 36

C7 input 6.08%

C8 input formula =C5/36+C5*C7/ 12

Then, position the cursor on C8, execute Excel menu tool → Univariate Solution, and select from the Univariate Solution dialog box that appears.

1) Select C8 in the target cell.

2) Enter 1539.29 in the target value.

3) Select C5 in the variable cell.

5. Press OK

C5 will show that the loan amount is 46,866.07.

To display the loan amount as a negative number, just enter-1539.29 in the target value of the univariate solution dialog box.