Відео

Fordi det er aktiviteten (dvs. omsætningen) der sammenlignes med for at analysere, hvorvidt omkostninger har udviklet sig negativt eller positivt

Hi Timothy 🙂Glad, you like it 🙂 I just tested the sheet and it works as intended. I cannot say why you get this error. Did you download a copy or did you just use it online? My best guess is that downloading a copy to your own computer having Excel software will fix the problem. Kind regards, Carita

Det er rigtig dejligt at høre, at det kan bruges! Held og lykke med studierne 😊

Thx 😊

Thank you so much 😊

Hi and thank you 😊. The formulas in Excel are made, so you easily can drag the cell further out, hence expanding to 15 periods. Of course you have to insert some empty rows first in order to have the needed amount of rows. If this does not help you, I recommend to study the formulas in the cells of the 9th and 10th period, see how the develope and add the 11th up to 15th period in a similar manner. Kind regards, Carita

Hi..Thanks a lot for your appreciative comment 😊. My first thought is whether you have activated the sheet after download - you probably did that already. However, if you for some reason cannot choose the option type in the scroll down menu, it’s really not a problem - you just scroll down the sheet itself instead and all 4 possible types of options are shown below. The feature of choosing option type in the menu was just to make it more user friendly as you would always have your option presented in the above tree of the page. Hope you will be able to use it. Kind regards, Carita

Hi 😊Given the data you supply and assuming that the tree has two steps dyring the two years, the price for an American put is 14,2994 in my model. This is exactly the same you get using DerivaGem in the book "Options, Futures, and Other Derivatives" by John Hull. Therefor I cannot see that the correct answer would be 15,13 unless of course there is a typo in some of the given data or that the number of periods (not stated) is different from 2. I have tested with a various different number of periods and neither of my tests result in an option price of 15,13. I hope, you find out - I would be interested to hear you solution ☺

You’re welcome, good to hear 😊

Hello, My best guess is, that the formula isn’t working due to the way, you typed in the information. Perhaps you used a dot (.) instead of a comma (,)? My advice would be to download the sheet again and observe how I’ve entered the information and look for any mismatches in how you entered the information. The upmovement, the downmovement and the probability are all calculated using Excel formulas - and as I’m sure you are very well aware of, they only function if they can recognize the numbers and signs in the entered data which the formulas are using. Hope it works out for you 🙂

Hi Taylor I cannot say that I have any particular knowledge regarding your question nor am I able to point to any research regarding the topic. However, my thoughts are that you would need a binomial tree for each time period (each business day) since you need an average of the index. Hence placing the index at time 0 and use periods of 2, of 3, of 4 up to 21 business days and after that calculate a simple average of the prices from the 21 binomial trees. I cannot say if this rather simple idea is the best way to go - but it's the only soution that I can see without using overlapping formulas in Excel - which of course doesn't work. Yo can easily drag the formulas in my binomial trees to extend the periods up to whatever you need. Kind regards Carita

Hi - it's the formula to discount or compound the interest over the periods of time. Microsoft explaines the formula like this: "This article describes the formula syntax and usage of the EKSP function in Microsoft Excel. Description Returns e raised to a power of number. The constant e is equal to 2.71828182845904, which is the base of the natural logarithm." Kind regards, Carita

Thx a lot😊

Thank you 😊. I am puzzled that you cannot find the sheet. I just tested the link and it worked just fine. Hope it works out for you. Otherwise let me know and we will find another solution, if you still want the sheet 😊

​​@@caritahnborg5928 I apologies the download worked successfully

@@caritahnborg5928 I've downloaded the file using the link and it appears to work for me perfectly. Thanks a lot for the video and the workbook :)

​@@caritahnborg5928I forgot to tell you that I found the sheet, but I have two questions. First question: In the Black Scholes model, there are variables that are considered constant, such as yield volatility and dividends. Does your method have constants? Second question: Did you create the option price using approximately finite differences with an option formula, for example the Black Scholes model, or did you create the option price using just numerics without an option formula?

