Posts by: WST Expert 1
Re: Printing
Logic:
Write a code to count the number of visible worksheets in the file, say it returns 8
Then write your print macro to print from worksheet number 2 thru 8 less 1
You can do this easily in a for loop.
Logic:
Write a code to count the number of visible worksheets in the file, say it returns 8
Then write your print macro to print from worksheet number 2 thru 8 less 1
You can do this easily in a for loop.
Re: Technical Question: Excel for PC vs Excel for Mac shortcuts
AutoSum: ALT = is Command Shift T Edit Mode: F2 is Ctrl U Anchor cell reference in edit mode: F2 is Command T Underline: Ctrl U is Command U When pasting, in PC, you can hit ENTER, in Mac version, you have to hit Ctrl V (or Command V) For full set of Excel for Mac shortcuts, go to: Read More
AutoSum: ALT = is Command Shift T Edit Mode: F2 is Ctrl U Anchor cell reference in edit mode: F2 is Command T Underline: Ctrl U is Command U When pasting, in PC, you can hit ENTER, in Mac version, you have to hit Ctrl V (or Command V) For full set of Excel for Mac shortcuts, go to: Read More
Re: Data Table Question
Nope! Unfortunately, only one output cell at a time for a two variable table. You can get fancy with a self-referencing table, but I highly advise against that as it causes circs and is massive annoying to maintain. Good news about data table is that once set up, its easy.
Nope! Unfortunately, only one output cell at a time for a two variable table. You can get fancy with a self-referencing table, but I highly advise against that as it causes circs and is massive annoying to maintain. Good news about data table is that once set up, its easy.
Re: WST Macro
As silly as it sounds, this could be the case of one of your keys on your keyboard being stuck / sticky? Can you try each combination of keys separately: i.e. Ctrl+B to make sure it bolds Shift+B to make sure you get a capital B ALT + any key on the menu/ribbon Then do a Ctrl+Shift+B for our blue m... Read More
As silly as it sounds, this could be the case of one of your keys on your keyboard being stuck / sticky? Can you try each combination of keys separately: i.e. Ctrl+B to make sure it bolds Shift+B to make sure you get a capital B ALT + any key on the menu/ribbon Then do a Ctrl+Shift+B for our blue m... Read More
RE: Merger Modeling Basics: Synergies and Cash PE question
The ability to pay analysis is an extremely quick and dirty analysis that analyzes the maximum purchase price an acquiror can pay based on the funding cost of debt (as cash consideration). As a result, it works regardless of who the acquiror is since there is no stock component to the analysis. Syne... Read More
The ability to pay analysis is an extremely quick and dirty analysis that analyzes the maximum purchase price an acquiror can pay based on the funding cost of debt (as cash consideration). As a result, it works regardless of who the acquiror is since there is no stock component to the analysis. Syne... Read More
Re: Questions about total debt & preferred stock
Yes correct.
Yes correct.
RE: Merger Modeling Basics: Amortization
As this is a quick and dirty analysis, goodwill amortization (usually zero) and any tax deducts (i.e. 338(h)(10) elections) are based on purchase price of equity and as such are not included in this short analysis. Don't think too much into this analysis - the concepts are discussed in the M&A ... Read More
As this is a quick and dirty analysis, goodwill amortization (usually zero) and any tax deducts (i.e. 338(h)(10) elections) are based on purchase price of equity and as such are not included in this short analysis. Don't think too much into this analysis - the concepts are discussed in the M&A ... Read More
Re: Adv Merger Model
Similar to the Complex LBO model, we are calculating Post-Transaction Goodwill. As such, in allocating purchase price, we allocate the purchase price first to book value (hence minus Target Equity from BS) and then allocate to other items, finally with Goodwill as the final excess amount. If need be... Read More
Similar to the Complex LBO model, we are calculating Post-Transaction Goodwill. As such, in allocating purchase price, we allocate the purchase price first to book value (hence minus Target Equity from BS) and then allocate to other items, finally with Goodwill as the final excess amount. If need be... Read More
Re: Complex trading comps - Sears Holdings
This is considered a one-time item that is non-recurring. Please see the Sears video in Complex Trading Comps course for full explanation.
This is considered a one-time item that is non-recurring. Please see the Sears video in Complex Trading Comps course for full explanation.
This will get kind of ugly but bear with us here: So say A1 is a cell containing "Operator: John Doe Address: 123 S Washington St. Phone: (123) 456-789" (including the line breaks). Then in B1, you want to separate out the Operator using this formula: =LEFT(A1,FIND("Address",A1... This will get kind of ugly but bear with us here:
So say A1 is a cell containing "Operator: John Doe
Address: 123 S Washington St.
Phone: (123) 456-789" (including the line breaks).
Then in B1, you want to separate out the Operator using this formula:
=LEFT(A1,FIND("Address",A1)-2)
This should yield "Operator: " and the operator's name in B1.
Then in C1, we can just get the name only using:
=RIGHT(B1,LEN(B1)-FIND(": ",B1)-1)
Now we want to start getting the address line in D1 here:
=RIGHT(A1,LEN(A1)-LEN(B1))
And finish it with E1:
=LEFT(D1,FIND("Phone",D1)-2)
And finally, we get the raw address in F1 like this:
=RIGHT(E1,LEN(E1)-FIND(": ",E1)-1)
Continue this pattern with Phone. In the end, you will have some "extra" cells since the only relevant cells right now are C1 and F1, but we wanted to show you some steps in between instead of jumping right to the answer. Keep us posted on whether you need help with how to isolate the Phone Number. Read More