solution
solution.
We borrow $ 200,000.00 and want to pay our mortgage in 15 years. The annual interest rate is 6 percent.
Question 1. Build an influence diagram that represents how changes in annual interest rate and changes in loan amount affect monthly payment (at the end of the period). Given that the number of periods is unchanged.
Question 2. Use the Data Table technique in Excel to determine how changes in annual interest rate (from 6 percent through 12 percent in 3 percent increments) and changes in loan amount (from $ 200,000.00 through $ 240,000.00 in $ 10,000.00 increments) affect monthly payment (at the end of the period).
Note: An accurate specification of the three parameters in the Data Table Window is required.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
