Hello,

I am trying to see how paying a certain amount of my loan will change my overall interest expense and interest expenses per round. I am running the program SAP where I am a manufacturer and need to be as efficient as possible and have the highest net income/ company evaluation as possible. We run 4 rounds, 20 days in each round. My issue is, I cannot seem to figure out how to formulate the proper formula to show the effects on my loan with a down payment. My goal for this table is to input a number in the "Amount to Pay" and have it change the numbers in the rest of the chart according to the amount. Any help would be greatly appreciated and please let me know if more information is given.

I plan to have the payment take place at the begining of each round. However, if after each round is easier to calculate, that is perfectly fine as well. Thank you for your time!

File Home Insert Page Layout Formulas Data Review View Help Search Conditional Formatting Format as Table Cell Styles Alignment Number Cells Editing Ideas Paste Clipboard 011 Calibri - 11 BIU - A A - - A Font X r Styles Ideas to fix 1 Loan Repayment Calculations Total Days 4 80 3 Inputs Rounds Days/Round Daily Loan Interest 20 2644.8 Total Interest 211,584.00 7 Interest Rate 0.0331 Daily Int Exp Round interest Starting Loan 8,000,000.00 9 10 Amount to Pay R1D1 12 R2D1 13 R3D1 14 R4D1 15 New Loan 8,000,000.00 8,000,000.00 8,000,000.00 8,000,000.00 ... Production Estimate Loan Repayment Sheet ... L File Home Insert Page Layout Formulas Data Review View Help Search Conditional Formatting Format as Table Cell Styles Alignment Number Cells Editing Ideas Paste Clipboard 011 Calibri - 11 BIU - A A - - A Font X r Styles Ideas to fix 1 Loan Repayment Calculations Total Days 4 80 3 Inputs Rounds Days/Round Daily Loan Interest 20 2644.8 Total Interest 211,584.00 7 Interest Rate 0.0331 Daily Int Exp Round interest Starting Loan 8,000,000.00 9 10 Amount to Pay R1D1 12 R2D1 13 R3D1 14 R4D1 15 New Loan 8,000,000.00 8,000,000.00 8,000,000.00 8,000,000.00 ... Production Estimate Loan Repayment Sheet ... L