8🧵9

#XLSref: #Excel Function DB():

📝

DB = (C-TD) × R

📝 R (Rate) is rounded 2 3 decimal places (Precision 3)
📝 Depr for Y0 (7mo) is calculated this way:

DB_Y0 = C × R × (M / 12)

#spreadsheets #spreadsheets #xls 👉