<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0"><channel><title>Experiments in Finance</title><link>http://www.experiglot.com</link><description>Because you shouldn't need an MBA to be savvy about finance and business</description><language>en</language><lastBuildDate>Wed, 04 Nov 2009 17:08:38 PST</lastBuildDate><generator>http://wordpress.org/?v=abc</generator><sy:updatePeriod xmlns:sy="http://purl.org/rss/1.0/modules/syndication/">hourly</sy:updatePeriod><sy:updateFrequency xmlns:sy="http://purl.org/rss/1.0/modules/syndication/">1</sy:updateFrequency><geo:lat>37.792778</geo:lat><geo:long>-122.421881</geo:long><image><link>http://www.experiglot.com</link><url>http://www.experiglot.com/wp-content/themes/gfx/experiment.jpg</url><title>Experiments in Finance</title></image><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/experiglot" type="application/rss+xml" /><feedburner:browserFriendly>This is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site, subject to copyright and fair use.</feedburner:browserFriendly><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><item><title>Off-topic: Do you know more than the average American?</title><link>http://feedproxy.google.com/~r/experiglot/~3/9kMyi-0yLck/</link><category>Blogging</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Wed, 04 Nov 2009 17:08:38 PST</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=796</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>The Intercollegiate Studies Institute (ISI) published a <a href="http://www.americancivicliteracy.org/resources/quiz.aspx" rel="tag">civics quiz and literacy report</a> a while ago that I meant to post. Feel free to take it, and then click on the links on the left for more info on some of their findings. Embarassingly, I only scored a 75% (that&#8217;s a C), which although higher than the average American at 49%, is still pretty dismal considering all the education I&#8217;ve had. </p>
<p>Although the parts are no doubt edited down so that only the most unbelievable bits are aired, here&#8217;s a funny clip from Jaywalking on money matters from the <a href="http://en.wikipedia.org/wiki/The_Tonight_Show_with_Jay_Leno">Tonight Show with Jay Leno</a>.</p>
<p><center><br />
<object width="580" height="360"><param name="movie" value="http://www.youtube.com/v/7M9XoT5WsWE&#038;hl=en&#038;fs=1&#038;rel=0&#038;border=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/7M9XoT5WsWE&#038;hl=en&#038;fs=1&#038;rel=0&#038;border=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="580" height="360"></embed></object><br />
</center></p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=9kMyi-0yLck:WBhWiiYhQ2g:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>The Intercollegiate Studies Institute (ISI) published a civics quiz and literacy report a while ago that I meant to post. Feel free to take it, and then click on the links on the left for more info on some of their findings. Embarassingly, I only scored a 75% (that&amp;#8217;s a C), which although higher than [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/11/04/off-topic-do-you-know-more-than-the-average-american/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">0</slash:comments><category domain="http://rss.financialcontent.com/stocksymbol">ISI</category><feedburner:origLink>http://www.experiglot.com/2009/11/04/off-topic-do-you-know-more-than-the-average-american/</feedburner:origLink></item><item><title>How to create a pivot table in Excel 2007 – Part I – a quick and basic intro</title><link>http://feedproxy.google.com/~r/experiglot/~3/ONhDPF4rCCs/</link><category>Excel function tutorials</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Wed, 21 Oct 2009 06:21:57 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1292</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>Seems like it&#8217;s been eons since I posted an Excel tutorial, so I thought I&#8217;d write a brief intro on how to create <a href="http://office.microsoft.com/en-us/excel/HA010346321033.aspx" rel="tag">pivot tables in Excel</a>. Pivot tables are unnecessarily mysterious and perplexing to many people, but as you&#8217;ll soon see, they&#8217;re easy to set up and a convenient way to look at spreadsheet data once you get the hang of it. There are multiple ways to set up a pivot table, but this tutorial goes through how I usually do it, and the method works for both Excel 2007 and 2003.</p>
<p>First, suppose we have the data below, which shows two managers, their employees, and the number and amount of sales each employee made in 2008 and 2009:</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step1.PNG" alt="step1" title="step1" width="456" height="379" class="aligncenter size-full wp-image-1299" /></center></p>
<p><span id="more-1292"></span></p>
<p>Let&#8217;s pretend we want to find out <strong>how many sales each manager, Bob and Bill, had in 2009</strong>. How would we do this using a pivot table? </p>
<p><strong>Step 1: Highlight the data you&#8217;re interested in analyzing.</strong> Again, different people have different ways of building pivot tables, but this just happens to be the one I use most often:</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step2.PNG" alt="step2" title="step2" class="aligncenter size-full wp-image-1300" /></center></p>
<p><strong>Step 2: In Excel 2007, go to the &#8220;Insert&#8221; tab (circled in red below), and click on the &#8220;PivotTable&#8221; icon.</strong> (In Excel 2003, go to the menu item &#8220;Data&#8221; and select &#8220;PivotTable and PivotChart Report&#8221;. Click on &#8220;Next&#8221;, and then &#8220;Finish&#8221;)</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step3.PNG" alt="step3" title="step3" width="442" height="400" class="aligncenter size-full wp-image-1301" /></center></p>
<p>Once you click on the icon, a pop-up window will appear:</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step4.PNG" alt="step4" title="step4" width="569" height="546" class="aligncenter size-full wp-image-1302" /></center></p>
<p>which prompts you to fill in blanks on where the data is that you want to analyze and a few other things. Since we already highlighted the data in Step 1, the range of the data has already been pre-populated for us. Just hit the &#8220;OK&#8221; button and the pop-up window will go away and you&#8217;ll see the following appear in your worksheet (click image to enlarge):</p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/10/step5-1024x725.PNG"><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step5-1024x725.PNG" alt="step5" title="step5" width="512" height="312" /></a></center></p>
<p>You&#8217;ll notice there are several areas with labels on them, like &#8220;Drop Row Fields Here&#8221; and &#8220;Drop Column Fields Here&#8221;. I think this is probably the most confusing part of building a pivot table. Chances are, you will most often use the Row and Data Fields areas, so let&#8217;s focus on these first.</p>
<p><strong>Step 3: Build your pivot table by clicking and dragging items</strong>. We&#8217;re interested in looking at the data by manager, so the first thing we want to do is click on &#8220;Manager&#8221; in the field list menu (click image to enlarge):</p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/10/step6.PNG"><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step6.PNG" alt="step6" title="step6" width="512" height="312" class="aligncenter size-full wp-image-1304" /></a></center></p>
<p>and then drag the entire word into the &#8220;Drop Row Fields Here&#8221; Section. </p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/10/step7.PNG"><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step7.PNG" alt="step7" title="step7" width="512" height="312" class="aligncenter size-full wp-image-1305" /></a></center></p>
<p>Once you drop &#8220;Manager&#8221; into the &#8220;Drop Row Fields Here&#8221; area (circled in red above), you&#8217;ll see the data appear, with &#8220;Bill&#8221; and &#8220;Bob&#8221; since these are the only two &#8220;Managers&#8221; we have in our data. In Excel 2007, you can also drag the word into the &#8220;Row Labels&#8221; area within the pop-up window but I&#8217;m ignoring the additional features of 2007 for now.</p>
<p>Next, we wanted to look at the total # of sales by Manager, so we repeat the same thing we did above by clicking on the &#8220;# of sales&#8221; item in the list and dragging it, this time, to the &#8220;Drop Data Items Here&#8221; section (click image to enlarge):</p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/10/step8.PNG"><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step8.PNG" alt="step8" title="step8" width="512" height="312" class="aligncenter size-full wp-image-1306" /></a></center></p>
<p>Again, once &#8220;# of sales&#8221; is dropped into the data items area, the numbers immediately appear, summing the &#8220;# of sales&#8221; together by manager. </p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/10/step9.PNG"><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step9.PNG" alt="step9" title="step9" width="512" height="312" class="aligncenter size-full wp-image-1307" /></a></center></p>
<p>One final step. Remember that our data was for 2008 and 2009, so the # of sales by manager that we see is the total for both years. Suppose we just wanted to see the # of sales for this year. We could do this by clicking on &#8220;year&#8221; in the field list and dragging &#8220;year&#8221; to the &#8220;Drop Page Fields Here&#8221; area (click image to enlarge):</p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/10/step10.PNG"><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step10.PNG" alt="step10" title="step10" width="512" height="312" class="aligncenter size-full wp-image-1308" /></a></center></p>
<p>Again, as soon as you drop &#8220;year&#8221;, you&#8217;ll see a drop-down menu appear that defaults to &#8220;all&#8221; (click image to enlarge):</p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/10/step11.PNG"><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step11.PNG" alt="step11" title="step11" width="512" height="312" class="aligncenter size-full wp-image-1309" /></a></center></p>
<p>Click on the drop-down menu and you can select &#8220;2009&#8243; from the list instead (click image to enlarge):</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step12.PNG" alt="step12" title="step12" width="378" height="300" class="aligncenter size-full wp-image-1310" /></center></p>
<p>As soon as you choose &#8220;2009&#8243;, the figures change to show &#8220;# of sales by manager in 2009&#8243; for a total of 54 sales instead of 87 :</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/10/step13.PNG" alt="step13" title="step13" width="375" height="393" class="aligncenter size-full wp-image-1298" /></center></p>
<p>I&#8217;ll write more tutorials on how to work with pivot tables, but this is just a way to get you started. Feel free to leave comments with questions about pivot tables and I&#8217;d be happy to try to cater future tutorials toward answering the most popular ones. Hope this has been helpful!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=ONhDPF4rCCs:60u_jZXABjE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Seems like it&amp;#8217;s been eons since I posted an Excel tutorial, so I thought I&amp;#8217;d write a brief intro on how to create pivot tables in Excel. Pivot tables are unnecessarily mysterious and perplexing to many people, but as you&amp;#8217;ll soon see, they&amp;#8217;re easy to set up and a convenient way to look at spreadsheet [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/10/21/how-to-create-a-pivot-table-in-excel-2007-part-i-a-quick-and-basic-intro/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">4</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/10/21/how-to-create-a-pivot-table-in-excel-2007-part-i-a-quick-and-basic-intro/</feedburner:origLink></item><item><title>Moving out of corporate finance!</title><link>http://feedproxy.google.com/~r/experiglot/~3/SQNkUyrtlzc/</link><category>Career</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Thu, 08 Oct 2009 16:04:57 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1286</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>As I think I mentioned a few posts ago, there are a lot of changes going on at work. Earlier this year, I had set a goal of trying something different by the end of the year. Well, it&#8217;s now Q4, and I&#8217;ve decided to move out of my current role in the company&#8217;s Finance department and into one of their Operations divisions, allowing me to be closer to the company&#8217;s business and products, where I&#8217;ve wanted to be for a long time.</p>
<p>Don&#8217;t worry &#8212; I don&#8217;t think this will have one iota of impact on the content of this blog, be it on value investing, personal finance, or Excel tutorials. The role I&#8217;ll be taking will still require analytical skills, and I wouldn&#8217;t have taken it if I didn&#8217;t think I&#8217;d learn from it. </p>
<p>Guess that means I should to edit my &#8220;About&#8221; page too :)</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=SQNkUyrtlzc:ZQ2XO33Jdck:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>As I think I mentioned a few posts ago, there are a lot of changes going on at work. Earlier this year, I had set a goal of trying something different by the end of the year. Well, it&amp;#8217;s now Q4, and I&amp;#8217;ve decided to move out of my current role in the company&amp;#8217;s Finance [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/10/08/moving-out-of-corporate-finance/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">5</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/10/08/moving-out-of-corporate-finance/</feedburner:origLink></item><item><title>The most common career mistake most young employees make</title><link>http://feedproxy.google.com/~r/experiglot/~3/Sj6ppd33AK4/</link><category>Career</category><category>Corporate finance</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Fri, 25 Sep 2009 22:24:39 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1232</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p><em>This is the first post in a series called &#8220;<a href="http://www.experiglot.com/2009/09/04/managing-your-career-an-introductory-series/">Managing your career &#8211; an introductory series</a>&#8220;. The main audience I have in mind are analyst-level employees in corporate finance, but I think many parts can be applied more generally to anyone working in US corporations these days. </em></p>
<p>I work with a lot of people who are in their first corporate job after college, and I&#8217;ve been there myself as well. The most common expectation I&#8217;ve heard from them is that someone will manage their career for them, and they look to their manager and leaders in their group to do so. </p>
<p>While it&#8217;s true that truly great managers will look out for opportunities for you and push roadblocks away to give recognition to employees who deserve them, the sad truth is that in most corporations, there are usually very few leaders of this sort, and the corporate system makes it extremely difficult for exceptions to be made. </p>
<p>So, how do you go about managing your career?</p>
<p><span id="more-1232"></span></p>
<p><strong>Step I: Explore</strong></p>
<p>The best thing you can do when you are in an entry-level role is to determine what areas you are interested in and widen your experience by trying different companies, groups, and departments. In other words, actively manage your career rather than expect management to look out for your best interests. Actually, this is also good advice for mid-career professionals, although as you get more experienced in your career, you&#8217;ll often find that it&#8217;s harder to make switches between departments and roles without eyebrows being raised. (Not that this should ever stop you from doing what you think is best for yourself!)</p>
<p>How do you go about figuring what roles might be a good fit? Ask yourself the following questions:</p>
<p><strong>What do you think you want to do?</strong> In my experience, it&#8217;s a myth that most people know what they want to do in life, even if they&#8217;re in their 50s. Although there are exceptions, most people chase after what everyone else thinks is important and think they know what they want but don&#8217;t, so don&#8217;t worry if you don&#8217;t know what it is you want. Instead, just try narrowing down your interests a bit at a time. Start by listing out the things you&#8217;ve done in your life &#8212; be they jobs, volunteer roles, hobbies &#8212; and what you particularly liked and didn&#8217;t like about them. Are there patterns? For example, do you really enjoy interacting with people or prefer working alone? How about figuring out puzzles? A regular schedule and structure, or the opposite? Going to different places? As simplistic as this sounds, taking the time to be introspective and figuring out what you like (and don&#8217;t like) is a good investment and one that will help you find a role that&#8217;s satisfying rather than one you go with just because it&#8217;s what everyone else advises or values.</p>
<p><strong>What areas do I find interesting?</strong> Once you know the kinds of work you might enjoy doing, start listing out groups, roles or departments that might coincide with those interests. Don&#8217;t be afraid to reach out to someone who works in one of those groups to have lunch or coffee to have a casual conversation, and don&#8217;t target the highest manager you can find. Instead, look for people who are doing the actual day-to-day work in a group and, if possible, who are willing to speak openly about what they do. Keep it casual, be honest about wanting to explore other functional areas and tell them you just want to learn about what it is that their group does. Everyone has been there and most are willing to share their own experiences. Most importantly, ask them questions. How do they describe their job? What does their typical day looks like, who do they work with, and what do they like the most and the least about their role? Are there other people they would recommend you talk to? People love talking about themselves, and if you come across as a genuinely interested party, it&#8217;s amazing what you can learn. If they ask what you&#8217;re interested in, you&#8217;ve already got some idea based on knowing the characteristics of the role you&#8217;re looking for and why you think their group might be a good match.</p>
<p>A final word for those starting out in their career: consider working or going abroad. I&#8217;m not the first person who will tell you that it&#8217;s easier to move overseas when you&#8217;re younger, and I won&#8217;t be the last. But having international experience is valuable both professionally and personally, especially as jobs becomes more and more globally focused. </p>
<p>I&#8217;ll write more about next steps to actively managing your career upcoming posts. In the meantime, feel free to share any suggestions or comments below.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=Sj6ppd33AK4:nXPmsuwgPx0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>This is the first post in a series called &amp;#8220;Managing your career &amp;#8211; an introductory series&amp;#8220;. The main audience I have in mind are analyst-level employees in corporate finance, but I think many parts can be applied more generally to anyone working in US corporations these days. 
I work with a lot of people who [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/09/25/the-most-common-career-mistake-most-young-employees-make/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">2</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/09/25/the-most-common-career-mistake-most-young-employees-make/</feedburner:origLink></item><item><title>It’s a big jump from real estate theory to real estate practice…especially in the Bay Area</title><link>http://feedproxy.google.com/~r/experiglot/~3/Q9e5kAxYo78/</link><category>Housing</category><category>Personal finance</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Mon, 14 Sep 2009 06:11:16 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1238</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>Last week, we made our first actual bid on a house, and boy, was it a roller-coaster ride. Up until then, we had been browsing <a href="http://www.redfin.com" rel="tag">Redfin</a> and <a href="http://mlslistings.com">MLS listings</a>, looking at open houses in the area and not really seeing anything we liked or that was remotely within our price range.</p>
<div style="float: left; margin: 15px 10px 0 0"><img src="http://www.experiglot.com/wp-content/uploads/2009/09/house1.jpg" title="The house we almost bought"/></div>
<p> Then we happened across a house in a neighborhood we hadn&#8217;t been considering. It was as close to what we were ideally looking for as we had seen, and it didn&#8217;t need any obvious changes or upgrades. Believe it or not, that&#8217;s rare on the <a href="http://en.wikipedia.org/wiki/San_Francisco_Peninsula" rel="tag">Peninsula</a>. For readers who are unfamiliar with Bay Area housing, you just have to trust me on this one. It&#8217;s been a shock to understand just what sort of housing inventory and pricing there is around here, even in a &#8220;down economy&#8221;.</p>
<p><span id="more-1238"></span></p>
<p>The trouble was, a house like this one naturally attracted several interested parties. We toured on a Thursday, over a week before the first scheduled open house tour, and by Saturday, the seller&#8217;s agent had already contacted our agent to say that she had people interested in putting in a bid. As complete newbies to buying a house, let alone in the Bay Area, and let alone under sudden pressure, we suddenly found ourselves seeing the house that day a second time and being advised by our agent to bid the asking price for the house at $899K if we truly wanted it and wanted to avoid having them hold an open house (where it would surely attract even more interest and potential bidders). </p>
<p>Again, for non-Bay Area readers, yes, you read that price correctly, for a 3 bed, 2 bath house of ~1600 sq. ft., built in the 30s, and with a lot size of about 6K sq. ft.</p>
<p>While it wasn&#8217;t the perfect house &#8212; it was in a neighborhood that lots of people liked but a city we hadn&#8217;t even been considering and in a not-so-great school district &#8212; we decided to go ahead and bid on it at asking.</p>
<p>Then seller&#8217;s agent called and said she was leaving town for the long weekend and wouldn&#8217;t be back to help her client with offers until Monday night. Believe it or not, just that act changed the course of everything.</p>
<p>Those extra few days gave us time to reconsider the house and whether bidding $899K for it was something we were comfortable with. We also had time to read all the disclosures on the house (nothing set of big alarm bells in our heads, but still, when you&#8217;re a first-time home buyer and read about cracks in the foundation, you get a little concerned). By the time our agent came with all the paperwork on Monday to make the official bid, we had gotten cold feet. Luckily, he&#8217;s the husband of a former coworker, and he didn&#8217;t take our hesitation badly at all. After a lot of discussion, we decided to bid $875K instead and even at that point, we weren&#8217;t completely sure about whether it was the choice. Like I said, cold feet.</p>
<p>That night, I found myself swinging the complete opposite direction, convinced that the house <em>was</em> the right one and hoping that our bid wasn&#8217;t too low and a counter offer would be made so we&#8217;d get a second chance at it. I spent most of the next morning distracted and anxious. By noon though, however, we learned that the seller had accepted another bid for what we guess was around $890K. Ugh.</p>
<p>In retrospect, had the seller&#8217;s agent not left town, who knows? Maybe we would have been the high bidder and the seller would have gotten more money for it as well. Funny how some little thing like that can change the outcome of future events.</p>
<p>Nevertheless, the whole experience was a really uncomfortable one for me. I&#8217;m not the type of person who does impulse purchases, I don&#8217;t buy expensive things or items at full price, and I&#8217;m not into brands. Actually, I have a tendency to suffer from analysis paralysis. </p>
<p>The concept of having to put emotion into a purchase this large (i.e. find a house that you love, which means you have to go through a house a few times and picture yourself and your family actually living in it) and plunking down something north of $850K to realistically get what you want is unchartered territory for me. How do you manage to picture yourself living in a place without getting emotionally attached to it and then distance yourself enough to put an objective dollar range on it, and then be comfortable with the possibility of losing it anyway? </p>
<p>Heh. I&#8217;m not convinced I&#8217;ll be much more prepared if the same situation comes up again in the future. Meanwhile, the housing market seems to be picking up, just to add to the pressure and confusion. A lot of houses that have been on the market for months are suddenly starting to have open houses again, and I see many more listings at $800-900K going into &#8220;pending sale&#8221; state within a couple of weeks&#8217; time.</p>
<p>The funny thing is, it seems that everyone who&#8217;s bought a house in the Bay Area has a similar story of getting emotionally vested in a house only to lose a bid to someone else. Apparently it&#8217;s just a normal and very common part of the buying process here. </p>
<p>Now that a week has passed, I&#8217;ve finally come to grips with losing that house and having to move on and even the idea that there might actually be another house more suitable for us still out there somewhere. Wish us luck in finding it.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=Q9e5kAxYo78:ByRjFXXq4mw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Last week, we made our first actual bid on a house, and boy, was it a roller-coaster ride. Up until then, we had been browsing Redfin and MLS listings, looking at open houses in the area and not really seeing anything we liked or that was remotely within our price range.

 Then we happened across [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/09/14/its-a-big-jump-from-real-estate-theory-to-real-estate-practice-especially-in-the-bay-area/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">1</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/09/14/its-a-big-jump-from-real-estate-theory-to-real-estate-practice-especially-in-the-bay-area/</feedburner:origLink></item><item><title>Managing your career – an introductory series</title><link>http://feedproxy.google.com/~r/experiglot/~3/gprboy_D6KU/</link><category>Career</category><category>Corporate finance</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Fri, 04 Sep 2009 22:37:26 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1224</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>Thank god the long weekend is here. There have been a lot of changes at my work in recent months. Reorgs seem to beget reorgs, and my finance team this week found itself in the midst of an unexpected leadership change in the group we support. </p>
<p>Although sudden and unexpected job changes reinforce the need, no matter your work situation keeping tabs on opportunities and actively managing your career these days is essential and wise practice. </p>
<p>After all, what you really want are a few options when your hand is forced. Even if you don&#8217;t lose your job, being able to have a choice in your next move is freedom worth striving for. </p>
<p>This week, I realized that many of my teammates are younger than me, have less experience, and could use some guidance on career management, so I&#8217;ve set up some one-on-one meetings with them. Over the next few weeks, I&#8217;ll post steps and tips I&#8217;ve learned along the way on this site as well.</p>
<p>&#8216;Til then, though, enjoy the long <a href="http://en.wikipedia.org/wiki/Labor_Day">Labor Day</a> weekend, an apropos way to kick off a series on this topic!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=gprboy_D6KU:-4pqGjHGGGo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Thank god the long weekend is here. There have been a lot of changes at my work in recent months. Reorgs seem to beget reorgs, and my finance team this week found itself in the midst of an unexpected leadership change in the group we support. 
Although sudden and unexpected job changes reinforce the need, [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/09/04/managing-your-career-an-introductory-series/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">1</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/09/04/managing-your-career-an-introductory-series/</feedburner:origLink></item><item><title>This week’s festival of stocks</title><link>http://feedproxy.google.com/~r/experiglot/~3/exGKDa-W9b4/</link><category>Personal finance</category><category>Value investing</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Mon, 24 Aug 2009 15:26:07 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1217</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>I submitted my recent post on my <a href="http://www.experiglot.com/2009/08/19/update-on-qlti/">investment in QLTI </a>to this week&#8217;s <a href="http://www.fatpitchfinancials.com/1703/festival-of-stocks-155/" rel="tag">Festival of Stocks</a>, partly in an attempt to get back into investing (and particularly value investing) resources in the blogosphere. </p>
<p>I found a couple of interesting articles, one an analysis at <a href="http://www.oldschoolvalue" rel="tag">Old School Value</a> on  <a href="http://www.oldschoolvalue.com/featured/warren-buffett-stock-pick-portfolio/" rel="tag">Warren Buffett&#8217;s Stock picks</a> (Berkshire recently released its Q2 holdings) that will take me some time to go through, and another on <a href="http://etfdb.com/financial-advisor-center/do-leveraged-etfs-have-a-place-in-client-portfolios/" rel="tag">leveraged ETFs</a>, an interesting area I didn&#8217;t know much about (though truthfully, I would probably shy away from investing in these given my style). </p>
<p>The latter article is a bit annoying in that it requires you to register for free before you can read the entire post, but if you&#8217;ve been looking into investing in leveraged ETFs, it&#8217;s probably worth a read first. There are also some other articles highlighting specific stocks, the Indian market, and other areas related to stocks and investing should these fit your interests.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=exGKDa-W9b4:cIhIluhYhmk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>I submitted my recent post on my investment in QLTI to this week&amp;#8217;s Festival of Stocks, partly in an attempt to get back into investing (and particularly value investing) resources in the blogosphere. 
I found a couple of interesting articles, one an analysis at Old School Value on  Warren Buffett&amp;#8217;s Stock picks (Berkshire recently [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/08/24/this-weeks-festival-of-stocks/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">2</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/08/24/this-weeks-festival-of-stocks/</feedburner:origLink></item><item><title>Update on QLTI – a Graham Value Play</title><link>http://feedproxy.google.com/~r/experiglot/~3/CtixKLRfmyk/</link><category>Value investing</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Wed, 19 Aug 2009 17:33:33 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1168</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>Back in April, I wrote about my <a href="http://www.experiglot.com/2009/04/13/qlti-a-graham-value-play-experiment/" rel="tag">investment in QLTI</a>, which was the first stock I ever found that met all of Benjamin Graham&#8217;s criteria. I bought 1200 shares at $2.13 in an IRA account despite a runup of nearly 30% between the day I found the stock and the day I bought it, thanks to not having had sufficient time to research it enough before getting comfortable enough to invest in it. </p>
<p>At the risk of jinxing myself, QLTI closed today at $4.01, or 88% higher than my purchase price, excluding transactions costs. Truth be told, I had largely ignored it until this week when I noticed its performance.<br />
<span id="more-1168"></span><br />
At $2.13, QLTI was trading at 53% of its <a href="http://www.investopedia.com/terms/n/ncavps.asp" rel="tag">net current asset value (NCAV)</a> (based on financials released in July 2009), which is defined as current assets less total liabilities. </p>
<p>Under typical market conditions, you almost never find stocks trading at a discount to NCAV, and Graham recommended buying a diversified portfolio of stocks trading at 67% of NCAV as one of the best strategies to achieve superior returns. At $4.01, QLTI is almost at 100% of its NCAV. </p>
<p>I also found a <a href="http://www.grahaminvestor.com/articles/finding-undervalued-stocks" rel="tag">post at The Graham Investor referring to a strategy for selling</a>. The method is attributed to a person named Van Tharp, who wrote a book called <a href="http://www.amazon.com/gp/redirect.html?ie=UTF8&#038;location=http%3A%2F%2Fwww.amazon.com%2FSafe-Strategies-Financial-Freedom-Tharp%2Fdp%2F0071421475%3Fie%3DUTF8%26s%3Dbooks%26qid%3D1250727188%26sr%3D8-1&#038;tag=experimentinp-20&#038;linkCode=ur2&#038;camp=1789&#038;creative=9325">Safe Strategies for Financial Freedom</a><img src="http://www.assoc-amazon.com/e/ir?t=experimentinp-20&#038;l=ur2&#038;o=1" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" />. Tharp recommends the following after buying stocks at 2/3 of NCAV (quoted from <a href="http://www.grahaminvestor.com" rel="tag">The Graham Investor</a>):</p>
<blockquote><p>
Sell a third of your holding when a 50% profit is achieved. If the price continues upwards to 100% profit, you sell a number of shares to make up half your original holding.</p>
<p>You now have your original investment back and have a holding of &#8220;free&#8221; shares. This strategy can be performed in an IRA using a large portfolio of perhaps 30 similarly undervalued stocks. If the market has been declining for several months, there will be several such stocks to choose from. In an up trending market, however, it will be much harder to find good value candidates but diligent investors who do their homework will more often than not be well rewarded for their efforts.</p></blockquote>
<p>I&#8217;m inclined to try his method even though I missed the first step of selling after a 50% run-up given that I&#8217;ve never really figured out a good strategy to determine when to sell a stock. Of course, his method also assumes that your investment will reach a 50% or even 100% return at some point, and there&#8217;s certainly no guarantee that investments will work out that well, even if you can find a sufficient number of stocks trading at a sufficient discount to their NCAV.</p>
<p>More updates on this investment as they happen.</p>
<p>Note: As mentioned in my first post, if you choose to purchase QLTI and are a US shareholder, you should consider investing in a tax-advantaged account since QLTI is considered a Passive Foreign Investment Company (PFIC) and can bring significant and complex tax consequences if purchased in a regular investment account.</p>
<p>FD: I own shares of QLTI at the time of writing of this post. </p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=CtixKLRfmyk:hhcLrjVs9yE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Back in April, I wrote about my investment in QLTI, which was the first stock I ever found that met all of Benjamin Graham&amp;#8217;s criteria. I bought 1200 shares at $2.13 in an IRA account despite a runup of nearly 30% between the day I found the stock and the day I bought it, thanks [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/08/19/update-on-qlti/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">2</slash:comments><category domain="http://rss.financialcontent.com/stocksymbol">NCAV</category><category domain="http://rss.financialcontent.com/stocksymbol">PFIC</category><feedburner:origLink>http://www.experiglot.com/2009/08/19/update-on-qlti/</feedburner:origLink></item><item><title>My first investment in my son’s Coverdell account – En Pointe Technologies (ENPT)</title><link>http://feedproxy.google.com/~r/experiglot/~3/97NVfpWaOoE/</link><category>Value investing</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Tue, 11 Aug 2009 14:56:42 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1185</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>I&#8217;ve decided to follow George&#8217;s footsteps over at <a href="http://fatpitchfinancials.com" rel="tag">Fat Pitch Financials</a> and actively manage the investments in my son&#8217;s <a href="http://www.savingforcollege.com/intro_to_esas/" rel = "tag">Coverdell account</a>. Coverdell accounts are great because you can open one up and invest the money much more freely than in a <a href="http://www.savingforcollege.com/intro_to_529s/what-is-a-529-plan.php" rel="tag">529 plan</a>, they&#8217;re tax advantaged, and because their funds can be applied to secondary school rather than just college and graduate school. However, the maximum contribution that can be made to a beneficiary each year and across all sources is only $2K, and contributions can only be made until the beneficiary reaches 18 years of age.</p>
<p>This means I need to try to grow the money in the account as much as possible while limiting any downside. Enter <a href="http://www.fatpitchfinancials.com/18/arbitrage-and-special-situations/" rel="tag">special situations investing</a>, which turns out to be a great way to invest smaller amounts of money with pretty big returns. Of course, no investment is risk-free, but I&#8217;m hoping that by choosing workouts wisely, I&#8217;ll be able to get a better return on the account than if I bought a few odd-lot shares of an ETF or mutual fund.<br />
<span id="more-1185"></span><br />
For my first investment, I purchased 900 shares of <a href="http://www.enpointe.com/" rel="tag">En Pointe Technologies</a> (whose ticker symbol was ENPT until it went private on Monday). <a href="http://www.google.com/search?rlz=1C1_____en___US321&#038;sourceid=chrome&#038;ie=UTF-8&#038;q=contributor's+corner" rel="tag">Fat Pitch Financials&#8217; Contributor&#8217;s Corner</a> had it listed for some time as having entered into a merger agreement with the CEO to be bought out and taken private at $2.50/share, so when the stock dropped to $2.03 back in April, I decided the time was right. </p>
<p>As an aside, I have to say that for whatever reason, the fact that I was investing my son&#8217;s money somehow made the whole transaction more nervewracking even though I&#8217;ve made larger purchases of various investments in my own accounts. I guess it&#8217;s good and perhaps even normal to feel this way, but it wasn&#8217;t something I expected.</p>
<p>Even though ENPT had filed papers entering into a definitive agreement, the deal was far from guaranteed. The termination date (the date by which the agreement to merge could be terminated by either party) moved from July 31 to August 14, and various additional filings and amendments were submitted between the time I purchased the stock in mid-April and the <a href="http://www.enpointe.com/CEO_letter.asp">announcement (yesterday) that the deal had been closed</a> and that all shareholders would receive $2.50 for each share of stock they own. </p>
<p>Including the $8.95 fee I had to pay for purchasing the shares and basing the end date as of Monday, my return was 22.6%. In comparison, the S&#038;P 500 went up about 20.5% during the same period, so I&#8217;m glad I still beat the index, even though the market has been going straight up since April. (I&#8217;ll recalculate the second figure once I receive the cash for my shares in my account. <strong>Update: received the cash in my account this morning, 8/12!</strong>) Additionally, I&#8217;ll start hunting for new workouts or special situations to invest in, and hopefully I&#8217;ll have found another good investment by the time I receive the cash in my account.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=97NVfpWaOoE:XFurBJ6pEwA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>I&amp;#8217;ve decided to follow George&amp;#8217;s footsteps over at Fat Pitch Financials and actively manage the investments in my son&amp;#8217;s Coverdell account. Coverdell accounts are great because you can open one up and invest the money much more freely than in a 529 plan, they&amp;#8217;re tax advantaged, and because their funds can be applied to secondary [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/08/11/my-first-investment-in-my-sons-coverdell-account-en-pointe-technologies-enpt/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">2</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/08/11/my-first-investment-in-my-sons-coverdell-account-en-pointe-technologies-enpt/</feedburner:origLink></item><item><title>Off topic and for nerds only – ever yearned for your old high school calculator?</title><link>http://feedproxy.google.com/~r/experiglot/~3/qmz5nne-RTY/</link><category>Personal finance</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Mon, 03 Aug 2009 12:50:17 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1167</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<div style="float: left; margin: 15px 10px 0 0"><a href="http://www.experiglot.com/wp-content/uploads/2009/08/casio_fx-3900P.1.jpg" target="_blank"><img src="http://www.experiglot.com/wp-content/uploads/2009/08/casio_fx-3900P.1.jpg" alt="casio_fx-3900P.1" title="casio_fx-3900P.1" width="218" height="244"/></a></div>
<p>Are you one of those people who&#8217;s ever pined for a scientific calculator you had in the past? I&#8217;m dating myself (among other things) here, but I attended high school before the epoch of graphing TI calculators but after slide rules (thankfully)! </p>
<p>Somewhere between AP calculus, college, and many moves between states after graduation, I lost my much loved Casio and couldn&#8217;t for the life of me remember the model. At the time, it was amazing (to me at least) for its ability to be programmable, iterate and solve equations, deal with radians&#8230;you get the idea.</p>
<p>Enter <a href="http://mycalcdb.free.fr/main.php?l=0&#038;p=2" rel="tag">MyCalcDB</a>, which appears to be an exhaustive database of calculators of all kinds last updated on July 17th of this year. After narrowing down the dates and manufacturer to Casio, I found my calculator within minutes. It even shows thumbnails of each calculator where available. </p>
<p>So, for the tiny portion of readers who are as nerdy as I am and long for things like out-of-date scientific calculators, I thought I&#8217;d share this resource :)</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=qmz5nne-RTY:2jNuNJTRC5U:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Are you one of those people who&amp;#8217;s ever pined for a scientific calculator you had in the past? I&amp;#8217;m dating myself (among other things) here, but I attended high school before the epoch of graphing TI calculators but after slide rules (thankfully)! 
Somewhere between AP calculus, college, and many moves between states after graduation, I [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/08/03/off-topic-and-for-nerds-only-ever-yearned-for-your-old-high-school-calculator/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">2</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/08/03/off-topic-and-for-nerds-only-ever-yearned-for-your-old-high-school-calculator/</feedburner:origLink></item><item><title>Using Excel’s built-in amortization table</title><link>http://feedproxy.google.com/~r/experiglot/~3/DgPG7lW6Q8c/</link><category>Excel function tutorials</category><category>Housing</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Mon, 27 Jul 2009 06:05:18 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1091</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>Thanks to our nascent house hunt, I&#8217;ve been trying to back into figures on mortgages and monthly payments. Luckily, Excel has a handy <a href="http://office.microsoft.com/en-us/excel/HA010346401033.aspx" rel="tag">built-in amortization template</a> just perfectly suited for this purpose. </p>
<p>Here&#8217;s how you get to the template in Excel 2007 (which according to my <a href="http://www.experiglot.com/2009/05/02/poll-which-version-of-microsoft-excel-do-you-use/">recent poll</a> is the version most readers use, if only by a hair).</p>
<p>In Excel 2007, go to the &#8220;menu&#8221; button (the goofy-looking windows symbol in a circle) in the upper left-hand corner. Click on &#8220;New&#8221;. This will bring up the following window:</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/07/step1.PNG" /></center></p>
<p><span id="more-1091"></span></p>
<p>Click on &#8220;Installed templates&#8221;, which will bring up seven built-in templates for you to choose from. Double-click on &#8220;Loan Amortization&#8221;.</p>
<p><center><img src="http://www.experiglot.com/wp-content/uploads/2009/07/step2.PNG" /></center></p>
<p>This will create a blank template for you to fill out, like so (click image below to enlarge):</p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/07/step3.PNG" target="_blank"><img src="http://www.experiglot.com/wp-content/uploads/2009/07/step3-1024x540.PNG" alt="step3" title="step3" width="1024" height="540" class="aligncenter size-large wp-image-1145" /></a></center></p>
<p>You can fill in data in the orange boxes, and Excel will automatically calculate monthly payments, remaining amount on the principal, remaining balance, and interest paid to date, along with several other fields in the columns below. If you choose to make extra payments, the template automatically takes those into consideration as well. In the upper right-hand area is a summary of the loan scenario, including monthly payment amount and total interest to be paid. </p>
<p>Here&#8217;s an example of what all of this looks like for a hypothetical loan (click image below to enlarge):</p>
<p><center><a href="http://www.experiglot.com/wp-content/uploads/2009/07/step4.PNG" target="_blank"><img src="http://www.experiglot.com/wp-content/uploads/2009/07/step4-1024x768.PNG" alt="step4" title="step4" width="1024" height="768" class="aligncenter size-large wp-image-1146" /></a></center></p>
<p>In Excel 2003, you can get to the same template through the following steps. Go to &#8220;File&#8221; >> &#8220;New&#8221; >> &#8220;New Workbook&#8221; >> &#8220;On my computer&#8230;&#8221; >> &#8220;Templates&#8221; >>  &#8220;Spreadsheet Solutions&#8221; >> &#8220;Loan Amortization&#8221;.</p>
<p>This template has helped me create a simple model to play around with figures to get a total picture of fund outlays, tax savings, and different mortgage scenarios in our nascent house-hunting process.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=DgPG7lW6Q8c:noj4Ip2zUGs:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Thanks to our nascent house hunt, I&amp;#8217;ve been trying to back into figures on mortgages and monthly payments. Luckily, Excel has a handy built-in amortization template just perfectly suited for this purpose. 
Here&amp;#8217;s how you get to the template in Excel 2007 (which according to my recent poll is the version most readers use, if [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/07/27/using-excels-built-in-amortization-table/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">4</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/07/27/using-excels-built-in-amortization-table/</feedburner:origLink></item><item><title>Handling unexpected change</title><link>http://feedproxy.google.com/~r/experiglot/~3/ov_K1r0F1yI/</link><category>Blogging</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Fri, 17 Jul 2009 13:13:15 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1099</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>Sorry for the delay in updating this site. My mother-in-law passed away last week from cancer, and our family is still recovering from the loss. </p>
<p>More pertinent posts will be forthcoming, but I happened across this recently at work and found parts of it somewhat comforting, so I thought I&#8217;d share, in case anyone else has recently experienced loss. Titled &#8220;How to Deal with Change&#8221;, it&#8217;s from <a href='http://www.wikihow.com/Main-Page'>wikiHow</a>.</p>
<p><b><center>HOW TO DEAL WITH CHANGE</center></b></p>
<p>Being prepared for change involves flexibility, strength of self-purpose and belief in one&#8217;s own worth. </p>
<ol>
<li>  <b>Be prepared.</b>  Life is full of unexpected surprises; don&#8217;t let this be a lesson you refuse to learn.  Death, loss and strange situations will be a part of your life, no matter how much you may try to cocoon yourself with reasoning, savings and assets. The major key to coping with change is to accept the reality of change and its inevitability.
</li>
<li>  <b>Realize there&#8217;s only one thing you can control &#8211; yourself.</b>  Once you cotton on to the reality that you cannot change others and that the only way they can change you is if you let them, then you suddenly find yourself empowered. Empowerment is a key element of change acceptance and change management.  When you feel empowered, you will roll with changes as a whale rolls through the ocean waves, commanding and unbothered by events but conscious of a need to roll with the surrounding effects to lessen their impacts.
</li>
<li> <b>Take time to recoup.</b>  If you are grieving after a death, be it a person or a pet, do not let anyone tell you how long to grieve for. That decision is yours. It does make sense to make a decision in your own mind about what grieving you need to do, as your life cannot meander in sorrow forever. However, it is most clear that those who avoid grieving end up worse off and can experience break-downs and inability to cope at unexpected times. With grief for death, there will always be a piece of your heart missing but if you accept this and you are willing to carry the memories as lively as can be for the rest of your life, this will help you reach some acceptance of what has happened. If it is a job loss or some other personal loss that is not death, you still need mourning time to assuage your sadness and grief over a loss of something that once filled a large part of your life. Perhaps a small ending ceremony of some sort will help to give you a sense of closure and allow you to move forward.<br />
<span id="more-1099"></span>
</li>
<li><b>Be purposeful.</b>  Change occurs but you do not need to be buffeted by it. Have a purpose in life, no matter what it be, that serves as your own personal anchor. While it is important to be open to change and to be flexible as to the possibilities that change opens up for you, it is also important to remain true to yourself and the dreams that you hold in life. This self-belief and your dreams are your anchor. Whatever else life throws in your way, these are the barometers by which you can measure your progress in the world and how you are reacting to change. Be prepared to question your methods of getting to where you wish to go but be less prepared to change your destination if it means dismantling the person you are inside.<br />
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=ov_K1r0F1yI:QNNwJeSelLw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Sorry for the delay in updating this site. My mother-in-law passed away last week from cancer, and our family is still recovering from the loss. 
More pertinent posts will be forthcoming, but I happened across this recently at work and found parts of it somewhat comforting, so I thought I&amp;#8217;d share, in case anyone else [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/07/17/handling-unexpected-change/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">2</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/07/17/handling-unexpected-change/</feedburner:origLink></item><item><title>MBA by practice, but physicist at heart</title><link>http://feedproxy.google.com/~r/experiglot/~3/uI44VTVQcHY/</link><category>Business &amp; entrepreneurship</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Wed, 24 Jun 2009 21:48:54 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1068</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>Like many people, I find it irritating whenever I hear meaningless business phrases used over and over again. You know, things like:</p>
<ol>
<li>We should leverage the engineering team for this project.</li>
<li>Can we gain any synergies by doing this?</li>
<li>We don&#8217;t have the bandwidth on our team to take this on.</li>
<li>Let&#8217;s discuss this offline (as in not in the current meeting).</li>
</ol>
<p>Meaningless business jargon is so commonplace in daily corporate life that someone created <a href="http://www.betterworkplacenow.com/bingo/index.html">Business Buzzword Bingo</a> a while back &#8212; a fun game to play while sitting in meetings.</p>
<p>I recently heard a new term which a quick internet search reveals isn&#8217;t apparently all that new: &#8220;bad optics&#8221;. I saw this in some meeting notes that were being sent around, and I chuckled at the time, thinking whoever took the notes either misunderstood what was being said (perhaps &#8220;OpEx&#8221;, often short for &#8220;Operating Expenses&#8221;, or &#8220;Operational Excellence&#8221;) or had an overly aggressive spell checker.<br />
<span id="more-1068"></span><br />
But I discovered I was wrong after seeing the phrase pop up more and more at work. A couple of my teammates finally confirmed that saying something &#8220;is bad optics&#8221; means that something &#8220;looks bad to an observer&#8221;. </p>
<p>I have no idea how that came to happen.</p>
<p>The word &#8220;optics&#8221; to me &#8212; perhaps because I studied physics, but also for most people, I&#8217;d still guess &#8212; is a branch of physics dealing with light and its interaction with matter. &#8220;Bad optics&#8221; conjures up the embarrassing problem with the <a rel="tag" href="http://en.wikipedia.org/wiki/Hubble_Space_Telescope">Hubble Space Telescope mirror</a>, or an image that&#8217;s out-of-focus, perhaps due to dirt on a lens. It does <em>not</em> mean that something shouldn&#8217;t be done in order to prevent a PR gaffe. Besides, what&#8217;s wrong with saying something &#8220;looks bad&#8221; instead of &#8220;it&#8217;s bad optics&#8221;? </p>
<p>To readers in other countries, I&#8217;m curious. Do you experience meaningless business jargon where you work, especially if you work in languages other than English? If so, what are some common phrases you hear?</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=uI44VTVQcHY:skd26hThccM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>Like many people, I find it irritating whenever I hear meaningless business phrases used over and over again. You know, things like:

We should leverage the engineering team for this project.
Can we gain any synergies by doing this?
We don&amp;#8217;t have the bandwidth on our team to take this on.
Let&amp;#8217;s discuss this offline (as in not in [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/06/24/mba-by-practice-but-physicist-at-heart/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">7</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/06/24/mba-by-practice-but-physicist-at-heart/</feedburner:origLink></item><item><title>This will make your day (a.k.a. when technology really *is* wonderful)</title><link>http://feedproxy.google.com/~r/experiglot/~3/ro_-wSawTj4/</link><category>Current events</category><category>Internet</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Fri, 12 Jun 2009 23:00:44 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1054</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<p>I don&#8217;t think this is new, but it&#8217;s still worth taking 5 min. to watch and definitely will make you smile :)</p>
<p><center><br />
<object width="660" height="525"><param name="movie" value="http://www.youtube.com/v/Us-TVg40ExM&#038;hl=en&#038;fs=1&#038;rel=0&#038;color1=0x2b405b&#038;color2=0x6b8ab6&#038;border=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/Us-TVg40ExM&#038;hl=en&#038;fs=1&#038;rel=0&#038;color1=0x2b405b&#038;color2=0x6b8ab6&#038;border=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="660" height="525"></embed></object></p>
<p></center><br />
The org behind this is called the <a href="http://playingforchange.org" rel="tag">Playing for Change Foundation</a> and its goal is to build and connect music/art schools around the world. Pretty inspiring.</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=ro_-wSawTj4:1Dg9pZxJ9pw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>I don&amp;#8217;t think this is new, but it&amp;#8217;s still worth taking 5 min. to watch and definitely will make you smile :)



The org behind this is called the Playing for Change Foundation and its goal is to build and connect music/art schools around the world. Pretty inspiring.</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/06/12/this-will-make-your-day-aka-when-technology-really-is-wonderful/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">2</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/06/12/this-will-make-your-day-aka-when-technology-really-is-wonderful/</feedburner:origLink></item><item><title>Still suffering from Bay Area housing price sticker shock</title><link>http://feedproxy.google.com/~r/experiglot/~3/EglQKjTye-Y/</link><category>Housing</category><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Leslie</dc:creator><pubDate>Mon, 08 Jun 2009 06:24:31 PDT</pubDate><guid isPermaLink="false">http://www.experiglot.com/?p=1004</guid><content:encoded xmlns:content="http://purl.org/rss/1.0/modules/content/"><![CDATA[<div style="float: left; margin: 15px 10px 0 0"><em><div id="attachment_1017" class="wp-caption left" style="width: 290px"><img src="http://www.experiglot.com/wp-content/uploads/2009/06/fixerupper.jpg" alt="A fixer-upper in Burlingame, CA priced at $1.1M" title="fixerupper" width="280" height="210" class="size-full wp-image-1017" /><p class="wp-caption-text">According to its description, 'needs work...but great value!' in Burlingame, CA, priced at $1.05M</p></div></em></div>
<p>We&#8217;re a few weeks into seriously starting to look at the Bay Area housing market (as in actually going to open houses and going on trips with our real estate agent to get to know neighborhoods). </p>
<p>Although we&#8217;re starting to get a bit more accustomed to prices of houses in the area, I still can&#8217;t get my head around the idea that a basic 3bd/2ba house will likely cost nearly $1M. These are houses that would run in the low hundred thousands anywhere else, let alone in Tennessee, where I spent most of my childhood.</p>
<p>We&#8217;re basically looking for a solid house that will retain (or possibly even appreciate) in value over time and that doesn&#8217;t involve an unreasonable commute time to my work; nothing fancy, and we don&#8217;t even care if it&#8217;s new, although not having to cross the Bay every day would be nice. </p>
<p>Here&#8217;s what I&#8217;ve been able to pick up so far from our trips:<br />
<span id="more-1004"></span></p>
<ol>
<li> Now that we have a little one, school districts are a factor, but from what I&#8217;ve been able to tell, people around here pay either a few $100K extra for a house in a good public school district or the same amount for a private school education in exchange for a lower cost house located in a worse public school district. This trade-off happens in other places in the US too, I suppose, but the amounts involved here are just incredible.</li>
<li> In some areas, one house that&#8217;s priced at $600K (a fixer-upper, as in unlivable condition at move-in) could literally be next to others that are north of $2M.</li>
<li>There are these things called &#8220;<a href="http://en.wikipedia.org/wiki/Short_sale_(real_estate)" rel="tag">short-sales</a>&#8221; that appear to be good deals but whose sales (at least in this area) are seldom completed or completed in any reasonable amount of time. It seems like every time we find a decently priced house on Redfin, it&#8217;s listed as a short sale. In short sales, the seller still owns the house, but owes more on the mortgage than he or she can get from selling the property. In many instances, more than one bank holds a mortgage on the house and each one must approve the sale in order for it to go through. Moreover, there are usually multiple bids on the property (including some with all-cash offers). The advice I&#8217;ve heard is that should we find a house we like on a short-sale, we ought to make a bid and then continue seeing houses because the likelihood we would get the house is next to nil.</li>
<li>Then there&#8217;s the mortgage&#8230;.the various flavors of mortgage loans are an area we&#8217;re still learning about. We&#8217;ve been talking to a loan broker and asking all sorts of questions. I never realized how complex mortgages could get (jumbo loans, FHAs, points, you name it).</li>
</ol>
<p>Because of where we live (close to Silicon Valley), there are probably more people willing to forego the use of an agent or a loan broker and instead head straight to <a href="http://www.redfin.com">Redfin</a>. We are content with the agent we have so far, but it&#8217;s interesting to see how many different ways there are to go about finding a house to buy.</p>
<p>Despite the sticker shock, I have to say that it&#8217;s been somewhat fun looking around and seeing if we can picture ourselves and our family living in the houses we&#8217;ve seen. We&#8217;re currently renting a house and have until next March, so at least we aren&#8217;t on a tight deadline. Still, I sometimes wonder if we will ever get to the point where we find something we like enough to pull the trigger on signing a HUGE mortgage. Our agent claims that the day we find our house, we&#8217;ll know it even before we walk in. I personally find that hard to believe, having <em>never</em> had that feeling about anything I&#8217;ve purchased, let alone a house. </p>
<p>What&#8217;s been your experience, and what advice do you have for a first-time home buyer? I&#8217;d be interested in hearing people&#8217;s advice, whether you&#8217;re in the Bay Area or not!</p>
<div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/experiglot?a=EglQKjTye-Y:osifmz8ZC7Q:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/experiglot?d=yIl2AUoC8zA" border="0"></img></a>
</div>]]></content:encoded><description>We&amp;#8217;re a few weeks into seriously starting to look at the Bay Area housing market (as in actually going to open houses and going on trips with our real estate agent to get to know neighborhoods). 
Although we&amp;#8217;re starting to get a bit more accustomed to prices of houses in the area, I still can&amp;#8217;t [...]</description><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.experiglot.com/2009/06/08/still-suffering-from-bay-area-housing-price-sticker-shock/feed/</wfw:commentRss><slash:comments xmlns:slash="http://purl.org/rss/1.0/modules/slash/">10</slash:comments><feedburner:origLink>http://www.experiglot.com/2009/06/08/still-suffering-from-bay-area-housing-price-sticker-shock/</feedburner:origLink></item></channel></rss>
