(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?
(This problem can be done using either a spreadsheet or your financial calculator. In either case,...
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?
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 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...
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...
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,...
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 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...
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...
Forums Calendar Gradebook MATSUBARA> Assessment ities and Loans You want to buy a $206,000 home. You plan to pay 15% as a down payment, and take out a 30 year loan for the rest a) How much is the loan amount going to be? b) what will your monthly payments be if the interest rate is 6%? c) what will your monthly payments be if the interest rate is 7%? Get help: Video Points possible 1 Unlimited attempts Submit
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...