Summarize ways to copy & paste efficiently in Excel
Full Question:
The commands that move data/formats/formulas over such as Ctrl+R, highlighting and hitting Ctrl Enter, etc. I know some bring just the formula over and some bring the formula over as well as the formatting. Can you provide a summery of which provides which?

GAAP requirement to recognize all known liabilities
In the M&A module, when illustrating the different effective tax rates in the Pre-/Post-142/338 election scenarios, it is stated that GAAP requires all companies to recognize all known liabilities as soon as possible, hence why under a 338 election, the reported GAAP effective tax rate is lower ... In the M&A module, when illustrating the different effective tax rates in the Pre-/Post-142/338 election scenarios, it is stated that GAAP requires all companies to recognize all known liabilities as soon as possible, hence why under a 338 election, the reported GAAP effective tax rate is lower than the IRS effective tax rate.

However, going back to the financial modeling module where we discuss DTLs, why do we assume the same tax rate (e.g. 40%) when calculated taxes owed from EBT under both the GAAP and IRS methologies? Shouldn't the GAAP taxes owed simply be the nominal value that is paid to the IRS, since we need to "recognize all known liabilities"? Read More

Hedge Fund - why the double counting ???
isn't the SHORT & LONG(from SHORT) exactly the same (in & out) ? so why are we double counting them when we calculate the Total Invested Capital?????

Re: GAAP requirement to recognize all known liabilities
Perhaps the numerical example from the Financial Modeling Module would help: Company ABC has Revenue of $500 and Expenses of $300. Where it differs between GAAP and IRS reporting is depreciation, where GAAP reports $20 and IRS reports $40 (due to MACRS). So Company ABC has EBT of $180 under GAAP an... Perhaps the numerical example from the Financial Modeling Module would help:

Company ABC has Revenue of $500 and Expenses of $300. Where it differs between GAAP and IRS reporting is depreciation, where GAAP reports $20 and IRS reports $40 (due to MACRS). So Company ABC has EBT of $180 under GAAP and $160 under IRS reporting. I can understand that because the statutory rate is 40%, then the taxes owed to the IRS is $160 x 40% = $64. However, the example shows that taxes owed under GAAP is $180 x 40% = $72. Clearly, this is how the DTL is derived.

But my question is why Company ABC doesn't report $64 in taxes owed under GAAP, much like the example does later on in the M&A Module, where under the 338h10 election, the GAAP taxes owed is simply the amount owed to the IRS (EBIT $1000 x 40% = $400) so that the effective tax rate is not 40% but 36.4% ($400 / GAAP EBIT $1100 = 36.4%)?

You said that "it just so happens that the effective tax rate (GAAP) is very close to 40%"... but wouldn't the effective tax rate then be calculated as 64/180, or 35.6%?

I apologize beforehand if this is somewhat confusing. A bit hard to verbalize. Read More

conditional average
what would be the formula to calculate conditional average, i.e. if conditions a,b, and c are met then average the rows x1:x40? I used average and if functions in an array formula and it did not accept all the conditions. The results displayed were not consistent with pivot table results.