(Answered) Create a loan amortization schedule using excel for a 15000

Finance

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?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M91867949
Price:- $25

Verified Expert

Priced at $50 Now at $25, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Please show all workkanab co and zion co are us companies

Please Show All Work Kanab Co. and Zion Co. are U.S. companies that engage in much business within the U.S. and are about the same size. They both conduct some international business as well. Kanab Co. has a subsidiary i ...

When figuring the benefit-cost ratio i know that i take the

When figuring the benefit-cost ratio, I know that I take the present value of cash inflows/ present value of cash outflows. Year 0 = (46,500) cash flow Year 1 = 12,200 cash flow Year 2 = 38,400 cash flow Year 3 = 11,300 ...

Timco is considering project a project a will cost 23000 it

Timco is considering project A. Project A will cost 23000. It should provide after tax cash inflows of 5000 per year for the next 6 years. The cost of funds is 10%. Find the MIRR. Should Timco buy it?

Question - laurie vaden is a nurse practitioner with her

Question - Laurie Vaden is a nurse practitioner with her own practice. She has developed contracts with several large employers to perform routine physical, fitness for duty exams, and initial screening of on-the-job inj ...

A risky fund has an expected return of 10 and standard

A risky fund has an expected return of 10% and standard deviation of 15%. The T-Bill rate is 5%. An investor allocates 60% of her retirement portfolio to the risky fund and 40% to T-Bills. What is the investor's risk ave ...

Initial outlay is 16853year 1 5625year 2 5504year 3

Initial outlay is $16,853 Year 1 $5,625 Year 2 $5,504 Year 3 $5,892 Year 4 $8,851 What is the discounted payback period? The discount rate is 10%...Round answer to two decimal points

Q1 you invest 272 at the beginning of every year and your

Q1. You invest $272 at the beginning of every year and your friend invests $272 at the end of every year. If you both earn an annual rate of return of 14.00%. a) how much will you have in your account after 40 years? b) ...

At the beginning of 2016 winston corporation issued 10

At the beginning of 2016, Winston Corporation issued 10% bonds with a face value of P600,000. These bonds mature in five years, and interest is paid semiannually on June 30 and December 31. The bonds were sold for P555,8 ...

A project currently generates sales of 20 million variable

A project currently generates sales of $20 million, variable costs equal 50% of sales, and fixed costs are $4.0 million. The firm's tax rate is 35%. Assume all sales and expenses are cash items. a. What are the effects ...

Assume a 80000 investment and the following cash flows for

Assume a $80,000 investment and the following cash flows for two alternatives. Year Investment A Investment B 1 $ 20,000 $ 45,000 2 30,000 25,000 3 22,500 25,000 4 15,000 - 5 20,000 - a. Calculate the payback for investm ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert