Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Car Loans You are provided the following screenshot of a car loan model. Consider the 'Interest rates' vs 'Terms (months)' scenarios in the model. Assume
Car Loans You are provided the following screenshot of a car loan model. Consider the 'Interest rates' vs 'Terms (months)' scenarios in the model. Assume that Excel's 'Data Table tool is used. 20000 60 Terms (months) Loan Amount Term (months) Interest Rate Payment ($333.33) 36 48 60 72 5.5% -$603.92-$465.13 $382.02 -$326.76 6.0% $608.44 $469.70 $386.66 $331.46 6.5% $612.98 -$474.30 $391.32 $336.20 7.0% $617.54 $478.92 -$396.02 $340.98 7.5% -$622.12 $483.58 -$400.76 -$345.80 8.0% $626.73 -$488.26 $405,52 Results (monthly payments) Interest rates The text 'Loan Amount' is entered in cell A1. In the Data Table, the scenarios being generated use two inputs: interest rate (cell B3) and term (cell B2). The output is the monthly payment (cell B4). Question 5 (1 point) What should be entered in the 'Row input cell' field of the Data Table dialogue box? $B$2 $B$5:$B$10 $B$3 $C$4:$F$4 Question 6 (1 point) What array formula exists in cells (C5] to (F10]? OX=TABLE(B2,B3)} {=ARRAY(C4:F4)} {=TABLE(B5,C4)} {=TABLE(C4,B5)}
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