interest payments and loan amortization

First off sorry if this is in the wrong section

Ok i have this problem, its a 12 year business loan worth $1million APR is 10%

I was asked to prepare a loan Amortization table and then asked
find the ration total interest payments to total repayments over the 12 years

I think i've worked out the loan repayments

PVA Factor: (1-91/(1+0.1)^12))/0.1) = 6.81
loan payments is 1mil/6.81 = 146842.88

but im getting stuck on the interest ratio part, is it as simple as 10% * 1million (then multiply this by 12 years?) or is there another formula i need to use!

thanks again for any help

Is the interest charged daily, monthly, annually?

If annually, I would lay it out: Y1 opening balance 1m, interest 10% * 1m = 100,000
First payment = 146842, closing balance 953158.

Y2 opening balance 953158, interest 10%*953158 95315.8, 2nd payment=146842, closing balance 901631.8 etc etc

That assumes that the interest is charged before the payment and not in arrears.

There might be something if you google, "loan amortization calculator".

Auto Loan Calculator - Free Auto Loan Payment Calculator for Excel

....I use these for my business or purchasing calcs, but banks figures come out slighly different for some odd reason..!

On the loan agreement you should have a page which will tell you the total interest payable on the loan. share these by 144 (12months x 12 years) and there is your average. Working smart beats working hard mate.

IMO its impossible to work out how a banks calculate interest unless you work for one or have a banking maths qualification

....Ah well I am glad for once that I don't have Banking Maths Calculation knowledge...!....because they don't seem to have 'loss' calculation buttons on their methods...!