A common personal and professional example that highlights key Excel financial functions are loan characteristics. Let's consider a loan with a present value of $20,000, an annual interest rate of 6%, with a 2-year payback period, Table 1 Using this information, calculate the following: - Convert the annual loan structure to quarterly and monthly - Monthly payment - Principal payment for a given payment - Interest payment for a given payment - Number of required payments - Future value of payments - NPV and IRR from the Lender's perspective

Table 1
Loan Structure
Loan principal	$ 20,000
Interest Rate (annual)	6.00%
Period (yrs)	2
Model
Convert Loan Structure
	Annual	Quarterly	Monthly
Loan principal	$ 20,000	$ 20,000	$ 20,000
Interest Rate	6.00%	1.50%	0.50%
Period	2	8	24
Monthly Payment
Excel Function: PMT to calculate the payment
PMT	Rate	Nper	Pv	Fv
($886.41)	0.50%	24	$ 20,000.00	0
Principal portion of a payment
Excel Function: PPMT to calculate the principal portion of a specific payment #
PPMT	Rate	Nper	Pv	Fv	Payment #
($882.00)	0.50%	24	$ 20,000.00	0	5
Interest portion of a payment
Excel Function: IPMT to calculate the interest portion of a specific payment #
IPMT	Rate	Nper	Pv	Fv	Payment #
($4.41)	0.50%	24	$ 20,000.00	0	5
Interest rate for a payment
Excel Function: Rate to calculate the interest rate based on a payment amount
PMT	Rate	Nper	Pv	Fv
$ (2,600.00)	0.88%	8	$ 20,000.00	0
Number of payments required
Excel Function: NPER to calculate the number of payment periods given a loan structure
PMT	Rate	Nper	Pv	Fv
$ (3,000.00)	1.50%	7.1	$ 20,000.00	0

My input is bold and underlined. I do not believe I have done the calculations correct.

Please assist.