Posts by: Guest 1
Re: Purchase Price Allocation
Hi, thanks for your prompt response. Just 2 follow up questions: 1. So as per I could understand from your explanation, EXISTING DTL should be adjusted to FMV, and not writen-off completely? Because my question was why do que write-off EXISTING DTL ENTIRELY (not just adjust to FMV)? Could you pleas... Read More
Hi, thanks for your prompt response. Just 2 follow up questions: 1. So as per I could understand from your explanation, EXISTING DTL should be adjusted to FMV, and not writen-off completely? Because my question was why do que write-off EXISTING DTL ENTIRELY (not just adjust to FMV)? Could you pleas... Read More
Re: WST Macro Problem
I have a related question: do the WST macros expire after the the 6-month video course period elapses?
I have a related question: do the WST macros expire after the the 6-month video course period elapses?
buyout of equity value?
Hello, I'm trying to understand why in an M&A transaction, we are only acquiring the equity portion of a company? For example, if your target company is worth EV of 100, Equity=500, Debt=700 and Cash =200. Why are we not buying the company at 1000 as opposed to a (usual) premium over equity v... Read More
Hello, I'm trying to understand why in an M&A transaction, we are only acquiring the equity portion of a company? For example, if your target company is worth EV of 100, Equity=500, Debt=700 and Cash =200. Why are we not buying the company at 1000 as opposed to a (usual) premium over equity v... Read More
AFM Core Model: pay down down with all excess cash
how do you model in paying down the debt with all excess cash?
how do you model in paying down the debt with all excess cash?
Why use average (industry) beta?
Hi, I watched the complex trading course as well as the finance 101 and corporate valuation course, yet I still have a question regarding the WACC calculation of the complex trading comps: Why do we use the average un-levered beta of the industry rather than WMT’s specific beta? I understand why ... Read More
Hi, I watched the complex trading course as well as the finance 101 and corporate valuation course, yet I still have a question regarding the WACC calculation of the complex trading comps: Why do we use the average un-levered beta of the industry rather than WMT’s specific beta? I understand why ... Read More
Completed Model: Advanced Bank Model
Hello, I took the advanced bank modeling course. I had a few problems in building out my model while watching the videos and am wondering if anybody has a complete model that I can review to see where I made my errors (aka: balance sheet not balancing). Also, I am attempting to modify this model to ... Read More
Hello, I took the advanced bank modeling course. I had a few problems in building out my model while watching the videos and am wondering if anybody has a complete model that I can review to see where I made my errors (aka: balance sheet not balancing). Also, I am attempting to modify this model to ... Read More
RE: Tax rate
So, as per I could understand the 40% tax rate was an assumption based on the verified normalized effective tax rate for discount retailers, is that right?
Tks.
So, as per I could understand the 40% tax rate was an assumption based on the verified normalized effective tax rate for discount retailers, is that right?
Tks.
Stock issued: calculated off Equity Value or EV?
I noticed that the calculation for stock issued in an M&A deal differs in your Simple Merger Model vs the Int-Adv Model. Why in the simple merger model do you calculate stock issued based on EV whereas in the Int-Adv Merger Model with PEP and TAP you calculate it based off the equity value?
I noticed that the calculation for stock issued in an M&A deal differs in your Simple Merger Model vs the Int-Adv Model. Why in the simple merger model do you calculate stock issued based on EV whereas in the Int-Adv Merger Model with PEP and TAP you calculate it based off the equity value?
Re: Inventory Writedown
I have one more question in regards to this. I have a balanced model right now, however when I put in 100 of writedowns on my I/S, my inventories do not fall by 100. I followed the steps to perform on the IS and CF but am a bit unsure about the B/S. Currently before any inventory writedown featur... Read More
I have one more question in regards to this. I have a balanced model right now, however when I put in 100 of writedowns on my I/S, my inventories do not fall by 100. I followed the steps to perform on the IS and CF but am a bit unsure about the B/S. Currently before any inventory writedown featur... Read More
Hi, two follow up questions here: (3). Sorry, but I was expecting an explanation of WST as I always have had here since I started the courses. Again, I have watched the videos and this specific point I'm asking you was not covered explicitly. So, could you please review my question and address th... Hi, two follow up questions here:
(3). Sorry, but I was expecting an explanation of WST as I always have had here since I started the courses. Again, I have watched the videos and this specific point I'm asking you was not covered explicitly. So, could you please review my question and address that issue (PV of covertibles x "market value of equivalent shares" x Face value)?
(4). In here, I wasn't asking you guys to repeat anything. Just wanted to know if there is any other adjustment that needs to be done. So, Am I forgetting anything on the adjustments to be made in the financials when assuming convert?
I again appreciate your assistance.
Rgds. Read More