H Input Area One-Variable Data Table: APR Two-Variable Data Table: APR and Cost of Home Cost of home $150,000.01 Calculated Results for Each APR Monthly Payment by Cost/APR Down Payment 9,993.34 APR Payment Total Repaid Total Interest APR $150,000.00 $175,000.00 $200,000.00 APP 5.96% 4.00% No. Years for Loan 20 4.25% Payments Per Year 12 4.50% 4.75% Output Area 5.009 Amount of Loan 5.25% Periodic Rate 5.50% No. Payment Periods 5.75% Monthly Payment 6.00% Total to Repay Loan 6.25% Total Interest Paid 6.50% 6.75% 7.00% 7.25% 7.50% 7.75% 8.00% Requirement: 1. Name the range based on requirement from cell 01:P6 2. Calculate the Output Area 3. For Monthly payment, use function: PMT 4. Fill the APR on One-Variablata Table. Start APR is 4% with step value 0.5% and stop value 8% Use What-if Analysis to insert the value on One-Variable Data Table HINT: One Row 3, you need to change the value as: Payment = B12, Total Repaid = B13, Total Interest = B14 5. Fill the Two-Variable Data Table Use What-if Analysis HINT: Replace the APR in Cell 13 with cell B12Calculation N P Q R Range Names Location Amount_of_Loan ='Home Loan"!$859 Down_Payment ='Home Loan"!$8$3 No._Payment_Periods ='Home Loan'!$8511 Periodic_Rate ='Home Loan'!$8$10 Purchase_Price ='Home Loan'!$8$2