You have decided to purchase a new car. You plan to take out a loan to pay for the car. The loan amount is $18,900. You will pay an interest rate of 6.5% and plan to pay off the car in 48 months. You want to calculate the total amount of money and the total amount of interest you will pay over the course of the loan. To help you with these calculations, |you decide to construct an amortization table. An amortization table provides details about the payment, interest amount, principal amount, and loan balance for every month of the loan. Perform the tasks below to complete the amortization table and loan summary calculations.

You have decided to purchase a new car. You plan to take out a loan to pay for the car. The loan amount is $18,900. You will pay an interest rate of 6.5% and plan to pay off the car in 48 months. You want to calculate the total amount of money and the total amount of interest you will pay over the course of the loan. To help you with these calculations, |you decide to construct an amortization table. An amortization table provides details about the payment, interest amount, principal amount, and loan balance for every month of the loan. Perform the tasks below to complete the amortization table and loan summary calculations.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: Is long term investment is classified as non-current assets?

A: Generally, the liquidity of the assets plays a significant role in determining whether they are…

Q: Solve using amortization table with steps

A: Loan amortization is the loan schedule table in which all the payments, interest charges and what…

Q: Define amortization period.

A: Amortization: Amortization is a process in which the cost of intangible assets is spread equally…

Q: WHAT I CAN DO? Solve and show your solution and explanations in a separate paper. 1. CM Company…

A: Loan is an amount which is borrowed from external sources like banks for a specific period. This…

Q: How would you describe a planned amortization class (PAC) tranche?

A: A Planned Amortization Class (PAL) Tranche will be explained:

Q: Solve using amortization table with steps

A: Loan is the amount which has been taken by the company or the person which requires to be repaid…

Q: Can someone explain this amortization schedule's breakdown?

A: The capital is the backbone of the company, and the company will be willing to raise the capital for…

Q: $100 is deposited in the bank and remains in the account for three years, earning 6% per year with…

A: Here, Initial Deposit Amount is $100 Interest Rate is 6% Interest Method is Simple Interest Method.

Q: Explain planned amortization class (PAC) tranche?

A: A collateralized contract commitment or CMO is a fixed income security that uses mortgage financed…

Q: Minimum amortization of the actuarial loss?

A: INTRODUCTION: Amortization is the process of progressively applying an asset's cost to expenditure…

Q: Define amortization schedule

A: Amortization: Amortization is an accounting method utilized to periodically lesser the book worth of…

Q: Discuss the nature of acquiring fixed assets?

A: Fixed assets are one of the major investments of a company and this covers the huge part of the…

Q: On January 1, 20x1, ABC Co leased equipment to XYZ, on the lease is shown below. Inc. Information…

A: First of all, we have to calculate the Present value of lease liability using 12% Present value of…

Q: On January 1, 20x1, ABC Co. sold machinery costing P3,000,000 with accumulated depreciation of…

A: Lets understand the basics. When asset is sold in exchange of non interest bearing notes then amount…

Q: Year Opening Balances 2015 April 2015 October 2016 April 2016 October 2017 April 2017 October 2018…

A: In this Question, we need to pass journal Entries for Bonds issued at a discount

Q: a b C d e Amortization Payment Payment Period every year every 3 months every month every 6 months…

A: The amortization payment is the periodic payment made at regular intervals to pay the loan amount In…

Q: How to calculate the Amortization Expense?

A: Depreciation , amortization , depletion all means the fall in value of assets due to one reason or…

Q: Define Amortization.

A: Amortization: It is the process of allocating the value of an intangible asset over its definite…

Q: What should be the pattern of amortization for a limitedlifeintangible?

Q: Define amortization expense

A: Amortization expenses is a tool or technique that helps to lower the book value of loans and…

Q: 1. A debt of Php 150,000 is to be amortized by ten semi-annual payments, the first to be made 6…

A: Loan is an amount which is borrowed from external sources like banks and this amount is repaid in…

Q: E10-14 (L04) (Purchase of Equipment with Zero-Interest-Bearing Debt) Chippewas Inc. has decided to…

A: Introduction: Interest rate amount: Interest amount is calculated on bond face value with interest…

Q: How is amortization different from depreciation?

A: a. Depreciation - Depreciation is charged in the assets to record use, wear and tear, passage of…

