How to Compute the Amortion Calculator Calculation using SfCalculate in Xamarin.Forms?

1 min read

The CalcQuickBase will provide options to directly parse and compute a formula which is derived from ICalcData. The ParseAndComputeFormula method of CalcEngine is used to evaluate the formulas using the values from ICalcData object by cell references.

CalcQuickBase calcQuick = new CalcQuickBase();
CalcEngine engine = new CalcEngine(calcQuick);

In the following, we have computed the Amortion Calculator to calculate the periodic payment for a loan.

string formula = "=-PMT(" + InterestRate.ToString() + "/" + NumberOfPaymentPerYear.ToString() + "," + LoanYears.ToString() + "*" + NumberOfPaymentPerYear.ToString() + "," + LoanAmount.ToString() + ")";
string result = engine.ParseAndCompute(formula);

Screenshot:

Sample link:

https://github.com/SyncfusionExamples/How-to-Compute-the-Amortion-Calculator-Calculation-using-SfCalculate-in-Xamarin.Forms-

Did you find this information helpful?

Yes

Comments (0)

How to Compute the Amortion Calculator Calculation using SfCalculate in Xamarin.Forms?

Access denied