Construct an amortization table for the loan described below.

A farmer loaned Php50,000 from a bank to fund the planting of corn. The banks rate is 15% compounded monthly and the term is 1 year. But since harvest is 6 months away from the time of planting, he asked that repayment be deferred for 6 months. The bank agreed and added 6 months to the repayment period to accommodate the 6 months deferment.

pls add explanation and do it on excel thank you!

Seatwork: Construct an amortization table for the loan described below. A farmer loaned Php50,000 from a bank to fund the planting of corn. The bank's rate is 15% compounded monthly and the term is 1 year. But since harvest is 6 months away from the time of planting, he asked that repayment be deferred for 6 months. The bank agreed and added 6 months to the repayment period to accommodate the 6 months deferment. 25