| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I create a spreadsheet to accrue interest on a balance 30+d
My ex is obligated to pay 68% of our daughters' medical costs. He has not
paid anything for over 3 years. If he owes me $10 on a copay, he has 30 days to pay me back. If he does not pay me back after 30 days, I am allowed to charge him 5.5% annual interest on the owed amount. I need to calculate how much he owes me after 1 month, 2 months, 3 months, up to 72+ months. May I please get help with creating this spreadsheet so that all I have to do is input data monthly? Any and all help is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Montly payment with interest paid and balance of loan | Excel Discussion (Misc queries) | |||
| How do I change a formula to accrue interest daily? | Excel Worksheet Functions | |||
| How to automate daily interest in a balance sheet? | Excel Discussion (Misc queries) | |||
| Simple interest, multiple payments, loan balance | Excel Worksheet Functions | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
