Answer these questions with formulas
C17
fx
D
Goal Seek Problems
=10xA36.8
1,5000 0.7500 3,0000 4.0000 5.0000
Use Goal Seek to find the value of X that makes Y equal to 280. Use Goal Seek to find the value of X that makes Y equal to 84.
Use Goal Seek to find the value of X that makes Y equal to 31.39. Use Goal Seek to find the value of X that makes Y equal to -50. Use Goal Seek to find the value of X that makes Y equal to 0.
Family income and Savings Average income 12 Number of worker in the Family
Combined income
$35,000.00
Enter a function to calculate the Combined Income for this family.
Average income
Combined income
per family member in A16 to establish the combined income goal of $22000.00.
88,000
17
18 Number
Average income
Enter a function then use Goal Seek to find the number of family members needed if everyone earns $50,000 to meet the goal of $225,000 as the combined income.
$50,000.00
21 Save for Retirement
23 Annual Rate of Return
7%
Exercise
Ready Accessibility Good to go
12
V
C17
|x v fx
Save for Retirement 22 Your goal is to save $1,000,000 for retirement. You do so in a savings account with a fixed annual Interest rate, compounded monthly 23 Annual Rate of Return 7% 24 Monthly deposit this value gets determined by Goal Seek 25 Years to retirement 26 Payments per year 27 Total value after 35 years Use goal seek to determine the monthly deposit over a 35 year period at 7% APR to save a million dollars for retirement 22 30 Instruction table Point Points Earned Use the Goal Seek function to find
Check
Lock
B16 value from Goal Seek 39 A18 value from Goal Seek Use FV function in 827 B24 value from Goal Seek 42 Penalty Points 43 Did not format values correctly
Your Grade
44 places 45 Other