Posts by: WST Expert 1
Re: Adding hyperlink to header in Excel
Hi Elliot,
Quick question to clarify your end goal: Will the hyperlink be "clickable" on a PDF version of the Excel file? Will it be a text hyperlink or an image?
Hi Elliot,
Quick question to clarify your end goal: Will the hyperlink be "clickable" on a PDF version of the Excel file? Will it be a text hyperlink or an image?
Re: Color Coding
Generally speaking, that type of cell would be considered a blue cell as it is an input. However, our WST Macros functions that automate blue and black color coding would treat that as a black cell because (strictly speaking) it is a formula, starting with an equal sign. That said, we would consi... Read More
Generally speaking, that type of cell would be considered a blue cell as it is an input. However, our WST Macros functions that automate blue and black color coding would treat that as a black cell because (strictly speaking) it is a formula, starting with an equal sign. That said, we would consi... Read More
Re: NPV
Yes, you are correct that if you include the original investment of $10, you would get NPV of $4.2. Our logic was to just take the NPV of future cash flows after the original investment. The logic by not including the $10: in the most traditional capital budgeting decision (invest or don't invest... Read More
Yes, you are correct that if you include the original investment of $10, you would get NPV of $4.2. Our logic was to just take the NPV of future cash flows after the original investment. The logic by not including the $10: in the most traditional capital budgeting decision (invest or don't invest... Read More
Re: Seasonal Working Capital
Is this in the context of an M&A and deciding working capital purchase price adjustments? If so, we would ask: When is this business being acquired - specifically when is deal closing? Is closing going to coincide at what part of the inventory build cycle? i.e. at the absolute low inventory (righ... Read More
Is this in the context of an M&A and deciding working capital purchase price adjustments? If so, we would ask: When is this business being acquired - specifically when is deal closing? Is closing going to coincide at what part of the inventory build cycle? i.e. at the absolute low inventory (righ... Read More
Re: Waterfall distribution IRR
As we suspected, the folks who drafted the documents probably don't have a clue how Excel's XIRR function works. We would say to stick with XIRR since it is very clearly stipulated in the document that XIRR is to be utilized. As you have already noted, there is an inherent conflict in the definition... Read More
As we suspected, the folks who drafted the documents probably don't have a clue how Excel's XIRR function works. We would say to stick with XIRR since it is very clearly stipulated in the document that XIRR is to be utilized. As you have already noted, there is an inherent conflict in the definition... Read More
Re: Waterfall distribution IRR
Hello, That's a good question. Can you please include the exact language (copy and paste) from the agreement so we can see the entire language in context? Usually, when the docs refer to XIRR, they have a further adjustment to the formula, or the section before or after has some additional informa... Read More
Hello, That's a good question. Can you please include the exact language (copy and paste) from the agreement so we can see the entire language in context? Usually, when the docs refer to XIRR, they have a further adjustment to the formula, or the section before or after has some additional informa... Read More
Re: Following up to my (Peter) question RE: Complex LBO Modeling Enhancements - Mezzanine / Warrants Holder Investor Returns
Yes, per answer to your previous question, you would also get mezz principal back. However, do note that if you are indeed exercising your warrants before exit year, the model would need to be adjusted to reflect such exercise, including the following adjustments: - increase in shares outstandin... Read More
Yes, per answer to your previous question, you would also get mezz principal back. However, do note that if you are indeed exercising your warrants before exit year, the model would need to be adjusted to reflect such exercise, including the following adjustments: - increase in shares outstandin... Read More
Re: Complex LBO Modeling Enhancements - Mezzanine / Warrant Holder Investment Return (with PIK and Warrants)
1) Yes, correct - in essence, the basic shareholders get diluted. If you are the mezzanine holder, you would be diluting basic shares. If you are both mezz AND common, in essence, you are diluting yourself in part, BUT mezz offers some protections that common doesn't have. 2) Yes, if warrants are... Read More
1) Yes, correct - in essence, the basic shareholders get diluted. If you are the mezzanine holder, you would be diluting basic shares. If you are both mezz AND common, in essence, you are diluting yourself in part, BUT mezz offers some protections that common doesn't have. 2) Yes, if warrants are... Read More
Re: Windows 10 - Data Value for Default Background Colour of White
Hi Andrew,
The default value is "255 255 255" to represent white. Afterward, you can log out and log back in (or restart Windows) so the changes can take effect.
Hi Andrew,
The default value is "255 255 255" to represent white. Afterward, you can log out and log back in (or restart Windows) so the changes can take effect.
Header pictures in VBA are instances of a Graphic object, which unfortunately cannot have any hyperlinks (reference: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/pagesetup-leftheaderpicture-property-excel). However, you could write a macro to insert a specific image from your computer ... Header pictures in VBA are instances of a Graphic object, which unfortunately cannot have any hyperlinks (reference: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/pagesetup-leftheaderpicture-property-excel).
However, you could write a macro to insert a specific image from your computer onto the Excel file, then attach a link to it. Of course, this won't be in the header, and thus wouldn't show up properly given the layout you have. So if you went with this approach, you would have to essentially "fake" a header with a series of blank rows above your data. Then, narrow in your page margins so that the header rows show up closer to the top of the printed page. Thus, your macro would insert the image (and its attached hyperlink) at the top of each of these blank placeholder rows.
What do you think about this alternative approach? Your Excel template would have to be changed, but it may produce the end result that you're looking for. Read More