Question

1. how to create an amortization schedule in excel

2.How to calculate interest and principal payments for loan or investment session in excel

3.how to calculate depreciation schedule in excel

Answer 1

`Hey,

Note: Brother if you have any queries related the answer please do comment. I would be very happy to resolve all your queries.

1. We use the PMT function to calculate the monthly payment on a loan with an annual interest rate of 5%, a 2-year duration and a present value (amount borrowed) of $20,000. We have named the input cells.

2. Use the PPMT function to calculate the principal part of the payment. The second argument specifies the payment number.

3. Use the IPMT function to calculate the interest part of the payment. The second argument specifies the payment number.

4. Update the balance.

5. Select the range A7:E7 (first payment) and drag it down one row. Change the balance formula.

6. Select the range A8:E8 (second payment) and drag it down to row 30.

It takes 24 months to pay off this loan. See how the principal part increases and the interest part decreases with each payment.

Note: Brother According to HomeworkLib's policy we are only allowed to answer first part if there are many. So, I request you to post other part as separate posts

Kindly revert for any queries

Thanks.