You can use and data you have to answer the question.
That is the data or you can use any data
User Interface Design using VBA This homework is to design the user interface for the Mortgage Amortization schedule project you did two weeks ago. In specific, create a two-button user interface that performs the following 1. A Button control that clears the input section of the project and gets a new set of input data from the users one at a time using inputBox). 2. A Button control that displays the Principal payments Vs. Interest Payments chart as shown below. You may record a macro that inserts the chart and assign it to this Button control 1 K 2 Total Cost of House 3 Down Payment 4 Amount of Mortgage loan 5 Interest Rate (ARPI 6 Time in Years 2 & Monthly Payment 9 Total Amount of Morte Loan 10 Interest Paid 11 B D Mortgage Amortization Schedule $ 500,000.00 $ 100,000.00 $ 400,000.00 3.25% 30 $ 1,740.83 $ 626,697.10 $ 226,697 10 Month 12 13 1 2 3 4 15 16 17 16 19 20 2 22 6 2 8 9 10 Monthly Beginning Mortgage Monthly Monthly Ending Balance Interest Payment Principal Balance 5 400.000,00 1,740 13 S 1,083.13 657495399,342 51 $ 199,34251 1,740.83 1,08155 659 27 59.683.24 $1963.24 1,74033 1,079.775 661.065398,022.18 S 198,022 18 1.7401 662,855397,359.13 $ 197,359,335 1.74083 1.076 15 S 664 645 196,69168 $ 396,601665 1.740.83 1.07.18 $ 666.445 396.028.24 $196,028.24 5 1.740835 1,072.58 668.25 $395.159.99 5 395.159.99 $ 1.740835 1,070775 670.06 5394,689.93 $ 194,689.91 1.740835 1.068.955 67187 5194018 06 $ 394,018.065 1.740.81 $ 1,067.13 $ 673.69 $393 344 17 $ 193,544.375 1.740.33 $ 1,055.115 675.52 $ 192,668 85 $ 392,66 RSS 1.740335 1,06345 67735 5391991.50 5 391.991.50 1.74033 S 1.061.645 679 18 S 19131232 5 391,312.125 1,740 335 1.059.805 681.02 $390,631 10 $ 130/631105 1.740335 1.057.96 682.87 $39.948.43 $ 389,4 415 1.740 335 1,056 115 5841189.261.72 24 25 12 27 28 16 Sheet1 User Interface Design using VBA This homework is to design the user interface for the Mortgage Amortization schedule project you did two weeks ago. In specific create a two-button user interface that performs the following 1. A Button control that clears the input section of the project and gets a new set of input data from the users one at a time using InputBoxO. 2. A Button control that displays the Principal payments Vs. Interest Payments chart as shown below. You may record a macro that inserts the chart and assign it to this Button control User Interface Design using VBA This homework is to design the user interface for the Mortgage Amortization schedule project you did two weeks ago. In specific, create a two-button user interface that performs the following 1. A Button control that clears the input section of the project and gets a new set of input data from the users one at a time using inputBox). 2. A Button control that displays the Principal payments Vs. Interest Payments chart as shown below. You may record a macro that inserts the chart and assign it to this Button control 1 K 2 Total Cost of House 3 Down Payment 4 Amount of Mortgage loan 5 Interest Rate (ARPI 6 Time in Years 2 & Monthly Payment 9 Total Amount of Morte Loan 10 Interest Paid 11 B D Mortgage Amortization Schedule $ 500,000.00 $ 100,000.00 $ 400,000.00 3.25% 30 $ 1,740.83 $ 626,697.10 $ 226,697 10 Month 12 13 1 2 3 4 15 16 17 16 19 20 2 22 6 2 8 9 10 Monthly Beginning Mortgage Monthly Monthly Ending Balance Interest Payment Principal Balance 5 400.000,00 1,740 13 S 1,083.13 657495399,342 51 $ 199,34251 1,740.83 1,08155 659 27 59.683.24 $1963.24 1,74033 1,079.775 661.065398,022.18 S 198,022 18 1.7401 662,855397,359.13 $ 197,359,335 1.74083 1.076 15 S 664 645 196,69168 $ 396,601665 1.740.83 1.07.18 $ 666.445 396.028.24 $196,028.24 5 1.740835 1,072.58 668.25 $395.159.99 5 395.159.99 $ 1.740835 1,070775 670.06 5394,689.93 $ 194,689.91 1.740835 1.068.955 67187 5194018 06 $ 394,018.065 1.740.81 $ 1,067.13 $ 673.69 $393 344 17 $ 193,544.375 1.740.33 $ 1,055.115 675.52 $ 192,668 85 $ 392,66 RSS 1.740335 1,06345 67735 5391991.50 5 391.991.50 1.74033 S 1.061.645 679 18 S 19131232 5 391,312.125 1,740 335 1.059.805 681.02 $390,631 10 $ 130/631105 1.740335 1.057.96 682.87 $39.948.43 $ 389,4 415 1.740 335 1,056 115 5841189.261.72 24 25 12 27 28 16 Sheet1 User Interface Design using VBA This homework is to design the user interface for the Mortgage Amortization schedule project you did two weeks ago. In specific create a two-button user interface that performs the following 1. A Button control that clears the input section of the project and gets a new set of input data from the users one at a time using InputBoxO. 2. A Button control that displays the Principal payments Vs. Interest Payments chart as shown below. You may record a macro that inserts the chart and assign it to this Button control
