Question: Pls answer 6-8. Dont use the pervious chart for that the questions use this ine instead. the information the wuestion is talking sbout is the

6. SAVING at 5\%: Using your answer from Question #4, Provide Table by filling in highlighted cells. How much will you have saved in 5 years if you save 20% of your discretionary spending? How much will you have saved in 50 years if you save 100% of your discretionary spending? What's the difference? Why is it so big? 7. SAVING at 10\%: Using your answer from Question #4, Provide Table by filling in highlighted cells. How-much will you have saved in 5 years if you save 20% of your discretionary spending? How much will you have saved in 50 years if you save 100% of your discretionary spending? What's the difference? Is this difference bigger or smaller than the difference calculated in Question #6? Why? Is this table encouraging or discouraging? Why? 8. DURING CAREER: Suppose that during your career you saved 20% of your $10,000 monthly paycheck (i.e. assume $2,000 of monthly discretionary income in Excel). Suppose you also invested your money at 9% (i.e. assume a 9% interest rate). Provide Table by filling in highlighted cells. How long would it take you to become a millionaire based on your savings? What about if you only saved $1,000 at 6% ? is either plan doable? Why or why not? Monthly Interest Rate Annual Interest Rate (APR) Total Amount of Monthly Discretionary Income: 6. SAVING at 5\%: Using your answer from Question #4, Provide Table by filling in highlighted cells. How much will you have saved in 5 years if you save 20% of your discretionary spending? How much will you have saved in 50 years if you save 100% of your discretionary spending? What's the difference? Why is it so big? 7. SAVING at 10\%: Using your answer from Question #4, Provide Table by filling in highlighted cells. How-much will you have saved in 5 years if you save 20% of your discretionary spending? How much will you have saved in 50 years if you save 100% of your discretionary spending? What's the difference? Is this difference bigger or smaller than the difference calculated in Question #6? Why? Is this table encouraging or discouraging? Why? 8. DURING CAREER: Suppose that during your career you saved 20% of your $10,000 monthly paycheck (i.e. assume $2,000 of monthly discretionary income in Excel). Suppose you also invested your money at 9% (i.e. assume a 9% interest rate). Provide Table by filling in highlighted cells. How long would it take you to become a millionaire based on your savings? What about if you only saved $1,000 at 6% ? is either plan doable? Why or why not? Monthly Interest Rate Annual Interest Rate (APR) Total Amount of Monthly Discretionary Income
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
