need help with everything please and greatly appreciated.

An amortized loan is a loan that is to be repaid in equal amounts on a monthly, quarterly, or annual basis. Many loans such as car loans, home mortgage loans, and student loans are paid off over time in regular, fixed installments; these loans are a great real-world application of compound interest. For example, suppose a homeowner borrows $100,000 on a mortgage loan, and the loan is to be repaid in 5 equal payments at the end of each of the next 5 years. If the lender charges 6% on the balance at the beginning of each year, what is the payment the homeowner must make each year? Given what you know about present value (PV) and future value (FV), you can deduce that the sum of the PV of each payment the homeowner makes must add up to $100,000 : $100,000=1.002PMT+1.062PMTT+1.002PMT+1.004PMRT+1.003PMTT=t=151.002PMRT You can use the formula for the present value of an ordinary annuity to find this payment amount: PVAN$100,000PMT=PMT1(1(++)1)=PMT6.00(1(1+0061)=$23,739.64 Each payment of $23,739.64 consists of two parts-interest and repayment of principal, An amortization schedule shows this beeakdown over time: You can calculate the interest in each period by multiplying the loan balance at the beginning of the year by the interest rate: Each payment of $23,739.64 consists of two parts-interest and repayment of principal. An amortization schedule shows this breakdown over time. You can calculate the interest in each period by multiplying the loan balancefat the beginning of the year by the interest rate: Interest in Year 1= Loan Balance at the Beginning of Year 1 Interest Rate =$100,0000.06=$6,000 Notice that the interest portion is relatively high in the first year, but then it declines as the loan balance decreases. The repayment of principal is. equal to the payment minus the interest charge for the year: You can perform similar calculations to fill in the remainder of the amortization schedule. Notice that the interest portion is relatively high in the first year, but then it declines as the loan balance decreases. The repayment of principal is equal to the payment minus the interest charge for the year: You can perform similar calculations to fill in the remainder of the amortization schedule. Suppose Charles borrows $50,000.00 on a mortgage loan, and the loan is to be repaid in 7 equal payments at the end of each of the next 7 years. If the lender charges 6% on the balance at the beginning of each year, and the homeowner makes an annual payment of $8,956.75, the homeowner will pay in interest in the first year Suppose Charles receives o $21,000.00 loan to be repaid in equal instaliments at the end of each of the next 3 years. The interest rate is 3% compounded annually. Use the formulo for the present value of on ordinary annuity to find this payment amount: PVAN=PMCr(1+a+n21 PMT=PVAN(1a+nv1)1 In this cose, PVAN equals , 1 equals , and N equals Using the formula for the present value of an ordinary annuty, the annual payment amount for this loan is Becouse this payment is fixed over time, enter this annual payment amount in the "Payment" column of the following table for all three years. Lach payment consists of two parts-interest and repayment of principal, You cen calculate the interest in year 1 by multiplying the loan balance at the beginning of the vear (IW2AN) by the interest rate (t). The repayment of principal is equal to the payment (PMr) minus the interest charge for the year: The interest paid in year 3 is Enter the values for interest and repayment of principal for you t in the following table. Becsuse the balance at the end of the first year is equal to the beginsing arnount minus the repayment of princinal, the ending batance for yzag, Because the balance at the end of the first year is equal to the beginning amount minus the repayment of principal, the ending balance for year 1 is This is the beginning amount for year 2 . Enter the ending balance for year 1 and the beginning amount for year 2 in the following table. Using the same process as you did for year 1 , complete the following amortization table by filling in the remaining values for vears 2 and 3 : Complete the following table by determining the percentage of each payment that represents interest and the percentage that represents principal for each of the three years. Step 3: Practice: Amortization Schedule Now it's time for you to practice what you've learned. Suppose Dina receives a $32,000.00 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 8% compounded annually. Now it's time for you to practice what you've learned. Suppose Dina receives a $32,000,00 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 8 of compounded annually. Complete the following amortization schedule by calculating the payment, interest, repayment of principal, and ending balance for each year Complete the following table by determining the percentoge of each payment that represents interest and the percentage that represents principat for each of the thee years. An amortized loan is a loan that is to be repaid in equal amounts on a monthly, quarterly, or annual basis. Many loans such as car loans, home mortgage loans, and student loans are paid off over time in regular, fixed installments; these loans are a great real-world application of compound interest. For example, suppose a homeowner borrows $100,000 on a mortgage loan, and the loan is to be repaid in 5 equal payments at the end of each of the next 5 years. If the lender charges 6% on the balance at the beginning of each year, what is the payment the homeowner must make each year? Given what you know about present value (PV) and future value (FV), you can deduce that the sum of the PV of each payment the homeowner makes must add up to $100,000 : $100,000=1.002PMT+1.062PMTT+1.002PMT+1.004PMRT+1.003PMTT=t=151.002PMRT You can use the formula for the present value of an ordinary annuity to find this payment amount: PVAN$100,000PMT=PMT1(1(++)1)=PMT6.00(1(1+0061)=$23,739.64 Each payment of $23,739.64 consists of two parts-interest and repayment of principal, An amortization schedule shows this beeakdown over time: You can calculate the interest in each period by multiplying the loan balance at the beginning of the year by the interest rate: Each payment of $23,739.64 consists of two parts-interest and repayment of principal. An amortization schedule shows this breakdown over time. You can calculate the interest in each period by multiplying the loan balancefat the beginning of the year by the interest rate: Interest in Year 1= Loan Balance at the Beginning of Year 1 Interest Rate =$100,0000.06=$6,000 Notice that the interest portion is relatively high in the first year, but then it declines as the loan balance decreases. The repayment of principal is. equal to the payment minus the interest charge for the year: You can perform similar calculations to fill in the remainder of the amortization schedule. Notice that the interest portion is relatively high in the first year, but then it declines as the loan balance decreases. The repayment of principal is equal to the payment minus the interest charge for the year: You can perform similar calculations to fill in the remainder of the amortization schedule. Suppose Charles borrows $50,000.00 on a mortgage loan, and the loan is to be repaid in 7 equal payments at the end of each of the next 7 years. If the lender charges 6% on the balance at the beginning of each year, and the homeowner makes an annual payment of $8,956.75, the homeowner will pay in interest in the first year Suppose Charles receives o $21,000.00 loan to be repaid in equal instaliments at the end of each of the next 3 years. The interest rate is 3% compounded annually. Use the formulo for the present value of on ordinary annuity to find this payment amount: PVAN=PMCr(1+a+n21 PMT=PVAN(1a+nv1)1 In this cose, PVAN equals , 1 equals , and N equals Using the formula for the present value of an ordinary annuty, the annual payment amount for this loan is Becouse this payment is fixed over time, enter this annual payment amount in the "Payment" column of the following table for all three years. Lach payment consists of two parts-interest and repayment of principal, You cen calculate the interest in year 1 by multiplying the loan balance at the beginning of the vear (IW2AN) by the interest rate (t). The repayment of principal is equal to the payment (PMr) minus the interest charge for the year: The interest paid in year 3 is Enter the values for interest and repayment of principal for you t in the following table. Becsuse the balance at the end of the first year is equal to the beginsing arnount minus the repayment of princinal, the ending batance for yzag, Because the balance at the end of the first year is equal to the beginning amount minus the repayment of principal, the ending balance for year 1 is This is the beginning amount for year 2 . Enter the ending balance for year 1 and the beginning amount for year 2 in the following table. Using the same process as you did for year 1 , complete the following amortization table by filling in the remaining values for vears 2 and 3 : Complete the following table by determining the percentage of each payment that represents interest and the percentage that represents principal for each of the three years. Step 3: Practice: Amortization Schedule Now it's time for you to practice what you've learned. Suppose Dina receives a $32,000.00 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 8% compounded annually. Now it's time for you to practice what you've learned. Suppose Dina receives a $32,000,00 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 8 of compounded annually. Complete the following amortization schedule by calculating the payment, interest, repayment of principal, and ending balance for each year Complete the following table by determining the percentoge of each payment that represents interest and the percentage that represents principat for each of the thee years