There is a separate thread for this topic that was closed by referencing a post to the Suite Ideas website. Since I liken this to prayer, I thought I would provide my solution for this issue. I also posted it to the comments of the suite ideas post, but thought it might find a larger audience here.
The challenge with this depreciation is that the out of the box averaging convention cannot handle the bonus in the first year. The depreciation calculation must be done using the Cost less the 1st year bonus.
I solved this problem by creating my own depreciation method called 40% BONUS-150DB with the following attributes:
Depreciation Period = Annually
End Period Number = Blank Next
Depreciation Method= Blank
Depreciation Rate Table=Blank
Depreciation Formula = IF ((NB-RV)/AL*1.5) > ((NB-RV)/(((AL-CP+1)*2)+1))*2 THEN IF (CP==1) THEN (((NB-RV-((NB-RV)40.0/100.0))/AL1.5)/2)+((NB-RV)40.0/100.0) ELSE ((NB-RV)/AL1.5) ENDIF ELSE IF (NB-RV) < ((NB-RV)/(((AL-CP+1)*2)+1))*2 THEN (NB-RV) ELSE ((NB-RV)/(((AL-CP+1)*2)+1))*2 ENDIF ENDIF
Final Period Convention = Value Based
Note that this formula handles the half year convention, so when associating this with an Alternate Method, the Convention should be set to None. For 2025, the IRS has set the Bonus depreciation at 100%, so this depreciation method is unnecessary, but when the bonus is changed to a value less than 100%, this will perform the correct calculation. As the percentage changes from year to year, you would have to create a new depreciation method for the percentage.
Since this isn't really a question, I guess the moderator could mark it as closed and answered.
Hope someone finds this useful.