Rebalancing Belushi Professor Belushi has a retirement account with Vanguard with assets of $360,809.37, allocated as...

Rebalancing Belushi

Professor Belushi has a retirement account with Vanguard with assets of $360,809.37, allocated as shown in Table 1.

He’s decided to rebalance his portfolio, so that looks like the allocation in Table 2. For example, he wants to sell his shares of the Europe Index Fund and buy shares of the Mid-Cap Index Fund.

Belushi is on the Vanguard web site and about to place fund-to-fund trade orders, when he reads the following notice:

“Vanguard has a policy restricting index fund exchanges. If you sell or exchange shares of an index fund, you won't be able to exchange back into that fund for 60 days.”

What is a feasible set of trades that will accomplish Belushi’s rebalancing?

Table 1: Current Allocation

Fund Number	0079	0072	0040	0028	0009	0024	0048	0081
Symbol	VEURX	VPACX	VFINX	VWESX	VIGRX	VEXPX	NAESX	VWIGX
Fund Name	Europe	Pacific	USA	Bonds	Growth	Explorer	Small-Cap	International
Allocation (%)	8.8%	17.4%	5.8%	13.1%	4.2%	13.1%	17.5%	20.1%

Table 2: Desired Allocation

Fund Number	0072	0040	0009	0081	0859	0123	0051
Symbol	VPACX	VFINX	VIGRX	VWIGX	VIMSX	VGSIX	VGENX
Fund Name	Pacific	USA	Growth	International	Mid-Cap	REIT	Energy
Allocation (%)	15.0%	15.0%	10.0%	15.0%	15.0%	15.0%	15.0%

Hint: Please use Solver function in Excel. This is the homework for Excel Modelling class

Solutions

Expert Solution

Table 1: Current Allocation
Fund Number	79	72	40	28	9	24	48	81
Symbol	VEURX	VPACX	VFINX	VWESX	VIGRX	VEXPX	NAESX	VWIGX
Fund Name	Europe	Pacific	USA	Bonds	Growth	Explorer	Small-Cap	International
Allocation (%)	8.80%	17.40%	5.80%	13.10%	4.20%	13.10%	17.50%	20.10%
	31751.22	62780.83	20926.94	47266.03	15153.99	47266.03	63141.64	72522.68	360809.37
Buy/sell	0.00	-8659.42	33194.46	0.00	20926.94	0.00	0.00	-18401.28

Table 2: Desired Allocation
Fund Number	72	40	9	81	859	123	51
Symbol	VPACX	VFINX	VIGRX	VWIGX	VIMSX	VGSIX	VGENX
Fund Name	Pacific	USA	Growth	International	Mid-Cap	REIT	Energy
Allocation (%)	15.00%	15.00%	10.00%	15.00%	15.00%	15.00%	15.00%
	54121.41	54121.41	36080.94	54121.41	54121.41	54121.41	54121.41	360809.37

Final	72	40	9	81	859	123	51
	VPACX	VFINX	VIGRX	VWIGX	VIMSX	VGSIX	VGENX
	Pacific	USA	Growth	International	Mid-Cap	REIT	Energy
	15.00%	15.00%	10.00%	15.00%	15.00%	15.00%	15.00%
	62780.83	20926.94	15153.99	72522.68	54121.41	54121.41	54121.41
	54121.41	54121.41	36080.94	54121.41	54121.41	54121.41	54121.41

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

Your finance professor is constantly harping on at you to start a retirement account. As a...

Your finance professor is constantly harping on at you to start a retirement account. As a result, you have just made your first $5,400 contribution to your company's retirement plan. Assume you earn an annual return of 13 percent and make no additional contributions to the plan. 2 part question What will your retirement plan be worth when you retire in 41 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) What...

Suppose that your retirement account has reached a value of $565,651

Suppose that your retirement account has reached a value of $565,651 at age 60. If you let the funds remain invested an EAR of 6.7% until age 65, and do not make further contributions, how much can you receive annually in perpetuity (at the end of the year) starting at end of the year at age 65?

Professor White, having reached the statutory retirement age, has retired and has been paid been paid...

Professor White, having reached the statutory retirement age, has retired and has been paid been paid his lump sum benefit of ₵200,000. The professor has no immediate need for the amount received and he is considering investing the amount in KK Motors Ltd, one of the top-performing stocks on the Ghana Stock Exchange. The stock under consideration has an expected return of 20% and a volatility of 12%. Suppose the risk-free rate is 15%, and the market portfolio has an...

For VFINX (Vanguard 500 Index Fund), what is its assets under management (AUM)?

please write a short analysisFor VFINX (Vanguard 500 Index Fund), what is its assets under management (AUM)?

An individual retirement account (IRA) has $10,000 in it, and the owner decides not to add...

An individual retirement account (IRA) has $10,000 in it, and the owner decides not to add any more money to the account other than interest earned at 7% compounded daily. How much will be in the account 34 years from now when the owner reaches retirement age ? Use a 365-day year.

Tanner is going to retire tomorrow. He has $1,600,000 in his retirement account. His account earns...

Tanner is going to retire tomorrow. He has $1,600,000 in his retirement account. His account earns 6.00% annually. He wants to make an annual withdrawal of $150,000 from the account. How many years will he be able to make this same withdrawal before the fund runs out of money? 30 years (approx) 22 years (approx) 17.5 years (approx) 27.3 years (approx)

An Individual Retirement Account (IRA) is an annuity that is set up to save for retirement....

An Individual Retirement Account (IRA) is an annuity that is set up to save for retirement. IRAs differ from TDAs in that an IRA allows the participant to contribute money whenever he or she wants, whereas a TDA requires the participant to have a specific amount deducted from each of his or her paychecks. When Shannon Pegnim was 14, she got an after-school job at a local pet shop. Her parents told her that if she put some of her...

Bonnie has decided to begin a retirement savings program whereshe will contribute to an account...

Bonnie has decided to begin a retirement savings program where she will contribute to an account that will accumulate tax free throughout her working life. She expects to retire in exactly 9 years from today, and her goal is to have accumulated the amount of $600000 when she reaches her future retirement age. In order to meet her goal, she will begin making MONTHLY contributions to a special account devoted to the retirement goal. Contributions to this account will begin...

Bonnie has decided to begin a retirement savings program whereshe will contribute to an account...

Bonnie has decided to begin a retirement savings program where she will contribute to an account that will accumulate tax free throughout her working life. She expects to retire in exactly9 years from today, and her goal is to have accumulated the amount of $600000 when she reaches her future retirement age.In order to meet her goal, she will begin making MONTHLY contributions to a special account devoted to the retirement goal. Contributions to this account will begin one month...

Your friend currently has $20,000 in an IRA (Individual Retirement Account) and estimate that it will...

Your friend currently has $20,000 in an IRA (Individual Retirement Account) and estimate that it will earn 6%/year. She is now 30 years old and plans to retire when she is 65 years old. If she wants $1,000,000 in the account in 35 years, how much more does she have to deposit every year to have the $1,000,000 total?

Subjects