Calculate the effective annual rate, Financial Management

Assignment Help:
I keep getting different answers in excel and the financial calculator. is there someone who can walk me through this problem step by step:

You plan to buy a new house for $250,000. You will definitely put $50,000 down, but you are unsure as to how to finance the remainder. The bank will give you a 30-year loan at an annual rate of 5% compounded monthly (first payment in one month). But, you also know that a mortgage broker will give you a 20-year loan with quarterly payments of $4,200.

A. Calculate the effective annual rate (EAR) for each loan.

B.Based on your answer to Part A, which loan should you choose? Briefly explain.

Related Discussions:- Calculate the effective annual rate

Cash flow duration, Cash flow duration, like effective duration, cons...

Cash flow duration, like effective duration, considers the change in the cash flow due to prepayment with the change in the interest rate. In effective duration,

Formulation of collection policy, Q. Formulation of Collection Policy ? ...

Q. Formulation of Collection Policy ? Formulation of Collection Policy:- The third characteristic of the receivable management is to formulate a collection policy. Collection p

What is percentage of sales method, Q. What is Percentage of Sales Method? ...

Q. What is Percentage of Sales Method? Percentage of Sales Method: - Under this process certain key ratios based on past year's information are established. These ratios is abl

return on equity, Lee Sun's has sales of $6,000, total assets of $5,000, a...

Lee Sun's has sales of $6,000, total assets of $5,000, and a profit margin of 10 percent. The firm has a total debt ratio of 40 percent. What is the return on equity?

Explain basril plc, BASRIL PLC (a) (i) Analysis of projects assum...

BASRIL PLC (a) (i) Analysis of projects assume they are divisible. Project 2 NPV at 12% = (140800 × 3·605) - 450000 = $57584 Project 2 profitability index = 5

Define the wave of mergers in the banking industry, What is behind the wave...

What is behind the wave of mergers in the banking industry? A: Various economic factors have caused banking institutions to merge over the past various years. These factors inclu

Calculate the present value and determine the npv, Assume today is 3 Decemb...

Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently employed as a personal banker for ANZ banking group in Sydney and earns $380

Define foreign exchange transaction among international bank, How are forei...

How are foreign exchange transactions between international banks settled? Answer:  a network of correspondent banking relationships is known as the interbank market with large c

Use npv method to show your calculations, Xcell engineering is planning to ...

Xcell engineering is planning to construct a futsal stadium which has 5 courts to be rented out at any point of time. Its initial cost of investment is RM$280,000. It is expected t

Why do analysts calculate financial ratios, Why do analysts calculate finan...

Why do analysts calculate financial ratios? The comparative measures are known as Ratios. Since the ratios show relative value, they permit financial analysts to compare inform

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd