Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi All,
I have a debt of about 500.000 USD with an annual interest rate of 4.5% (quarterly added, so every 3rd month, the debt is increased by approximately 4.5% * 0.25 = 1.13%).
Me and my friend are able to pay off debt at our own pace. I would like to setup an excel sheet, where I can calculate how much of the remaining loan each of us owes. However, due to the interest payments coming in, this makes it incredibly difficult, as it doesnt just become a total debt * 0.5 = how much we each owe calculation.
Does anybody have a youtube video that shows how to do this, or can make an example I can use? Would be very much appreciated!
P.S. we plan to enter the amounts we pay every month manually into the excel sheet and then let everything else run automatically.
I have a debt of about 500.000 USD with an annual interest rate of 4.5% (quarterly added, so every 3rd month, the debt is increased by approximately 4.5% * 0.25 = 1.13%).
Me and my friend are able to pay off debt at our own pace. I would like to setup an excel sheet, where I can calculate how much of the remaining loan each of us owes. However, due to the interest payments coming in, this makes it incredibly difficult, as it doesnt just become a total debt * 0.5 = how much we each owe calculation.
Does anybody have a youtube video that shows how to do this, or can make an example I can use? Would be very much appreciated!
P.S. we plan to enter the amounts we pay every month manually into the excel sheet and then let everything else run automatically.
