interest repayments , loan amortization?
Ok i have this problem, its a 12 year business loan worth million 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
Related Blogs
- How Do You Make An Amortization Table For An Auto Loan?
- Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble …
- Eligibility Rules for Private Student Loan Debt Consolidation …
- Kotak Car Loans–Kotak Car Finance Schemes | Eligibility …
- How to Determine Your Monthly Loan Amortization « financeinvestment
- 0 Apr Credit Cards | how to pay credit cards
- Student Loan Repayments: Why Get Confused? | consolidate college loans
- Loan Consolidation While In School | consolidate college loans
- Student Loan Consolidation Repayment Plans Available For Your …
- Amortization
- Home Loan Refinancing Quick & Dirty
- Low APR Credit Cards : Money Funk | Personal Finance & Frugal Living
- Small Business Loan Applications
- Manage Loans with an Amortization Table in Excel – Part 1 | TALKABOUT
- eChoice Fixed Rate Home Loans | Home Loan Finder
- St.George Intro 1 Year Fixed Rate | Home Loan Finder
- New Proposed Loan Regs Slam the Poor | FrumForum
- Japan Apr Economy Watchers' Index Hits 3-Year High of 49.8 | ForexLive
- Japan Apr Bank Lending -1.8%, 5th Y/Y Drop In Row; Mar -2.0 …
- Difference Between Amortization and Capitalization | Difference …
Loan Amortization Tables
Probably the most important investment that any one is ever likely to make in their lives is when they take out a mortgage to purchase a home. However in order for you to work out just what the right sort of mortgage is for you, you will need to calculate just how much you can afford. One of the most important things you need to be concerned with when taking out any sort of mortgage is what the rate of interest will be. Although there are various ways in which a person can actually work out what the interest rate is going to be on their mortgage most of the banks will calculate theirs according to a loan amortization table. Amortization is the number of years on which the loan has been taken out for in order for you to repay it fully.
Below we provide you with three of the different types of loan amortization tables that are used.
1. Equal Capital – This particular calculation system will show the monthly payments which are equal as well as the total payment to the bank which changes and the repayments which decrease as the term of the loan heads towards its expiry date.
2. Spitzer Amortization Table – This is probably the most optimal repayment method. With this type of loan the monthly payment you make is fixed and this is due on account to the capital and interest changing during the repayment period. Unfortunately there is a common misconception among many people who think that during the first year of this type of loan being taken out you will pay most or all of the interest on the loan.
3. Bolit Amortization Table – This particular method is where the payments are made on the interest and not on the principal loan and it is only after a given period that you will then begin to pay off the amount of the loan that was originally taken out.
Unfortunately there are many risks associated with loan amortization tables and these are the linking risk, the rising consumer price index, the rising prime risk, the exchange rate changing risk and a fluctuating interest rate risk. But if you are able to define the risk involved then you will have a better understanding of how each component has been cause and so by using the right sorts of tool it can then be neutralized.