So, here is my preliminary relational diagram:

It is pretty simple, but it should do the job.

Reply

So, here is my preliminary relational diagram:

It is pretty simple, but it should do the job.

I need to organize my job search. I am not in hyper job search mode: I have a good job, and I have priorities other than looking for a new employment. And yet, I am doing just enough searching to make for an organizational challenge. Suppose that in the near future I apply for a total of thirty to fifty positions at twenty different employers. At this level, I have plenty of applications, job descriptions, resumes, and letters to track but very few human contacts, responses, and interviews.

Here is what my database application should be able to do:

1. Store potential employers and information about these employers: websites, passwords, notes, HRC rating.

1.5. Store preliminary data about possible employers requiring more research.

2. Store specific jobs and application history, resumes used, letters, description, title, location, job ID.

3. Have a form for adding new job.

4. Perform queries on jobs previously applied to.

5. Produce reports on same.

6. When I do get a response from a potential employer, I need to be able to sit down in front of the computer and instantly see the particulars of the job, plus the particulars of my submission.

I have a little bit of a start already. In a short while, I will post a diagram of my data structure.

**1**. Be over-prepared: The syllabus is so extensive, and there are so many twists that may be put on standard material, that there are always going to be questions that look foreign. The more that you are prepared, the more that you will be able to handle some of these. Being over prepared also helps to deal with emotions. There were points during the exam when a little voice in my head said “There is no way that you are going to pass this.” Yet, that same voice was in my head during many sample exams which I passed with flying colors. Experience and over-preparation reveals that you can succeed even when you are not at your best. If you walk into the exam center with worries, or a cold,or the flu, or pain in your back, you know that you can still succeed.

**2**. Fill in the tough spots: It can hurt your head to learn new things. Identify the areas with which you struggle, and try to get your head around them. Two weeks before the exam, I still had some head-pain topics. Things like duration matching, convexity, interest rate swaps, and put-call parity. But, they were on my daily study schedule, and I forced myself to confront them each day. It paid off.

**3**. Fill in the fundamentals: Once you gain proficiency in a topic, the fundamentals look different. In the month before the test, I went back and reviewed some of the basics of interest theory. At this point, the basics were easy, and I picked up on some of the finer points that I missed the first time around. Amortization schedules, for instance. After I learned the basic formulas, it was easy to ignore the schedules they are based on. Yet many problems are made much easier by using schedules, rather than relying on formulas.

**4**. Memorization is easy: Once you understand things thoroughly, you don’t really need to do much memory work for these exams. After months of working problems, most things will be anchored in your head. And yet suppose that you find yourself trapped in a dark alley by two annuities, one of which is twice as long as the other. Then you will be glad that you memorized I have never encountered this fact in practice, but if I did, recognizing this identity might save me a couple of minutes. Spend a little time on memory work, it is easy.

**5**. Test symbolic solutions with numbers: If you have a problem with a purely symbolic solution, and you can narrow it down to a couple of possible solutions, you can frequently replace the variables with reasonable numbers, and see if the result is true. This is my favorite new solution technique I learned while studying for this exam.

**6**. Read MacDonald: Actually read it. After you learn the math, go back and read it. If you look at the notes from the sample problems, you will notice that the exam writers have made it pretty clear that the exam will be based on the book. Those non-numeric multiple choice questions can be very challenging. Read the book.

**7**. Number your Scrap Paper: I learned this trick when taking practice exams. If you have time to review problems at the end of the exam, you will need to find the scratch-work easily.

**8**. Practice with dull number two pencils: Two weeks before the exam, I put all of my mechanical pencils away, and worked only with old fangled sharpenable pencils. Two hours into the exam, you will be working with dull stubs, so you need to be prepared.

The title indicates that I passed FM. Here is how it happened.

I went easy on studying for the two days before the exam. I did some light reviewing of formulas, shoveled snow, walked the dog, and made candy. Weather was a concern. We have been getting blasted by winter each week, along with most of the rest of you in the Northeast. My spouse had generously agreed to come with me to the testing site (40 minutes away, in Lancaster), but I know that winter driving is very stressful for her, and that it was a pretty big thing for her to agree to come with me at all. I also knew that I would really like to have her emotional support after the exam, pass or fail.

We are buried under snow. I am glad that I checked online, because sometime in the last couple of years the Fruiteville Pike Prometric location moved down the street to the next plaza. I might have had trouble finding it, under the twenty-foot tall snow piles.

So, the test itself. I am so glad that I was over prepared. I had plenty of negative thoughts during the test. But I have been doing these problems under all sorts of conditions for months. It is like having a bad day at work: you know that you can still get your job done well, even on a bad day.

When I was all done with the exam, I still had about 21 minutes to go. This is about how I have been timing my sample exams. In those few minutes, I found errors on three marked questions. These were questions that I had reached the end of, and then found that my answer was not on the list. So frustrating. A little time away from the problem, though, and the mistake is often obvious. In these problems, it is often some vital misreading at the front end or back end of the problem.

Anyways, I worked right up to the end. I filled the survey at the end out in a big hurry, because I couldn’t wait to see the result. I was so surprised to see a “pass.”

That’s it. Now that I am done, it is like this big thing that has been dominating my life since early fall is just gone.

When I got home, I pulled out the exam MFE syllabus.

**Question:**

