Differences

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

--- car [2026/04/04 23:06] – admin
+++ car [2026/04/10 20:14] (current) – [Table] admin
@@ Line 1: / Line 1: @@
-^ Loan Parameter ^ Value ^
+| Loan Amount ($)           | 677000                                                                 |
+| Annual Interest Rate (%)  | 6.6                                                                    |
-| Loan Amount ($) | 10000 |
+| Duration (Years)          | 30                                                                    |
-| 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((r2c1/100/12 * r1c1) / (1 - pow(1 + r2c1/100/12, -r3c1*12)), 2)~~ |
+| **Total Cost**            | ~~=round(r0c1 + r4c1, 2)~~                                             |
-| **Total Interest Paid** | ~~=round((r4c1 * r3c1 * 12) - r1c1, 2)~~ |
-| **Total Cost** | ~~=round(r1c1 + r5c1, 2)~~ |

ewrobbins.com