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

  On september 1 2010 drill far company purchased a tract of

1. on november 15 2010 betty corporation accepted a note receivable in place of an outstanding accounts receivable in

  Why is a policies and procedures manual considered

Why is a policies and procedures manual considered an element of internal control?

  Adjusting entries are required at the end of the period to

adjusting entries are required at the end of the period to ensure that accrual accounting principles are applied. the

  Determining if an asset is impaired

What are the implications of this difference?

  Identifiable non-monetary asset-physical substance

Which of the following is an identifiable non-monetary asset without physical substance?

  In 2010 grand falls bankgfb had 4000000 in business loans

in 2010 grand falls bankgfb had 4000000 in business loans at an adverage interest rate of 3.5 percent as well as

  On the basis of the following data for breach co for the

on the basis of the following data for breach co. for the year ended december 31 2011 and the preceding year prepare a

  In the manufacture of 9656 units of a product direct

in the manufacture of 9656 units of a product direct materials cost incurred was 154137 direct labor cost incurred was

  Refer to the original data assume that the company sold

refer to the original data. assume that the company sold 31000 units last year. the sales manager is convinced that a

  Identify and describe several types of financial information

Identify and describe several types of financial information that would be more appropriate for Greg to review when evaluating the performance of segment managers.

  Calculate revenues for the year assuming

Assuming the assets increased by $25,000 during the year and liabilities amounted to $75,000 and $65,000 at the beginning and end of the year, respectively, calculate revenues for the year assuming the following additional information:

  Dollar amount of variable and fixed cost

Compute the dollar amount of variable and fixed cost that should have been allocated to each of the operating departments at the beginning of last year for planning purposes, that is, allocate the fixed and variable overhead based on the budgeted ..

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