Financial Analysis puzzles, solved step by step

Without a provision, net income falls Rs 37.5 lakh; with a full provision already booked, it does not move. With no provision, the Rs 50 lakh is an expense, tax falls Rs 12.5 lakh, and net income falls 37.5. Cash rises 12.5 from lower tax, receivables fall 50 and retained earnings fall 37.5. With a provision booked last year, the write-off only removes the debt and the provision together, so profit and cash are unchanged.

What happens when nothing was set aside?

Think of a shopkeeper with a customer who has run up a tab and then left town. The money was counted as owed; now it never will be. Writing off a debt with no provision turns an asset into an expense in one step: receivables fall Rs 50 lakh and a bad debt expense of Rs 50 lakh hits profit. Assuming the write-off is tax deductible, tax falls Rs 12.5 lakh, so net income falls Rs 37.5 lakh. On the cash flow statement, add back the Rs 50 lakh because no cash moved; cash from operations rises Rs 12.5 lakh, the tax saved. The balance sheet balances: assets fall 37.5 (receivables down 50, cash up 12.5) and retained earnings fall 37.5.

Why does the provision case show nothing this year?

Because the loss was already recognised. A provision for doubtful debtsAn amount set aside against receivables the company expects not to collect. It reduces net receivables on the balance sheet and is charged to profit when it is created. is booked when a loss becomes likely, and that is when profit takes the hit. Accounting recognises a loss when it becomes probable, not when the customer finally fails, so the write-off later is a tidy-up between two balance sheet lines. Gross receivables fall Rs 50 lakh, the provision against them falls Rs 50 lakh, and net receivables are unchanged. Under Ind AS 109 and IFRS 9 companies provide for expected credit losses in advance, which is this logic applied to a whole loan book.

What about tax in the provision case?

This is the follow-up that separates good answers. In many tax systems a general provision is not deductible until the debt is actually written off, so the tax saving arrives now even though the expense was booked last year. The books handle that with a deferred tax asset created last year and reversed this year: cash tax falls Rs 12.5 lakh now, with no effect on this year's profit. Treat the rule as something to confirm for the jurisdiction where the company files tax, rather than a fixed fact.

Net income rises Rs 7.5 crore, cash falls Rs 2.5 crore, and net fixed assets are Rs 10 crore higher. Income statement: depreciation down 10, pre-tax profit up 10, tax up 2.5, net income up 7.5. Cash flow: net income up 7.5 but the add-back down 10, so cash from operations down 2.5. Balance sheet: cash down 2.5, fixed assets up 10, assets up 7.5, matched by retained earnings up 7.5.

Why does profit rise while cash falls?

A shopkeeper who decides his delivery van will last ten years instead of five writes off half as much each year. The van is the same van, the fuel bill is the same, and no customer paid him more. Changing a useful life changes when the cost of an asset is recognised, not whether it is paid, so the extra profit is an accounting rearrangement with one real consequence: a higher tax bill. Depreciation falls 10, pre-tax profit rises 10, tax at 25% rises 2.5, and net income rises 7.5.

On the cash flow statement, start from net income, up 7.5, and add back depreciation, which is now 10 lower than before. Cash from operations is 7.5 - 10 = -2.5. Nothing changes in investing or financing, so cash falls 2.5. On the balance sheet, cash is down 2.5 and net fixed assets are up 10, because less accumulated depreciation has been charged against them: assets up 7.5. Retained earnings carry the 7.5 of extra net income, so liabilities and equity are also up 7.5.

Why is the higher profit not good news?

Because nothing about the business improved. The same machines wear out on the same schedule; the company will replace them on the same date for the same money; and it has handed Rs 2.5 crore to the tax authority earlier than it needed to. A profit increase that comes with a cash decrease and no operating change is cosmetic, and the choice to make it is itself a signal: management may be reaching for a target. It also breaks comparability with peers who kept the shorter lives, and the total charge over the asset's life is unchanged, so the profit that appears now is borrowed from later years.

What if tax depreciation did not follow book?

In practice the tax authority sets its own depreciation rates, and in India book depreciation under the Companies Act and tax depreciation under the Income Tax Act are computed separately; confirm the current rules before relying on this. Then cash tax does not change: net income still rises 7.5, but a deferred tax liabilityTax that the accounts recognise as owed on profit already reported, but that the tax return has not yet charged, so it will be paid in a later period. of 2.5 is booked instead of extra cash tax. On the cash flow statement, net income up 7.5, add-back down 10, deferred tax up 2.5: cash from operations is 0.0. The limit: in that version the change is purely cosmetic, cash untouched, which is why analysts read the depreciation policy note before they read the profit line.