What is the effect of a change in the interest rate from 8% to 10% in the spreadsheet model shown in Figure A? For the original model in Figure A, what interest rate is required to decrease the monthly payments by 20%? What change in the loan amount would have the same effect?
Discuss how does the prescriptive analytics relate to descriptive and predictive analytics? Give one example for each. Note: Answers must be in your own words. Create the spreadsheet models shown in below images and answer the following questions. What is the effect of a change in the interest rate from 8% to 10% in the […]