Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribedimage text in transcribed

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 24

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments Analysis And Management

Authors: Charles Jones, Nick Jones

11th Edition

0470477121, 9780470477120

More Books

Students also viewed these Finance questions