Give me step by steps instruction in which to solve this problem, and also the excat formula.

Account Shares Price Value Porfolio % A) Fill out Column H and indicate how many % of your total portolio is in each account. 10pts B) Create a DOUGHNUT Chart (pivot chart if you want) and show how much your portfolio is allocated to each category 10 points. Vanguard Rollover IRA Vanguard Rollover RA Vanguard Rollover IRA Vanguard Rollover RA Vanguard Rollover RA Vanguard Roth IRA Vanguard Roth IRA Vanguard Roth IRA Vanguard Roth IRA PCS 401K PCS 401K PCS 401K PCS 401K HSA Bank HSA Bank HSA Bank HSA Bank Symbol VTSAX VTIAX VBTLX VGSLX VTI VTSAX VTIAX VBMFX VGSIX VTSAX VTIAX VBTLX VGSLX VTI VEU BND VNQ Name Category Vanguard Total Stock Market Index Fund Admiral SUS Stocks Vanguard Total International Stock Index Fund Ador International Stocks Vanguard Total Bond Market Index Fund Admiral Si Bonds Vanguard Real Estate Index Fund Admiral Shares Alternatives Vanguard Total Stock Market Index Fund ETF US Stocks Vanguard Total Stock Market Index Fund Admiral SUS Stocks Vanguard Total International Stock Index Fund Adrr International Stocks Vanguard Total Bond Market Index Fund Investor S Bonds Vanguard Real Estate Index Fund Investor Shares Alternatives Vanguard Total Stock Market Index Fund Admiral SUS Stocks Vanguard Total International Stock Index Fund Adrr International Stocks Vanguard Total Bond Market Index Fund Admiral Si Bonds Vanguard Real Estate Index Fund Admiral Shares Alternatives Vanguard Total Stock Market Index Fund ETF US Stocks Vanguard FTSE All World ex US ETF International Stocks Vanguard Total Bond Market Index Fund ETF Bonds Vanguard Real Estate Index Fund ETF Alternatives 3,000.00 1,800.00 2,000.00 200 200 2,000.00 1,400.00 1,300.00 500 700 300 400 40 150 80 20 25 105.77 $317,310.00 35.44 $63,792.00 11.25 $22,500.00 141.05 $28,210.00 217.32 $43,464.00 105.77 $211,540.00 35.44 $49,616.00 11.25 $14,625.00 33.07 $16,535.00 105.77 $74,039.00 35.44 $10,632.00 11.25 $4,500.00 141.05 $5,642.00 217.32 $32,598.00 63.86 $5,108.80 85.39 $1,707.80 99.51 $2,487.75