If you? Know at all makes a repayment plan in Excel then k? Nnte I certainly please your help! I worked the following problem: I try to buy a new car that costs $ 27,000 and I have over $ 4,000 against a deposit?. The j? Annually concerning interest rate? GT 1 01% gain? Rkt? R f a month 60 months. I found out that the monthly payment will be $ 393rd 26. So I create in Excel, I entered the repayment plan? ACCESSIBLE loan anf than $ 23,000 in the A1 field. I then entered the formula = A1 * (. 0101/12) -393. 26 and copied this formula boxes A2 to A61. The 61st Box should be the balance owed on the loan $ 0 or close to it, but I’m always very different Subject? GE, all in the negative field from A2. What am I doing wrong? Please help if you can k?, W? I really re dankbar.Vielen Thanks be valid for your input yellowness-BN! But I have trouble understanding me, as the interest expense calculated. K nnten please tell me how to use the?