What is your monthly payment

Assignment Help Finance Basics
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

Reference no: EM131226715

Questions Cloud

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?

Reviews

Write a Review

 

Finance Basics Questions & Answers

  What is the dividend payout percentage

If the firm maintains its target financing mix and does not issue any equity next year what is the most it could spend on capital expenditures next year given its earnings?

  Financial statements and appropriate notes to the financial

Use the annual report for the year ending 2013 & 2014. Your group will need to review the major sections of this report in order to familiarize yourselves with the content of each of the financial statements and appropriate notes to the financial sta..

  Valuing bond and common stocks

XXC expects earnings per share to be $6.00 next period. The retention rate is 60% and return on equity (ROE) is 20%. The required return is 18%. Find out XXC's stock price?

  What is the value of the levered firm

The tax rate is 34 percent and the current cost of equity is 17.2 percent. What is the value of the levered firm?

  Suppose you find a 65 percent coupon bond with a current

suppose you find a 6.5 percent coupon bond with a current market price of 832. the yield to maturity is 16.28 percent

  Importance of proper coding

For this Assignment, you will be writing a report to the Board of Directors of Health Care Systems, Inc. regarding the importance of proper coding in order to ensure prompt reimbursement.

  When would a u.s. firm consider purchasing a call option

When would a U.S. firm consider purchasing a call option on euros for hedging? When would a U.S. firm consider purchasing a put option on euros for hedging?

  Calculate the inventory turnover for each year

calculate the inventory turnover for each year. comment on your findings

  The fairest determination of income occurs

Which costing method is based on the reasoning that the fairest determination of income occurs if the current costs are matched against current sales prices

  Classify the following items as an addition to the bank

1.classify the following items as a an addition to the bank balance b a subtraction from the bank balance c an addition

  Explain how its investments in municipal bonds

In the mid-1970s, these REITs got into such serious difficulty that many banks suffered large losses on their REIT loans. Explain how its investments in municipal bonds and REITs could reduce a bank's willingness to act as a lessor.

  Risks associated with the aggressive and conservative plan

Christensen and Associates is development an asset financing plan. Christensen has $500,000 in current assets of which 15 percent are permanent, and $700,000 in fixed assets.

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!

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