create a loan amortization table and using Excel

Amortization Schedule for a Loan Pavable Most loans are not repaid in one large payment but paid with smaller installment payments during the agreed upon term of the loan. The payments may be on a monthly, quarterly or semiannual basis but in all cases the payment represents interest and a principal. The payments continue until the loan is completely repaid Generally we compute the monthly payment for a mortgage using the following formula: A the pavment amount i - is the interest rate P - is the principal or loan amount n - is the number of periods The payment is set to make the present value of the payments equal to the amount of the loan at the end of the period. By convention, the quoted mortgage rate is annualized with monthly compounding Example: If a firm borrows $45,000 for 30 years at 6% the monthly payments would be computed as follows using the formula: 005 x 45,000 x(1+.005)360 (1+.005)360-1 = $269.80 monthly payment for loan Notes: Since we are looking for monthly payment the interest rate needs to be stated monthly (6%/12 = .5%) The monthly payment includes interest and principal The computation is also available in Excel using the following formula @PMT (rate, nper, pv) Rate - Interest rate (making sure it is stated for the payment ie; monthly, annually or semi- Nper - number of periods annually) Pv present value or the current loan value