Posts by: Guest 1
Conditional Formatting
I have a project for which there are three distinct phases and each one needs a different color. It needs to be color coded across the entire row. There are multiple steps for each phase. Although the steps stay the same, we make iterations in which they change phase constantly. Can I use condit... Read More
I have a project for which there are three distinct phases and each one needs a different color. It needs to be color coded across the entire row. There are multiple steps for each phase. Although the steps stay the same, we make iterations in which they change phase constantly. Can I use condit... Read More
Why do bankers use the paste enhanced picture for excl chart
It seems that pace enhanced pictures into ppt from excel for charts do not look nearly as clear as just pasting the actual chart in chart form. Why is the Paste enhanced picture the preferred format?
It seems that pace enhanced pictures into ppt from excel for charts do not look nearly as clear as just pasting the actual chart in chart form. Why is the Paste enhanced picture the preferred format?
RE: DCF EBITDA multiple approach
You know what you could be right on both... Thanks. I got it.
You know what you could be right on both... Thanks. I got it.
Re: Zoom in Excel
No, just a beeping noise everytime I hit the J.
No, just a beeping noise everytime I hit the J.
338h10 Election and pro forma balance sheet
How would you go about modeling a 338h10 election on the balance sheet. Lets say all of the assets on the books were at $100, but you paid $200 for the company with a 338h10 election. How do you know how to allocate the extra 100 across the assets? Or would you create a new asset category that would... Read More
How would you go about modeling a 338h10 election on the balance sheet. Lets say all of the assets on the books were at $100, but you paid $200 for the company with a 338h10 election. How do you know how to allocate the extra 100 across the assets? Or would you create a new asset category that would... Read More
Tax expense for terminal year
Hi WST, If a company enjoys a tax reduction for whatever the reason for, say, our project years (5 years). Should we adjust the terminal year tax expense to the normal level in order to obtain the correct terminal value? EX, the effective tax rate for t+1 till t+5 would be 10%; however, it would ... Read More
Hi WST, If a company enjoys a tax reduction for whatever the reason for, say, our project years (5 years). Should we adjust the terminal year tax expense to the normal level in order to obtain the correct terminal value? EX, the effective tax rate for t+1 till t+5 would be 10%; however, it would ... Read More
Re: Excel Macros
But where would I enter those in, it seems like if I want to edit my macros, it only allows the ctrl or the ctrl + shift options
But where would I enter those in, it seems like if I want to edit my macros, it only allows the ctrl or the ctrl + shift options
COUNTIF, Then What?
I have a list. Columns are A.) Date Trained and B.) Certified? (this is TRUE or FALSE) I want to make multiple pie charts from one table. I need the pie charts to show percentage certified and percentage not certified. Each pie chart needs to depict a different Date Trained. I currently am usin... Read More
I have a list. Columns are A.) Date Trained and B.) Certified? (this is TRUE or FALSE) I want to make multiple pie charts from one table. I need the pie charts to show percentage certified and percentage not certified. Each pie chart needs to depict a different Date Trained. I currently am usin... Read More
still unsure as to what the proper methodology is
i see what you're saying. the situation is this. we're in the senior secured debt and we are certain that the company is headed towards bankruptcy. we are certain the senior lenders will get the equity post bankruptcy. based on the new accounting standards, we must fair value the converted equity on... Read More
i see what you're saying. the situation is this. we're in the senior secured debt and we are certain that the company is headed towards bankruptcy. we are certain the senior lenders will get the equity post bankruptcy. based on the new accounting standards, we must fair value the converted equity on... Read More
Could someone walk me through the steps on how I can get my y axis labels in a chart to only have the dollar sign at the top marker and the rest aligned correctly but not with the dollar sign obviously. I have tried to do this as he is doing in video over and over again but it doesn't work.