Manual for sheet with on (big) call ----------------------------------- Please load the version you need: FondsCalc.TCD for use with TurboCalc 3.5+ (maybe earlier, too) FondsCalc.slk (SYLK-Format for use with other spreadsheets) In cell A1 is the title. For XX you can insert needed names. These are the kind of fonds, the name of it, the company and bank, too. example: Performance of the value for the fonds Weka-Nord (Corporation Nord-Invest) on Vereins- und Westbank. In cell A5 you should insert number of shares by your call. There are possibilities for sharing parts, and therefore no integer value in this cell. Shares from following calls you can insert into cells A8 and A11. If you don't own such shares, please insert 0 there. If three cells are less than you need for calling shares, please contact me. At the SYLK format no settings for the structure of numerical values were imported. In cell B5 you should insert the value of a share by calling (in Euro). In this value the spread for the call is integrated, of course. In cell B6 the value in your currency appears. The cells B8/B9 and B11/B12 are planned for following shares. If you don't own such shares, please insert 0 there. For all currency labels in this sheet: After the value the abbreviated currency name is shown. You should change it, if you use another currency as the default (EUR, DM), because it's only normal text. In this case you only have to change the text in cells C5/C6. All other texts are updated automatically. In cell M20 you should insert the exchange factor for your currency. This value describes how much of your currency are 1 Euro. The default value is 1.95583 for German marks (DM). In cell D5 (yellow cell) you should regularly insert the actual value for a share (in Euro) for getting a real calculation. Of course, that means the value for cash out shares. This cell is the only one, which you have to hold in current status by yourself. The entries in all other cells are only to set by start. In cell D6 the value appears in your currency. In cells F5/F8/F11 the differences between the value by today and by call is appearing (in Euro). A negative value describes a loss (especially in the weeks and months after call as direct result of the spread). In cells F6/F9/F12 the same values for your currency is appearing. In cell H5 the date for the call is needed. The cells H8/H11 are planned for dates of the calls for following shares. In cell I5 appears the current date. In cell A16 the number of shares is specified, which are called with the cash out. It contains only "won" profit, so it's an 100% tribute, of course. In cell J5 the difference for the performance (in Euro) for the time of one year is given. If the call isn't one year ago, there could be relatively big gains or losses. That depends on the speculation times for which no real predictions are possible. Securities and estates should show useful values after a few months already. After first cash out there should be normal values for fonds of stocks, too. In cell J6 are the same values for your currency. In cell I20 you should insert the appropriate costs of your depot (in %). example: 0.00125 means 0.125% (1 means 100%) At SYLK format no settings for structure of numerical values were imported, and so in this cell appears the decimal instead of the percent value, p.e. 0.00125. In cell I21 you should insert the counts of paying these costs during one year. (usual values are 4 to payment per quarter). In cell J20 you should insert the appropriate costs for the managing (in%). example: 0.00125 means 0.125% (1 means 100%) In cell J21 you should insert the counts of paying these costs during one year. (usual values are 4 to payment per quarter). If there are no such costs needed for your investment, or these already calculate into the performance, then you should insert 0% in the appropriate cell. In cell L20 the tax rate is needed. In Germany the tax for cash out is about 30.5%. There is a small amount of cash out, which is free of tax (999 DM). Please contact me for other values or calculation models for your country. In cell L21 the amount of cash out is needed, which is free of tax. In Germany there are 999 DM. In cell B22 the total amount of money for the call (in Euro) is given. In cell B23 is the same value for your currency. In cell D22 the current amount of the investment (in Euro) appears. That is the value you get by put today. In cell D23 is the same value for your currency. In cell F22 the current amount of the investment after taxation (in Euro) appears. That is the value you get by put today, and have to give a part to your government. In cell F23 is the same value for your currency. In cell L5 the true profit (in %) is given. There are already all appropriate costs included. In cell M5 appears the yearly "interest rate". Because a fonds of stocks doesn't cash out an interest rate, I "invented" this value to compare it with normal straight bonds. This value describes the theoretical interest rate for a straight bond with the same tribute as the appropriate fonds. This value is highly accurate and a very good thing for comparing. November '99