Posts by: Guest 1
PPE&depreciation schedule
Hello, I just finished the depreciation schedule session of advanced modeling, in which Capex starts to be depreciated in the next year. In fact Capex is not going into PPE immediately and construction for buildings often takes more than one year. During the construction period, capx is in the fo... Read More
Hello, I just finished the depreciation schedule session of advanced modeling, in which Capex starts to be depreciated in the next year. In fact Capex is not going into PPE immediately and construction for buildings often takes more than one year. During the construction period, capx is in the fo... Read More
Please elaborate why cash is deducted from enterprise value.
Full Question:
Please elaborate why cash is deducted from enterprise value. I always have performed this calculation because I presume the acquiror will use the cash to finance the deal.
Full Question:
Please elaborate why cash is deducted from enterprise value. I always have performed this calculation because I presume the acquiror will use the cash to finance the deal.
Corporate Valuation: Nuances on these methodologies
Hi there, I have a couple of doubts in relation to this module: (1). Could you please explain in more detail why capital leases are excluded (I watched that part twice and didn't really get it)? If we had a leasing finance (a credit line w/ a commercial bank) would we include it in the EV calc... Read More
Hi there, I have a couple of doubts in relation to this module: (1). Could you please explain in more detail why capital leases are excluded (I watched that part twice and didn't really get it)? If we had a leasing finance (a credit line w/ a commercial bank) would we include it in the EV calc... Read More
Re: Excel Macros
Right. Sorry for the confusion, but I am asking what is the code needed in VB to make the alt + shift + ctrl shortcuts work?
Right. Sorry for the confusion, but I am asking what is the code needed in VB to make the alt + shift + ctrl shortcuts work?
Goodwill
Hi WST,
Quick Question: should option proceeds be deducted from purchase price to calculate the goodwill?
Many thanks.
Hi WST,
Quick Question: should option proceeds be deducted from purchase price to calculate the goodwill?
Many thanks.
Re: Custom fonts for Chart Y Axis.
Ok, thanks. How about if you want two numbers say..the first and last i.e $0.00 or $30.00 would it be... [=0,30]$0.00;_$0.00 ??
Ok, thanks. How about if you want two numbers say..the first and last i.e $0.00 or $30.00 would it be... [=0,30]$0.00;_$0.00 ??
Wal-Mart Self Study Share repurchase
Hi WST, Hope all is well. While I am reviewing the Wal-Mart Advanced Financial Modeling excel, I realized that WM actually had a "share re-purchase program." However, I don't understand why on the projection we kept the common stock account in balance sheet constant. Should not we alloc... Read More
Hi WST, Hope all is well. While I am reviewing the Wal-Mart Advanced Financial Modeling excel, I realized that WM actually had a "share re-purchase program." However, I don't understand why on the projection we kept the common stock account in balance sheet constant. Should not we alloc... Read More
Re: 338h10 Election and pro forma balance sheet
Also, there would often be not a DTL...but more of a negative DTL (or I guess a DTA??) because cash taxes would actually be LESS than book taxes due to large amount of goodwill in a 338h10 that may be written off. Thus, do I need an asset on the balance sheet (or a contra liability to DTL) that woul... Read More
Also, there would often be not a DTL...but more of a negative DTL (or I guess a DTA??) because cash taxes would actually be LESS than book taxes due to large amount of goodwill in a 338h10 that may be written off. Thus, do I need an asset on the balance sheet (or a contra liability to DTL) that woul... Read More
How do you factor net operating losses (NOLs) in valuation?
Full Question: How do you factor net operating losses (NOLs) in valuation? I try to determine the NOL present value and add it to the enterprise value. This approach is very speculative, so I try to exclude NOLs from my valuation analysis unless I feel fairly confident the company/acquiror could us... Read More
Full Question: How do you factor net operating losses (NOLs) in valuation? I try to determine the NOL present value and add it to the enterprise value. This approach is very speculative, so I try to exclude NOLs from my valuation analysis unless I feel fairly confident the company/acquiror could us... Read More
]I have a standard report template in excel. I paste data into this Excel template based on a copied selection from an Access query. There are two columns, A.) Name and B.) Dollars The bottom row is a SUM of all the dollars above The columns remain static, but the rows will change depending on ho... ]I have a standard report template in excel. I paste data into this Excel template based on a copied selection from an Access query.
There are two columns, A.) Name and B.) Dollars
The bottom row is a SUM of all the dollars above
The columns remain static, but the rows will change depending on how many people the Access query returns.
1. Does Excel have a method to paste the data from access, and automatically expand or contract the rows to the number of rows necessary.
2. Does Excel have a method to automatically sort by dollars largest to smallest other than a filter I would have to manually reset with each report?
Keep in mind that I need the bottom row containing the SUM function to always be directly below the pasted names and dollar figures.
Thank you! Read More