At an interest rate of 2%, what is the value of an annuity that pays 1 dollar at the end of year one, two dollars at the end of year two, increasing in a similar way until the end of year eight, and then diminishing by one dollar each year thereafter until it reaches zero?

Who dreams up cash flows like this? Can you imagine going to your investment person and asking to buy such a product? I visited my imaginary bank, and here is what happened when I talked to the financial specialist:

No problem. What you are interested is known as a Palindromic Annuity. The present value of this financial product is Would you like me to derive that for you? No? Okay, in your case, we can write that as It might be easier for you to understand if I write it as That comes to $54.74. How will you be paying for that? Cash? Thank you for banking with us today.

*This gallery contains 5 photos.*

A week left until the financial mathematics exam. The best thing that I can say is that I can honestly not have worked any harder at studying. In the last three months, I have studied at least three hours a day, and frequently I have done eight to ten hours a day. Much of that time has been absolutely focused. The question is: have I studied as smartly as possible? I won’t know the answer to that until after the examination.

I have done about two hours of problems today. I see that there are 19 problems remaining in the queue. These are problems that I have seen before, and that I still wish to spend some time with. I spend enough time with each problem that I feel I am confident that I understand several ways to get to a solution, or until I get sick of looking at it. If I get sick of looking at it, it comes up on the queue again later today or tomorrow. If I am fluent with it, I don’t look at it for a few days. Eventually, it disappears from the queue.

Earlier today, I already did some easy numerical exercises. Later today, I will probably do an exam, which is a whole other kind of problem solving, because of time pressure (5 minutes per problem.)

What I am going to do here is type in problems as they come up on my screen, then write up solutions. If I don’t understand the problem, you will get to watch me struggle.

Person X enters into a long forward contract. If the spot price at expiration were S, the payoff would be -20. If the spot price at expiration were 1.2S, the payoff would be X.

Person Y enters into a short forward contract. If the spot price at expiration were 0.8S, the payoff would be 40. If the spot price at expiration were 1.1S, the payoff would be Y.

The forward price on each contract is the same.

What is X+Y?

We aren’t going to do a diagram for this one. I tried, on paper, and since we don’t know the values of 0.8S, 1.1S, or 1.2S, it is hard to know where to place them in relation to the forward price. So, let’s go with straight algebra, and see if that leads us to a reasonable solution.

A 15 year bond with semiannual coupons has a redemption value of $100. It is purchased at a discount to yield 10% compounded semiannually. If the amount for accumulation of discount in the 27^{th} payment is $2.25, which of the following is closest to the total amount of discount in the original purchase price?

We have all sorts of information here, so it should be easy to get to an answer. First, since the coupons are semiannual, we can just think entirely in 6 month terms. Since the bond is sold at a discount, we know that the coupon rate is less than the interest rate. We know that we can solve this problem by finding the original purchase price, and subtracting it from the redemption price. First, we need the coupon, which we can find using the premium discount formula.

Let’s start with that. Assuming that F=C, the amount of discount in the kth payment is:

Here are our givens:

Now solve for the original sale price. We might as well continue with the premium discount formula:

Discount in original price = 42.04.

Let’s just do one more.

To accumulate 8000 at the end of 3n years, deposits are made at the end of the each of the first n years and 196 at the end of each of the next 2n years. (1+i)^n = 2.

What is n?

These problems are much simplified by visualizing them in the right way. The easiest way to think of it is payments of 98 from 1 to 3n years, plus payments of 98 in years 2n+1 through 3n.

In math:

I am going to post one more, because it is a real bear. To solve it, you trust that the math will lead you to the answer.

Given a k year bond with semiannual coupons, and a yield rate of 10% convertible semi-annually, sold at a price p.

If the coupon rate had been r-0.04, the price would be P-200.

Calculate the present value of a 3k year annuity immediate paying 100 at the end of each 6 month period, at a rate of 10% semiannually.

Start at the end. We need to find:

Which means that what we really need is k (although v^k will do).

Dive in:

The thing about math at a certain level is that there are no more easy exercises. I have learned to make a habit of creating simple exercises. These are for the forward price, which is the contracted price to buy an asset at time T in the future; and the prepaid forward price, which is the price paid now for an asset that will be delivered at time T. In these problems, * r * is the continuous interest rate, and delta is the continuous dividend rate.

Solutions:

Later today, I will post some tougher ones that require a little thinking.

I have been listening to music while I study for this exam. Partly because I am studying in a room where there is some coming and going of people and pets, partly because the music keeps my body wiggling while I study, and partly because I am beginning to immerse myself in bebop jazz. I can’t study to most music with words, and I also have come to have a certain like for some current ambient and electronic music. So here’s my Financial Mathematics study music list:

Classic Bop Stuff:

- John Coltrane – Giant Steps
- Miles Davis – Kind of Blue
- Charles Minus – Ah Um
- Thelonious Monk
- Dave Brubeck – Time Out

Other:

- Christian McBride – People Music
- The Crystal Method
- The Teddy Bears
- Disparition

This is the first time in my life that I have studied to music. Strangely, it all started because I listen to podcasts, and I found that I can’t concentrate on math while I listen to podcasts, so I switched to music. Now, I am hooked.

Today, I am going to listen to classic Nirvana, even though it has words. What do you think of studying to music?