Q: Dfference between Deprecetion , amortization And fluctution?

A: The resources owned by the business which are required to be sold or to be used for operating the…

Concept explainers

Amortized Loans

The term "amortization" refers to spreading the value of a loan or a debt over a series of regular payments or installments comprising of both the principal and interest amount. It generally involves the process where in the value of a loan or an intangible asset is written down over its maturity period.

Question

AMORTIZATION

Period
Payment
Interest
Principal
Balance
$18.900.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
1
.***.....
2
*******
3
6.
9
10
11
12
13
14
15
16
17
18
$00
$0.00
$00
$0.00
$00
$0.00
$00
$0.00
$00
$0.00
$00
$0.00
$00
$0.00
$00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
$0.00

You have decided to purchase a new car. You plan to take out a loan to pay for the car.
The loan amount is $18,900. You will pay an interest rate of 6.5% and plan to pay off the
car in 48 months. You want to calculate the total amount of money and the total amount
of interest you will pay over the course of the loan. To help you with these calculations,
you decide to construct an amortization table. An amortization table provides details
about the payment, interest amount, principal amount, and loan balance for every month
of the loan. Perform the tasks below to complete the amortization table and loan
summary calculations.
Loan Amount
-$18,900.00
Loan Summary
Term (months)
Total Amount Paid
Total Interest Paid
48
Interest Rate
6.50%
Verify Interest Calculation
Payment
Buy new in Period 36?
Yes
No

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

b) You have decided to buy an apartment costing $140,000. At present you have $10,000 to be paid as down payment and your bank CAB agrees to provide you with the remaining amount of money. The interest rate is 12% to be repaid in 5 years period. Find the annual payment to be amortized and also prepare a schedule of amortization.
You plan to purchase a $320,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.20 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. (1) Construct the amortization schedule for the mortgage. b. (2) How much total interest is paid on this mortgage? Answer is not complete. Complete this question by entering your answers in the tabs below. Req A Req B1 Amortization Schedule Month 1 2 3 179 180 Construct the amortization schedule for the mortgage? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Req 82 Total Interest Amortization Schedule for the 15-Year Mortgage Interest Cumulative Principal Principal 272,000.00 270,999.26 Cumulative Interest Ending Balance
We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $80,000 at 9.25%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
You plan to use a 15 year mortgage obtained from a local bank to purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?
You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. Complete this question by entering your answers in the tabs below. Required A Required B Construct the amortization schedule for the first six payments. (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Amortization Schedule for first 6 payments (months) Month Beginning Loan Balance Payment Interest Principal Ending Loan Balance 1 2 3 4 5 6
Suppose you need to borrow $200,000 to buy a home, and you are deciding between a 15 year mortgage and a 30 year mortgage. Research a bank offering 15 year and 30 year mortgage loans and find the interest rates on those loans. Use the techniques you learned in this Module to do the following: 1. Calculate the monthly payment for a 15-year mortgage and for a 30-year mortgage. 2. Find the total amount of interest you will pay on the 15 year mortgage and on the 30 year mortgage. 3. Describe some of the factors (financial and non-financial) that can influence whether to obtain a shorter term mortgage or a longer term mortgage. 4. Which mortgage would you take, the 15 year or the 30 year? Explain your decision.
A man plans to take a vacation in 5 years. He wants to buy a certificate of deposit for $1300 that he will cash in for the trip. What is the minimum annual interest rate he must obtain on the certificate if he needs at least $1500 for the trip? Assume that the interest on the loan is computed using simple interest. The rate he must obtain is
Susan would like to buy a car. She went to the bank and got a loan for $40,000 at the annual interest rate of 4%, for 4 years. Calculate the monthly payment. Calculate the interest on the payment. Calculate the total payment. Make complete amortization schedule on excel
Please solve this
You plan to purchase a $290,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 7.25 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. Complete this question by entering your answers in the tabs below. Required A Required B Calculate your monthly payments on this mortgage. (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16)) Monthly payment Required B >
You are assiting a newly hired employee. You begin explaning the process of utilizing excel to finance properties. Consider the following. A realator has a house on sale for $640,000. If possible you believe you can finance the home for $300,000 for 20 years at a 3% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel. How would you caluclate this in Excel using the PV function? Rate: Nper: Pmt: FV: Type:
You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 5.25 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS