Answered step by step
Verified Expert Solution
Question
1 Approved Answer
that should be the only information need its all thats provided 3. Change the model to reflect what you think your life will be like,
that should be the only information need its all thats provided
3. Change the model to reflect what you think your life will be like, given your present situation. Discuss some of the trade-offs you might make to reach your goals. Print out the graphs ( don't need your personal information.) On the graphs - always have a title above the graph, and your name and class, with section Graph lines should always have symbols, shown in the legend, as often the graph will be printed out in black and white. Always have the graph time and date stamped to keep your work in order On the spreadsheets - always have name and class with section, and homework assignment Always have gridlines (controlled in the Page Set Up on the Print page of Excel). This also controls printing of gridlines if you have a spreadsheet you are moving to Word) B 45 46 D -S40,000 $30,000 -$20,000 $10,000 Kids College Starts 32 33 34 35 36 37 38 39 40 41 E S122,861 $125,318 $127,825 $130,381 $132,989 $135,648 $139,361 $141,129 $143,951 $146,830 $149,767 $152,762 $155,817 $158,934 5162,112 $165,355 $168,562 5172,035 $175,476 $179,985 $182,565 $185,216 F 5460,221 $504,043 $550,645 $600,188 5652,841 5708,782 $768,201 $831,297 $898,280 $969,372 51,044,808 $1,124,835 $1,209,716 $1,299,724 $1,395,153 $1,496,310 51,603,518 $1,717,121 51,837,450 $1,964,978 52,100,017 $2,243,022 47 48 49 50 51 52 53 54 55 56 57 SS 59 60 61 62 63 64 65 66 G S250,000 $265,000 $280,000 $295,000 $310,000 $325,000 $340,000 $355,000 $370,000 $385,000 $400,000 5415,000 $430,000 5445,000 S460,000 $475,000 $490,000 $505.000 $520,000 $535,000 $550.000 $565,000 H $670,221 S739,043 $810,645 $885,188 $962,841 $1,033,782 $1,108,201 $1,156,297 $1,268,280 $1,354,372 51,444,808 $1,539,835 $1,639,716 $1,744,724 $1,855,153 $1,971,310 $2,093,518 $2,222,121 52.357.480 $2499,978 $2,650,017 $2.808,022 Kids College Ends 43 44 45 46 47 48 49 50 51 52 53 D A G F H 1 2 a 4 5 Inputs in Grey Ito 45 after 45 5.50N 14.00N Pension growth Savings Salary Increase 5.00 Salary Increase 2.00% Ber Salary $40,000 School Debt $20,000 Pension Fund to Salary 12.05 8 7 House Equity Leave College First Job 10 12 13 14 New Car Age 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Marry New Child 15 16 17 18 19 20 21 22 23 House Debt $20,000 -$10,000 $5,000 50 -$20,000 $15,000 -$10,000 $20,000 $ 20,000 $180,000 -$170,000 -$160,000 -$150,000 -5140,000 -$130,000 -$120,000 -5110,000 -3100,000 -590,000 S80,000 $70,000 560,000 -550.000 Salary $40,000 S42,000 $44,100 $46,305 $45,620 551,051 553,604 $56,284 $59,098 562,052 $65,156 563,414 $71,834 $75,426 $79,197 $83,157 $87,315 $91,681 595,255 5101,078 5106,112 5111,499 5117010 Pension $5,908 $12,436 $19,634 $27,553 $36,250 $45 784 556,219 567,624 $80,072 593,542 $108,415 $124 483 5141,939 S160,886 $181.433 $203,694 $227,793 $253,863 5282,044 5312456 5345, 246 $380,802 5419,028 Net Worth $14,092 $2,436 $14,634 $27,553 $16,250 $30,784 $46,219 $47,624 $50,072 546,358 56,565 $34 483 $75,939 $120,886 $166,433 $213,594 $262,793 $313,863 $367,044 $422.486 5450 340 $540,802 5604 028 New Child 25 26 27 28 29 30 32 540,000 $55,000 $70,000 $35,000 $100,000 $115,000 $130,000 $145,000 $160,000 $175,000 $190,000 $205,000 5220,000 $225,000 37 38 39 40 43 42 43 44 OR a 3. Change the model to reflect what you think your life will be like, given your present situation. Discuss some of the trade-offs you might make to reach your goals. Print out the graphs ( don't need your personal information.) On the graphs - always have a title above the graph, and your name and class, with section Graph lines should always have symbols, shown in the legend, as often the graph will be printed out in black and white. Always have the graph time and date stamped to keep your work in order On the spreadsheets - always have name and class with section, and homework assignment Always have gridlines (controlled in the Page Set Up on the Print page of Excel). This also controls printing of gridlines if you have a spreadsheet you are moving to Word) B 45 46 D -S40,000 $30,000 -$20,000 $10,000 Kids College Starts 32 33 34 35 36 37 38 39 40 41 E S122,861 $125,318 $127,825 $130,381 $132,989 $135,648 $139,361 $141,129 $143,951 $146,830 $149,767 $152,762 $155,817 $158,934 5162,112 $165,355 $168,562 5172,035 $175,476 $179,985 $182,565 $185,216 F 5460,221 $504,043 $550,645 $600,188 5652,841 5708,782 $768,201 $831,297 $898,280 $969,372 51,044,808 $1,124,835 $1,209,716 $1,299,724 $1,395,153 $1,496,310 51,603,518 $1,717,121 51,837,450 $1,964,978 52,100,017 $2,243,022 47 48 49 50 51 52 53 54 55 56 57 SS 59 60 61 62 63 64 65 66 G S250,000 $265,000 $280,000 $295,000 $310,000 $325,000 $340,000 $355,000 $370,000 $385,000 $400,000 5415,000 $430,000 5445,000 S460,000 $475,000 $490,000 $505.000 $520,000 $535,000 $550.000 $565,000 H $670,221 S739,043 $810,645 $885,188 $962,841 $1,033,782 $1,108,201 $1,156,297 $1,268,280 $1,354,372 51,444,808 $1,539,835 $1,639,716 $1,744,724 $1,855,153 $1,971,310 $2,093,518 $2,222,121 52.357.480 $2499,978 $2,650,017 $2.808,022 Kids College Ends 43 44 45 46 47 48 49 50 51 52 53 D A G F H 1 2 a 4 5 Inputs in Grey Ito 45 after 45 5.50N 14.00N Pension growth Savings Salary Increase 5.00 Salary Increase 2.00% Ber Salary $40,000 School Debt $20,000 Pension Fund to Salary 12.05 8 7 House Equity Leave College First Job 10 12 13 14 New Car Age 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Marry New Child 15 16 17 18 19 20 21 22 23 House Debt $20,000 -$10,000 $5,000 50 -$20,000 $15,000 -$10,000 $20,000 $ 20,000 $180,000 -$170,000 -$160,000 -$150,000 -5140,000 -$130,000 -$120,000 -5110,000 -3100,000 -590,000 S80,000 $70,000 560,000 -550.000 Salary $40,000 S42,000 $44,100 $46,305 $45,620 551,051 553,604 $56,284 $59,098 562,052 $65,156 563,414 $71,834 $75,426 $79,197 $83,157 $87,315 $91,681 595,255 5101,078 5106,112 5111,499 5117010 Pension $5,908 $12,436 $19,634 $27,553 $36,250 $45 784 556,219 567,624 $80,072 593,542 $108,415 $124 483 5141,939 S160,886 $181.433 $203,694 $227,793 $253,863 5282,044 5312456 5345, 246 $380,802 5419,028 Net Worth $14,092 $2,436 $14,634 $27,553 $16,250 $30,784 $46,219 $47,624 $50,072 546,358 56,565 $34 483 $75,939 $120,886 $166,433 $213,594 $262,793 $313,863 $367,044 $422.486 5450 340 $540,802 5604 028 New Child 25 26 27 28 29 30 32 540,000 $55,000 $70,000 $35,000 $100,000 $115,000 $130,000 $145,000 $160,000 $175,000 $190,000 $205,000 5220,000 $225,000 37 38 39 40 43 42 43 44 OR a Step 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