Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me fill out these two charts just need the excel formula if you need more data please let me know (you can zoom
Please help me fill out these two charts just need the excel formula if you need more data please let me know
(you can zoom in to read the data)
TOTAL - PORTFOLIO MODEL (TAXABLE ACCOUNT) *** QUARTERLY-COMPOUNDING: 15.0% 100 115 15.0% 15.0% 74.9% 115 132 15.0% 32.3% 50% 132 152 15.0% 52.1% Quarterly-Trading Growth Rate @ (3X ETFs) Annual Growth Rate @ Margin Rate @ Marginal Tax Rate @ Annual Contribution @ QUARTER-ANNUAL-TRADING MODEL DATE: 4/28/21 29% 152 175 15.0% 74.9% $20,000 60.0% Year Age BOY EQUITY BALANCE CUMULATIVE DEPOSIT BALANCE BOY MARGIN BALANCE AMOUNT BORROW EOY ACCOUNT BALANCE ANNUAL GAIN TAX AMOUNT EOY A/T EQUITY BALANCE A/T ANNUAL GAIN A/T ANNUAL GAIN % A/T CUMULATIVE GAIN A/T CUMULATIVE GAIN % 0 23 20,000 20,000 30,000 10,000 52,470 22,470 6,516 45,954 15,954 79.8% 15,954 79.8% 1 24 FAMILY SPENDING ACCOUNT - PORTFOLIO MODEL (TAXABLE) *** QUARTERLY-COMPOUNDING: 10.0% 100 110 10.0% 10.0% 46.4% 110 121 10.0% 21.0% Quarterly-Trading Growth Rate @ (3X ETFs) Annual Growth Rate @ Margin Rate @ Marginal Tax Rate @ One-Time Contribution @ 50% 121 133 10.0% 33.1% 29% 133 146 10.0% 46.4% $1,000,000 40.0% $20,000 15% Annual Contribution @ Annual Distribution @ EOY Balance QUARTER-ANNUAL-TRADING MODEL DATE: 4/28/21 Year Age BOY EQUITY BALANCE CUMULATIVE ADDITIONS BOY MARGIN BALANCE AMOUNT BORROW EOY B/T NET BALANCE ANNUAL GAIN TAX AMOUNT EOY A/T EOY ANNUAL EOY A/T NET BALANCE DISTRIBUTION NET BALANCE ANNUAL NET GAIN ANNUAL NET GAIN % CUMULATIVE NET GAIN CUMULATIV NET GAIN 0 23 1,000,000 1,000,000 1,500,000 500,000 1,696,150 696,150 201,884 1,494,267 224,140 1,270,127 270,127 27.0% 270,127 27.0% 1 24 TOTAL - PORTFOLIO MODEL (TAXABLE ACCOUNT) *** QUARTERLY-COMPOUNDING: 15.0% 100 115 15.0% 15.0% 74.9% 115 132 15.0% 32.3% 50% 132 152 15.0% 52.1% Quarterly-Trading Growth Rate @ (3X ETFs) Annual Growth Rate @ Margin Rate @ Marginal Tax Rate @ Annual Contribution @ QUARTER-ANNUAL-TRADING MODEL DATE: 4/28/21 29% 152 175 15.0% 74.9% $20,000 60.0% Year Age BOY EQUITY BALANCE CUMULATIVE DEPOSIT BALANCE BOY MARGIN BALANCE AMOUNT BORROW EOY ACCOUNT BALANCE ANNUAL GAIN TAX AMOUNT EOY A/T EQUITY BALANCE A/T ANNUAL GAIN A/T ANNUAL GAIN % A/T CUMULATIVE GAIN A/T CUMULATIVE GAIN % 0 23 20,000 20,000 30,000 10,000 52,470 22,470 6,516 45,954 15,954 79.8% 15,954 79.8% 1 24 FAMILY SPENDING ACCOUNT - PORTFOLIO MODEL (TAXABLE) *** QUARTERLY-COMPOUNDING: 10.0% 100 110 10.0% 10.0% 46.4% 110 121 10.0% 21.0% Quarterly-Trading Growth Rate @ (3X ETFs) Annual Growth Rate @ Margin Rate @ Marginal Tax Rate @ One-Time Contribution @ 50% 121 133 10.0% 33.1% 29% 133 146 10.0% 46.4% $1,000,000 40.0% $20,000 15% Annual Contribution @ Annual Distribution @ EOY Balance QUARTER-ANNUAL-TRADING MODEL DATE: 4/28/21 Year Age BOY EQUITY BALANCE CUMULATIVE ADDITIONS BOY MARGIN BALANCE AMOUNT BORROW EOY B/T NET BALANCE ANNUAL GAIN TAX AMOUNT EOY A/T EOY ANNUAL EOY A/T NET BALANCE DISTRIBUTION NET BALANCE ANNUAL NET GAIN ANNUAL NET GAIN % CUMULATIVE NET GAIN CUMULATIV NET GAIN 0 23 1,000,000 1,000,000 1,500,000 500,000 1,696,150 696,150 201,884 1,494,267 224,140 1,270,127 270,127 27.0% 270,127 27.0% 1 24Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started