Daily Loan amortization schedule

I've trying to make an excel sheet for loan amortization for Channel Finance which is for 75 days @11.4%. The basis purpose is to keep track of the interest and outstanding balance on day basis and planning the payments in such a way that the interest element keeps under check.Kindly help me out with a template or with the formulas.

I have found a spreadsheet template (attached) for calculating loan on daily basis.Could anyone of you please convert the template to calculate the loan for 75 days.