Math

posted by .

Need to make a monthly amortization schedule. Borrowing 16000 over 4 years at 3.5%. Do I need to calculate for 48 months in order to do this project correctly? I do all the calcs for 48 months and I still end up with approx a payment left over?

  • Math -

    16000 = paym (1 - (1.00291666..)^-48)/.00291666..

    I got payment = 357.70

    # Paym - Inter- Repaym - Balance
    0 000.00 00.00 000.00 16000.00
    1 357.70 46.67 311.03 15688.97
    2 357.70 45.76 311.94 15377.03
    ...
    ..
    48 357.70 1.04 356.67 -0.72

    done with Excel, error due to roundoff of original payment
    Make sure you carry enough decimals of
    .002916666... in your calculator, I did .035/12 and then stored that result in memory.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. math

    John's account of 98.50 has been delinquent for 3 months. After 90 days office charges a 2% service charge, compounded monthly that is added to future bills. What would be the amount owed after 9 months?
  2. math

    A person takes out a monthly installment loan of $2000 with an annual percentage rate of 13.0% if the person can afford no more than $70 per month, then which of the following terms are feasible?
  3. science

    Shown below are the data giving the length of life of lights in an underground tunnel. 9.0 months 7.0 months 8.2 months 8.3 months 7.8 months 8.1 months 7.5 months 7.6 months 9.1 months 7.4 months I calculated the standard deviation …
  4. Statistics

    Shown below are the data giving the length of life of lights in an underground tunnel. 9.0 months 7.0 months 8.2 months 8.3 months 7.8 months 8.1 months 7.5 months 7.6 months 9.1 months 7.4 months I calculated the standard deviation …
  5. math

    Andy needs to pay off a loan of $18,000 in 5 years. Find the amortization payment he would need to make each bi-monthly pay period (twice a month) at 6% compounded bi-monthly, in order to pay off the loan.
  6. help please math

    Andy needs to pay off a loan of $18,000 in 5 years. Find the amortization payment he would need to make each bi-monthly pay period (twice a month) at 6% compounded bi-monthly, in order to pay off the loan.
  7. Math

    Andy needs to pay off a loan of $18,000 in 5 years. Find the amortization payment he would need to make each semi-monthly pay period (twice a month)at 6% compounded bi-monthly, in order to pay off the loan.
  8. Math

    Louise Grantham is buying a home for $198,500 with a 20% down payment. She has a 5.75% loan for 25 years. Create amortization schedule for the first two months of her loan.
  9. Finance

    You are considering borrowing $150,000 to purchase a new home. a. Calculate the monthly payment needed to amortize an 8 percent fixed-rate 30-year mortgage loan. b. Calculate the monthly amortization payment if the loan in (a) was …
  10. Math

    You plan on borrowing $14000 at 16% APR for 5 years. Use Web Loan Calculator to find the monthly payment. Find the total interest paid on this loan for the first 20 months. Set up a spread sheet to answer. Here is an example of what …

More Similar Questions