excel project

mely1999

ExcelProject1.xlsx

Home >Business & Finance homework help >excel project

Project 1

FIN 3403 Excel Project 1 Part (A)			(4 points)
Kayti Schumann Condo Amortization Schedule
Inputs
Loan amount - - - - - - - - - - - - - -
Term (in years) - - - - - - - - - - - -
Annual interest rate - - - - - - - - -
Payment per year - - - - - - - - - -
Year	Principal Amount				Principal
	Owing at	Installment	Annual	Principal	Amount Owing
	Beginning of Year	Payment	Interest	Payment	at Year End
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
Totals
FIN 3403 Excel Project #2 Part (B)			(4 points)
Josh White Mercedes-Benz Amortization Schedule
Inputs
Loan amount - - - - - - - - - - - - - - -
Term (in months) - - - - - - - - - - - - -
Monthly Interest rate - - - - - - - - - -
Payment per month - - - - - - - - - -
	Principal Amount				Principal
Month	Owing at	Installment	Monthly	Principal	Amount Owing
	Beginning of Year	Payment	Interest	Payment	at Month End
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
Totals
			(4 points)

(C) As time progresses, what is happening to the portion of the installment payment that is contributing to interest? As time progresses, what happens to the portion of the installment payment that is contributing to principal?