Search found 2542 matches

by #Cruncher
Mon Apr 16, 2018 12:32 am
Forum: Investing - Theory, News & General
Topic: Do the math on savings rate vs. portfolio return rate
Replies: 1
Views: 706

Re: Do the math on savings rate vs. portfolio return rate

The referenced article includes a footnote 1 Both of these examples assumes a 3% increase in wages per year but a static savings rate as a percentage of income. Since the thread title says "Do the math ...", here is the formula from Finance Formulas as shown in this post that accounts for the 3% ann...
by #Cruncher
Thu Apr 12, 2018 11:26 pm
Forum: Investing - Theory, News & General
Topic: I Bond’s Variable Rate Will Fall To 2.22% On May 1
Replies: 36
Views: 4691

Re: I Bond’s Variable Rate Will Fall To 2.22% On May 1

I use eyebonds.info to value my I bonds each month. Of course, this site does not take into account the 3 month penalty if you redeem before 5 years. The link may not work as alpenglow posted it. If so, try eyebonds.info/ibonds . To "take into account the 3 month penalty if you redeem before 5 year...
by #Cruncher
Mon Apr 09, 2018 11:17 pm
Forum: Personal Finance (Not Investing)
Topic: Mandatory IRA Distributions at 70 1/2
Replies: 6
Views: 1051

Re: Mandatory IRA Distributions at 70 1/2

Off the top of my head, let's change #Cruncher's example to make 70th birthday in December, so there's a full 12 months of SS benefits in year 1. Also, let's make the RMD $50K instead of $20K. The top of your head is right on, dodecahedron! In this case the total two year tax is indeed less when th...
by #Cruncher
Mon Apr 09, 2018 4:45 pm
Forum: Personal Finance (Not Investing)
Topic: Mandatory IRA Distributions at 70 1/2
Replies: 6
Views: 1051

Re: Mandatory IRA Distributions at 70 1/2

While deferring is usually not the best choice because you will then have to take 2 RMDs in the second year, in some cases it can reduce your total tax bite for both years combined. When that occurs it is usually due to how SS income is taxed. Alan, could you please give an example of how taxes mig...
by #Cruncher
Sun Apr 08, 2018 1:02 pm
Forum: Investing - Help with Personal Investments
Topic: Tax Advice Needed: Vanguard 1099 TIPS Bond Premium
Replies: 2
Views: 225

Re: Tax Adivice Needed: Vanguard 1099 TIPS Bond Premium

I expected I would be reporting a capital loss on the bonds due to not reporting ABP [amortization of bond premium] in 2012 and 2013. However, the basis that Vanguard provided on my 1099 exactly equals the proceeds For Schedule D I'd report the cost basis equal to the proceeds with a consequent $0 ...
by #Cruncher
Fri Apr 06, 2018 10:42 am
Forum: Investing - Help with Personal Investments
Topic: Question on dreaded 1099 OID tips in fund
Replies: 3
Views: 333

Re: Question on dreaded 1099 OID tips in fund