@@metehan9185 Hi again. Great that the download worked 😊. On your questions, I suggest litterature like “Fixed Income Modelling” by Claus Munk - I think, you’ll find the info there - it seems as if you are looking for some more detailed info than I can provide here.

Thank you very much 😊

Thank you for the appreciative comment. I myself looked so many places for videos of this type, when I needed them, so now I’m glad to share 😊

Dejligt at høre - godt, at filmen kan hjælpe 😊

Hi - thank you for reaching out. In order to use the sheet you have to save a copy on your computer (and you probably have to activate the editing - usually easy to see at the top of the sheet). The cells open for input are: Stock price, Volatility given, Total lifetime in years, Number of periods, Strike price and Risk free rate. The other cells are protected in order to preserve the formulas and thus keep the sheet functioning. I hope, this will work for you - I have had it tested by some of my friends and they could use the sheet as here described.

Hi again - one more thing: The cells are only protected in the first sheet with the "standard" binomial tree. The other sheets (dividend, currency and futures) are completely open for you to alter as you wish 🙂

Hi Lana. Thank you for your message - I’ll look into it and fix it. It was kind of you to let me know. Kind regards, Carita

Hi again - I replaced the link and I hope it will work for the download now. I will be so grateful, if you will let me know whether it is working or not.

Hej 😊 Ja, du kan altid sætte to funktioner lig med hinanden i skæringspunktet - uanset typen af funktion. Se fx en god forklaring i forhold til eksponentielle funktioner på kanalen: Gymnasiemaple Thomas Schausen

Hej Sigrid Selve omsætningstallene skal man have på forhånd fra fx en opgavetekst eller fra et regnskab for en virksomhed. Omsætningen består af antallet af alle de varer, der er solgt (afsætningen) ganget med salgspriserne uden moms. I praksis er det helt umuligt at regne ud, medmindre man har adgang til virksomhedens regnskab. Det er jo ikke til at vide, hvor mange stk. der er solgt af hver vare eller hvilke salgspriser, de er solgt for. Derfor får man enten omsætningen (salget) oplyst eller man finder tallene for omsætningen i virksomhedens regnskab. Denne film handler kun om, hvordan man ud fra givne regnskabstal kan beregne selve indekstallene, så man kan se den procentvise stigning og sammenligne (dette er gennemgået i filmen om forklaring af indekstal). Mvh Carita

Mange tak 😊

Mange tak 😊

Hej Nicolai. Mange tak 😊. Du har helt ret - det er fordi en bankkonto som udgangspunkt er en værdi (medmindre der er overtræk 😉)

Tak 😊

Jeg er helt enig

Mange tak 😊 Godt, den kan bruges 😊

Tak Niklas!

Tak 😊

@@caritahnborg5928 kan man være så heldig at du vil hjælpe med at tyde et par nøgletal og om jeg har forstået opsat det korrekt? 😅 har nemlig nogle andre ord i regnskabet

@@nananannananaomi Hej igen 😊. Tak for tilliden, men må desværre melde pas, da jeg er i fuld gang med onlineundervisning af mine egne elever. Håber, du finder en god løsning 😊

Tak 😊 Du har helt ret - det er en smutter! Det ændrer dog ikke noget på den principielle forklaring om brug af debet og kredit i det dobbelte bogholderi, så jeg håber, det gav mening alligevel 😊

@@caritahnborg5928 nej det gør det nok ikke ... det giver bare en "lille" minus i din perfekte video :-)

Tak 😊. Godt, den kan bruges 😊

Tak 😊

Mange tak. For tiden arbejder jeg på matematik-videoer, derfor tør jeg ikke love en video om bogføring af feriepenge lige nu.Jeg kan kort oplyse, at du skal debitere feriepengene på samme måde, som du debiterer lønomkostning - og kreditere skyldig AMB og skyldig A-skat af feriepengene på de samme skyldige konti, som bruges ved AMB og A-skat af almindelig løn. De feriepenge, som skal udbetales til medarbejderen, krediteres på skyldige feriepenge eller på bank, når du evt. overfører til feriekonto.