(solution) ………………………………………………..due 10/10

(solution) ………………………………………………..due 10/10

………………………………………………..due 10/10 10 pm

Loan Option 1
Loan Amount
Monthly Payment Loan Option 2
Loan Amount $30,000 Monthly Payment $460 Annual Rate (APR)
Total Payments
(NPER) Annual Rate (APR)
Total Payments
(NPER) 84 Total Interest Total Interest Total Cost of Loan Total Cost of Loan Amortization Schedule
Period
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20 Beginning Balance Principal
Payment Interest Payment 21
22
23
24 Loan Option 2
$30,000 Loan Option 3
Loan Amount
$30,000
Quarterly Payment 8.00%
60 Annual Rate (APR)
Total Payments
(NPER)
Total Interest
Total Cost of Loan Ending Balance $1,588.38
8.05% Create Date By Whom
mm/dd/yyyy Firstname Lastname Description Workbook Name Mod. Date By Whom Mod. Description Last Version Backup Name Create Date Sheet Name Creator Purpose e06ws11Loans.xlsx