Deferred revenue decreases by 10
how does it change the 3 statements?

my understanding: (assuming 40% tax rate)
I/S: revenue+10, taxes +4, NI+ 6
B/S: COGS-10, unearned revenue-10
no change to CFS (but NI+6...how to offset?)
I am not sure. Can anyone help? Thanks a lot!

#### WSO Elite Modeling Package

• 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
• Elite instructors from top BB investment banks and private equity megafunds
• Includes Company DB + Video Library Access (1 year)

COGS would not be the same value as revenue since one is a cost and one is a revenue number. You also have to book a decrease in inventory. You also don't offset net income (not sure why you think you would ever do this). You are recognizing a revenue number that was delayed until now so of course your NI would be higher. Essentially deferred revenue (b/s liability) was turned into a revenue (i/s credit).

Thank you so much for your reply!!!
So, for B/S, inventory-4, shareholders' equity+6, Unearned revenue-10?

If that is what your cost number is. Think of it like a journal entry. If the cost is 4 then you would debit COGS and then credit inventory for the same amount.

IS: Rev +10, Taxes +4, NI+6

B/S: Current Liabilities (10), Retained Earnings +6

CFS: Cash Provided by Operating Activities (10)

I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done

• 1
• 1

BBA18 your balance sheet doesn't balance so that's wrong see @Draymond23" for the correct answer

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Extra credit for mentioning DTAs

I/S:
+6 (net of -4 tax when you recognize the deferred revenue of 10)

CFS:
-10 since revenue is non-cash
+4 for DTA reduction (you'd already paid cash taxes on the deferred revenue. IRS uses cash accounting but GAAP uses accrual)

so 0 net change in cash

B/S
Assets
-4 DTA

Liabilities
-10 deferred revenue
Equity
+6 retained earnings

thank you very much. i am elaborating a bit to add color. to give some background, let's look at the increase in deferred revenue that presumably occurred before this decrease in deferred revenue. it's much simpler to understand when zooming out a few periods. the key thing to remind ourselves is deferred revenue creates a DTA up front, meaning when your cash (asset) goes up by 100 and deferred revenue (liability) goes up by 100, you pay the IRS 40 (cash goes down 40) and DTA (asset) goes up by 40.

your answer is spot on: once the goods are delivered, the deferred revenue liability bucket goes down and your revenue finally pays a visit to the P&L (COGS/inventory acctg applies for certain businesses too) and flows through the other two statements. notice when we recognize the revenue in the P&L (assuming C corp) we automatically apply our tax rate to get to net income (and NI flows through CF & BS). this is double-counting taxes, so we must remember to unwind the DTA when decreasing deferred revenue.

Also curious about this accounting puzzle. Will push you a bit further.

I agree with the above approach but here's an additional question: we'd also recognize the expenses/costs once we recognize the revenue. However, the DTA created was for taxes paid to IRS earlier on the revenue amount, not the pre-tax amount. Now that we recognize the revenue along with its costs, we have a different income tax expense number than the DTA number. The difference would be the tax rate times the cost/expenses figure.

What would you do in this situation?
Of course the balance sheet still balances. I would apply unwind the DTA to fully cover the income tax expense but then there's residual DTA left on the balance sheet that was paid to the IRS in an earlier period which we didn't use up. Does this get written down or is it carried forward as with NOL-related DTAs? Any idea?

Array

How do we know that cash taxes have already been paid on deferred revenue? For example, if the \$10 decrease in deferred revenue accounted for recognizing revenue for month 1 of service in a new 12 month service contract, there wouldn't be a DTA yet because we would likely not have paid cash taxes to the IRS yet, correct?

So in that scenario, the Assets would be -4 due to cash being down 4, and that would balance out against the -4 balance on the L&E side. Am I missing something here?

Thats probably too much for an interview question, but prior to your paying the taxes you'd set up the DTA, but also increase the current liability for 'income taxes payable.'

As you earned the revenue, you'd still reduce the dta because you're recognizing gaap taxes on the is, and unwinding that timing difference between gaap and tax. When you actually pay the cash taxes, you'll reduce that income taxes payable liability which shows up as a use of cash on the cfs.

Not accounting for DTA's, this is the way you answer this question.

10 deferred revenue decrease.

IS: Rev +10 (1-T) - NI +6
CFS: NI +6, decrease in deferred rev (use of funds) -10. Overall change - +4
BS: Assets: Cash +4. Liabilities: Decrease in def rev 10, increase in NI 6

But I think no change to the CFS. taxes payable increase by 4, so you need to adjust CFO by adding 4?

Thanks for the insight.

I agree with Daveo - since NI goes up by 6 and is impacted by a non-cash expense, we should adjust it in the CFS to get the net change in cash we use in the BS.

When answering this in an interview, do we want to talk about the decrease in inventory or increase in COGS that's associated with providing a good or service?

Best Response

Sorry for bumping this but isn't this incorrect? (Need to make sure I'm not going crazy)

IS: Revenue +10(1-T), NI +6
CFS: NI +6 Deferred Rev -10 so overall change -4
BS: Cash -4, Liabilities -10 NI +6 and that ties -4, = -4.

This should be the correct one...you are realizing a revenue here but it's non-cash so you subtract that when you calculate net change in cash. So you end up with -4.

What if deferred revenue increases by ten? You wouldn't log a ten decrease of revenue, right? Just deferred revenue up 10 and cash up 10?

This is a time sensitive question if anyone happens to know the answer

You have paid it and accounted for it in the net income already? Then the net income (tax adjusted) goes to the CFS.

This is the way I thought about doing it:

IS: Revenue +10(1-T), NI +6
CFS: NI +6 Deferred Rev -10 so overall change -4
BS: Cash -4, Liabilities -10 NI +6 and that ties -4, = -4

Just a question, how do you account for the decrease in inventory? Assume COGS is equal to \$5, on the BS it would be -\$5 Inventory, how do you balance that on the liabilities side?

Assuming \$5 decrease in Inventory (Increase in COGS), there should be nothing impacting Liabilities.

IS: Rev -5, NI: -3

CF: NI -3, Inv. +5, ---- Change in Cash +2

BS: A [Cash +2, Inventory -5 = -3], E [Retained Earnings -3]

Array

IS: Rev +10, NI +6 --- assuming 40% tax rate

CF: NI +6, Deferred Rev -10, ---- Change in Cash -4

BS: A [Cash -4], L+E [Deferred Revenue -10, Retained E +6 = -4]

Array
TripleARated:

IS: Rev +10, NI +6 --- assuming 40% tax rate

CF: NI +6, Deferred Rev -10, ---- Change in Cash -4

BS: A [Cash -4], L+E [Deferred Revenue -10, Retained E +6 = -4]

why is there a decrease in liability of -10? shouldnt it 10 and then once you receive the cash you add cash and decrease the L? in this case of deferred revenue couldn't you do: A(-4 cash +10 acc.receivables), L=0 and E= 6?

regards

Because Deferred Revenue is classified as a Liability.

To go deeper, deferred revenue is when a company takes payment for the product or service but has not yet delivered. It is classified as a Liability because a company using accrual accounting can only record it as revenue when money is received and the product or service is delivered. It is a liability because there is still the possibility that the product or service may not be delivered, or the buyer might cancel.

Of course, there are a lot of nooks and crannies to this under GAAP and IFRS but this is the basic premise.