Posts by: WST Expert 1
RE: Summarize ways to copy & paste efficiently in Excel
Copy / Paste => copies and pastes formulas/values, formatting and comments Ctrl + R / D => copies and pastes formulas/values and formatting don't forget about Ctrl + L and Ctrl + Shift + U with our macros Ctrl + Enter => copies and pastes formulas/values only Ctrl + ' => copies and ... Read More
Copy / Paste => copies and pastes formulas/values, formatting and comments Ctrl + R / D => copies and pastes formulas/values and formatting don't forget about Ctrl + L and Ctrl + Shift + U with our macros Ctrl + Enter => copies and pastes formulas/values only Ctrl + ' => copies and ... Read More
RE: Selecting two or more non-adjacent cells to quicky get sum
To highlight non-adjacent cells, use mouse - it's quicker. One could write a macro, but not worth it. When you have more than 1 cell (whether adjacent or not adjacent) selected, see the bottom right of your status bar. The sum should appear.
To highlight non-adjacent cells, use mouse - it's quicker. One could write a macro, but not worth it. When you have more than 1 cell (whether adjacent or not adjacent) selected, see the bottom right of your status bar. The sum should appear.
Re: Interview Question - What would Hamilton or Dave Do?
The approach would be the same to all companies - identify the revenue growth. break down where the revenue comes from, who's the customers, # units, sales price, etc. So with TiVo, same thing - how many customers, average price, growth rates, etc. Then, break down the costs that TiVo has. A retail ... Read More
The approach would be the same to all companies - identify the revenue growth. break down where the revenue comes from, who's the customers, # units, sales price, etc. So with TiVo, same thing - how many customers, average price, growth rates, etc. Then, break down the costs that TiVo has. A retail ... Read More
Re: Income Tax Payable
Either way would be fine. We prefer to keep it separate.
Either way would be fine. We prefer to keep it separate.
RE: Accessing the file location for auto-starting macro toolbar
You may not see this directory because it is a hidden system folder that you need to unhide. Follow the directions for unhiding system folders - in Windows Explorer, go to TOOLS => FOLDER OPTIONS => VIEW => Hidden Files and folders => Show hidden files and folders. You should be able to ... Read More
You may not see this directory because it is a hidden system folder that you need to unhide. Follow the directions for unhiding system folders - in Windows Explorer, go to TOOLS => FOLDER OPTIONS => VIEW => Hidden Files and folders => Show hidden files and folders. You should be able to ... Read More
RE: Treasury Options: Shares dilution
When calculating valuation of a private company, you are supposed to calculate the Implied Total Enterprise Value, deduct Net Debt, if any, to arrive at Implied Equity Value. There is no Price per Share to speak of since it is private and is rather meaningless even if there were internal number of s... Read More
When calculating valuation of a private company, you are supposed to calculate the Implied Total Enterprise Value, deduct Net Debt, if any, to arrive at Implied Equity Value. There is no Price per Share to speak of since it is private and is rather meaningless even if there were internal number of s... Read More
Re: PIK interest and P&L/Cashflow
In our model, the PIK interst is actually adjusted thru the Debt Sweep which runs thru CFF debt repayment line. If you wanted to, yes you could separate the logic and have as a separate line item on CFF but we chose to run it thru the Debt Sweep since all the information is already there. On the deb... Read More
In our model, the PIK interst is actually adjusted thru the Debt Sweep which runs thru CFF debt repayment line. If you wanted to, yes you could separate the logic and have as a separate line item on CFF but we chose to run it thru the Debt Sweep since all the information is already there. On the deb... Read More
Re: Diluted shares outstanding
It should be on either the IS construction or the CF construction. We will check and respond.
It should be on either the IS construction or the CF construction. We will check and respond.
Re: a question about the certificat?ion
For purposes of the WST Certification process, use ending balance as we did in the training.
Normally one should use Average balance for working capital ratios that mix BS and IS, but for simplicity, use ending. When in doubt, do what was done in the training for the certification.
For purposes of the WST Certification process, use ending balance as we did in the training.
Normally one should use Average balance for working capital ratios that mix BS and IS, but for simplicity, use ending. When in doubt, do what was done in the training for the certification.
That was an illustrative exercise. We're teaching you how to think, not the only scenario that could occur!