Problem:
An individual has a $120,000 30 year mortgage at 6% fixed. This individual also has a floating rate Home Equity line of credit for $20,000. The current rate on this loan is 8.5%. Only interest payments are required on the Home Equity line. The individual has an increase in discretionary income of $500 per month. Assuming rates will stay constant, does it make more economic sense to pay down the mortgage or the Home Equity loan first?
How would I show the work in excel?