Question

(This problem can be done using either a spreadsheet or your financial calculator. In either case,...

(This problem can be done using either a spreadsheet or your financial calculator. In either case, show all of your work. In the case of a spreadsheet, please print out the entire spreadsheet and indicate where your answers to the various parts of this problem can be found.)A borrower is given a choice between taking out a CPM loan for $250,000 at an interest rate of four percent (4.00%), or to pay two points and receive an interest rate of 3.75% on the loan. Both loans are for thirty (30) years.a. What would the monthly payments be on the 4% loan?b. If the borrower pays for the points upfront with a check, what will the monthly payments be?c. If the borrower decides to add the points into the amount that is being borrowed, what will the monthly payments be?d. Based on the effective annual yield, which of these three possibilities results in the lowest cost to the borrower?

0 0
Add a comment Improve this question Transcribed image text
Answer #1


CASEA CA兆 CASED Effective nual ials-ml) L003338 12

Add a comment
Know the answer?
Add Answer to:
(This problem can be done using either a spreadsheet or your financial calculator. In either case,...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. (This problem can be done using either a spreadsheet or your financial calculator. In either...

    1. (This problem can be done using either a spreadsheet or your financial calculator. In either case, show all of your work. In the case of a spreadsheet, please print out the entire spreadsheet and indicate where your answers to the various parts of this problem can be found.) A CPM loan is made for $50,000 at 5 percent interest for 30 years. Calculate: a. The monthly payments for principal and interest. b. Interest and principal payments during month 1....

  • can I please have help with this? how would I calculate this in a financial calculator?...

    can I please have help with this? how would I calculate this in a financial calculator? Calculate the effective cost of the following loan if the borrower Loan amount: $100,000; Term: 30 years a. 8.285% b. C. prepays at the end of year 3 Interest rate: 7.5%; Monthly Payment: 5% prepayment penalty over entire te mn 8.645% 8.935% None of the above d. 20. You borrow $100,000 mortgage with monthly payments. You can either choose 15-year term wi choose 30-year...

  • Problem 1 (Required, 25 marks) A borrower has borrowed $2000000 from the bank. It is given...

    Problem 1 (Required, 25 marks) A borrower has borrowed $2000000 from the bank. It is given that the loan charges interest at an annual effective interest rate 16.0755% and compound interest is assumed. (a) Suppose that the borrower decides to repay the loan by 180 monthly payments made at the end of every month, (i) Using retrospective method, calculate the outstanding balance at 60th repayment date. (ii) Calculate the interest due and principal repaid in 120th repayment. (b) Suppose that...

  • An investor has $60,000 to invest in a $280,000 property. He can obtain either a $220,000...

    An investor has $60,000 to invest in a $280,000 property. He can obtain either a $220,000 loan at 9.5 percent for 20 years or a $180,000 loan at 9 percent for 20 years and a second mortgage for $40,000 at 13 percent for 20 years. All loans require monthly payments and are fully amortizing. Which alternative should the borrower choose, assuming he will own the property for the full loan term? Would your answer change if the borrower plans to...

  • May I please have help with these? also how would I put this in the calculator?...

    May I please have help with these? also how would I put this in the calculator? For 26-30) A borrower is faced with choosing between two mortgages: Loan B 80,000 25 yr 10.5% 2 pt 496 Loan A Loan amount Term Interest rate Discount points Prepayment penalty 80,000 25 yr 10% 5 pt 0% Assuming monthly payments, if the loans are a. Loan A b. Loan B c. Both loan are same d. Can not determined with the info given...

  • You need a new car. You can either lease or buy the car for 365 000...

    You need a new car. You can either lease or buy the car for 365 000 SEK. In both cases you expect to use the car for 5 years. It will have a residual value of 120 000 SEK after 5 years. You can borrow at a rate of 3.5% APR with monthly compounding. (a) In case you buy the car you will take an annuity loan over 5 year at a borrowing rate of ${col}%. What will be your...

  • You need a new car. You can either lease or buy the car for 365 000...

    You need a new car. You can either lease or buy the car for 365 000 SEK. In both cases you expect to use the car for 5 years. It will have a residual value of 120 000 SEK after 5 years. You can borrow at a rate of 3.5% APR with monthly compounding. (a) In case you buy the car you will take an annuity loan over 5 year at a borrowing rate of ${col}%. What will be your...

  • Develop a spreadsheet model to determine how much a person or a couple can afford to...

    Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 28​% of monthly gross income. From​ this, you must subtract total nonmortgage housing​ expenses, which would include insurance and property taxes and any other additional expenses. This defines the affordable monthly mortgage payment. In​ addition, guidelines also suggest that total affordable monthly debt​ payments, including housing​...

  • Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 4.75% for...

    Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 4.75% for 30 years, monthly payments. The lender will charge you two discount points and the loan has a 3% prepayment penalty. A. (1 pt) What is the annual percentage rate (APR) of the loan? Answer: _______ B. (1 pt) How many points are required to yield an APR of 5.25%? Answer: _______ Suppose you take a fixed-rate mortgage for $200,000 at 5.00% for 30 years,...

  • May I please have help with 19 and 20 and how to solve them ? Calculate...

    May I please have help with 19 and 20 and how to solve them ? Calculate the effective cost of the following loan if the borrower prepays at Loan amount $100,000, Term: 30 years; Interest rate: 75% Monthly Payment, b. 8.645% d. None of the above the end of year 3 8.285% 5%prepayment penalty over c 8.935% 20. You borrow $100,000 choose 30-year term payment between these two mortgages? a. $84,854 b. $102,366 c. $125,786 d. None of the above...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT