Windows application

Question

how to do loan amortization i am getting last two months as negative answer, i want loan blance should 0 of last month. Please can any one help me

Amit Gupta · Answer

If you have implemented the correct formula then it will work accordingly, Do re-recheck the implemented formula. Here is a website for formula and calculations https://emicalculator.net/

S J · Answer

_loanAmount = decimal.Parse(txtLoanamt.Text); _intrestRate = double.Parse(txtIntrestrate.Text); _year = int.Parse(txtYear.Text); _months = _year * 12; if (_intrestRate > 1) { _intrestRate = _intrestRate / 12; } R = (_intrestRate / 100); F = Math.Pow(1 + R, _months); // decimal s = (_loanAmount * (Decimal)R); decimal val = (Decimal)(F - 1); decimal EMI = (_loanAmount * (Decimal)R) * (decimal)F / val; // decimal val = (_loanAmount * (Decimal)((R * F / (-1 + F)))); _monthlyPayment = Math.Round(EMI, 2); decimal tot = _monthlyPayment * _months; _totalPayment = Math.Round(tot, 2); monthlypmt = Convert.ToDecimal(_monthlyPayment); totalpmt = Convert.ToDecimal(_totalPayment); txtMontlypayment.Text = Convert.ToString(monthlypmt); txtTotalPayment.Text = Convert.ToString(totalpmt); _loan.LoanAmount = _loanAmount; //_loan.Intrest = Convert.ToDecimal(_intrestRate) / 100; _loan.Intrest = Convert.ToDecimal(txtIntrestrate.Text); _loan.Loanperiod = Convert.ToString(_year); _loan.MonthlyPayment = Convert.ToDecimal(_monthlyPayment); _loan.TotalPayment = Convert.ToDecimal(_totalPayment); _loan.AccountNo = txtAccno.Text; _loan.Name = txtName.Text; _loan.LoanStatus = "Pending"; _loan.Date = DateTime.UtcNow.ToString(); _loan.TypeOfLoan = combboxLoantypes.Text; _loan.RemaningMonths = _months; _dbEntity.LoanDetailTables.Add(_loan); try { _dbEntity.SaveChanges(); string temp = txtAccno.Text; var iteam = (from user in _dbEntity.UserAccountDetails where user.Account_No == temp select user).FirstOrDefault(); _loan.TotalBalance = iteam.Balance; _loan.Email = iteam.Email; SetValueForText1 = iteam.Account_No; _dbEntity.SaveChanges(); } catch

Laxmidhar Sahoo · Answer

hi plsease display details