Question

In: Finance

All the remaining questions are based on the following scenario: You take out an $19,000.00 car...

All the remaining questions are based on the following scenario:

You take out an $19,000.00 car loan that calls for 48 monthly payments at an APR of 6.7%. Complete an amortization table and answer the following questions.

You must complete the amortization table to answer the questions (otherwise your answers could be off due to rounding error... all totals are based on intermediate numbers that have not been rounded). The answer you enter must be rounded (correctly) to two decimal places. You do not need to include commas or dollar signs in your answer. For example, the end balance after 41 months would be entered as 3096.82.

5. What is your loan payment?

6. What is the total interest paid on the loan?

7. What is the total amount you paid on the loan?

8. What is the balance on the loan at the end of 48 months?

Solutions

Expert Solution

5)

The loan payment is calculated using the following equation

Monthly payment on the loan = $ 452.34

---------------------------------------------------------------------------------

The amortization schedule on the loan is done making use of excel.

6)

Total interest paid on the loan = $ 452.34 48 months - $ 19000

Total interest paid on the loan = $ 2712.25

-------------------------------------------------------------------------------

7)

Total amount paid on the loan = $ 21712.32

-----------------------------------------------------------------------------------------

8)

Balance of the loan at the end of 48 months = -0.07


Related Solutions

The remaining questions in this workbook assignment are based on the following scenario. Information was collected...
The remaining questions in this workbook assignment are based on the following scenario. Information was collected from a reputable internet site for an investigation into the fuel economy of various makes of car and whether these varied over time. Data was collected for fifteen different models of vehicle from twelve different manufacturers. After collection, the observed vehicle models were classified as sedan, sports or 4WD. The data for sedans is provided in the file sedan_economy.csv, also available in the same...
questions 1-5 are based on scenario 1: Does public speaking stress you out? How much does...
questions 1-5 are based on scenario 1: Does public speaking stress you out? How much does it stress you out? Many researchers are interested in studying how people respond to stressful social situations. One study brought participants into a laboratory, measured their cortisol (stress hormone) levels when they first arrived, made them give a speech in front of a group of strangers with only 5 minutes to prepare, and then measured their cortisol levels again to see if they had...
If you take out a car loan for $35,000, will pay an annual interest rate of...
If you take out a car loan for $35,000, will pay an annual interest rate of 4% on the loan, and make monthly payments of $547.58, how many payments will you need to make? -What are you solving for? -What is your answer?
You take out a car loan at your local bank for the purchase of a new...
You take out a car loan at your local bank for the purchase of a new car. The total cost including taxes and preparation costs are: $25,985. Your bank’s nominal interest rate for car loans is at the moment 7 1⁄4 % for a 5-year amortization period. Calculate your monthly payments and the remaining balance after 3 years.
Use the following information for all remaining questions on this worksheet. The lengths of human pregnancies...
Use the following information for all remaining questions on this worksheet. The lengths of human pregnancies are normally distributed with a mean of 268 days and a standard deviation of 15 days. a. If one pregnant woman is randomly selected, find the probability that her pregnancy lasts less than 260 days. Round your result to 4 decimal places. b. Is it unusual for one woman to have a pregnancy that lasts less than 260 days? c. If we looked at...
Use the following information for all remaining questions on this worksheet. The lengths of human pregnancies...
Use the following information for all remaining questions on this worksheet. The lengths of human pregnancies are normally distributed with a mean of 268 days and a standard deviation of 15 days. 1.a) If one pregnant woman is randomly selected, find the probability that her pregnancy lasts less than 260 days. Round your result to 4 decimal places. a. 0.2969 b. 0.7031 c. 0.5000 d. 0.2742 1.b) Is it unusual for one woman to have a pregnancy that lasts less...
Use the following information for all remaining questions on this worksheet. The lengths of human pregnancies...
Use the following information for all remaining questions on this worksheet. The lengths of human pregnancies are normally distributed with a mean of 268 days and a standard deviation of 15 days. 1.a) If one pregnant woman is randomly selected, find the probability that her pregnancy lasts less than 260 days. Round your result to 4 decimal places. a. 0.2969 b. 0.7031 c. 0.5000 d. 0.2742 1.b) Is it unusual for one woman to have a pregnancy that lasts less...
Suppose you take out a car loan that requires you to pay $9,000 now, $3,000 at...
Suppose you take out a car loan that requires you to pay $9,000 now, $3,000 at the end of year 1, and $7,000 at the end of year 2. The interest rate is 3% now and increases to 6% in the next year. What is the present value of the payments?
Suppose you take out a car loan that requires you to pay $7,000 now, $5,000 at...
Suppose you take out a car loan that requires you to pay $7,000 now, $5,000 at the end of year 1, and $6,000 at the end of year 2. The interest rate is 4% now and increases to 9% in the next year. What is the present value of the payments?
You take your car to the mechanic. The mechanic says that based on the knocking sound...
You take your car to the mechanic. The mechanic says that based on the knocking sound there is a 40% chance that the transmission is the problem, 25% chance it's the pistons, a 25% chance that it's the radiator and a 10% chance that it is none of them. He then hooks up the car to the diagnostic computer and says that the computer is returning an error code. 25% of the time the transmission is faulty, this error appears,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT