Search found 2552 matches

by #Cruncher
Mon Jun 25, 2018 10:31 am
Forum: Investing - Help with Personal Investments
Topic: Individual Treasuries at auction - Cost
Replies: 4
Views: 306

Re: Individual Treasuries at auction - Cost

The whole reason there is an auction is that competitive bids are either at a premium or discount to par. Bids are in terms of yield, not price. After the yield is determined at the auction, it is converted to the price by a formula. At the initial auction of a Treasury note or bond, the coupon is ...
by #Cruncher
Mon Jun 25, 2018 9:40 am
Forum: Investing - Theory, News & General
Topic: I-bonds look pretty bad right now
Replies: 82
Views: 9171

Re: I-bonds look pretty bad right now

… So on $10K, the deferral for five years is worth about $10. Good example to isolate the effect of deferral, Kevin. The table below expands your comparison to seven assumed inflation rates from 1.0% to 4.0%, and five different holding periods from 2 to 30 years. To make the differences more compar...
by #Cruncher
Sun Jun 24, 2018 2:12 pm
Forum: Investing - Theory, News & General
Topic: I-bonds look pretty bad right now
Replies: 82
Views: 9171

Re: I-bonds look pretty bad right now

... I thought that the penalty is really a sunk cost. Alternatively, if they were more than 1 year but less than 5 years old, you could look at the penalty as boosting your YTM through year 5.... I don't understand the point of framing it in either of these ways. I'm not sure what jeffyscott means ...
by #Cruncher
Fri Jun 22, 2018 10:14 pm
Forum: Investing - Theory, News & General
Topic: I-bonds look pretty bad right now
Replies: 82
Views: 9171

Re: I-bonds look pretty bad right now

Since it was a 0% I-bond, I should have (at least) $1000 inflation adjusted 2013 dollars. Based on your inflation figures, I don't. I do not know if that is because of the lag or if the inflation adjustment that you applied to TBM was wrong. Firstly, spdoublebass in this post didn't apply an inflat...
by #Cruncher
Fri Jun 22, 2018 1:54 pm
Forum: Investing - Help with Personal Investments
Topic: How can I find out % return on Vanguard Total Bond Index?
Replies: 9
Views: 919

Re: How can I find out % return on Vanguard Total Bond Index?

I currently have $3,031 invested in Vanguard Short Term Bond Index . I have noticed that every month I get a dividend distribution of around $6.50. (underline added) Are you sure this is the right fund, Jester? I see a $0.01625 / share May dividend for Short-Term Bond Index Investor Shares (VBISX) ...
by #Cruncher
Fri Jun 22, 2018 12:18 pm
Forum: Investing - Theory, News & General
Topic: I-bonds look pretty bad right now
Replies: 82
Views: 9171

Re: I-bonds look pretty bad right now

3. Whenever the 6-month CPI change they use is negative, I Bonds may get a bonus because of what I call the "floor feature" ...). The following table quantifies, for all I Bonds issued before November 2015, the bonus arising from the two cases where the CPI change was negative. [1] For example, scr...
by #Cruncher
Wed Jun 20, 2018 7:29 pm
Forum: Investing - Theory, News & General
Topic: Advice on Roth conversions
Replies: 19
Views: 1318

Re: Advice on Roth conversions

… we plan to liquidate some stock holdings in MegaCorp - to the tune of $300K-400K this year in LTCG -total MegaCorp holding is about $1.1 M. This is likely to continue for 3+ years ... bradpevans: Its not clear how much is basis / how much is gain? ... Good question. The stock sale results in a LT...
by #Cruncher
Wed Jun 20, 2018 10:36 am
Forum: Investing - Help with Personal Investments
Topic: Treasury Direct Question
Replies: 23
Views: 2185

Re: Treasury Direct Question

