Reference no: EM131226715
Excel Exercise: Loan Amoritization
Loan Amoritization Video: https://www.youtube.com/watch?v=PlMvy2fnrQ0
Create a Loan Amortization Schedule Excel Assignment
For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. You can rewatch the video on p. 8 of this lesson and/or create a loan amortization schedule similar to the one illustrated in under LO 4.13 of Chapter 4 of the textbook.
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%.
a. What is your monthly payment?
b. What is the total amount of payments made over the life of the loan
2. 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%.
a. What is your monthly payment?
b. What is the total amount of payments made over the life of the loan?
c. How many years will it take to pay off the loan if you pay an extra $100 per month?
Attachment:- Attachments.rar
|
What are your variables of interest
: In the method section of your paper, you will present the design of your study. The design of your study refers to the plan for actually conducting the research. It specifies where you will conduct observations or an experiment. It also specifies..
|
|
Compute the value of acme common stock
: Compute the value of Acme Common Stock if the next dividend is expected to be $1.20 per share. Investors require a 9% rate of return on stocks with the same risk as Acme.
|
|
Explain the importance of human resource management
: In your own words, explain the importance of Human Resource Management (HRM) to any organization then determine a HRM function that interest you as a future career. Explain your rationale.
|
|
Recommended improvements to the program
: Assess the three (3) most important experiences you have had in completing the Strayer University MSHRM program. Suggest three (3) recommended improvements to the program.
|
|
What is your monthly payment
: What is your monthly payment? 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?
|
|
Discuss at least three social-cognitive factors
: Discuss at least three social-cognitive factors that motivate offenders to commit crime. Select one of the prevention and treatment programs discussed in Chapter 7, and discuss how that program can be used to treat the three factors you selected.
|
|
What is pay-for-knowledge plan
: What is pay-for-knowledge plan? Explain the role of training in pay-for-knowledge plans. Response needs to me 3/4 of a page double spaced. As well as original.
|
|
Macroeconomic impact of unions
: Discuss this issue in an essay (minimum 500 words). Make sure to include in your essay the macroeconomic impact of unions, the prevalence of U.S. employment laws, whether HRM has replaced the need for unions and consider the three goals of the lab..
|
|
Why does riordan need a strategic plan
: What role should ethical and social responsibility considerations have in Riordan's strategic management plan?
|