No, you don't escape the OID by investing in a fund instead of individual TIPS. You're wrong here, Nisi. Holders of individual TIPS held in a taxable account will receive a 1099-OID. However, holders of a TIPS fund (or a fund like Vanguard Target Retirement Income Fund - VTINX that itself holds a T...
by #Cruncher
Thu Apr 05, 2018 8:21 pm
Forum: Investing - Theory, News & General
Topic: 30 yr tips auction 2/15: 1.0% yield?
Replies: 174
Views: 16862

Re: 30 yr tips auction 2/15: 1.0% yield?

It's not cost effective for the insurance company to immunize the real annuities, which is done separately with TIPS instead of nominal Treasuries, when the demand for the product is so low. I agree that demand for inflation-indexed annuities is low. I believe part of the reason is that they provid...
by #Cruncher
Wed Apr 04, 2018 5:01 pm
Forum: Investing - Help with Personal Investments
Topic: Magic Number - Approach considering Social Security and Pension
Replies: 14
Views: 1462

Re: Magic Number - Approach considering Social Security and Pension

It's easier in my mind if you would just leave out inflation in your calculations. Do everything in age 55 dollars. This is made less easy by the $14,000 pension starting at age 65 which I assume is not inflation-indexed. To do everything in age 55 dollars we need to convert the pension to that bas...
by #Cruncher
Tue Apr 03, 2018 8:28 pm
Forum: Personal Finance (Not Investing)
Topic: I-bonds and the IRS
Replies: 3
Views: 1083

Re: I-bonds and the IRS

[In reply to email inquiry, TreasuryDirect said] "This means in order to get the new interest rate you would have to wait to submit your taxes until May." If the rate is increased on 11April that is what I will do. Knowing the rate determined by the BLS CPI announcement April 11th (see this schedul...
by #Cruncher
Sat Mar 31, 2018 4:26 pm
Forum: Personal Finance (Not Investing)
Topic: Calculating monthly interest on CD for cashflow..APY v. APR
Replies: 3
Views: 323

Re: Calculating monthly interest on CD for cashflow..APY v. APR

Does anyone have a good spreadsheet or formula for calculating monthly interest on a CD or other cash investment? Here's a simple spreadsheet you can build. I checked it (through 3/29/2018) against a CD that I've had for 11 months at Capital One. Note how after one year (365 days), the balance will...
by #Cruncher
Fri Mar 30, 2018 2:34 pm
Forum: Investing - Theory, News & General
Topic: Consistent Yield & Duration to Help Choose TIPS Fund
Replies: 84
Views: 20327

Re: Consistent Yield & Duration to Help Choose TIPS Fund

I've updated the Yield to Maturity and Duration Calculator with WSJ TIPS Prices 3/29/2018 [1] and the weighting effect of the 10-year auctions in January & March and the 30-year auction in February. As shown in the table below, the weighted average yield of the bonds in the 1+ years broad index is 0...
by #Cruncher
Thu Mar 29, 2018 12:47 pm
Forum: Personal Finance (Not Investing)
Topic: SS Taxation -Please Clarify
Replies: 12
Views: 1325

Re: SS Taxation -Please Clarify

After reading the Bogleheads wiki on the subject [Taxation of Social Security benefits] ... $90,000 AGI [?] exceeds couple's upper base of $44,000 so 85% of SS is taxable, 85% of $20,000 = $17,000 Your $90,000 is correct. (However it is not called AGI (Adjusted Gross Income) -- that refers to somet...
by #Cruncher
Wed Mar 28, 2018 7:08 am
Forum: Personal Finance (Not Investing)
Topic: Can someone list all the benefits of "FRA" ? [vs taking SS one month before FRA]
Replies: 12
Views: 1127

Re: Can someone list all the benefits of "FRA" ? [vs taking SS one month before FRA]

Here is a month by month breakdown of the exact percentages: [How Your Social Security Benefit Is Reduced] Here is similar information showing the benefit per $1,000 of Primary Insurance Amount (PIA) depending on how many months one claims before the Normal (aka Full) Retirement Age (NRA). It also ...
by #Cruncher
Mon Mar 26, 2018 2:04 pm
Forum: Investing - Help with Personal Investments
Topic: Treasury Bills vs. I-bonds vs. Intermediate-term tax-exempt muni bonds
Replies: 24
Views: 3568

Re: Treasury Bills vs. I-bonds vs. Intermediate-term tax-exempt muni bonds

[The formula =B1*(1+B7)^IF(B2<5,B2-0.25,B2) ] implicitly assumes that the I bond is held only 12 months. Otherwise that yield loss should be amortized across the (unknown) holding period. No, the formula is correct and works for any period of one year or more. The penalty for redeeming before five ...
by #Cruncher
Mon Mar 26, 2018 1:10 pm
Forum: Personal Finance (Not Investing)
Topic: When to Take Social Security (again...)
Replies: 62
Views: 5476

Re: When to Take Social Security (again...)

Here's a thread from a few years ago, arguing you can spend MORE in your 60s if you delay ... Here is an illustration where a single taxpayer delaying SS to age 70 can have $10,000 MORE to spend (after federal income tax) each year from age 62 to 70 and also live slightly longer before running out ...
by #Cruncher
Sun Mar 25, 2018 9:52 am
Forum: Investing - Help with Personal Investments
Topic: Treasury Bills vs. I-bonds vs. Intermediate-term tax-exempt muni bonds
Replies: 24
Views: 3568

Re: Treasury Bills vs. I-bonds vs. Intermediate-term tax-exempt muni bonds

I am trying to decide between putting $10,000 into a 2-year bank CD earning 2.55% or an I-bond currently earning 2.58%. I am in the 12% federal tax bracket (filing jointly) and I would either pay an additional 3.07% state income tax on the CD or forfeit 3 months of interest on the I-bond (by redeem...
by #Cruncher
Sat Mar 24, 2018 9:53 pm
Forum: Personal Finance (Not Investing)
Topic: Chris Hogan's Retirement Calculator
Replies: 10
Views: 3515

Re: Chris Hogan's Retirement Calculator

... assuming 2.75% inflation, ROR = 12% and a 6% withdrawal rate. Here is what the calculator appears to do: Takes the $120,000 and inflates it to $270,792 using 30 years and 2.75% inflation rate which is good. Then it simply divides the $270,792 by 6% to get the $4,513,200. So If I change the with...
by #Cruncher
Fri Mar 23, 2018 4:26 pm
Forum: Personal Finance (Not Investing)
Topic: Mortgage and Social Security Question
Replies: 5
Views: 829

Re: Mortgage and Social Security Question

If your life expectancy is 20 years, then losing one year of SS is a 5% reduction in the 8% benefit, for a net real return of 3%. The return depends on both life expectancy and the age at which one delays one year. For example, assume one will die at age 86 and one's Normal Retirement Age (NRA) is ...
by #Cruncher
Fri Mar 23, 2018 1:07 pm
Forum: Investing - Help with Personal Investments
Topic: Treasury Bills vs. I-bonds vs. Intermediate-term tax-exempt muni bonds
Replies: 24
Views: 3568

Re: Treasury Bills vs. I-bonds vs. Intermediate-term tax-exempt muni bonds

2) I-bonds: ... I know the historical rates fluctuate: http://www.ibonds.info/I-Bond-Rates/I-Bond-Composite-Rate.aspx. The graph on this webpage shows the history of "Initial Composite Rates". A much more useful graph in my opinion is the one of historical fixed rates on this webpage . I would use ...
by #Cruncher
Thu Mar 22, 2018 3:35 pm
Forum: Personal Finance (Not Investing)
Topic: Present Value of a FERS Pension with a Spousal Benefit
Replies: 7
Views: 885

Re: Present Value of a FERS Pension with a Spousal Benefit

Here are the numbers I think are relevant. ... I’m the annuitant and I’m 62.6 years old. My wife is 59.8 years old. The unreduced annual pension amount is $65,700 [$5,475/mo]. The reduced annual pension amount, after deducting for the spousal benefit, is $59,100 [$4,925/mo] ... If I predecease my w...
by #Cruncher
Wed Mar 21, 2018 12:00 pm
Forum: Investing - Help with Personal Investments
Topic: Treasury Bill Rates
Replies: 32
Views: 3167

Re: Treasury Bill Rates

... one month T Bills, currently returning approximately 1.7%. Is that percentage the equivalent rate I would receive over a year? Roughly yes. The precise return over a 365-day year would be 1.740% calculated as follows: First, using the Treasury's formula , determine the price corresponding to a ...
by #Cruncher
Thu Mar 15, 2018 9:15 am
Forum: Investing - Help with Personal Investments
Topic: Is my math wrong? - How much should I save monthly?
Replies: 26
Views: 2536

Re: Is my math wrong? - How much should I save monthly?

... this site: https://www.bankrate.com/calculators/savings/saving-goals-calculator.aspx is estimating more like $1,250. To be precise the Bankrate calculator returns $1,234.96 (with "Amount of first deposit" = $54,000). This one gives 1250.70 https://www.thecalculatorsite.com/finance/calculators/s...
by #Cruncher
Thu Mar 08, 2018 10:34 pm
Forum: Investing - Help with Personal Investments
Topic: Quick bond pricing + effective duration question
Replies: 9
Views: 964

Re: Quick bond pricing + effective duration question

I was able to duplicate the $100 price of the bond in that Investopedia article by valuing a temporary 10-year immediate annuity of $6 per year plus the final payment of $100 at the end of the 10th year using an interest rate of 6% per year Yes, the price will indeed be $100 for a ten-year bond wit...
by #Cruncher
Tue Mar 06, 2018 11:38 pm
Forum: Investing - Help with Personal Investments
Topic: Portfolio Checkup: What have I missed? Some questions (pension buyout, DW SSA filing)
Replies: 14
Views: 962

Re: Portfolio Checkup: What have I missed? Some questions (pension buyout, DW SSA filing)

A pension question! Starting at age 55, I am eligible to collect a pension ... With the 100% joint/survivor selection, the monthly payment is $353 at age 55. At age 62, the monthly payment would be $462/month. The pension is not inflation adjusted. ... at age 55 ... I can take a one-time buyout of ...
by #Cruncher
Sat Mar 03, 2018 5:20 pm
Forum: Personal Finance (Not Investing)
Topic: CD - Early Withdrawal and Reinvest
Replies: 11
Views: 942

Re: CD - Early Withdrawal and Reinvest

This might help: When To Break A CD Calculator Since it gives a "Yes/No" answer, "Should I ..." instead of "When to ..." might be better in the link name, Flobes. To actually provide a "When to" answer, I developed a little spreadsheet that calculates the yield on the new CD needed to break even. H...
by #Cruncher
Fri Mar 02, 2018 10:31 pm
Forum: Investing - Theory, News & General
Topic: Harvard blows $1Billion picking stocks, averaged 4.4% returns over last decade
Replies: 79
Views: 10504

Re: Harvard blows $1Billion picking [exotic things besides] stocks, averaged 4.4% returns over last decade

From the Bloomberg article : Harvard over the past decade ended June 30 posted a 4.4 percent average annual return, among the worst of its peers. It even lagged the simplest approach: Investing in a market-tracking index fund holding 60 percent stocks and 40 percent bonds, which earned an annual 6.4...
by #Cruncher
Thu Mar 01, 2018 1:47 pm
Forum: Personal Finance (Not Investing)
Topic: Understanding effect of capital gains on income tax bracket
Replies: 5
Views: 1133

Re: Understanding effect of capital gains on income tax bracket

see tfb's stack bar chart on 12/11/11 here https://www.bogleheads.org/forum/viewtopic.php?t=86849 (Click here to go directly to tfb 's post without having to scroll through the thread to find it.) The following illustrates the chart with actual numbers from the original post. After the $24,000 stan...
by #Cruncher
Wed Feb 28, 2018 8:40 am
Forum: Investing - Help with Personal Investments
Topic: Quick bond pricing + effective duration question
Replies: 9
Views: 964

Re: Quick bond pricing + effective duration question

The referenced Investopedia article is poor for a couple of reasons. Firstly the example is arithmetically impossible: As an example, assume that an investor purchases a bond for 100% par and that the bond is currently yielding 6%. Using a 10 basis-point change in yield (0.1%), it is calculated that...
by #Cruncher
Tue Feb 27, 2018 9:54 pm
Forum: Investing - Help with Personal Investments
Topic: Schwab 1099 Problems for Maturing TIPS
Replies: 4
Views: 820

Schwab 1099 Problems for Maturing TIPS in 2017

Unfortunately one of the two problems on my Schwab 1099s for 2014 and 2015 occurred again on the 2017 1099. This time it related to my 2.625% coupon TIPS that matured 7/15/2017 . On the 1099-B the figure reported under "1e-Cost or other basis" again omits the OID that accumulated between purchase an...
by #Cruncher
Thu Feb 22, 2018 12:04 am
Forum: Investing - Theory, News & General
Topic: 30 yr tips auction 2/15: 1.0% yield?
Replies: 174
Views: 16862

Re: 30 yr tips auction 2/15: 1.0% yield?

but the point is that one tenth of the purchasing power of this bucket will be readily available each year without any concerns for liquiidity or loss of purchasing power. ... The price of a ten nominal dropped 0.5% today and 3% in the last month. ... if you need dollars for some unforeseen event t...
by #Cruncher
Tue Feb 20, 2018 2:02 pm
Forum: Investing - Theory, News & General
Topic: "The Effects of Social Security Benefits and RMDs on Tax-Efficient Withdrawal Strategies"
Replies: 10
Views: 2365

Re: "The Effects of Social Security Benefits and RMDs on Tax-Efficient Withdrawal Strategies"

From the article referenced in the original post: The tax law does not adjust the $25,000 and $34,000 PI [Provisional Income -- used in determining how much of SS is taxed] thresholds for inflation, an aspect that is important when planning retirement income withdrawals over several decades This lac...
by #Cruncher
Sun Feb 18, 2018 11:03 am
Forum: Personal Finance (Not Investing)
Topic: How to pay ZERO taxes in retirement with 6-figure expenses
Replies: 201
Views: 108459

Re: How to pay ZERO taxes in retirement with 6-figure expenses

You can imagine that if you retired into a 0% bracket, but needed $100,000 -- do some guesses as to the future bracket schedule & see how much money you would pay in taxes -- and remember that you need the entire $100,000, so you would be withdrawing more to cover the taxes. Which is also taxed at ...
by #Cruncher
Sat Feb 17, 2018 2:59 pm
Forum: Investing - Theory, News & General
Topic: 30 yr tips auction 2/15: 1.0% yield?
Replies: 174
Views: 16862

Re: 30 yr tips auction 2/15: 1.0% yield?

Auction yield was 1.003% Here's the auction results PDF . Also: I couldn't find a google sheet spreadsheet form that was functional in laying out costs of a sample floor. Magellan and Cruncher had some phenomenal Xcel but I prefer google sheets. Anyone have a link? I believe you're referring to spr...
by #Cruncher
Wed Feb 14, 2018 12:21 pm
Forum: Investing - Theory, News & General
Topic: 30 yr tips auction 2/15: 1.0% yield?
Replies: 174
Views: 16862

Re: 30 yr tips auction 2/15: 1.0% yield?

If one's eventual goal is to at least partly annuitize the tips ladder, then duration matching is useful. in other words you want the average maturity of your tips ladder to somewhat closely match that of the annuity you are hoping to buy. This helps it be a better hedge on the price you will end u...
by #Cruncher
Mon Feb 12, 2018 2:38 pm
Forum: Investing - Theory, News & General
Topic: The Mathematics of Retirement Investing
Replies: 127
Views: 19626

Re: The Mathematics of Retirement Investing

... #Cruncher....Quick question. Will the spreadsheets be updated for the new tax rates? Here is the updated method for creating the 2-column spreadsheet discussed in this post : Select all, copy, and paste at cell A1: [*] Years Withdrawal rate Salary Social Security Adjust working spending $ for r...
by #Cruncher
Sat Feb 10, 2018 4:16 pm
Forum: Investing - Theory, News & General
Topic: Matching a TIPS bond ladder with ST and LT TIPS bond funds
Replies: 98
Views: 5564

Re: Matching a TIPS bond ladder with ST and LT TIPS bond funds

If one were to rebalance on a weekly or daily [basis] the interest rate risk would nearly go away. This is not the case, BobK. As the frequency of duration adjustment increases, the benefit of doing so gets smaller and smaller. I increased the number of adjustments 8-fold in the example from my pre...
by #Cruncher
Sat Feb 10, 2018 8:38 am
Forum: Investing - Theory, News & General
Topic: Matching a TIPS bond ladder with ST and LT TIPS bond funds
Replies: 98
Views: 5564

Re: Matching a TIPS bond ladder with ST and LT TIPS bond funds

You have to update the weights at least quarterly ... Be aware that adjusting the duration of the funds more frequently reduce s, but does not eliminate , interest rate risk. To see this I constructed a very hypothetical example. It assumes one wants to have $1,000 (inflation adjusted) in four year...
by #Cruncher
Wed Feb 07, 2018 2:11 pm
Forum: Investing - Theory, News & General
Topic: Matching a TIPS bond ladder with ST and LT TIPS bond funds
Replies: 98
Views: 5564

Re: Matching a TIPS bond ladder with ST and LT TIPS bond funds

I'm still pondering this method, which basically seems to be a strategy for "simulating" a bond ladder with a sliding "duration targeting" approach that utilizes a short-term and a long-term bond fund. You simply ratchet down the average duration of the two funds to match your year-by-year spending...
by #Cruncher
Mon Feb 05, 2018 5:53 pm
Forum: Investing - Theory, News & General
Topic: Recovering from a "draw down" on 7-10 year US Treasuries
Replies: 15
Views: 1758

Re: Recovering from a "draw down" on 7-10 year US Treasuries

A fund can have a duration of around 7 by only holding 7-10 year bonds or it can have the same duration by holding a ladder from 1 to 15 (or so) years. Both funds would behave similarly. This can be illustrated by comparing two hypothetical "funds". Fund A holds three zero coupon bonds each with ma...
by #Cruncher
Sun Feb 04, 2018 8:12 am
Forum: Investing - Help with Personal Investments
Topic: I BONDS Maturing in 2030
Replies: 42
Views: 3037

Re: I BONDS Maturing in 2030

With a high fixed rate I Bond, it probably makes more sense to hold until maturity. In the following example this is the better course as long as the marginal tax rate at maturity is less than 48%. My example assumed if the I Bond were redeemed this year (Case A), the gain would be taxed at 12%. It...
by #Cruncher
Thu Feb 01, 2018 11:01 pm
Forum: Investing - Help with Personal Investments
Topic: I BONDS Maturing in 2030
Replies: 42
Views: 3037

Re: I BONDS Maturing in 2030

My only solution (that I can see at this time) is to sell our I Bonds little by little over the next 12 years so that in year 2030 we will have no more than $30,000 in accrued interest. With a high fixed rate I Bond, it probably makes more sense to hold until maturity. In the following example this...
by #Cruncher
Thu Feb 01, 2018 12:41 pm
Forum: Personal Finance (Not Investing)
Topic: Social Security Updates...
Replies: 16
Views: 2846

Re: Social Security Updates...

Any reduction in benefit caused by claiming before FRA is calculate[d] by the month. As shown in footnote c on this SSA webpage the reduction is 5/9% for each month up to 36 and 5/12% for each additional month. Months ------ Reduction ------ 1 5/9 % ( 0.56% ) 2 1 1/9 % ( 1.11% ) 3 1 2/3 % ( 1.67% )...
by #Cruncher
Mon Jan 29, 2018 8:46 pm
Forum: Investing - Theory, News & General
Topic: Inflation and Constant rate (4% rule) vs. RMD-based portfolio withdrawals
Replies: 11
Views: 1116

Re: Inflation and Constant rate (4% rule) vs. RMD-based portfolio withdrawals

1. RMDs are not necessarily "withdrawn" from the portfolio in the sense that you use the full amount for living expenses. You may reinvest them ... in a taxable account ... Here's an illustration in constant dollars assuming: $1,000,000 balance at age 70 in a traditional IRA and $0 in a taxable acc...
by #Cruncher
Sat Jan 27, 2018 6:06 pm
Forum: Personal Finance (Not Investing)
Topic: Capital Gains Tax Question
Replies: 8
Views: 1412

Re: Capital Gains Tax Question

LTCG and Qualified dividends don't lift your ordinary income into higher brackets. The LTCG/QDI "float on top" of the ordinary income True. In addition to the graphical representations shown here by cas and here by Toons , here is a numerical illustration. It is for a 2017 joint return with the sta...
by #Cruncher
Thu Jan 25, 2018 10:48 pm
Forum: Personal Finance (Not Investing)
Topic: Social Security “Hump” and the new tax rates???
Replies: 36
Views: 5402

Re: Social Security “Hump” and the new tax rates???

If I am projecting forward, I assume I am doing everything in today's dollars, and assume everything ... will ... grow with inflation. The one exception ... would be the ... SS income thresholds, which do not increase with inflation.Thus I decreased them about 35% , which was a rough approximation ...
by #Cruncher
Wed Jan 24, 2018 11:44 am
Forum: Investing - Help with Personal Investments
Topic: Help needed with a loan/payoff scenario.
Replies: 16
Views: 1012

Re: Help needed with a loan/payoff scenario.

... what I would really like to know is how to solve this problem in general. In general, the lump sum should be the amount needed to reduce the loan balance to what it would have been if you had continued to make the extra payments. Using the symbols below this would be p2m less p2e. I've included...
by #Cruncher
Mon Jan 22, 2018 11:29 pm
Forum: Investing - Theory, News & General
Topic: Portfolio size needed to reach each tax bracket in retirement
Replies: 19
Views: 2947

Re: Portfolio size needed to reach each tax bracket in retirement

The "Income" column in your table is wrong, willthrill81. Based on the joint tax tables (as shown here in the Wiki), here is what I believe you intended to show: Starts Incl Incre- Cumu- Rate At Std Ded ment X 25 lative ---- ------ ------- ------- --------- ---------- 10% 0 24,000 24,000 600,000 600...
by #Cruncher
Sat Jan 20, 2018 2:26 pm
Forum: Personal Finance (Not Investing)
Topic: Federal tax estimator that includes Social Security income?
Replies: 21
Views: 2673

Re: Federal tax estimator that includes Social Security income?

Yes, looks like Intuit updated Taxcaster for 18. ... According to it, I'm looking at saving about 17K off my tax bill next year vs this year. I have a hard time believing that. Can't judge the reasonableness of that without knowing your income and deductions, Fess McGee. But for joint filers taking...
by #Cruncher
Fri Jan 19, 2018 10:01 am
Forum: Investing - Help with Personal Investments
Topic: Job terminated. Convert small pension to lump sum or annuity?
Replies: 18
Views: 1722

Re: Job terminated. Convert small pension to lump sum or annuity?

To answer you[r] question about rate of return, you can do it in Excel using the IRR or XIRR function. It's easier to use the Excel RATE function . For example, using JBTX 's assumption in this post of 55 years for the single life pension, it shows an annualized return of 4.25%: 4.2516% = 12 * RATE...
by #Cruncher
Sun Jan 14, 2018 11:54 am
Forum: Personal Finance (Not Investing)
Topic: Social Security “Hump” and the new tax rates???
Replies: 36
Views: 5402

Re: Social Security “Hump” and the new tax rates???

[Wiki's] Social Security tax impact calculator Wondering how this “Hump” will change with the new tax rates? ... Any chance someone will update the wiki page[?] Taking your second question first, tamucpa, you could send a private message to PapaGeek , the author of the Wiki page and the spreadsheet...