MathPlotAI Logo MathPlotAI

Loan & Instalment Table

Loan & Instalment Table
Loading the math board and drawing, please wait…
2019-10-29 21:28
FunctionSequenceCoordinate GeometryProbability & Statistics
This example demonstrates a loan and instalment calculation table, visually showing changes in each payment amount, interest, and remaining loan balance. Core mathematical concepts include percentage calculations, sequences, function graphs, and coordinate geometry. It uses GeoGebra commands like If, Textfield, and TableText. Suitable for high school mathematics teaching, focusing on financial mathematics and sequence applications.

GeoGebra Commands & Parameters

  1. If((C7 * $C$4) > $B$4, Min[$B$4, (C7 * $C$4)], Max[(C7 * $C$4), 0]) → B8
  2. If((C7 * $C$4) < $B$4, 0, (C7 * $C$4) - B8) → C8
  3. If((C8 * $C$4) > $B$4, Min[$B$4, (C8 * $C$4)], Max[(C8 * $C$4), 0]) → B9
  4. If((C8 * $C$4) < $B$4, 0, (C8 * $C$4) - B9) → C9
  5. If((C9 * $C$4) > $B$4, Min[$B$4, (C9 * $C$4)], Max[(C9 * $C$4), 0]) → B10
  6. If((C9 * $C$4) < $B$4, 0, (C9 * $C$4) - B10) → C10
  7. If((C10 * $C$4) > $B$4, Min[$B$4, (C10 * $C$4)], Max[(C10 * $C$4), 0]) → B11
  8. If((C10 * $C$4) < $B$4, 0, (C10 * $C$4) - B11) → C11
  9. If((C11 * $C$4) > $B$4, Min[$B$4, (C11 * $C$4)], Max[(C11 * $C$4), 0]) → B12
  10. If((C11 * $C$4) < $B$4, 0, (C11 * $C$4) - B12) → C12
  11. If((C12 * $C$4) > $B$4, Min[$B$4, (C12 * $C$4)], Max[(C12 * $C$4), 0]) → B13
  12. If((C12 * $C$4) < $B$4, 0, (C12 * $C$4) - B13) → C13
  13. If((C13 * $C$4) > $B$4, Min[$B$4, (C13 * $C$4)], Max[(C13 * $C$4), 0]) → B14
  14. If((C13 * $C$4) < $B$4, 0, (C13 * $C$4) - B14) → C14
  15. If((C14 * $C$4) > $B$4, Min[$B$4, (C14 * $C$4)], Max[(C14 * $C$4), 0]) → B15
  16. If((C14 * $C$4) < $B$4, 0, (C14 * $C$4) - B15) → C15
  17. If((C15 * $C$4) > $B$4, Min[$B$4, (C15 * $C$4)], Max[(C15 * $C$4), 0]) → B16
  18. Textfield(Loan) → Loan_amount
  19. Textfield(m) → InputBox1
  20. Textfield(instalment) → InputBox2
  21. If((C15 * $C$4) < $B$4, 0, (C15 * $C$4) - B16) → C16
  22. If((C16 * $C$4) > $B$4, Min[$B$4, (C16 * $C$4)], Max[(C16 * $C$4), 0]) → B17
  23. If((C16 * $C$4) < $B$4, 0, (C16 * $C$4) - B17) → C17
  24. TableText({{A6, B6, C6}, {A7, B7, C7}, {A8, B8, C8}, {A9, B9, C9}, {A10, B10, C10}, {A11, B11, C11}, {A12, B12, C12}, {A13, B13, C13}, {A14, B14, C14}, {A15, B15, C15}, {A16, B16, C16}, {A17, B17, C17}}, "|_lll") → text4

AI Drawing Prompt Reference

Create a loan and installment table to show changes in each payment amount, interest, and remaining loan balance. Input the loan amount, number of installments, and installment amount, then calculate and display the interest, actual payment amount, and remaining loan balance for each period. The table has 17 rows, each representing one period, showing the period number, interest, actual payment amount, and remaining loan balance.
The prompt above was compiled from the original drawing commands and is for reference only.