Loan database Formulae Total Interest = Loan amount X interest percent Installment = Loan period X 12 Monthly Amount = Loan amount / Installment Monthly Interest = Total Interest / Installment Monthly Payment = Monthly Amount + Monthly Interest Total Pay = Monthly Pay X Installment Depreciation for Formulae There are Two types of Depreciatio calculation Method : First Method : SLM ( Straight Line Method ) Second Method : WDV ( Written Down Value ) Formulae For SLN =sln(cost,salvage,value) Enter First year Book Value = cost-first year depreciation Second Year Book Value = First Year Dep. - Second Year Dep. Now Increment ++ Formulae For WDV =db(cost,salvage,period,year) Enter First year Book Value = cost-first year depreciation Second Year Book Value = First Year Dep. - Second Year Dep. Now Increment ++ Cash Reciept Formulae particular =vlookup(product id मा click , रेन्ज select गर्ने , 2,0) Enter Rate = vlookup(p...