Question

FINANCIAL FUNCTIONS D USING FINANCIAL FUNCTIONS E 1 3 4 YEARLY 5 PRINCIPAL INTEREST R/PERIOD(MONTHS) 6.00% 6.50% 7.00% PMT TOTAL PAID 6 8500 8500 8500 8500 48 7 48 72 8 7.50% 48 60 8500 8.00% 10 8500 16.50% 11 48 12 2 YEARLY 13 INTEREST R PERIOD(MONTHS) 6.00% PRESENT VALUE PMT 14 200 48 15 200 6.50% 60 16 200 200 200 72 7.00% 17 7.50% 8.00% 48 18 60 19 200 48 16.50% 20 21 3 YEARLY INTEREST R/PERIOD(MONTHS) 6.00 % 6.50% 22 FUTURE VALUE PMT 23 200 48 24 60 200 200 200 25 72 7.00% 7.50% 8.00%) 16.50% 7.00% 26 48 27 200 60 28 200 48 29 180000 240 30 Pryaped E PmT Cnat, , po fe) - PVCAat, e, nt, fe FPUCAate,p, pt) Fr hat, eptpu

Answer 1

1
	YEARLY
PRINCIPAL	INTEREST RATE	PERIOD (MONTHS)	PMT	TOTAL PAID
8500	6.00%	48	($ 199.62)	($ 9,581.89)
8500	6.50%	48	($ 201.58)	($ 9,675.70)
8500	7.00%	72	($ 144.92)	($ 10,433.99)
8500	7.50%	48	($ 205.52)	($ 9,864.99)
8500	8.00%	60	($ 172.35)	($ 10,340.96)
8500	16.50%	48	($ 243.07)	($ 11,667.58)
	YEARLY
	INTEREST RATE	PERIOD (MONTHS)	PMT	PRESENT VALUE
	6.00%	48	200	($ 8,516.06)
	6.50%	60	200	($ 10,221.74)
	7.00%	72	200	($ 11,730.89)
	7.50%	48	200	($ 8,271.67)
	8.00%	60	200	($ 9,863.69)
	16.50%	48	200	($ 6,993.74)
	YEARLY
	INTEREST RATE	PERIOD (MONTHS)	PMT	FUTURE VALUE
	6.00%	48	200	($ 10,819.57)
	6.50%	60	200	($ 14,134.79)
	7.00%	72	200	($ 17,832.19)
	7.50%	48	200	($ 11,155.17)
	8.00%	60	200	($ 14,695.37)
	16.50%	48	200	($ 13,470.73)
	7.00%	240	180000	($ 93,766,798.77)

Here is the formula version

A E 1 2 31 48 YEARLY 5 PRINCIPAL INTEREST RATE PERIOD (MONTHS) PMT TOTAL PAID 6 8500 0.06 =PMT(B6/12,C6,46) =C6*D6 7 8500 0.065 =PMT(B7/12,C7,A7) =C7*D7 8 8500 0.07 =PMT(B8/12, C8,48) =C8*D8 9 8500 0.075 =PMT(B9/12,C9,49) =C9*D9 10 8500 0.08 60 =PMT(B10/12,010, A10) =C10*D10 11 8500 0.165 48 =PMT(B11/12,011, A11) C11*011 48 0165 YEARLY INTEREST RATE PERIOD (MONTHS) PMT 0.06 200 0.065 200 0.07 72 200 0.075 0.08 200 0.165 200 PRESENT VALUE =PV(B15/12,C15,D15) =PV(B16/12,016,016) =PV(B17/12,017,017) =PV(B18/12,C18,018) =PV(B19/12,C19,D19) =PV(B20/12,020,020) 200

200 60 YEARLY INTEREST RATE PERIOD (MONTHS) PMT 0.06 0.065 200 0.07 200 0.075 200 0.08 200 0.165 200 0.07 240 180000 72 FUTURE VALUE =FV(B24/12,024,024) =FV(B25/12, C25,D25) =FV(B26/12, C26,026) =FV(B27/12,c27,027) =FV(B28/12,c28,028) =FV(B29/12,029,029) =FV(B30/12,C30,030) 48 60