Create a loan amortization schedule

Assignment Help Accounting Basics

Reference no: EM13973029

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?

How many years will it take to pay off the loan if you pay an extra $100 per month?

Reference no: EM13973029

Questions Cloud

Evaluate the equality of the scrutinized laws : Evaluate the equality of the scrutinized laws discussed in this assignment compared to other more globally accepted laws across countries. Provide an example to support your response.

Problem regarding the professional conduct rules : Which AICPA Code(s) of Professional Conduct rules apply in this situation (explain how and why they apply)? Cite the specific verse(s) for at least one Biblical principle that you feel is relevant to the situation (explain how and why it applies).

Problem regarding the physical inventory count : At the end of each quarter, the store performs a physical inventory count. When the current physical inventory count was performed on March 31st, 327 stainless steel cylinder head gaskets were counted.

Specify internet connection via service provider : When you submit your plan, include a brief (1-2 paragraphs) description of your design in the assignment comments.

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

Describe the orientations of the sun, moon and earth : Describe the orientations of the sun, moon and earth during spring and neap tides. In your discussion, explain why the maximum tidal range (spring tide) occurs during new moon and full moon phases and the minimum tidal range (neap tide) at first-q..

Produce a website discussing the value : Pick a Marymount Core Value (Excellence, Integrity, Professionalism, Diversity, Respect, Faith or Service) and produce a website discussing the value.

Identification of commodity businesses : A recent article in Fortune magazine listed the following firms among the top ten most admired companies in the United States: Dell, Southwest Airlines, Microsoft, and Johnson & Johnson.

Can equilibrium be established when price equal 3 : Discuss a change in demand resulted in a change in the market price. Provide an example of how a change in supply resulted in a change in the market price. How does the price mechanism work to keep markets in equilibrium?

User Account

All Pages