Category Archives: loan amortization schedule

I need help with excel can someone help:?

Churchill University is offering its faculty a generous retirement package. Professor Norman Smith has accepted the proposal; but before moving to his retirement home in Naples, Florida, he wants to settle his account with the school credit union. Professor Smith has five years remaining on a six-year car loan, with an interest rate of 8.25 [...]

0% APR or $1,000 cash back?

Buying a new car and I would like to know exactly how much a 0% APR is worth to compare against an optional rebate. The deal is you choose 0% APR for 60 months or you take $1,000 cash back. Let’s say I can get an alternative loan at 4% APR, and the car costs [...]

First and Second Mortgage Strategy – Do I focus on 1st or 2nd?

1st loan – 6.875 30 yr fixed with 10 yr interest only option / 2nd loan 9.875 25 yr fixed with 10 year interest only option. If I want to pay more than the interest only, should I just follow the regular amortization schedule, or pay interest only on lower rate and max out payment [...]

Excel Spreadsheet help – Can you help me set up a worksheet for this?

I have to complete this assignment in the next few hours and have no idea where to begin….any help would be sincerely appreciated. Here it is: A man has 5 years remaining on a six year car loan, his interest rate is 8.25% and his monthly payment is $525.00. His credit union is willing to [...]

I have an urgent math problem due tomorrow?

My problem asks Calculate the simple interest for a loan of $674,100 at a rate of 6% for 30 years. but I get a huge number when I compute the simple interest formula. Then it asks to compare it with my amortization schedule interest . Which according to me is at the very bottom where [...]

Please Help Me I have no clue?

An organization has a $50,000 loan that is to be amotized over 10 years. create an amortization schedule for a loan at 7.5% interest compounded monthly. What if the organization decided that they wanted to pay the loan off in 5 years? Amount to pay in 10 years = P(1 + r/100)^N = 50000(1.075)^10 = [...]

If I make double principal payments on my mortgage should it take more than one month off the end of the loan?

I just started my payments in Dec of ’07, and have been making double and triple principal payments every month. I’ve been keeping track with the online amortization schedule which updates after each payment. The extra payments only seem to be taking one month of the end of the loan. I always heard that paying [...]

How to determain car loan interest?

I can track my mortgage payments from an amortization schedule and see exactly how much I need to pay each month in order to get it paid on in x amount of time (I put this together on an excel spreadsheet). I want to do this with my car loan, but each month the interest [...]

In Excel, how do I calculate how much interest will be paid after 10, 20, 30 years on a loan?

I know how to create an amortization schedule to figure out the interest over the life of the loan, so that is NOT what I am looking for. I am looking for a formula where I can specify the loan amount, payment amount, interest rate, and number of periods, and then have it tell me [...]

Finance Management?

Doess anyone know where I can find info. or perform calculations on Bank Loan Amortization and Mortgage Bond Amortization Schedule(s). There are many on the web, consder the sources below, or do a yahoo search on "bank loan" and "mortgage bond" seperately with "amortization" and "calculator" as additional keywords addthis_url = ‘http%3A%2F%2Fwww.ucufutsal.com%2Floan-amortization-schedule%2Ffinance-management’; addthis_title = ‘Finance+Management%3F’; [...]