The way it works is ... Nicely written explanation of how a Treasury auction works, PJW! The auction was today and I now see this information: Maturity Date = 07/19/2018 High Rate = 1.815% Investment Rate = 1.843% Price Per $100 = 99.858833 (These figures appear on the 28-day bill auction results P...
by #Cruncher
Mon Jun 18, 2018 4:46 pm
Forum: Investing - Theory, News & General
Topic: I-bonds look pretty bad right now
Replies: 82
Views: 9171

Re: I-bonds look pretty bad right now

Based on a marginal tax rate of 22%, and assuming that CPI inflation is constant, here is what I got: … The current fixed rate is 0.3%, so no matter how long you hold your I-bond, you'll never keep up with inflation. :| As shown in the following table, this is true for any constant inflation of at ...
by #Cruncher
Mon Jun 18, 2018 11:22 am
Forum: Personal Finance (Not Investing)
Topic: Social Security advice needed
Replies: 28
Views: 1951

Re: Social Security advice needed

... (using the life expectancy of 85), I come up with total payouts at $279,036 if I took it at age 62 and $312,588 at age 66. That's a difference of $33,552. The four years from age 62 to 66 where I would receive the 1,011 a month equals $48,528. Based on the above numbers, it looks like it makes ...
by #Cruncher
Sat Jun 16, 2018 3:54 pm
Forum: Investing - Help with Personal Investments
Topic: When to "raise my rate" (Ally bank CD)
Replies: 19
Views: 2458

Re: When to "raise my rate" (Ally bank CD)

It matures December 2021. Current APY for the CD is 2%, and I can exercise my increase option to raise it to 2.35% immediately. Should I do it now, or wait? Your CD has 3.5 years to run. If you raise the rate to 2.35% now, each $1 of current value will grow to $1.0847 (1.0235 ^ 3.5). The following ...
by #Cruncher
Sat Jun 16, 2018 10:58 am
Forum: Investing - Theory, News & General
Topic: Treasury Notes Return vs Actual TIPS Return
Replies: 11
Views: 3152

Re: Treasury Notes Return vs Actual TIPS Return

I've updated my comparisons to include TIPS maturing in 2018. These are the 10-year TIPS issued in 2008 and the 5-year TIPS issued in 2013. Here is a chart showing the difference between the inflation-adjusted return of a 10-Year TIPS bought at auction and held to maturity and my estimate of the yie...
by #Cruncher
Fri Jun 15, 2018 4:27 pm
Forum: Personal Finance (Not Investing)
Topic: Savings rate to achieve retirement goals?
Replies: 10
Views: 1105

Re: Savings rate to achieve retirement goals?

You need $1,750,000 at a 4% draw to obtain $70K + $30K Social Security. You have $400K today, at a 5% growth rate, you need to contribute $7,027 per MONTH for exactly 120 months [f]or 10 years. You have $400K today, at a 5% growth rate, you need to contribute $3,834.05 per MONTH for exactly 180 mon...
by #Cruncher
Thu Jun 14, 2018 7:22 pm
Forum: Investing - Theory, News & General
Topic: 30 yr tips auction: june 21: 1.0% yield?
Replies: 25
Views: 2781

Re: 30 yr tips auction: june 21: 1.0% yield?

So index factor is 1.01575 and accrued interest is $3.76 per $1000. So if the bond auctions at par one will need $1019.51 per bond. Here is what the total cost would be for other auction yields including the $3.76 interest accrued for 4-1/2 months [1]: Cost per Yield Price $1,000 Face 0.83% 104.457...
by #Cruncher
Thu Jun 14, 2018 4:38 pm
Forum: Personal Finance (Not Investing)
Topic: Long-term gains and Tax Bracket
Replies: 14
Views: 1591

Re: Long-term gains and Tax Bracket

E.g., for $100 LTCG, the marginal rates from ordinary income between $101K and $101.5K are ... Even though it's of no practical use [*], I felt compelled to understand the strange graph you produced, FiveK, particularly the skinny stalagmite that rises between 101,300 and 101,330. But first it's ne...
by #Cruncher
Thu Jun 14, 2018 9:41 am
Forum: Investing - Theory, News & General
Topic: 30 yr tips auction: june 21: 1.0% yield?
Replies: 25
Views: 2781

Re: 30 yr tips auction: june 21: 1.0% yield?

For what it's worth here's a chart of the 30 year yield and the added additional yield over the ten year yield. Good chart, Doc. Here's another that shows the flattening TIPS yield curve. This one is from the start of 2016 and simply shows the weekly yields for the 30-Year , 10-Year , and 5-Year Co...
by #Cruncher
Wed Jun 13, 2018 8:25 am
Forum: Personal Finance (Not Investing)
Topic: Long-term gains and Tax Bracket
Replies: 14
Views: 1591

Re: Long-term gains and Tax Bracket

See tfb's picture (12/11/11 5:26PM) here https://www.bogleheads.org/forum/viewtopic.php?t=86849 Click here to go directly to the post with tfb 's chart. Below is a variant of that chart showing, side-by-side, the long term capital gain (LTCG) brackets and the new 2018 brackets for ordinary income. ...
by #Cruncher
Tue Jun 12, 2018 1:40 pm
Forum: Personal Finance (Not Investing)
Topic: Confused by Two DinkyTown Calculators
Replies: 8
Views: 1245

Re: Confused by Two DinkyTown Calculators

Is there anything I'm missing? If not, then Cruncher could you give me the Excel formula for this? I've built a little spreadsheet around the PMT function with the following changes from the approach in my previous post : Ignore inflation and instead forecast in constant dollars with the assumed in...
by #Cruncher
Mon Jun 11, 2018 7:01 am
Forum: Personal Finance (Not Investing)
Topic: Calculation of APY (Annual Percentage Yield) for Savings
Replies: 10
Views: 674

Re: Calculation of APY (Annual Percentage Yield) for Savings

It is also better (more consistent) to use months that are 1/12 of a year. What do you mean by this, dm200? No month is exactly 1/12 of 365 (or 366) days. What some (perhaps many) banks and credit unions do is advertise/disclose a rounded APY and "back in" the lowest rate that rounds to the desired...
by #Cruncher
Sun Jun 10, 2018 9:08 pm
Forum: Personal Finance (Not Investing)
Topic: Confused by Two DinkyTown Calculators
Replies: 8
Views: 1245

Re: Confused by Two DinkyTown Calculators

Go here... http://www.dinkytown.net/java/RetirementIncome.html … Year(s) of retirement: 39 … It will calculate $7,313 of monthly income - after taxes and adjusted for inflation. That equals $87,756 annually … Go here... http://www.dinkytown.net/java/RetirementDistribution.html … Amount You want to ...
by #Cruncher
Sun Jun 10, 2018 2:59 pm
Forum: Personal Finance (Not Investing)
Topic: Calculation of APY (Annual Percentage Yield) for Savings
Replies: 10
Views: 674

Re: Calculation of APY (Annual Percentage Yield) for Savings

… Calculate interest (rounded to nearest cent) for FIRST compounting period (month in example - is $99.17 Calcullate annual yield (before rounding) - 1.196511961 in this example Round to two decimal places - as required by regulations = 1.20% Your example doesn't work in reverse, dm200. If we start...
by #Cruncher
Sat Jun 09, 2018 4:58 pm
Forum: Investing - Theory, News & General
Topic: Mathematical error in the bogleheads guide to investing book
Replies: 3
Views: 1160

Re: Mathematical error in the bogleheads guide to investing book

It looks like the original poster is referring to this sentence (on page 61 of my paperback edition): In Table 5.7, we can see that the wider spread in the fixed yields (.75 percent) helped the taxable TIPS outperform the lower-yielding I Bond by $116 for those investors in the lowest tax bracket. T...
by #Cruncher
Thu Jun 07, 2018 7:07 pm
Forum: Personal Finance (Not Investing)
Topic: Help needed with formula for calculating future expense
Replies: 4
Views: 329

Re: Help needed with formula for calculating future expense

You could treat inflation as compound interest (like on a CD/Bond). Here is a site that shows how to use it: https://exceljet.net/formula/calculate-compound-interest The referenced webpage does mention the Excel FV function which can provide the answer; but it doesn't give the appropriate usage. Th...
by #Cruncher
Thu Jun 07, 2018 4:52 pm
Forum: Investing - Theory, News & General
Topic: 30 yr tips auction: june 21: 1.0% yield?
Replies: 25
Views: 2781

Re: 30 yr tips auction: june 21: 1.0% yield?

If you don't care about the real yield but only the principal it matters not in matching those long term liabilities. 1% isn't much, but it's not "chopped liver" either. For example the cost of a $30,000 per year 30-year hypothetical [*] ladder with each bond yielding 1% would be about $126,000 les...
by #Cruncher
Thu Jun 07, 2018 8:11 am
Forum: Personal Finance (Not Investing)
Topic: SS calculator for estimated amount $ working min years 40 quarters or fixed # of years
Replies: 12
Views: 950

Re: SS calculator for estimated amount $ working min years 40 quarters or fixed # of years

... I am trying to find out ... the estimated amount of social security ( or PIA??) that I will get say if I only work 10-15 years instead of 30-35 years, but with decent earnings (not low wages) approx 90-120 K ... Below is a table showing the Primary Insurance Amount (PIA) for Case A from the Ben...
by #Cruncher
Wed Jun 06, 2018 10:59 pm
Forum: Personal Finance (Not Investing)
Topic: Social Security - Reality Check
Replies: 16
Views: 2368

Re: Social Security - Reality Check

My full retirement age is 67; hers is 66.5. By the time I turn 62, she will be past her FRA. I have earned almost all of our income throughout our marriage. My wife does not have nearly enough SS credits to qualify for benefits on her own. ... if I retire at 62, I can expect to get about $1400/mont...
by #Cruncher
Wed Jun 06, 2018 10:36 am
Forum: Investing - Help with Personal Investments
Topic: Basic 30-year TIPS vs 30-Year Treasury Bond Question
Replies: 9
Views: 540

Re: Basic 30-year TIPS vs 30-Year Treasury Bond Question

… a 30-year TIPS ... Interest Rate would be 1.0% … a 30-year Treasury Bond, the interest rate would be: 3.125% ... if inflation turned out to be exactly 2.125% every year over the next 30 years, the resulting principal + interest payments between a 30-year TIPS and 30-year Treasury would be identic...
by #Cruncher
Sun Jun 03, 2018 11:54 am
Forum: Personal Finance (Not Investing)
Topic: Profile: The Road to 1Million USD
Replies: 42
Views: 8430

Re: Profile: The Road to 1Million USD

I see your grid and I raise you :mrgreen: Same website, different chart. This one is the path to one million dollars. It assumes 7% yearly growth. Link: http://www.fourpillarfreedom.com/the-million-dollar-age-grid/ Here is a variant of that chart. Instead of the age when one will have accumulated $...
by #Cruncher
Sat Jun 02, 2018 1:01 pm
Forum: Personal Finance (Not Investing)
Topic: Keep pension or roll over to IRA?
Replies: 14
Views: 1044

Re: Keep pension or roll over to IRA?

... Using the OP's original data and no COLA, there will be a single rate from the original $35,000 where she can get $8,200 a year indefinitely ... How would you calculate that rate, and what is it? You're looking for the rate r such that 35000 * (1 + r) ^ 25 = 8200 / r I don't know how to solve f...
by #Cruncher
Sat Jun 02, 2018 8:39 am
Forum: Personal Finance (Not Investing)
Topic: Keep pension or roll over to IRA?
Replies: 14
Views: 1044

Re: Keep pension or roll over to IRA?

You can play around with figures at www.immediateannuities.com I just did it for you, using rough approximations, and IF you put that amount into an annuity today, for payment to start in 25 years, it would pay approximately $447 per month for life. This morning, ResearchMed, I only get $409 per mo...
by #Cruncher
Fri Jun 01, 2018 3:34 pm
Forum: Personal Finance (Not Investing)
Topic: Profile: The Road to 1Million USD
Replies: 42
Views: 8430

Re: Profile: The Road to 1Million USD

A simple compound interest calculator says that if you start with $17,300, are saving $43,000 a year, and earn an average 6% return a year, you will hit $1M by approximately 2033. Yes, and here it is expanded to show the results for additional constant [*] growth rates of 0% - 5%, 7%, & 8%. Row 5 s...
by #Cruncher
Fri Jun 01, 2018 12:26 am
Forum: Forum Issues and Administration
Topic: How do you post a column aligned table of data ?
Replies: 11
Views: 1342

Re: How do you post a column aligned table of data ?

(I noticed this old thread referenced here by LadyGeek .) If you have columns of different size numbers in a spreadsheet, you can use the Excel RIGHT and TEXT functions to align them. For example, here is a table prepared from three columns of numbers in cells A2:C45. It was prepared with the follo...
by #Cruncher
Wed May 30, 2018 10:33 am
Forum: Personal Finance (Not Investing)
Topic: Lump sum Vs Annuity
Replies: 9
Views: 556

Re: Lump sum Vs Annuity

I am 56 years old. ... if I take the Lump sum now I will receive $413,000. ... if left in the pension plan will be $452,000 in 5 years.… My wife, age 41 … I’ve had two heart attacks … The Annuity does not include a COLA. The options for the annuity include (as of today): Single life @2055.44 monthl...
by #Cruncher
Tue May 29, 2018 1:42 pm
Forum: Investing - Help with Personal Investments
Topic: SPIA - inflation adjusted or not?
Replies: 12
Views: 1474

Re: SPIA - inflation adjusted or not?

... buying a[n] inflation adjusted SPIA of 2% or 3% pay raise each year, ... It's confusing to call an annuity that increases a fixed percent each year "inflation adjusted" since it is not actually adjusted to match inflation. The term "COLA" (for Cost of Living Adjustment), while still technically...
by #Cruncher
Tue May 29, 2018 11:56 am
Forum: Investing - Help with Personal Investments
Topic: US Tres bill on Fidelity
Replies: 9
Views: 719

Re: US Tres bill on Fidelity

I see under new issues on Fixed income on Fidelity a 3 months US Tres 3 months zero coupon with expected yield of 1.9% and settlement of 5/31/2018. This auction took place earlier today. As shown on the auction results PDF file the yield ("High Rate") came in at 1.895%. The corresponding "Investmen...
by #Cruncher
Mon May 28, 2018 1:51 pm
Forum: Investing - Theory, News & General
Topic: The Savings Rate Grid
Replies: 47
Views: 6694

Re: The Savings Rate Grid

Question on the net worthify calculator - does it assume that your income is gross? ... Yes, the savings rate you enter should be your pre-tax savings rate (i.e. the amount you're saving divided by your gross income). An implicit assumption is that your tax rate will be the same in retirement as be...
by #Cruncher
Sun May 27, 2018 10:55 am
Forum: Investing - Theory, News & General
Topic: The Savings Rate Grid
Replies: 47
Views: 6694

Re: The Savings Rate Grid

Savings Rate --- 00%---- 15.60 Years to FI Savings Rate --- 10%---- 13.00 Savings Rate --- 20%---- 11.70 Savings Rate --- 30%---- 10.30 Savings Rate --- 40%----- 9.40 Snowjob, I don't see how you can get these numbers with the Networthify calculator referenced in willthrill81's first post . Assumin...
by #Cruncher
Fri May 25, 2018 3:44 pm
Forum: Personal Finance (Not Investing)
Topic: I need some math help-calculating interest savings
Replies: 31
Views: 1624

Re: I need some math help-calculating interest savings

Total interest reduction. 181320 - 95893.01 = 85426.99 I also get about $85,000 by comparing the total payments on the original loan terms against the total payments on the accelerated recast loan. To simplify and make all the numbers consistent I assume: 4.25% 30-year $235,200 loan Make two regula...
by #Cruncher
Tue May 22, 2018 8:05 am
Forum: Investing - Help with Personal Investments
Topic: Have Annuity Rates Gone Up?
Replies: 15
Views: 1740

Re: Have Annuity Rates Gone Up?

We can use the Excel PMT function to estimate what the effect of higher interest rates would be. For example, the following table shows the estimated payout over various years at 3% and 4%. The increase in payout ranges from 0.54% to 0.76% points depending on years. For comparison I've included toda...
by #Cruncher
Mon May 21, 2018 9:51 am
Forum: Investing - Theory, News & General
Topic: Discontinuity and marginal vs effective rates
Replies: 39
Views: 1886

Re: Discontinuity and marginal vs effective rates

Defining the SS Hump as the range of non-Social Security income subject to a marginal tax rate of 40.7% [*], the following table shows w[h]ere it lies for various amounts of SS benefit: … In my opinion, we need to be careful to let people know that there are two issues which will change this calcul...
by #Cruncher
Sun May 20, 2018 1:34 pm
Forum: Investing - Theory, News & General
Topic: Do I understand duration correctly?
Replies: 33
Views: 2635

Re: Do I understand duration correctly?

Take a bond fund with a duration of 5 in a rising interest rate environment. Year 1, interest rates increase by 1%. Bond fund should recover in 5 years. Year 2, interest rates increase by another 1%. Bond fund now requires 9 years to recover. It takes much less than nine years to "recover" after tw...
by #Cruncher
Sat May 19, 2018 10:45 pm
Forum: Investing - Theory, News & General
Topic: Discontinuity and marginal vs effective rates
Replies: 39
Views: 1886

Re: Discontinuity and marginal vs effective rates

Many will never encounter the [Social Security] Hump and others will blow past it in the blink of an eye with no means by which to avoid it. Others are in the middle and can efficiently plan for it. Defining the SS Hump as the range of non-Social Security income subject to a marginal tax rate of 40...
by #Cruncher
Fri May 18, 2018 9:01 am
Forum: Personal Finance (Not Investing)
Topic: When to claim Social Security: two reasons not to wait
Replies: 68
Views: 11949

Re: When to claim Social Security: two reasons not to wait

1. When I use cfiresim or firecalc, I get the same income (within 2%) whether I use age 62, 67, or 70 to start SS. This is for covering my wife and me until we're 110/105, ... I think what's happening is the earlier SS helps mitigate unfavorable sequences of return in my other retirement savings. G...
by #Cruncher
Wed May 16, 2018 12:15 pm
Forum: Personal Finance (Not Investing)
Topic: When to claim Social Security: two reasons not to wait
Replies: 68
Views: 11949

Re: When to claim Social Security: two reasons not to wait

(... I'm 64 and my wife is 63 this year. We are planning to both wait until 70 to start our benefits. ...) ... I would take a good look at the numbers ... Thanks. I have looked at the numbers several ways - with my wife starting benefits at 62, 66.4 (her FRA) and 70. My analysis and http://maximize...
by #Cruncher
Mon May 14, 2018 11:53 am
Forum: Personal Finance (Not Investing)
Topic: When to claim Social Security: two reasons not to wait
Replies: 68
Views: 11949

Re: When to claim Social Security: two reasons not to wait

So I started taking SS at 62 which was 6 years ago. Guess because of the market run up over that time, I've done OK. I'm happy I took it @62. :happy Whether taking early turns out better financially depends on future returns and longevity. The following table shows for given past and future returns...
by #Cruncher
Sat May 12, 2018 3:07 pm
Forum: Personal Finance (Not Investing)
Topic: When to claim Social Security: two reasons not to wait
Replies: 68
Views: 11949

Re: When to claim Social Security: two reasons not to wait

If you compare the full benefits for age 63 vs age 66, break even does not happen until age 77. When you consider the net benefits, how much did you get from the Federal Government after tax, break even happens at age 73 and 4 months, 42 months earlier! You're making two mistakes here, PapaGeek. Th...
by #Cruncher
Fri May 11, 2018 4:49 pm
Forum: Investing - Theory, News & General
Topic: TIPS yield curve
Replies: 14
Views: 2587

Re: TIPS yield curve

The following table shows my attempt to arrive at an estimate of what the real yield would be if TIPS were indexed according to the seasonally adjusted CPI. ...To create this spreadsheet: Select All, Copy, and Paste the following at cell A1 of a blank Excel sheet: ... Select All, Copy, and Paste th...
by #Cruncher
Tue May 08, 2018 12:23 pm
Forum: Personal Finance (Not Investing)
Topic: 100%, 75%, 50% Joint & Survivor?
Replies: 17
Views: 1724

Re: Which PERS Benefit Option would be best?

I'm glad to hear that we are on the right track with Option 6. ... I'm now trying to decide between 100%, 75% and 50% . If I understand your reply correctly, from a "purely financial" perspective, all three of these Joint and Survivor options are similar from a cost or present value standpoint? My ...
by #Cruncher
Mon May 07, 2018 10:22 pm
Forum: Personal Finance (Not Investing)
Topic: 100%, 75%, 50% Joint & Survivor?
Replies: 17
Views: 1724

Re: Which PERS Benefit Option would be best?

I ran five of the options through my longevity estimator and the present values (PV) of the survival-weighted payments came out about the same ($649,000 to $665,000) when discounted at 4%. These are for a 59 year old woman and 63 year old man both with mortality probabilities based on the SSA 1960 C...
by #Cruncher
Sat May 05, 2018 3:36 pm
Forum: Investing - Theory, News & General
Topic: TIPS yield curve
Replies: 14
Views: 2587

Re: TIPS yield curve

... it appears that there is no simple shortcut to avoid doing the seasonal adjustment calculations. Bummer. I thought I'd come up with a simple way to approximate the seasonally adjusted real yield. But then I ran a test with a 7/17/2017 settlemnt date and the simple method failed. So now I'm goin...