Scenario Principal borrowed Monthly rate Number of monthly payments 0.30% 360 Lowest Principal Likely Principal Highest Principal $200,000 $350,000 0.50% 240 $450,000 0.60% 180 1 You may want to use the PMT function in your solution. Please ensure all cell references in the scenario summary are labelled appropriately (use range names) else points will be deducted. The preliminary set-up of this problem needs to be on worksheet 'Question 3' The worksheet containing your scenario summary will have its default title 'Scenario Summary'. Principal borrowed Monthly rate Number of monthly payments 0.30% 360 1 Scenario 2 Lowest Principal 3 Likely Principal 4 Highest Principal 5 $200,000 $350,000 $450,000 0.50% 240 0.60% 180