Question

Your client obtained financing in the form of a $100,000 amortizing loan with payments of $955.65...

Your client obtained financing in the form of a $100,000 amortizing loan with payments of $955.65 at the end of each month for 15 years. What is the APR being paid? What is the EAR being paid? Please use excel

Homework Answers

Answer #1

CELL REFERENCES PROVIDED. THANK YOU

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
. A property is sold for $200,000. Typical financing terms are an 85% fully amortizing loan...
. A property is sold for $200,000. Typical financing terms are an 85% fully amortizing loan with a 10 % interest rate over 15 years with monthly payments . If the before - tax cash flow is $2,000, what is the overall capitalization rate? (A) 10.96% (B) 11.96% (C) 19.13% (D) 9.96%
1) i. What is an amortizing loan? A) A loan in which the borrower only pays...
1) i. What is an amortizing loan? A) A loan in which the borrower only pays principal. B) A loan in which portions of both principal and interest are paid in every period. C) A loan in which the interest portion of payments increase over time while the principal decreases. D) A loan in which the borrower pays interest once the principal balance is depleted. ii) What is the payment on a 60-month, $10000 car loan with APR of 9.13%?...
If you take out an $8000 car loan that calls for 48 monthly payments of $240...
If you take out an $8000 car loan that calls for 48 monthly payments of $240 each, what is the APR of loan? What is the EAR on loan? please indicate steps, rather than excel or financial calculator solution
You take a fixed-rate, amortizing, 7-year loan to buy a car. The loan amount is $130,000,...
You take a fixed-rate, amortizing, 7-year loan to buy a car. The loan amount is $130,000, the APR is 4%. Payment is expected at the end of each month. What will the mortgage balance be right after you make your 45th payment assuming all payments were made on time and no prepayments were made? Round your answer. a. 64,884        b. 76,843        c. cannot be determined        d. 84,648        e. 50,038
1.You are borrowing $100,000 for an amortized loan with terms that include annual payments,6 year loan,...
1.You are borrowing $100,000 for an amortized loan with terms that include annual payments,6 year loan, and interest rate of 4.5 per year.  How much are your equal annual payments?  Answer to the nearest cent xxx.xx, and do not enter the dollar sign. 2.Calculate the total present value of the following three cash flows: $15  obtained one year from today, $24 obtained two years from today, and $30 obtained three years from today.  Use 6.7% as the interest rate.  Answer to the nearest cent,  xxx.xx and...
Consider an amortizing loan. The amount borrowed initially is $21618, the interest rate is 5% APR,...
Consider an amortizing loan. The amount borrowed initially is $21618, the interest rate is 5% APR, and the loan is to be repaid in equal monthly payments over 17 years. As we know, while each monthly payment will be the same, the amounts of interest and principle paid will change from payment to payment. How much of the very first payment is interest?
You have obtained a loan of $250,000 to purchase a home. What are the monthly payments...
You have obtained a loan of $250,000 to purchase a home. What are the monthly payments if the APR is 3.75% for 30 years (payments will be made monthly for the next 30 years)
A loan is to be repaid in end of quarter payments of $1,000 each, with there...
A loan is to be repaid in end of quarter payments of $1,000 each, with there being 20 end of quarter payments total. The interest rate for the first two years is 6% convertible quarterly, and the interest rate for the last three years is 8% convertible quarterly. Find the outstanding loan balance right after the 6th payment. Please show/explain your work, I'd like to learn how to do it without excel
The Shelby Cobra retails for ​$37,340 ​(all taxes​ included). What are the monthly loan payments for...
The Shelby Cobra retails for ​$37,340 ​(all taxes​ included). What are the monthly loan payments for the car if you make a down payment of ​$4​,481 the term is 4 years and the APR is 15​%? ​ (Car loan payments are made at the end of each​ month.) What is the amount of the monthly​ payment?
1.A loan is offered with monthly payments and a 12.50 percent APR. What’s the loan’s effective...
1.A loan is offered with monthly payments and a 12.50 percent APR. What’s the loan’s effective annual rate (EAR)? 2. Assume that you contribute $360 per month to a retirement plan for 15 years. Then you are able to increase the contribution to $720 per month for another 25 years. Given a 6.0 percent interest rate, what is the value of your retirement plan after the 40 years?