Homework Answers
nice question.Add Answer to:
You want to buy a car that will cost $33,100. You have $2,750 cash as a...
You want to buy a car that will cost $33, 100. You have $2,750 cash as...
You want to buy a car that will cost $33, 100. You have $2,750 cash as a down payment. You will finance the remainder of the cost through a loan that will require equal monthly payments of principal and 6.75% APR interest over five years. Compute the amount of the monthly loan payment that you will need to make. Rate 6.75% Nper PMT PV FV Type Prepare a loan amortization schedule using the format presented below. Use the amortization schedule...
You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
You want to buy a house in five years. You prefer to live in an area...
You want to buy a house in five years. You prefer to live in an area in which houses are currently selling at an average price of $325,000. You know that the average price of the houses in the area will likely increase by 1.25% per year over the next five years. What will be the average price of a house in the area in five years? Nper PMT PV You know that 20% of the price of the house....
7. Loans and Financing: a. Ken and Marcy plan to have their kitchen remodeled at a...
7. Loans and Financing: a. Ken and Marcy plan to have their kitchen remodeled at a cost of $6,000. The carpenter suggests that they pay $600 down, followed by 18 monthly payments of $325. What is the finance charge for this payment schedule? b. Trevor asks his bank for a loan of $22,000 to add a guest room to his house. His bank offers financing at 7.25% compounded monthly, for a term of 5 years, payable monthly. What is Trevor’s...
12. You decide to buy a car that costs $15.000. You want to borrow all the...
12. You decide to buy a car that costs $15.000. You want to borrow all the money at a 6.5% (annual) interest rate. You want to pay it in 4 months. Find your monthly payment and write it in the table below. a. Fill in the amortization schedule showing how much of each of your monthly payments go to interest and how much to your principal. Principal: $15,000.00 Interest Rate: 6.50% Payment Interval: Monthly # of Payments: 4 Payment: S...
Use the PMT function in Excel to compute the monthly payment on a $328000 business loan...
Use the PMT function in Excel to compute the monthly payment on a $328000 business loan at an annual interest rate of 7.15% over 20 years, where the interest is compounded monthly. Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type) Fv and Type are not necessary. Ignore them. Enter the amount of your monthly payment below. Do not include the dollar sign ($)
Assume that you want to buy a new car in 5 years, and that the price...
Assume that you want to buy a new car in 5 years, and that the price of the car will be $30,000. (Assume all cash flows occur at the end of the period throughout all of the Excel problems throughout our entire course.) Use Excel time value of money functions to solve the problems outlined below (one or more of these: PV, FV, RATE, NPER, PMT) (This question doesn't require a text box with written answers, but you need to...
8. Mortgages: a. What is the period interest rate on a mortgage with a 4.8% APR...
8. Mortgages: a. What is the period interest rate on a mortgage with a 4.8% APR compounded semiannually? b. A certain family can afford a monthly mortgage payment of $1,340.00. With an APR of 5.25% per annum, what is the maximum mortgage amount they can afford if they prefer a 20-year amortization period? N = I% = PV = PMT = FV = P/Y = C/Y = PMT: END BEGIN c. The Lees have purchased a new home for $360,000,...
You want to by a house for $380,000. The bank will loan you 80% of the...
You want to by a house for $380,000. The bank will loan you 80% of the amount at the following terms: 40 years, monthly payments, and an APR of 8.7%. What will be your monthly payment on the mortgage loan? (What numbers do I put into the financial calculator for N, I/Y, PV, FV and PMT?)
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...
You want to buy a car that will cost $33, 100. You have $2,750 cash as a down payment. You will finance the remainder of the cost through a loan that will require equal monthly payments of principal and 6.75% APR interest over five years. Compute the amount of the monthly loan payment that you will need to make. Rate 6.75% Nper PMT PV FV Type Prepare a loan amortization schedule using the format presented below. Use the amortization schedule...
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
You want to buy a house in five years. You prefer to live in an area in which houses are currently selling at an average price of $325,000. You know that the average price of the houses in the area will likely increase by 1.25% per year over the next five years. What will be the average price of a house in the area in five years? Nper PMT PV You know that 20% of the price of the house....
12. You decide to buy a car that costs $15.000. You want to borrow all the money at a 6.5% (annual) interest rate. You want to pay it in 4 months. Find your monthly payment and write it in the table below. a. Fill in the amortization schedule showing how much of each of your monthly payments go to interest and how much to your principal. Principal: $15,000.00 Interest Rate: 6.50% Payment Interval: Monthly # of Payments: 4 Payment: S...
Assume that you want to buy a new car in 5 years, and that the price of the car will be $30,000. (Assume all cash flows occur at the end of the period throughout all of the Excel problems throughout our entire course.) Use Excel time value of money functions to solve the problems outlined below (one or more of these: PV, FV, RATE, NPER, PMT) (This question doesn't require a text box with written answers, but you need to...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago