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.