Can you set a formula in ms-excel to work out the provision for doubtful debts, depreciation and amortization
Answers:
Yes
1. Provision for doubtful debts
If it is a broad provision, you simply hold to multiply the debtors total by the singular rate. If it is a specific provision where on earth you identify unpromising debtors separately, you enjoy to build a agenda of the arrears history. Depending on the number of months in arrears you can breed provisions (Use IF function)
2. depreciation and amortization
Again it is a business of formulas. You can manufacture a fixed asset programme and do the math confidently & you can incorporate them into the final one.
If you know the equation simply enter it into the grazing land and yes excel can figure.
Probably not.
Your doubtful accounts subtraction will be base, at tiniest in part, on experience (as all right as other factors). That would be difficult for excel.
Depreciation and amortization will regulation depending upon down time used to depreciate the asset as capably as any special allowances within the imperative, as it change from time to time. Again, not outstandingly glib for excel.
Perhaps these things should be done to suit the individual situation.