ADMIN 410 UNH Management Information Systems Loan Option Analysis Excel Project Requirements For Part 2:Sports Plus is a sporting goods retail store. They

ADMIN 410 UNH Management Information Systems Loan Option Analysis Excel Project Requirements For Part 2:Sports Plus is a sporting goods retail store. They want to use Excel
to help them decide the best way to fund a major building expansion.
They have found two banks that will lend them the money for the
expansion. The terms from each bank are listed in the start file.Calculate the monthly payment amount and the total amount of
interest paid for each option in the green cells. Be sure the amounts in
the calculated cells will change if the input values change. (Notes:
For the terms offered by Bank 1, you must consider that the 0% Down
Payment is an input and may change, so it should be included in the
subsequent calculations of the monthly payment and total interest paid.
Also, be sure that the Bank 1 Annual Interest Rate is 3.5% and the Bank
2 Annual Interest Rate is 4.0%)For the terms offered by Bank 1 complete the one-variable data table
to show the impact of changes in the Down Payment on the Monthly
Payment.For the terms offered by Bank 2 complete the two-variable data table
to show the sensitivity of the total interest paid amount to changes in
interest rates and changes in loan terms. Format the results of the
two-variable data table to currency and round to the nearest dollar.Assume Sports Plus can negotiate the interest rate from Bank 2. What
interest rate should they request to make the total interest paid in
the loan from Bank 2 equal to the total interest paid in the loan from
Bank 1? A
C
D
E
F
G
H
I
Sports Plus
Loan Option Analysis
Bank 1
Loan Amount
Down Payment
Annual Interest Rate
Term of Loan (in years)
Number of payments per year
$250,000
0%
3.5%
7
12
Bank 1
Sensitivity of the Monthly
Payment to changes in the
Down Payment
0%
5%
10%
15%
20%
Monthly Payment
Total Interest Paid
Total Payment
Bank 2
Loan Amount
Down Payment
Annual Interest Rate
Term of Loan (in years)
Number of payments per year
$
200,000
5%
4.0%
10
12
Monthly Payment
Total Interest Paid
Total Payment
Bank 2
Sensitivity of the Total Interest Paid to Changes in Interest Rate and Loan Term
Term of Loan (in years)
4
5
6
7
8
9
Interest Rate
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
B
3.00%
3.25%
3.50%
3.75%
4.00%
4.25%
4.50%
4.75%
5.00%
5.25%
5.50%
10

Purchase answer to see full
attachment