How much will you owe a bank at the end of the 34th month if you took a loan of $125,000 for a period of 48 months at a rate of 4% per year compounded daily, if you paid the bank your entire bonus of $20,000 at the end of the 6th month to bring down the loan quickly? You make payments to the bank at the end of every month.

Answers:	$14,221
	$15,727
	$16,590
	$18,063

Could you work the question out in excel and show the steps you use to solve the question?

thanks for your help!!