Create a loan amortization schedule

Assignment Help Accounting Basics

Reference no: EM13974153

https://www.youtube.com/watch?v=PlMvy2fnrQ0 (use this example as a template)

Create a loan amortization schedule using Excel for a $15,000 car loan that will be repaid over 60 months at an annual interest rate of 6%.
1. What is your monthly payment?
2. What is the total amount of payments made over the life of the loan

Create a loan amortization schedule using Excel for an $180,000 mortgage that will be repaid over 30 years with monthly payments. The annual interest rate is 5.5%.
1. What is your monthly payment?
2. What is the total amount of payments made over the life of the loan?
3. How many years will it take to pay off the loan if you pay an extra $100 per month?

Reference no: EM13974153

Questions Cloud

What are the author''s main points? : What are the author's main points? How does this source fit into my research? Is this source objective, or does it have a bias?

How do internet and social media affect quality of education : An essay informing the audience about some aspect of an issue, problem, or controversy related to the CORE READINGS, using and synthesizing ideas, concepts, information, and viewpoints found in 5 or more sources to support the thesis.

How to analyse spectrum of a digital signal using dft method : To learn how to analyse spectrum of a digital signal using DFT method. To learn how to perform I/O operations using interrupt method and program/implement them using the evaluation toolkit

Describe the given poster in one paragraph : Describe the poster in one paragraph

Create a loan amortization schedule : Create a loan amortization schedule using Excel for a $15,000 car loan that will be repaid over 60 months at an annual interest rate of 6%. What is your monthly payment?

What are some resources that can be used besides : What are some resources that can be used besides the school library?

Fix jobs using each of the following scheduling algorithms. : Using the given information, calculate which jobs will have arrived ready for processing by the time the first job is finished or interrupted using each of the following scheduling algorithms.

Utilizing one of the internet search engines : Utilizing one of the internet search engines, find an organization that has recently been forced to increase or decrease capacity dramatically to align with customer demand. Discuss specifically the key drivers for the change in demand along with the..

Statement of changes in partners capital accounts : Prepare, in good form, a statement of changes in partners' capital accounts from January1, Year 5, to December 31, Year 6. Show your calculations.

User Account

All Pages