Question

Today is July 1, 2000. Youve just borrowed $10,000 to purchase a car. The terms of the loan are 6% APR with monthly compounding Its an exceptionally short term loan- only 6 months total in duration. In addition, you1l only make payments 2, 4, and 6 months from today. The first payment will be $30. The second payment (made 4 months from today) will be $300. Part A) Determine the size of the last payment (made 6 months from today) Parts B/C/D) Complete the amortization schedule given below. Enter the values into PolyLearn which correspond to the three boxes (labeled as Parts B/C/D) below: Principal at End of Month Month # Principal Begin of Month Interest Due Payment Change in Made Principal 0.00 30.00 0.00 300.00 0.00 10,000.00 10,050.00 10,050.00 50.35 -249.40 49.36 Part B 9,871.20 9,920.56 0.00 4 Part C 9,920.56 Part D

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Statement showing loan repayment schedule

Month Principal at beginning of month Interest Due @ 0.5% PM Payment made Change in principal Principal at end of month
a b =a*0.5% c d=b-c a+d
1 10000 50 0 50 10050
2 10050 50.25 30 20.25 10070.25
3 10070.25 50.35 0 50.35 10120.60
4 10120.60 50.60 300 -249.40 9871.20
5 9871.20 49.36 0 49.36 9920.56
6 9920.56 49.60 9970.16 -9920.56 0.00
Add a comment
Know the answer?
Add Answer to:
Today is July 1, 2000. You've just borrowed $10,000 to purchase a car. The terms of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem 4 Today is July 1, 2000. You've just borrowed $100,000 to purchase a house. The...

    Problem 4 Today is July 1, 2000. You've just borrowed $100,000 to purchase a house. The terms of the loan are 6% APR with monthly compounding. It's a standard 30 year loan, with 360 payments, which occur at the end of each month. Part (A) owe? Immediately after you make your 57th payment, how much money do you still Part (B) Immediately after you make your 359th payment, how much do you stll owe? Part (C) What proportion of the...

  • Un July 1, a man borrowed $2000 at 6% simple interest. He paid $500 on August...

    Un July 1, a man borrowed $2000 at 6% simple interest. He paid $500 on August 30 and $600 on September 29. Find the balance on October 29 of the same year. A man owes $100, due in two months, and $400, due in eight months. His creditors have agreed to settle his debts by two equal payments in four months and ten months, respectively. Find the size of each payment if the rate of interest is 6% and the...

  • Kelsey owes $10,000 today but cannot make the payment. Instead she is to repay this amount...

    Kelsey owes $10,000 today but cannot make the payment. Instead she is to repay this amount in two equal payments, one in 3 months from today and one in 9 months from today. If the focal date is 9 months from today and money is worth 4.5% compounded quarterly. The amount of the equal payments is (6 marks) a. $5,170.66 b. $5,112.81 C. $5,042.13 d. $5,141.73 Julia decides to purchase a new home and takes out a mortgage for $250,000....

  • please answer all of the following questions 25. You currently owe $26,000 on a car loan...

    please answer all of the following questions 25. You currently owe $26,000 on a car loan at 4.25 percent interest. If you make monthly payments of $596.59 per month, how long i.e., number of months rounded to one decimal place) will it take you to fully repay the loan? 26. It is now January 1. You plan to make 5 deposits of $300 each, one every 6 months, with the first payment being made exactly six months from today. If...

  • Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the format shown below: Scenario:...

    Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the format shown below: Scenario: 2 years ago Janice got a $100,000, 15-year mortgage with an annual interest rate of 6% and monthly payments. 1) What is her monthly payment? 2) How much does she owe today (after 24 payments)? 3) How much will she owe in 3 years (after 60 payments)? 4) How much will she owe in 3 years (after 60 payments) if she makes an extra...

  • Accounting Spreadsheet Assignment Credit Card You went on a binge. You've heard the old saying, "If...

    Accounting Spreadsheet Assignment Credit Card You went on a binge. You've heard the old saying, "If you play, you're going to have to pay." The day of reckoning has arrived. Your current credit card balance is $10,000 с D E A 1 Your Name 2 Credit Card Payment Schedule 3 Date 4 5 Interest Rate XX% 6 7 Monthly Pymt SXXX.XX 8 9 Monthly 10 Month Payment 11 0 12 1 SXXX.XX Interest Principal Card Balance 10,000.00 XXX.XX $ $XXX...

  • You would like to save annually for buying a car 6 years from today. Suppose the...

    You would like to save annually for buying a car 6 years from today. Suppose the first deposit is made today and the last deposit will be made 5 years from now. Assume the car will cost you $30,000 and your deposits earn you interest at 6% p.a. compounded annually. a. What is your annual deposit amount? b. Instead of making annual deposits, you would like to make your deposit monthly and the bank is happy to pay your interest...

  • 1) You wish to borrow $150,000 from a lending institution for the purchase of a house....

    1) You wish to borrow $150,000 from a lending institution for the purchase of a house. The bank will lend this amount at an Annual Percentage Rate of 4.5% to be paid-off with equal monthly mortgage payments over a 30-year period. This is a 4.5% APR, 30-year fixed-rate mortgage loan. You wish to know how this loan will affect your federal income tax burden, as only the interest paid on a home mortgage, not the principal, is tax deductible. Construct...

  • Your client, age 29 and unmarried, came into your office today. She provided you with the...

    Your client, age 29 and unmarried, came into your office today. She provided you with the following information: Her income is $76,000. She contributes 6% of her salary to a 401(k), receiving a 3% salary match from her employer. She also saves $250 per month into a Roth IRA. She has fixed expenses of $28,500 and discretionary expenses totaling $1,500 per month. Her federal income tax rate is 15%, State is 5%, Social Security and Medicare (FICA) is 7.65% She...

  • You plan to purchase a $1 million home in Great Falls, VA. You will make a...

    You plan to purchase a $1 million home in Great Falls, VA. You will make a 20% down payment, and finance the rest with an $800,000 jumbo mortgage from First National Bank of Finance. The current rate offered on this 30 year, fixed rate mortgage is 6% per year, compounded monthly. a)         What is the monthly payment for this mortgage (ignore any tax and insurance escrow amounts)? b)         Just after you make the third monthly mortgage payment, you are transferred...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT