Amortization information

Prepare an amortization schedule for a three year…?

Prepare an amortization schedule for a three year loan of ,000. The interest rate is 9% per year, and the loan calls for equal annual payments.

How much interest is paid over the life of the loan? (use a financial calculator)
(Also, develop the amortization schedule using Excel spread sheet)


Friends of Amortization Fast

My negative amortization loan?

I have a negative am loan which i was tricked into getting by my broker but thats another story, anyways my wife loves this home and i do not want to sell it but im afraid i wont be able to afford it if i were to refinance at the current rate, i have 2 more years before i can refinance without a penalty and i currently have about 90k in equity. What can i or should i do?? whats a great loan that’s out there that can help me out until i can better stabilize myself economically, my wife is going to school and works part time so i cannot afford a higher payment now, she should finish school in about 1 1/2 years and might be better off financially then. What is a good loan that can help me out and have a low payment and not negatively amortize??


Friends of Amortization Fast

How do you calculate Amortization?

Ok so I have to do an amortization table by hand now I know how to use the TVM solver on my calculator…but what do you do after that? So you have to future value the interest and everything but then how do you use it to fill the table? Im sorry if this question seems juvenille but I would really appreciate some help. Thank you :)


Related Blogs

how can i calculate amortization on the BA II Plus calculator?

You have just taken out an installment loan for
0,000. Assume that the loan will be repaid in 12
equal monthly installments of ,456 and that the
first payment will be due one month from today.
How much of your third monthly payment will go
toward the repayment of principal?
a.,757.22 b. ,359.12
c. ,212.50 d. ,925.88
e.,333.33


Related Blogs

where is the best site to get a loan amortization table?

A table of rates to help me calculate the amortization on my own.


Related Blogs

Need an amortization calculator?

I’m looking to calculate when my loan will finish (paying above the minimum payment) rather than how much i will be paying. I just need the name of what this would be called. any help is appreciated.

Thanks in advance


Related Blogs

Where I can I find an advanced loan amortization calculator?

I need a loan amortization calculator or spreadsheet that will allow me to input graduated payments (ex. 12 months @ followed by 36 months @ 0 etc). I’m trying to chart and graph a payment schedule for my student loans. The online calculators I’ve found only let you input one set of payments.


Related Blogs

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! :o

thanks again for any help


Related Blogs

How do I make an Amortization schedule in Excel?

This is my HW question:
Create an Amortization schedule for a long term loan in an Excel Spreadsheet.
Use 340,000 for the amount financed for 30 years with a rate of 6.25 %
and print out 24 months of the schedule. (It may be helpful to fill in values before you enter
the formula for calculating monthly payment.)

I have no idea how to put this into excel.


Related Blogs

How to construct a loan amortization?

Construct a loan amortization sheduled for a 3yr. 11% loan of ,000. The loan requires three equal, end-of-year payments.
I need help with the formula: ,000=PMT(PVIFA 9,4)


Related Blogs