Swamped with your writing assignments? Take the weight off your shoulder!
With an initial balance of $1,000,000 on September 30, 2019, which was invested in the “All Weather” portfolio on the first trading day of October 2019 (per Excel Part I), rebalance the portfolio with the following procedure: a. Rebalance the “All Weather” portfolio annually, on the first trading day of October 2020 and October 2021, using the ETFs’ respective opening prices and initial weights while concurrently calculating the daily balance for the “All Weather” portfolio using daily closing prices (NOT adjusted prices). Do provide the number of shares needed for each ETF (need not round up/down; use four decimal places) on each rebalancing date. Construct a chart, containing the daily fund balance of the “All Weather” portfolio and SPY, for the whole sample period from September 30, 2019 to September 30, 2022. This chart is to be used in the report component.