Financial accounting question You are evaluating two mortgage options. The terms of both mortgages are identicalexcept for their interest rates and compounding frequencies. Mortgage X offers arate of 5.75 percent, compounded quarterly. Mortgage Y offers a rate of 5.65 percent,compounded monthly. Which mortgage should you select and why?a. X; the annual percentage rate is 5.75 percentb. Y; the annual percentage rate is 5.65 percentc. X; the effective annual rate is 5.87 percentd. Y; the effective annual rate is 5.80 percente. The mortgages are equivalent offers so you can select either one.

Step 1: Define Effective Annual Rate (EAR)The Effective Annual Rate (EAR) represents the true annual…

Answered: You are evaluating two mortgage…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A mortgage has the following terms: Amount: $750,000 Rate: 6.25% Amortization (Years): 30 Term (Years): 20 Please determine the following: What is the Monthly Payment? In preparing an Income Statement, what is the Interest Expense for years 1 – 5? What is the Principal Balance at the end of year 6? What is the value of the loan at the expiration? If rates remain constant (flat), what would the benefit be to refinance this loan after year 10? do all the questions 1-5 and show the formulas in excel and show how you got it
You take out a 30-year mortgage, at a nominal annual rate of X%, with monthly compounding. Each month, you make exactly the required payment. Consider the following table of data from the amortization schedule: Month N N + 1 Beginning Balance Payment $1,322.14 Interest Principal Ending Balance $217,120.83 $216,404.82 Based on this information, what is the nominal annual interest rate (with monthly compounding) for this mortgage? Enter your answer in X.XX format (2 decimal places). For example, if your answer is 6.25%, enter "6.25".
You want to take a $172260 mortgage at j2 = 11.59 % and can afford topay up to $5030 per quartely. What repayment period in the whole years should you request ? What will be your payment year to repay mortgage in calculatednumber of years ?
Please eolve this question on excell and show formulas please.
You are interested in a fixed-rate mortgage for $399,500 and need to choose the between options: a 15-year mortgage or a 30-year mortgage. The current mortgage rate is 6.5% for the 15-year mortgage, and 3.75% for the 30-year mortgage. Both require a 15% down payment. (Hint: make use of the amortization formula from Chapter 12). (a) What are the monthly principal and interest payments for EACH loan? Show your work. (b) What is the total amount of interest paid on EACH loan? Show your work. (c) Overall, how much more interest is paid by choosing the 30-year mortgage? Show your work.
Consider a home mortgage of $150,000 at a fixed APR of 6% for 25 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. a. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.)
Calculate the original loan size of a fixed-payment mortgage if the monthly payment is $1,146.78, the annual interest rate is 8.0%, and the original loan term is 15 years.
Consider a home mortgage of $200,000 at a fixed APR of 3% for 25 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. a. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) b. The total amount paid over the term of the loan is $ (Round to the nearest cent as needed.) c. Of the total amount paid,% is paid toward is paid % toward (Round to one decimal place as needed.) the principal, the principal, and % is paid for interest. and
A price level adjusted mortgage (PLAM) is made with the following terms: Amount = $96,000Initial interest rate = 4 percentTerm = 30 yearsPoints = 6 percent Payments to be reset at the beginning of each year. Assuming inflation is expected to increase at the rate of 6 percent per year for the next five years: b. What is the loan balance at the end of the fifth year?c. What is the yield to the lender on such a mortgage? I am having trouble with b. and c.
Use an amortization table (Use Spreadsheet application such as Excel) that determines the monthly mortgage payment based on interest rate of 35% and a principal of GHS1000,000 with a 15-year maturity and then for a 30-year maturity. Is the monthly payment for the 15-year maturity twice the amount for the 30-year maturity or less than twice the amount? Explain.
Consider a home mortgage of $150,000 at a fixed APR of 6% for 30 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. a. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) b. The total payment over the term of the loan is $ (Round to the nearest cent as needed.) c. Of the total payment over the term of the loan, (Round to the nearest tenth as needed.) % is paid toward the principal and % is paid toward interest.
Consider a home mortgage of $225,000 at a fixed APR of 6% for 30 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. a. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) b. The total amount paid over the term of the loan is $ (Round to the nearest cent as needed.) c. Of the total amount paid,% is paid toward the principal, and % is paid for interest. (Round to one decimal place as needed.)

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS