Question: How to complete an amortization table for the installment note. You will first need to calculate the required payment. Remember from your principles course that payment calculations use the same time value of money concepts, only instead of multiplying by the table value, to find a payment you will divide. Start with the initial principal balance and find the appropriate "n" and "i" in your table; then simply divide by that table value to solve for the annual payments.

Please include formulas and steps and the information is giving below.

Golf World, Inc., borrowed $150,000 from a bank by signing a three-year installment note on October 1, 2018, bearing 10% interest. The note requires equal payments each year on September 30.

	CREATE THIS AMORTIZATION TABLE MANUALLY
DATE		Beginning Loan Balance	Interest Rate	Annual Payments	Interest Expense	Principal Reduction Expense	Ending Loan Balance
2018	Oct 1
2019	Sept 30
2020	Sept 30
2021	Sept 30
	PAYMENT CALCULATION		PMT		solve in cell F8 using the PMT formula
	n =
	i =
	Table Value
	Payments