21 N > Comments Share Clear Sort Filter Reapply Advanced Flash Fill Remove Duplicates Consolidate Data Analysis Relationships Text to Columns Data Validation Manage Data Model What-If Forecast Analysis Sheet Group Ungroup Subtotal ?, Solver Sort & Filter Data Tools Forecast Outline Analyze C D E F G H I J K L M N P Q R S T U V W X Y Z File Home Insert Page Layout Formulas Data From Text/CSV Recent Sources Review View Automate Help Queries & Connections From Web Existing Connections Properties Get Data From Table/Range Refresh All Stocks Currencies Geography Get & Transform Data Workbook Links Queries & Connections Data Types C16 A X fx Riverwalk Clinic 2 Annual Interest Rate 3 Term in Months 4 Loan Amount 5 Monthly Payment 11 12345678902222 B 5.25% 360 $ 1,360,785 $7,514.31 Instructions: Using the Solver add-in tool, determine the following: If you wanted a Monthly Payment of $5250 and the Annual Interest Rate and Term in Months could be modified but the Annual Interest Rate must equal 2% or higher 14 and the Term in Months is less than or equal to 720 15 What would the following optimal values be: 16 17 Annual Interest Rate: Term in Months: 18 File Home Insert Page Layout Formulas Data From Text/CSV Recent Sources Review View Automate Help Queries & Connections From Web Existing Connections Properties Get Data x From Table/Range Refresh All Stocks Currencies Geography Workbook Links Queries & Connections Data Types < KN N Clear Reapply Sort Filter Advanced Text to Columns Sort & Filter Comments Share Flash Fill Remove Duplicates Data Validation Consolidate Data Analysis Relationships Manage Data Model What-If Forecast Analysis Sheet Group Ungroup Subtotal ?, Solver Data Tools Forecast Outline Analyze 49.999676635934 B D E F G H J K L M N 1 C12 A Get & Transform Data X fx Auto Loan 2 Annual Interest Rate 3 Term in Months 4 Loan Amount 5 Monthly Payment 6 7 8 9 Instructions: 10 11 12 13 14 5.25% $ 31,300 $698.33 Using the What-If Analysis -> Goal Seek tool, determine the following: 1. If the Monthly Payment was $698.33, how many months is the term? Round up... Term in Months: 50 P Q R S T U V W X Y File Home Insert Page Layout Formulas Data From Text/CSV Recent Sources Review View Automate Help Queries & Connections From Web Existing Connections Properties Get Data From Table/Range Refresh All Stocks Currencies Geography Workbook Links Queries & Connections Data Types D16 Get & Transform Data X fx A B C D E F G H Auto Loan 2 Annual Interest Rate 3 Term in Months 4 Loan Amount 5 Monthly Payment 4.75% $ 31,300 $800.00 12 13 14 15 16 +2345678 DECE 9 Instructions: 10 11 17 10 Using the What-If Analysis -> Goal Seek tool, determine the following: 1. What Interest Rate would you need to have a $800 payment? Interest Rate: 42.593 4 KN N Comments Share Sort Filter Clear Reapply Advanced Text to Flash Fill Remove Duplicates Consolidate Data Analysis Relationships ?, Solver Columns Data Validation Manage Data Model What-If Forecast Analysis Sheet Group Ungroup Subtotal Sort & Filter Data Tools Forecast Outline F Analyze J K L M N P Q R S U V W X Y