How to Calculate your Maximum Loan AmountExcel formula: Calculate original loan amount | ExceljetExcel formula: Calculate original loan amount | ExceljetHow to Calculate your Maximum Loan Amount21/11/2014 · The formula for calculating your maximum loan principal would look something like this: Maximum Loan Amount = P/R {1 – [1 (1+R)^M] } This is just a rough estimate. Your lender may factor in other variables not stated ;· This formula allows us to calculate the maximum amount \( C \) which can be borrowed with a given loan duration \( N \), interest rate \( r \) and annuity \( m \). Formula \[ C = \frac{m \cdot (1-( 1+ \frac{r}{n})^{-N})}{\frac{r}{n}} \ \]09/04/2021 · The formula for calculating your maximum loan principal would look something like this: Maximum Loan Amount = P/R {1 – [1 (1+R)^M] } This is just a rough estimate. Your lender may factor in other variables not stated Used: A = ( P r ) [ 1 - (1+r) -N ] Where, A = Loan Amount P = Payment Amount r = Rate of Interest (compounded) N = Number of Payments Rate of Interest Compounded is, If Monthly, r = i 1200 and N = n 12 If Quarterly, r = i 400 and N = n 4 If Half yearly, r = …Answer: The following methodology should be used to calculate the maximum amount that can be borrowed forpartnerships (partners’ self-employment income should be included on the partnership’s PPP loan application; individual partners may not apply for separate PPP loans): • Step 1: Compute 2019 payroll costs by adding the following:The loan Interest calculation is semi annual compounding I have used this formula: termInMonths = termInyears 12; monthlyInterestRate = InterestRatePercentage 1200; maxLoanAmount = maxMonthlyPayment ((((1 + monthlyInterestRate) ^ termInMonths) - 1) (monthlyInterestRate ((1 + monthlyInterestRate) ^ termInMonths)));
