hello there, i found if we reconstruct all of this, which settlement date not precisely similiar date or month to maturity date, we need to adjust cashflow present value, which we need to discount with power of yearfrac function

Solver does not appear to be available anymore. Suggestions on another way to solve this problem?

I think when you copied the cell from the 10% to the 25% the array "H14:H1013" didn't copy correctly, I bet the 25% has "H15:H1014".

Futures options are expensive 😳😳😳😳😳😳😳 especially compared to their equity counterparts 😳😳😳😳😳😳😳

Awesome! Thanks!!!!

very helpful thanks

Wonderful videos. Would you please show how you computed NPV and IRR? I've been reverse-engineering the numbers and get your NPV value if each CF is $32,500,000 with an initial investment of $100M. However, the IRR seems to require a CF of $31,250,000 with the same $100M investment. This is for the pro-forma P&L, not the MC. Thank you, these are very informative.

Thank you very much for a concise and good presentation👍

very clear. thanks

This helped. Thank you!

Very practical information. I 'm to be applied in my portfolio. Thanks for teaching.

Hi Ronald, Thanks for the video. I had one question, how would you identify a rate sensitive asset or a liability on a balance sheet?

I've wanted to calculate this for my portfolio for some time, but didn't know how to do it, so thank you for showing it.

Funny how now you can import into ChatGPT, and it will perform the calculations.

New to you tube. Not sure if I can download the spreadsheet so I can play with my numbers,

Helpful!

Very nice explanation, I have finally understood it for a lifetime.

They are also in excel btw

Thank you sooooo much for demystifying the Monte Carlo simulation. This is exactly what I've been searching for. Thank you again.

Thank you!

Great simple and succinct explanation ❤

nice

nice

what will make this video better is if you click on the cells to see the formula (it will take seconds), I have no idea how you got % < 0

Can explain formula Total debt I have confusion

Thanks for the video. Let's say I invest $100 on 01/10/2024. I then deposited an extra $100 on 25/10/2024. Then on 01/11/2024 I receive my interests amounting to $20, which means now I have a total of $220. How do I annualise this return? (considering the additional investment)

do you know that youre so smart? ily

much better than school lectures🎉

Hello Ronald, I was looking for this information and had a question. Why do we calculate fixed rate bond with the libor interest and not with the fixed coupon rate? This confuses me a lot. Thanks in advance.

Loved it! Monte Carlo was always like some magic that only experts knew how to use. No more. I am now ready to use it to run simulations of my retirement withdrawals. Wow!

Sir, Please explain at 2:12 how do you calculate weights of bond b and a against bond c

(Current Value/Initial Investment)^(365/Days)-1 si ottiene il medesimo risultato.

Changing the Put exercise price to a lower value would create a "Strangle" (If anyone is wondering).

I am a master student in a german university. Thank you so much for your lecture❤

Great video. It would have been much help if you walked us through how you setup the graph. You left that part out as if it was easy.

Hey Your videos look great, I am going to binge these for my midterm.

This video had plenty of air pockets that make it confusing to a beginner. Look at some of the comments below, viewers are confused as to how company A domiciled in US can make 6% Euro interest payments if they borrowed in dollars and company B domiciled in France make 8% USD interest payments if they borrowed in Euro. Where does company A and company B get these foreign currencies to make interest payments from if they are borrowing in their local currency? What do they do? Draw from some secret vault with foreign currency reserves? Convert their borrowings into foreign currencies? Well, as pointed out by a viewer, that would expose them to FX risk which defeats the entire purpose of the swap. You missed out one key item. Here it is everyone. The principals are EXCHANGED. Company A gets the 40 million euro and Company B gets the 52 million USD at the start of the swap. You failed to mention that. Now here is what happens. Company A invests the 40m euros. Company B invests the 52m USD. The investment pays back in? Yes, you guessed it. Euros for company A and USD for company B. That's how they then make the foreign currency payments. At the end of the swap term, the principals are exchanged back to the original parties. Company A gets the 52 million USD back. Company B gets the 40 million euro back.

Nyc

Thank you so much!

Thank you so much, sir.

I bought this for an exam, but it didn't arrive in time, and I'm glad it didn't because I would have never figure out how to use this.

Excellent analysis, thanks! 👌 Just a small off-topic question: 😅 I have a set of words 🤷‍♂️. (behave today finger ski upon boy assault summer exhaust beauty stereo over). What should I do with this? 🤷‍♂️

how to get the tangent line? (orange color line on ERP graph) and also when i do it but nothing changes

Ur KZbin video still the best ❤

You make a 2-hour lecture redundant

Is this Chris Hansen?

Vid starts at 6:20

When I use SUMPRODUCT function to get portfolio returns then use the variance function on the result, I get the same results

I love your videos! All of them are well explained and help me to understand better the concepts, thank you! ❤

I really appreciate your efforts! I need some advice: My OKX wallet holds some USDT, and I have the seed phrase. (air carpet target dish off jeans toilet sweet piano spoil fruit essay). Could you explain how to move them to Binance?