Hello all,
I am trying to create an amortization stream based on a daily rate. So for example start date may be 01/01/2022 and end date may be 12/31/2022. The contract amount is 12,000. That would derive a daily rate. Then I want a formula that places the monthly amount based on the daily rate in each column by month. The trick is the start and end dates may be both be in the middle of the month and not clean beginning or end dates (the 1st or the 31st).
So it would look like this:
Contract # Contract Amount Start Date End Date Daily Amount January February March and so on
1234 $12,000 01/01/2022 12/31/2022 <FORMULA> <FORMULA> <FORMULA> <FORMULA> <FORMULA>
It's a relatively common setup for prepaids or revenue. Please revert back with any questions.
THANK YOU FOR YOUR HELP
I am trying to create an amortization stream based on a daily rate. So for example start date may be 01/01/2022 and end date may be 12/31/2022. The contract amount is 12,000. That would derive a daily rate. Then I want a formula that places the monthly amount based on the daily rate in each column by month. The trick is the start and end dates may be both be in the middle of the month and not clean beginning or end dates (the 1st or the 31st).
So it would look like this:
Contract # Contract Amount Start Date End Date Daily Amount January February March and so on
1234 $12,000 01/01/2022 12/31/2022 <FORMULA> <FORMULA> <FORMULA> <FORMULA> <FORMULA>
It's a relatively common setup for prepaids or revenue. Please revert back with any questions.
THANK YOU FOR YOUR HELP