Hello - I have a fixed rate loan amortization schedule extract below with each payment being made on the 23rd of each month (unless this day of the month falls on a weekend date but this is fine in anycase as the terms of the loan agreement is to charge the loan interest payable upto and including the 23rd of the next period even if payment is made afterwards) so was wondering if there was a formula that I can insert under the loan repayment column whereby if the date is not 23rd of any month, then it shows a blank but when it comes to the 23rd, it shows the committed payment of - £165.55. I would imagine it would probably be an IF statement based on if the first date of 04/04/2022 for example is not equal to 23/04/2022, then this would be blank, but when it comes to the date of 23/04/2022, £165.55 is displayed.
Any assistance would be appreciated.
Thanks
Any assistance would be appreciated.
Thanks
| Original Loan Amount | £7,500.00 |
| Loan Term (Years) | 4 |
| Loan Start Date | 04-Apr-22 |
| Loan Expiry Date | 03-Apr-26 |
| Interest Rate | 2.86% |
| Days | 365 |
| Committed Payment | -£165.55 |
| Date | Loan C/fwd | Interest | Interest Adj | Loan Repayment | Loan B/fwd |
| 04/04/2022 | £0.00 | £0.00 | £7,500.00 | ||
| 05/04/2022 | £7,500.00 | £0.59 | £7,500.59 | ||
| 06/04/2022 | £7,500.59 | £0.59 | £7,501.18 | ||
| 07/04/2022 | £7,501.18 | £0.59 | £7,501.76 | ||
| 08/04/2022 | £7,501.76 | £0.59 | £7,502.35 | ||
| 09/04/2022 | £7,502.35 | £0.59 | £7,502.94 | ||
| 10/04/2022 | £7,502.94 | £0.59 | £7,503.53 | ||
| 11/04/2022 | £7,503.53 | £0.59 | £7,504.11 | ||
| 12/04/2022 | £7,504.11 | £0.59 | £7,504.70 | ||
| 13/04/2022 | £7,504.70 | £0.59 | £7,505.29 | ||
| 14/04/2022 | £7,505.29 | £0.59 | £7,505.88 | ||
| 15/04/2022 | £7,505.88 | £0.59 | £7,506.47 | ||
| 16/04/2022 | £7,506.47 | £0.59 | £7,507.06 | ||
| 17/04/2022 | £7,507.06 | £0.59 | £7,507.64 | ||
| 18/04/2022 | £7,507.64 | £0.59 | £7,508.23 | ||
| 19/04/2022 | £7,508.23 | £0.59 | £7,508.82 | ||
| 20/04/2022 | £7,508.82 | £0.59 | £7,509.41 | ||
| 21/04/2022 | £7,509.41 | £0.59 | £7,510.00 | ||
| 22/04/2022 | £7,510.00 | £0.59 | £7,510.59 | ||
| 23/04/2022 | £7,510.59 | £0.59 | -£165.55 | £7,345.62 |
| 24/04/2022 | £7,345.62 | £0.58 | £7,346.20 | ||
| 25/04/2022 | £7,346.20 | £0.58 | £7,346.77 | ||
| 26/04/2022 | £7,346.77 | £0.58 | £7,347.35 | ||
| 27/04/2022 | £7,347.35 | £0.58 | £7,347.93 | ||
| 28/04/2022 | £7,347.93 | £0.58 | £7,348.50 | ||
| 29/04/2022 | £7,348.50 | £0.58 | £7,349.08 | ||
| 30/04/2022 | £7,349.08 | £0.58 | £7,349.65 | ||
| 01/05/2022 | £7,349.65 | £0.58 | £7,350.23 | ||
| 02/05/2022 | £7,350.23 | £0.58 | £7,350.81 | ||
| 03/05/2022 | £7,350.81 | £0.58 | £7,351.38 | ||
| 04/05/2022 | £7,351.38 | £0.58 | £7,351.96 | ||
| 05/05/2022 | £7,351.96 | £0.58 | £7,352.53 | ||
| 06/05/2022 | £7,352.53 | £0.58 | £7,353.11 | ||
| 07/05/2022 | £7,353.11 | £0.58 | £7,353.69 | ||
| 08/05/2022 | £7,353.69 | £0.58 | £7,354.26 | ||
| 09/05/2022 | £7,354.26 | £0.58 | £7,354.84 | ||
| 10/05/2022 | £7,354.84 | £0.58 | £7,355.41 | ||
| 11/05/2022 | £7,355.41 | £0.58 | £7,355.99 | ||
| 12/05/2022 | £7,355.99 | £0.58 | £7,356.57 | ||
| 13/05/2022 | £7,356.57 | £0.58 | £7,357.14 | ||
| 14/05/2022 | £7,357.14 | £0.58 | £7,357.72 | ||
| 15/05/2022 | £7,357.72 | £0.58 | £7,358.30 | ||
| 16/05/2022 | £7,358.30 | £0.58 | £7,358.87 | ||
| 17/05/2022 | £7,358.87 | £0.58 | £7,359.45 | ||
| 18/05/2022 | £7,359.45 | £0.58 | £7,360.03 | ||
| 19/05/2022 | £7,360.03 | £0.58 | £7,360.60 | ||
| 20/05/2022 | £7,360.60 | £0.58 | £7,361.18 | ||
| 21/05/2022 | £7,361.18 | £0.58 | £7,361.76 | ||
| 22/05/2022 | £7,361.76 | £0.58 | £7,362.33 | ||
| 23/05/2022 | £7,362.33 | £0.58 | -£165.55 | £7,197.36 |
