Differences

This shows you the differences between two versions of the page.

--- car [2026/04/04 23:03] – admin
+++ car [2026/04/04 23:11] (current) – [Table] admin
@@ Line 1: / Line 1: @@
-^ Loan Parameter ^ Value ^
+| Loan Amount ($)           | 35000                                                                  |
+| Annual Interest Rate (%)  | 2.9                                                                    |
-| Loan Amount ($) | 10000 |
+| Duration (Years)          | 5                                                                      |
-| Annual Interest Rate (%) | 5 |
+| **Monthly Payment**       | ~~=round((r1c1/1200 * r0c1) / (1 - (1 + r1c1/1200)**(-r2c1*12)), 2)~~  |
-| Duration (Years) | 5 |
+| **Total Interest Paid**   | ~~=round((r3c1 * r2c1 * 12) - r0c1, 2)~~                               |
-| **Monthly Payment** | ~~=round((r1c1/100/12 * r0c1) / (1 - pow(1 + r1c1/100/12, -r2c1*12)), 2)~~ |
+| **Total Cost**            | ~~=round(r0c1 + r4c1, 2)~~                                             |
-| **Total Interest Paid** | ~~=round((r3c1 * r2c1 * 12) - r0c1, 2)~~ |
-| **Total Cost of Loan** | ~~=round(r3c1 * r2c1 * 12, 2)~~ |

ewrobbins.com