by ·0 Comments

AT&T iPhone6 Upgrade: 2-Year contract vs. Next plans

iPhone6Upgrade Options with AT&T

         

         If you are getting ready to upgrade to iPhone6 through AT&T, you might be in for a surprise or two. The first surprise is that back in July of last year, AT&T changed its phone upgrade eligibility date from 20 months to 24 months.

         Using a 2-year contract option, this change most likely means that you did not qualify for an iPhone6 pre-order last Friday, and will probably have to wait till after September 19th’s official release to place your upgrade order. If you are not willing to wait, you can pay AT&T an upgrade surcharge ($40 if your upgrade date is later this month) to upgrade immediately.

         Alternatively, you can take a completely different route, and go with a Next 12 or Next 18 installment plans and forget about service contracts and early termination fees altogether. At first glance, it’s pretty hard to follow AT&T’s case for the Next plans.

         In this post I will present my own calculations and conclusions pertaining to different scenarios when either a 2-year contract or one of the two Next plans works better. Since Samsung Galaxy S5 is offered at the same price as iPhone6, these calculations will work for all of the Android lovers out there as well.

Continue reading

by ·0 Comments

Top 10 Free resources to learn Microsoft Excel

Top 10 Free resources to learn Microsoft Excel

         Students often ask me to recommend best online Excel resources for further reference. After fighting the urge to LMGTFY them 🙂 , I suggest to utilize the largest search engine in the World, and trust Google to present the most relevant results for their query. (Searching for specific terms within relevant time frame would improve your search results dramatically.)

         In addition, the second largest search engine in the World can stream very helpful How-To videos on magnitude of topics. This means that one can search YouTube to learn not only how to unclog a toilet, but also how to create a PivotChart.

         If you are in a hurry, and don’t feel like watching a 10 minute video;SlideShare comes to the rescue, and offers a plethora of presentations, including Excel tutorials. Heck, you can browse through the SlideShare version of this post below.

         That being said, some of us feel safer when using credible and trusted sources for all of our Excel needs. I started compiling the list of useful resources before YouTube and Slideshare came to existence, and added others over time. I hope that this post will satisfy your thirst for Excel knowledge. Many of these sites include tutorials, blog entries, discussion forums and YouTube videos.

Continue reading

by ·0 Comments

State Income Tax Rate Inequality in America.

USA State Tax Map

         Let’s face it, as Americans we are not all created equal. This fact is especially pronounced when it comes to paying taxes. Most of us have to pay income taxes, yet the exact amount varies by our income level. Having each individual state impose its own income tax laws does not help this matter either.

         The IRS already makes the task of figuring out your income tax liability rather cumbersome: you have to determine your Adjusted Gross Income (AGI), subtract the amount of your deductions (standard or itemized), reduce this number by any personal and dependent exemptions you qualify for; and then hopefully arrive at your Taxable Income amount. After ignoring all of the other possible credits, exceptions and unique tax situations that might or might not apply to you, you can have a lot of fun playing with up to seven tax brackets that correspond to your earnings amount.

         I used the Tax Foundation website to retrieve pertinent state income tax information for 2014 tax year to see exactly how individual states add complexity in calculating our tax liability. I specifically wanted to retrieve maximum possible marginal tax rate by state in 2014. Below are my findings.

Continue reading