I am trying to make a depreciation calculation
I wanted to make so whatever date a person selected based on the month, it will output a different percentage later in the snippet
For January: (3.485%)February: (3.182%)March: (2.879%)April: (2.576%)May: (2.273%)June: (1.970%)July: (1.667%)August: (1.364%)September: (1.061%)October: (0.758%)November: (0.455%)December: (0.152%)
my snippet currently but wanted to add other depreciation convention as well, not sure how to best execute this
{note} Depreciable Value of Asset: ${formtext: name=Depreciable Value of Asset $; default=; cols=20}
Line 14(a) Placed in Service Date (Month-Day-Year): {formdate: MMM; name=PISD Month} {formdate: DD; name=PISD Day} {formdate: YYYY; name=PISD Year}
Line 14(c) Asset Useful Life in Years: {formtext: name=Useful Life in Years}
Line 14(b) Prior Depreciation: ${formtext: name=Taken Depreciation}
Line 14(c) Proposed Method of Depreciation under §168 (MACRS) {formmenu: ; Mid-Month; ; name=Depreciation Convention}/{formmenu: ; Straight-Line; name=Method of Depreciation}
Line 14(d) Present overall method of accounting: {formmenu: ; Cash; Accural; name=Method of Accounting}
Line 15 Description of business: {formtext: default=Residential Rental Real Estate; cols=30; name=Business Description\ }
Line 14(a) Depreciation Missed: ${formtext: name=Missed Depreciation}
Asset Class: {formtext: name=Asset Class; cols=30; default=Rental Residential Real Estate}
{endnote}{formtext: name=Taxpayer Name; default=Taxpayer Name; cols=30}
Tax Year: {formtext: name=Tax Year; default=2025; cols=6}
Primary SSN: {formtext: name=SSN; cols=10}
Form 3115 Required Attachments
Part II of Form 3115
Line 14(a) Item being changed: unclaimed depreciation of ${=`missed depreciation`} on {=`business description `} property placed in service on {=`pisd month`} {=`pisd day`} {=`pisd year`}
Line 14(b) ${=`taken depreciation`} depreciation was previously taken
Line 14(c) Proposed method: depreciation under §168 (MACRS) using the {=`method of depreciation`} method over a {=`useful life in years`} year life.
Line 14(d) Present overall method of accounting: {=`method of accounting`}
Line 15 Description of business: {=`business description `}
Part IV of Form 3115 {note} assuming rental real estate property{endnote}
Line 26:
{formtext: name=First Year} Depreciation: ${=`depreciable value of asset $`} x {=1/`useful life in years`; format=,.3%} x = ${=`depreciable value of asset $`*(1/ `useful life in years`)}
Depreciation: ${=`depreciable value of asset $`} x {=1/`useful life in years`; format=,.3%} = ${=`depreciable value of asset $`*(1/ `useful life in years`)}
Prior Year Depreciation actually taken ${=`taken depreciation`}
Correct Depreciation - Already taken Depreciation: ${=`depreciable value of asset $`*(1/ `useful life in years`)} - ${=`taken depreciation`}
Total Missed Depreciation: ${=(`depreciable value of asset $`*(1/ `useful life in years`)* `# of Yrs since in service`)}
Schedule E of Form 3115
Line 7(a) Code section under which the property will be depreciated: Section 168 and regulations.
Line 7(b) Asset Class: {=`asset class`}
Line 7(d) Depreciation method: Section 168 (MACRS) {=`method of depreciation`}.
Line 7(e) Useful life: {=`useful life in years`} years.
Line 7(f) Convention: ;
Line 7(g) First-year special depreciation: No, property doesn't qualify
Line 7(h) Account: Single asset account
Hi @Felix_Yeung,
Welcome to the Blaze forum 
Are you looking into something like this? I used our keyed list to implement it.
{formmenu: ; default=Mid-Month; name=Depreciation Convention}
{formdate: MMMM; name=month}
{month_rates=["Mid-Month": ["January": 0.03485, "February": 0.03182, "March": 0.02879, "April": 0.02576,"May": 0.02273, "June": 0.01970, "July": 0.01667, "August": 0.01364, "September": 0.01061, "October": 0.00758, "November": 0.00455, "December": 0.00152]]}Month rate: {=month_rates[`depreciation convention`][month]}
Please let me know if you have any further questions.
I updated and was not able to reference the month_rates
{note} Depreciable Value of Asset: ${formtext: name=Depreciable Value of Asset $; default=; cols=20}
Line 14(a) Placed in Service Date (Month-Day-Year): {formdate: MMMM; name=month} {formdate: DD; name=PISD Day} {formdate: YYYY; name=PISD Year}
Line 14(c) Asset Useful Life in Years: {formtext: name=Useful Life in Years}
Line 14(b) Prior Depreciation: ${formtext: name=Taken Depreciation}
Line 14(c) Proposed Method of Depreciation under §168 (MACRS) {formmenu: ; Mid-Month; name=Depreciation Convention}/{formmenu: ; Straight-Line; name=Method of Depreciation}
{month_rates=["Mid-Month": ["January": 0.03485, "February": 0.03182, "March": 0.02879, "April": 0.02576,"May": 0.02273, "June": 0.01970, "July": 0.01667, "August": 0.01364, "September": 0.01061, "October": 0.00758, "November": 0.00455, "December": 0.00152]]}Month rate: {=month_rates[`depreciation convention`][month]}
Line 14(d) Present overall method of accounting: {formmenu: ; Cash; Accural; name=Method of Accounting}
Line 15 Description of business: {formtext: default=Residential Rental Real Estate; cols=30; name=Business Description\ }
Line 14(a) Depreciation Missed: ${formtext: name=Missed Depreciation}
Asset Class: {formtext: name=Asset Class; cols=30; default=Rental Residential Real Estate}
{endnote}{formtext: name=Taxpayer Name; default=Taxpayer Name; cols=30}
Tax Year: {formtext: name=Tax Year; default=2025; cols=6}
Primary SSN: {formtext: name=SSN; cols=10}
Form 3115 Required Attachments
Part II of Form 3115
Line 14(a) Item being changed: unclaimed depreciation of ${=`missed depreciation`} on {=`business description `} property placed in service on {=`month`} {=`pisd day`} {=`pisd year`}
Line 14(b) ${=`taken depreciation`} depreciation was previously taken
Line 14(c) Proposed method: depreciation under §168 (MACRS) using the {=`method of depreciation`} method over a {=`useful life in years`} year life.
Line 14(d) Present overall method of accounting: {=`method of accounting`}
Line 15 Description of business: {=`business description `}
Part IV of Form 3115 {note} assuming rental real estate property{endnote}
Line 26:
{formtext: name=First Year} Depreciation: ${=`depreciable value of asset $`} x {=month_rates[`depreciation convention`][month]; format=,%} = ${=(`depreciable value of asset $`*{=(month_rates[`depreciation convention`][month]); format=,.2%}); format=.2}
Depreciation: ${=`depreciable value of asset $`} x {=1/`useful life in years`; format=,.3%} = ${=`depreciable value of asset $`*(1/ `useful life in years`); format=$,.2f}
Prior Year Depreciation actually taken ${=`taken depreciation`; format=$,.2f}
Correct Depreciation - Already taken Depreciation: ${formtext: name=Correct Depreciation; cols=8} - ${=`taken depreciation`; format=$,.2f}
Total Missed Depreciation: ${=`missed depreciation`; format=$,.2f}
Schedule E of Form 3115
Line 7(a) Code section under which the property will be depreciated: Section 168 and regulations.
Line 7(b) Asset Class: {=`asset class`}
Line 7(d) Depreciation method: Section 168 (MACRS) {=`method of depreciation`}.
Line 7(e) Useful life: {=`useful life in years`} years.
Line 7(f) Convention: ;
Line 7(g) First-year special depreciation: No, property doesn't qualify
Line 7(h) Account: Single asset account
Cannot convert "2.27%" to a number.
because the month rate are used later in the calculation but i am unable to reference it to get the numebr to do the calculation
See Line 26 , Yera Depreciation: $xxx,xxx x "" Is not in the list "month_rates"
Hi @Felix_Yeung,
It is working fine for me. You will need to change the depreciation convention to "Mid-Month" from the dropdown, as the month_rates list only contains rates for the mid-month convention.
Please let me know if you have any further questions.
{note} Depreciable Value of Asset: ${formtext: name=Depreciable Value of Asset $; default=; cols=20}
Line 14(a) Placed in Service Date (Month-Day-Year): {formdate: MMM; name=PISD Month} {formdate: DD; name=PISD Day} {formdate: YYYY; name=PISD Year}
Line 14(c) Asset Useful Life in Years: {formtext: name=Useful Life in Years}
Line 14(b) Prior Depreciation: ${formtext: name=Taken Depreciation}
Line 14(c) Proposed Method of Depreciation under §168 (MACRS) {formmenu: ; Mid-Month; ; name=Depreciation Convention}/{formmenu: ; Straight-Line; name=Method of Depreciation}
Line 14(d) Present overall method of accounting: {formmenu: ; Cash; Accural; name=Method of Accounting}
Line 15 Description of business: {formtext: default=Residential Rental Real Estate; cols=30; name=Business Description\ }
Line 14(a) Depreciation Missed: ${formtext: name=Missed Depreciation}
Asset Class: {formtext: name=Asset Class; cols=30; default=Rental Residential Real Estate}
{endnote}{formtext: name=Taxpayer Name; default=Taxpayer Name; cols=30}
Tax Year: {formtext: name=Tax Year; default=2025; cols=6}
Primary SSN: {formtext: name=SSN; cols=10}
Form 3115 Required Attachments
Part II of Form 3115
Line 14(a) Item being changed: unclaimed depreciation of ${=`missed depreciation`} on {=`business description `} property placed in service on {=`pisd month`} {=`pisd day`} {=`pisd year`}
Line 14(b) ${=`taken depreciation`} depreciation was previously taken
Line 14(c) Proposed method: depreciation under §168 (MACRS) using the {=`method of depreciation`} method over a {=`useful life in years`} year life.
Line 14(d) Present overall method of accounting: {=`method of accounting`}
Line 15 Description of business: {=`business description `}
Part IV of Form 3115 {note} assuming rental real estate property{endnote}
Line 26:
{formtext: name=First Year} Depreciation: ${=`depreciable value of asset $`} x {=1/`useful life in years`; format=,.3%} x "MONTH-RATE"= ${=`depreciable value of asset $`*(1/ `useful life in years`)}
Depreciation: ${=`depreciable value of asset $`} x {=1/`useful life in years`; format=,.3%} = ${=`depreciable value of asset $`*(1/ `useful life in years`)}
Prior Year Depreciation actually taken ${=`taken depreciation`}
Correct Depreciation - Already taken Depreciation: ${=`depreciable value of asset $`*(1/ `useful life in years`)} - ${=`taken depreciation`}
Total Missed Depreciation: ${=(`depreciable value of asset $`*(1/ `useful life in years`)* `# of Yrs since in service`)}
Schedule E of Form 3115
Line 7(a) Code section under which the property will be depreciated: Section 168 and regulations.
Line 7(b) Asset Class: {=`asset class`}
Line 7(d) Depreciation method: Section 168 (MACRS) {=`method of depreciation`}.
Line 7(e) Useful life: {=`useful life in years`} years.
Line 7(f) Convention: ;
Line 7(g) First-year special depreciation: No, property doesn't qualify
Line 7(h) Account: Single asset account
My issue is at Line 26 how do i pull the month rate in percentage format so calculate,
Hi @Felix_Yeung,
Thanks for your response. I've sent you a direct message to schedule a quick call to help you with this.