Question: please show work on excel and regular paper formulas. Q1 Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep

please show work on excel and regular paper formulas.
please show work on excel and regular paper formulas. Q1 Portfolio Rebalancing

Q1 Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter. i. 60% in stocks via ETF SPY; i 35% in bonds via ETF TUT. iii. 5% in cash Over the month of Sep. SPY went from $452 to 5429, and TLT went from $149 per share to $144 per share. Cash has an interest rate of 0.1% annually a. What is your overall account balance before rebalancing? What proportion of that is in SPY, TLT, and CASH respectively? (5 points) b. How do you rebalance your account to keep the allocation at 60-35-5 for SPY TLT and cash respectively? What to buy and what to sell in dollar amour (5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Q1. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 60% in stocks via...

Q:

Q1. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 50% in stocks via...

Q:

In this problem, if cash were 0.1% annually INSTEAD of zero interest rate would you then do $20,000,000 * 0.10%= $20000, and that would be the input for Account $ balance before rebalancing? so like...

Q:

In this problem, if cash were 0.1% annually INSTEAD of zero interest rate would you then do $20,000,000 * 0.10%= $20000, and that would be the input for Account $ balance before rebalancing? so like...

Q:

For this problem how would it be different if cash had an interest rate of 0.1% annually, instead of zero interest rate? Q1. Portfolio Rebalancing You have 100 million dollars in your investment...

Q:

Q1. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 60% in stocks via...

Q:

Q1. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 60% in stocks via...

Q:

Q1. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 60% in stocks via...

Q:

Q1. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 60% in stocks via...

Q:

STAPLES NO 2 01. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: 1. 50%...

Q:

Q3: Design a Pseudocode to insert a node in the middle of singly linked list.

Q:

Twelve points are placed on the circumference of a circle and all the chords connecting these points are drawn. What is the largest number of points of intersection for these chords?

Q:

CAPM and Valuation You are considering acquiring a firm that you believe can generate expected free cash flows of 1 0 0 0 0 a year forever However you recognize that those cash flows are uncertain LO...

Q:

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...