6🧵9

#XLSref: #Excel Function DB():

👀 DB(A1,A2,A3,7,7) 💬15,845.10▶️ Depr in Y6 (5mo)
📝 Let R=Rate, S=SALVAGE, C=COST, L=LIFE, M=MONTH, TD={Total depr from B4}:

R = 1 - ((S/C)^(1/L))

#spreadsheets #spreadsheets #xls 👉