FIN 350 Midterm Harford WINTER 2019

Suppose that you have two loan choices with monthly payments Choice Loan Amount Term (years) Interest Rate 1 $ 250,000 30 5% 2 $ 220,000 30 4.50% (a) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for the entire term and there are no origination costs for the two loans? Incremental Borrowing Cost: $3,254.72 (b) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for only 6 years (72 months) and there are no origination costs for the two loans? Incremental Borrowing Cost: $650.94

= Consider two loans with one-year maturities and identical face values: a(n) 8.4% loan with a 1.03% loan origination fee and a(n) 8.4% loan with a 4.5% (no-interest) compensating balance requirement. Which loan would have the higher effective annual rate? Why? The EAR in the first case is%. (Round to one decimal place.) er cl

The bank offers you the following three options to pay back the loan from the previous question: I: To pay the interest of 6.00% annually II: To pay an interest of 0.49% monthly III: To pay an interest of 1.46% quarterly Which of these three options would be most beneficial for you? O All three options would be equally beneficial Option II ○ Option III Option I O Option II and Option III would be equally beneficial

Please answer fast i give you upvote.

Hello Can you show how to calculate the compensating balance requirement? In my solution guide i have this: 76/953 = 7.975% My question: Why do we devide 76/953 and not say 1076/953 to calulate the effective annual cost?

In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12.

K Find the APR (true annual interest rate), to the nearest 0.01%, for the loan given below. Purchase Price Add-On Interest Rate $4350 3.7% Down Payment $380 Number of Payments 12 *** The APR for the loan amount is%. (Type an integer or decimal rounded to the nearest hundredth as needed.)

Need all four quest...

Solve the problem. Round money to the nearest cent, rate to the nearest tenth of a percent, and time to the nearest day. Find the maturity value of a loan at 7,6% for 8 months if the principal is $21,890. O $23.137.73 O $22,860.46 O $23,099.92 O$22.999.09 D Question 17 Solve the problem. Round money to the nearest cent, rate to the nearest tenth of a percent, and time to the nearest day. Jane Clark borrowed some money from her bank. After 242 days, she paid a maturity value of $11,751, which included interest of $844. Find the interest rate on her loan. O 11.5% O 12.2% O 11.4% O 11.2%

What discount rate should a lender charge to earn an interest of 2 1/4 % on a 90-day loan? Hint: An interest rate r and discount rate d are said to be equivalent if these two simple rates give the same present value for an amount due in the future. Thus, r = d/(1 - dt) and d = r/(1 + rt)

65

which of the following statements are true? 1. there is an inverse relationship between interest rates and future vales 2. the effective annual interest rate (EAR) will be higher than the annual percentage rate (APR) for a loan that compounds interest annually 3. there is an inverse relationship between present value and interest rates 4. all else equal, the more frequent interest in compounded on a loan, the more interest you will have to pay.

I would appreciate it If you could also explain how to plug this into a financial calculator

Suppose the interest rate is 3.6% b. Having $650 in one year is equivalent to having what amount today? c. Which would you prefer, $650 today or $650 in one year? Does your answer depend on when you need the money? Why or why not? **round to the nearest cent**

If the proceeds of a loan of P12,450 will be paid with P12,840 at the end of 1 year and 9 months. What is the simple interest discount rate? A. 1.75% В. 1.74% С. 1.73% Answer:

Finding the Interest Rate: Concept Connection Example 6-3 (page 237) 18. What interest rates are implied by the following lending arrangements? a. You borrow $500 and repay $555 in one year. b. You lend $1,850 and are repaid $2,078.66 in two years. c. You lend $750 and are repaid $1,114.46 in five years with quarterly compounding. d. You borrow $12,500 and repay $21,364.24 in three years under monthly compounding. (Note. In parts c and d, be sure to give your answer as the annual nominal rate.) Lasher, William R.. Practical Financial Management (Page 276). South-Western College Pub. Kindle Edition.

Please help I'm confused what is the difference?  Answer Both Questions I'll rate!

Use one of excel's TVM functions among =PV, =FV, =PMT, =RATE, =NPER, =CUMIPMT, =CUMPRINC answer this questions. (Please input the functions in excel and screeshot it )

If you borrow $9000 at an annual percentage rate (APR) of r (as a decimal) from a bank, and if you wish to pay off the loan in 3 years, then your monthly payment M (in dollars) can be calculated using:  M = 9000 (er/12-1) / 1 - e-3r 1) Describe what M (0.035) would represent in terms of the loan, APR, and time. 2) If you are only able to afford a max monthly payment of $300, describe how you could use the above formula to figure out what the highest interest rate the bank could offer you and you would still be able to afford the monthly payments. In addition, determine the maximum interest rate that you could afford.

uestion 1: Solve the following TVM problems using Excel formulas. You MUST use Excel formulas (FV or PV) to receive credit. ou can assume that all payments are made at the beginning of the period and use "1" for the "type" argument in the formula. A. Suppose you invest 11,400 today. What is the future value of the investment in 29 years, if interest at 7% is compounded annually? B. Suppose you invest $ 11,400 today. What is the future value of the investment in 29 years, if interest at 7% is compounded quarterly? C. Suppose you invest $ 570 monthly. What is the future value of the investment in 29 29 years, if interest at + 5% is compounded monthly? 5 6 7 8 19 20 21 22 23 24 25 26 27 28 29 Question 1 Question 2 + Ready Accessibility: Investigate MAR 17 A 国 W X

3. I can borrow from two different banks. One of them is charging me 6.75% APR compounded monthly and the other one charges me 6.65% APR compounded weekly. What is the effective annual rates for each one and which one should I choose? (Show Work)

rive loan is below. Payments of $1,987.26 are made monthly. Payment # Payment 1 1,987.26 2 1,987.26 3 1,987.26 Interest Debt Payment Balance 1,604.17 383.09 1,602.41 384.85 1,600.65 386.61 Provide your answer below: X Y Z Calculate the value of z, the balance of the loan at the end of month 3. Give your answer to the nearest dollar. Do not include commas or the dollar sign in your answer.

Find the effective yield on a discount loan with the given discount rate r and the time. (Round your answer to two decimal places.) r = 2%, 2 months

Calculate the CAT (total annual cost) for option 1 and then find which option is better to ask for a loan and explain why is it better.   1. Personal Loan         MNL Bank          2.25% simple monthly interest rate         2. Savings Bank CAT= 30% 3. XYZ Bank  CAT= 28.30% 4. 123 Bank  CAT= 26.64%

Suppose that you want to avoid paying interest and decide you'll only buy the furniture when you have the money to pay for it. An annuity is basically the opposite of a fixed-installment loan: you deposit a fixed amount each month and receive interest based on the total amount that's been saved. The future value formula is: 12t 12 [(1 - - - - ] 1 12 A = r where is the regular monthly payment, ▾ is the annual interest rate in decimal form, and ʼn is the term of the annuity in years. If you chose an annuity with a term of two years at 4.8% and a monthly payment of $120, the future value would be $3016.45. Recalculate the future value amount if you're willing to raise your monthly payment $20 per month. Round your answer to the nearest cent. The future value would be $ X

I need the excel function typed out? Example =RATE???? G. Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate!                             INPUTS:     OUTPUT:           Period   27 Rate is   APR       Payment   2229.45             Loan amount   358000

FOLLOW THE FORMULAS GIVEN ABOVEDOWNVOTE IF YOU DONT FOLLOW THE FORMULAS