What is the total amount of payments made over life of loan

Assignment Help Finance Basics
Reference no: EM131110352

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

Reference no: EM131110352

Questions Cloud

How much should floyd corporation report : On January 1, 2011, a machine was purchased for $900,000 by Floyd Co. The machine is expected to have an 8-year life with no salvage value. It is to be depreciated on a straight-line basis.
Describe the strategic decision making involves great comple : 1. Describe the strategic decision making involves great complexity,2. Uncertainty and Risk3. The strategic decision making process and consider how bounded rationality and cognitive simplification effect on the performance of strategic decision make..
What will be the company''s tax liability and earnings : If Connors does not make the acquisition, what will be the company's tax liability and earnings after taxes each year over the next 15 years? b. If the acquisition is made, what will be the company's tax liability and earnings after taxes each year o..
Monopolies rely on barriers of entry to maintain power : Monopolies rely on Barriers of Entry to maintain the power to set prices. Carefully define and describe a natural monopoly plus TWO other types of entry barriers. Explain why 1) monopolies are economically inefficient and 2) why regulators tend to be..
What is the total amount of payments made over life of loan : 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?
Both the lessor and the lessee are on a calendar year basis : If Secada paid $30,000 to a real estate broker on January 1, 2011, as a fee for finding the lessee, how much should be reported as an expense for this item in 2011 by Secada Co.?
What is each country ratio of producing plums and apples : The accompanying hypothetical production possibilies tables are for New Zealand and Spain. Each country can produce apples and plums. Plot the production possibilities data for each of the two countries separately. Referring to your graphs, answer th..
Choice makes arrivals a priori three times : The morning arrival times for 10 days of a school bus at the Tipperary street pickup stop are 8:05, 8:06, 8:09, 8:12, 8:03, 8:15, 8:11, 8:16, 8:00, and 8:14.
Grady leasing company signs an agreement on january : Azure Company assumes direct responsibility for all executory costs, which include the following annual amounts: (1) $900 to Frontier Insurance Company for insurance and (2) $1,600 to Crawford County for property taxes.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  It is now january 1 you plan to make a total of 5 deposits

it is now january 1. you plan to make a total of 5 deposits of 600 each one every 6 months with the first payment being

  Differences between a domestic and multinational firm

Define and discuss major differences between a domestic and multinational firm. Discuss four ways that firms can benefit in the international market.

  Consider the following three bond quotes a treasury note

consider the following three bond quotes a treasury note quoted at 10230 a corporate bond quoted at 99.45 and a

  Mortgage or home equity loan

An individual has a $120,000 30 year mortgage at 6 percent fixed. This individual also has a floating rate Home Equity line of credit for $20,000. The current rate on this loan is 8.5 percent

  Research topics on managerial problems

Based on your business experience and the information accumulated in this class, identify three possible research topics related to the subject of the course.

  Chips home brew whiskey management forecasts that if the

chips home brew whiskey management forecasts that if the firm sells each bottle of snake-bite for 20 then the demand

  What is the net present value of a baruch mba

Using the above calculations what is the Net Present Value of a Baruch MBA?

  Risk premium if the annual return on the sampp 500 index

risk premium if the annual return on the sampp 500 index was 12.4 percent. the annual t-bill yield during the same

  Over the last decade businesses have come to realize how

over the last decade businesses have come to realize how important it is to totally integrate business processes across

  Required dollar rate of return on projects

Your company's required dollar rate of return on projects of similar risk is 10%. Inflation in the US and Japan is expected to be 3% and 2%, and the current spot rate is ¥ 125/$.

  How would you define working capital what could happen if

how would you define working capital? what could happen if an organization neglected to manage its working capital?

  How much is taken out for federal income tax

Maggie Vitteta, single, works 38 hours per week at $9.00 an hour. How much is taken out for federal income tax with one withholding exemption?

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