I have an interview tomorrow for a real estate investment banking analyst position and I am trying to figure out how to build an NAV Model. What is the simplest way to describe how you find the market value of debt?
Trending Content - Investment Banking Forum
| +234 | UBS Healthcare | 49 | 1h |
| +65 | UBS MDs Treat Employees like Dogshit, Data to Prove it | 9 | 12h |
| +59 | More diversity needed in the industry | 11 | 2d |
| +57 | Shana tova - happy new year | 9 | 1d |
| +48 | NYC Wall Street Run Club | 13 | 2d |
| +24 | Lost all ambition / don’t care at all anymore | 7 | 6h |
| +21 | Feeling a bad pattern forming. I need some help | 3 | 3d |
| +21 | What is the role of an analyst at your firm? | 1 | 2d |
| +19 | Reaching out to interviewer who rejected me | 2 | 3d |
| +17 | "Don't include firm in Cover Letter's file name" | 5 | 23h |
Career Resources
Is this for a Real Estate group? Usually, NAV is calculated using book value of debt. Regardless, there are 2 main ways to get the market value of debt. The quick one (applies to real estate) which serves as a good proxy of the last reported market value of debt is to look at the latest filings and find the mark to market on debt line item and adjust accordingly. The other one would be to track the company's publicly traded debt tranches (Bonds, Debentures etc.) on BBG to check their current price and adjust the book value accordingly.
So how would you calculate that in Excel. Say if market interest rates were 4.4% and the book value interest rates were 5.0%. Would you simply just multiply the amount of debt by 1.06%?
That is not how the public debt market works. The interest rate on bonds is fixed and has nothing to do with the mark to market calculation. The only thing that fluctuates would be the price of the bond. When bonds are issued to public markets they have a face value which is the amount that the company borrows at that point in time and it is the amount upon which interest is calculated as well as the capital value repaid upon maturity (usually 100k tranches). The price of that bond though in public markets can fluctuate. Hence, this bond may trade at 99 in the public markets. In this example, the company would account for a value of 100 borrowed in its accounting books but the market value of that debt would be 99 (1% discount).
Doesn't private debt fluctuate as well? Hence why we follow the 10-year treasury?
And we follow the Libor for lines of credit as well?
Private debt is private hence you cannot just grab a current value quote for it. You follow all PUBLICLY traded debt tranches and use book value for private debt. This is the best estimate of the market value of debt you can get.
I wonder if recruiters ever get on WSO and end up seeing one of their interviewees. It would be so demoralizing if you came in and kkxty was your interviewer.
Quo minus accusantium id enim aut quisquam. Dicta magni architecto quasi sint cumque dolorem. Labore quidem voluptas dolores. Animi earum cupiditate quam officia placeat. Natus repellat aliquam ut facilis doloremque.
Aut earum sapiente veniam molestias qui enim suscipit. Dolore molestiae suscipit non ipsam qui omnis. Qui quod tempora esse officiis a.
Nulla cupiditate tempora voluptates ipsam asperiores. Aut est officiis optio optio sequi sit nihil reprehenderit.
Ut quas ea dolore tenetur non tempora. Voluptas eum nobis qui amet ut vero molestiae. Ab ex nisi quis rerum velit consequatur ex et. Odio rerum laudantium architecto ex. Neque nihil est nisi quia et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...