Homework Answers
Answer
Option 3
the monthly interest rate =yearly nominal rate /number of compounding in a year =5/12 %
number of months =12*2=24
PV=-400000
so the formula is in the option 3.
Add Answer to:
Question 5 10 pts You borrow $400,000 at a rate of 5% per year compounded monthly...
In order to buy a car, you borrow $35,000 from a friend at 12%/year compounded monthly...
In order to buy a car, you borrow $35,000 from a friend at 12%/year compounded monthly for 4 years. You plan to repay the loan with 48 equal monthly payments. a. How much are the monthly payments? b. How much interest in in the 23rd payment? c. What is the remaining balance after the 37th payment?
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,...
In order to buy a car, you borrow $33,000 from a friend at 8%/year compounded monthly...
In order to buy a car, you borrow $33,000 from a friend at 8%/year compounded monthly for 4 years. You plan to repay the loan with 48 equal monthly payments. What is the remaining balance after the 37th payment?
2. (10 pts) You borrow $40,000 from the local bank at 5% APR, compounded monthly on...
2. (10 pts) You borrow $40,000 from the local bank at 5% APR, compounded monthly on a 6-year loan but you want to pay for the loan with payments every four months. (a) What is your effective interest on your 4-month payment? (b) What is your payment made every four months? (c) What is the APY for your loan with your payments??
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...
An example is a car purchase where you might pay $3,500 down and borrow $31,000 towards...
An example is a car purchase where you might pay $3,500 down and borrow $31,000 towards a $34,500 car. If the annual interest rate is 5.45%, you will be making 60 monthly payments and if these payments completely pay off the loan so that no money is due at the end of these payments, what would be the amount of your monthly payment? Assume that the payment is made at the end of each month. Include the equation you used...
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 ($)
7. You purchase a home and secure a 30 year equal payment loan for $200,000 at a interest rate of 5.25% APR compounded monthly. After 5 years the interest rate drops to 4.75% APR compounded month...
7. You purchase a home and secure a 30 year equal payment loan for $200,000 at a interest rate of 5.25% APR compounded monthly. After 5 years the interest rate drops to 4.75% APR compounded monthly. The bank is charging 2 points to originate the new loan. How many months do you need to stay in the house after the refinance to make the refinance a benefit? (10 Pts) a. 18 months b. 20 months C. 30 months 36 months...
You borrow $100,000 today. You will repay the loan with 5 equal annual payments starting next...
You borrow $100,000 today. You will repay the loan with 5 equal annual payments starting next year. Each payment is equal to $20,000 In addition to these payments, you will make a "balloon payment" in year 5 . If the interest rate on the loan is 2% APR, compounded annually, how big is the balloon payment? Group of answer choices $6,304 $6,960 $5,731 $6,327
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
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,...
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...
7. You purchase a home and secure a 30 year equal payment loan for $200,000 at a interest rate of 5.25% APR compounded monthly. After 5 years the interest rate drops to 4.75% APR compounded monthly. The bank is charging 2 points to originate the new loan. How many months do you need to stay in the house after the refinance to make the refinance a benefit? (10 Pts) a. 18 months b. 20 months C. 30 months 36 months...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
Most questions answered within 3 hours.
-
Computer Programming II CS141(Java)
Mention the appropriate relationship between following
classes:
HOD–StaffMember
Car–Ferrari
Student-Address
BankAccount–FixedAccount
House-Building...
asked 12 minutes ago -
Assume one of your finals has 50 questions on it, and
lucky for you, it's all...
asked 1 hour ago -
Rice Products in Bangladesh
Business behavior is derived in large part from the basic cultural
environment...
asked 2 hours ago -
The following base sequence is found for a mRNA fragment from
wild-type E. coli: 5'- UAUCAGUAGAUAAUGUAACC-3'...
asked 3 hours ago -
For this exercise, round all regression parameters to three
decimal places.
One of the two tables...
asked 3 hours ago -
What is the 5% level of significance for mean = 3.60, standard
deviation = 0.94, and...
asked 3 hours ago -
Prior to beginning work on this discussion, please read the
article by Hayley Peterson, 15 Companies...
asked 4 hours ago -
Which pair of aqueous solutions, when mixed, will form a
precipitate?
A) NaNO3 and AgC2H3O2
B)...
asked 4 hours ago -
1-Write an algorithm to get two numbers from the user (as
inputs) and calculate the sum...
asked 7 hours ago -
Define white-collar crime. What is the difference between
offender and offense-based definitions of white-collar crime? What...
asked 8 hours ago -
Consider a reaction which is 1st order with respect to A and 1st
order with respect...
asked 8 hours ago -
c++
The length of the hypotenuse of a right-angled triangle is the
square root of the...
asked 8 hours ago