This post is currently awaiting moderation.
Question
In: Accounting
You just purchased a car for $50,000. You paid $10,000 for the down payment and the rest is the loan. The car loan is for 36 months at an annual
You just purchased a car for $50,000. You paid $10,000 for the down payment and the rest is the loan. The car loan is for 36 months at an annual interest rate of 6%. The loan payments should be made at the end of each month.
A. How much is the monthly payment on the loan? Total monthly payment is ________.
B. How much of the monthly payment is the interest payment in month 17?The interest amount is ________.
C. How much of the monthly payment is the payment of principal in month 9?The principal payment is ________.
Solutions
Expert Solution
|
|
Payment Formula |
|
Payment Formula |
|
|
|
Interest Formula |
|
Interest Formula |
|
|
|
PMT(rate,period,-borrowing) |
|
PMT(rate,period,-borrowing) |
|
|
|
|
|
|
|
|
A.
|
payment
|
|
$1,216.88
|
|
|
|
Formula
|
|
=PMT(6%/12,36,-(50000-10000)) |
|
|
B. |
Interest |
|
$ 115.53 |
|
|
|
Formula
|
|
=-CUMIPMT(6%/12,36,(50000-10000),17,17,0) |
|
|
|
|
|
|
|
|
C. |
Principal |
|
$1,058.27 |
|
|
|
Formula |
|
=-CUMPRINC(6%/12,36,(50000-10000),9,9,0) |
|
A.
|
payment
|
|
$1,216.88
|
|
Formula
|
|
=PMT(6%/12,36,-(50000-10000)) |
Junaid answered 2 years agoRelated Solutions
You have just purchased a car and taken out a $50,000 loan. The loan has a...
You have just purchased a car and taken out a $50,000 loan. The
loan has a 5-year term with monthly payments and an APR of 6%. How
much will you pay in interest, and how much will you pay in
principle, during the first month and second month? (Hint:
construct an amortization table to show the breakdown of interest
and principal paid in the first two months).
You have just purchased a car and taken out a $50,000 loan. The loan has a...
You have just purchased a car and taken out a $50,000 loan. The
loan has a five-year term with monthly payments and an APR of
6.0%.
How much will you pay in interest, and how much will you pay
in principal, during the 1st, 2nd, and 12th month?
How much will you pay in interest, and how much will you pay
in principal, at the end of the 4th year?
How much will you pay in interest, and how much...
A $21,000 car loan is repaid with one payment of $26,533.47 after 36 months. What is...
A $21,000 car loan is repaid with one payment of $26,533.47
after 36 months. What is the annual effective discount rate? Round
your answer to 3 decimal places.
The effective annual rate of discount has been 6% for the last 3
years. Prior to that it was 5%. A bank account has a balance of
$550 today. A single deposit of $X was placed in an account 8 years
ago. Calculate the value of X.
Given that i(m) = 0.216772...
Marie and Alex just paid $250,000 for a house. They made a down payment of $50,000...
Marie and Alex just paid $250,000 for a house. They made a down
payment of $50,000 and assumed a 30-year $200,000 mortgage with a
fixed annual interest rate of 5.50%. The house will serve as a
residence for several years, but Marie and Alex also view it as an
investment, as property values in the neighborhood are projected to
increase at a rate of 5% per year in the near future. Property
taxes on their home will be $4,236 the...
Marie and Alex just paid $250,000 for a house. They made a down payment of $50,000...
Marie and Alex just paid $250,000 for a house. They made a
down payment of $50,000 and assumed a 30-year $200,000 mortgage
with a fixed annual interest rate of 5.50%. The house will serve as
a residence for several years, but Marie and Alex also view it as
an investment, as property values in the neighborhood are projected
to increase at a rate of 5% per year in the near future. Property
taxes on their home will be $4,236 the...
Marie and Alex just paid $250,000 for a house. They made a down payment of $50,000...
Marie and Alex just paid $250,000 for a house. They made a down
payment of $50,000 and assumed a 30-year $200,000 mortgage with a
fixed annual interest rate of 5.50%. The house will serve as a
residence for several years, but Marie and Alex also view it as an
investment, as property values in the neighborhood are projected to
increase at a rate of 5% per year in the near future. Property
taxes on their home will be $4,236 the...
You want a bank loan in order to buy a car (with no down payment of...
You want a bank loan in order to buy a car (with no down payment
of your own). You already own a house on which you pay $1,600 per
month in mortgage payments, $300 per month in property taxes and
$100 per month in utilities. Your gross family income is $80,000
per year. You have no other debts. The bank is willing to give you
a loan which will be amortized over 5 years (i.e., 60 monthly
payments). The interest...
You have saved $10,000 for a down payment on the purchase of a new car, however,...
You have saved $10,000 for a down payment on the purchase of a
new car, however, since you plan to buy the car one year from
today, you need to decide how to invest the money for one year. You
are limited to one of two choices:
1. A Bond Fund with an expected return of 3%/year
2. A Stock Fund with an expected return of 7%/year.
Which fund is best? Explain why!
When you purchased your car, you took out a five-year annual-payment loan with an interest rate...
When you purchased your car, you took out a five-year
annual-payment loan with an interest rate of 5.9% per year. The
annual payment on the car is $5,000. You have just made a payment
and have now decided to pay off the loan by repaying the
outstanding balance. What is the payoff amount for the following
scenarios?
a. You have owned the car for one year (so there are four years
left on the loan)?
b. You have owned the...
1. When you purchased your car, you took out a five-year annual-payment loan with an interest...
1. When you purchased your car, you took out a five-year
annual-payment loan with an interest rate of 6.5% per year. The
annual payment on the car is $4,500. You have just made a payment
and have now decided to pay off the loan by repaying the
outstanding balance. What is the payoff amount for the following
scenarios?
a. You have owned the car for the one year (so there are four year
left on the loan)?
answer: $15,416.09
b....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
ADVERTISEMENT