User Account

All Pages

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)

  1. 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
  1. 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.

Reviews

Write a Review

Accounting Basics Questions & Answers

  The potential for improved control over the availability of

sycamore company uses a certain part in its manufacturing process that it buys from an outside supplier for 37 per part

  Variances warrant investigation

Compute material price and quantity variances.?Do either or both of the variances warrant investigation?

  Identifying and addressing business and financial risks

Financial markets are the forums in which buyers and sellers of financial assets such as stocks and bonds, and commodities such as grains, oil and gold, meet. Write a paper of not more than 10 pages on business and financial risk, as follows:

  Prepare a schedule of expected collections from customers

Prepare a schedule of expected collections from customers for March and prepare a schedule of expected payments for direct materials for March.

  Mirk labs is a pharmaceutical company which currently

mirk labs is a pharmaceutical company that currently enjoys a patent monopoly in europe canada and the united states

  Determine the maturity value of the note

Determine the due date of the note and determine the maturity value of the note.

  Develop an entity relationship diagram for a database

Using a graphics program, develop an entity relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases.

  Prepare a complete cost production report showing units and

the assembly department uses a process cost accounting system and a weighted-average cost flow assumption. the

  Quillen compnay is performing a post-audit of a project

quillen compnay is performing a post-audit of a project completed one year ago. the initial estimates were that the

  Research and locate a company who was audited by an outside

research and locate a company who was audited by an outside source and explain the method technique and findings of an

  Widget inventory at the end of year using variable costing

What is the dollar value of the widget inventory at the end of the year using variable costing?

  Seaver corporation manufactures mountain bikes it has fixed

seaver corporation manufactures mountain bikes. it has fixed costs of 4620000. seavers sales mix and contribution

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd