A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial...
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial balance of $15000. What is the balance due halfway through the 4 years?
SHOW HOW TO SOLVE ON EXCEL
Homework Answers
Add Answer to:
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial...
Use excel For example.. I want it looks like that. A car is purchased with a...
Use excel
For example.. I want it looks like that.
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial balance of $15000. What is the balance due half way through the 4 years? 01 cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 -1500 1500 1500 1500 5500 0 2 4 ($535.27) ($1,159.39) pv ($150,535.27) ($201,159.39)
QUESTION 4 A car is purchased with a 48-month, 9% nominal loan with an initial balance...
QUESTION 4 A car is purchased with a 48-month, 9% nominal loan with an initial balance of $15,000. What is the balance due halfway through the 4 years. $7,489 $9,123 $6,094 $8,176 QUESTION 3 Find EUAW of the following project. Use 8 years for the analysis and no renewal, along with i= 10%. The initial cost is $2,800; EUAB is $900 and its useful life is 5 years. $334.51 $497.11 $850.23 $114.67
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. Wha...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
9) Sue can afford $500 a month for 3 years for a car loan. If the interest rate is 4 percent compounded monthly, how much can he afford today to borrow to purchase a car? (NOTE: show results and show...
9) Sue can afford $500 a month for 3 years for a car loan. If the interest rate is 4 percent compounded monthly, how much can he afford today to borrow to purchase a car? (NOTE: show results and show calculations used in financial calculator-which formula and the inputs into TVM Solve/Grid below) In Finance calculator- TVM Solver- show your inputs and then output Page 519 Values Entered (inputs) END PMT: END or BGN PV P/N PMT FV Solve for...
Suppose the interest rate is 9% APR with monthly compounding. What is the present value of...
Suppose the interest rate is 9% APR with monthly compounding. What is the present value of an annuity that pays $250 every three months for the next five years closest to? Convert APR to EAR and then use Texas Instruments BA II to solve using: N: I/Y: PV: PMT: FV: The present value of an annuity that pays $250 every three months for the next five years is closest to A) $2280 B) $3985 C) $3990 D) $3995
• 1) A new car is purchased and a $20,000 loan is taken. The loan is...
• 1) A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the monthly payment? • 2)A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the balance after 3 years? . 3) A new car is purchased and a $30,000 loan...
Long questions Throughout this question, assume annual interest rate is 3.6% with monthly compounding. You are...
Long questions Throughout this question, assume annual interest rate is 3.6% with monthly compounding. You are a loan officer in the mortgage department of a local bank. A customer, who is also a Stevens alum, walks in and applies for a $750,000 loan to buy a starter home in Hoboken. The standard terms your bank have been offering to previous customers are as followed, • Contract A: a 15-year fixed rate loan, with an annual rate of 3.6% and with...
You have to repay your car loan of $20,000 in 48 month (A) with i =...
You have to repay your car loan of $20,000 in 48 month (A) with i = 1.25% per month. a) What is your effective rate of interest per year? b) What is your effective rate of interest per month? c) What is your monthly payment?
show all work pleasee :) 5) A man agrees to pay $300 per month for 48...
show all work pleasee :)
5) A man agrees to pay $300 per month for 48 months to pay off a car loan. If interest of 12% per annum is charged monthly, how much did the car originally cost? How much interest was paid? 6) Chase Bank was offering a 30-year fixed-rate mortgage of 7.38%. George and Debby Ashton purchased a house for $180,000. After putting 20% down as a down payment. they finance the balance with Chase Bank. a....
Use excel
For example.. I want it looks like that.
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial balance of $15000. What is the balance due half way through the 4 years? 01 cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 -1500 1500 1500 1500 5500 0 2 4 ($535.27) ($1,159.39) pv ($150,535.27) ($201,159.39)
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
9) Sue can afford $500 a month for 3 years for a car loan. If the interest rate is 4 percent compounded monthly, how much can he afford today to borrow to purchase a car? (NOTE: show results and show calculations used in financial calculator-which formula and the inputs into TVM Solve/Grid below) In Finance calculator- TVM Solver- show your inputs and then output Page 519 Values Entered (inputs) END PMT: END or BGN PV P/N PMT FV Solve for...
• 1) A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the monthly payment? • 2)A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the balance after 3 years? . 3) A new car is purchased and a $30,000 loan...
Long questions Throughout this question, assume annual interest rate is 3.6% with monthly compounding. You are a loan officer in the mortgage department of a local bank. A customer, who is also a Stevens alum, walks in and applies for a $750,000 loan to buy a starter home in Hoboken. The standard terms your bank have been offering to previous customers are as followed, • Contract A: a 15-year fixed rate loan, with an annual rate of 3.6% and with...
show all work pleasee :)
5) A man agrees to pay $300 per month for 48 months to pay off a car loan. If interest of 12% per annum is charged monthly, how much did the car originally cost? How much interest was paid? 6) Chase Bank was offering a 30-year fixed-rate mortgage of 7.38%. George and Debby Ashton purchased a house for $180,000. After putting 20% down as a down payment. they finance the balance with Chase Bank. a....
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