The Becker family is getting a home loan to finance a $260,000 mortgage.While looking for a mortgage, they found two alternatives:Mortgage A30-year loan with an interest rate of 3.611% and a monthly payment of$1,184.Mortgage B15-year loan with an interest rate of 2.7%Recall:Loan Payment Formula.png|A. Calculate the total amount paid for Mortgage A.B. Calculate the total interest paid for Mortgage A.C. Calculate the monthly payment for Mortgage B.D. Calculate the total amount paid for Mortgage B.E. Calculate the total interest paid for Mortgage B.F. Write a two or more sentences giving the Becker family some adviceabout which mortgage to choose.G. Why might the Becker family not take your advice from part c)?Answer in one or two sentences.

Loan re-payments are done through periodic fixed amounts or sums. The periodic payments include both…

Answered: A. Calculate the total amount paid for…

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

Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the information below! You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
PA Use PMT= to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $217,000. The bank requires a 20% down payment and three points at the time of closing. The cost of the home is financed with a 30-year fixed-rate mortgage at 7%. Complete parts (a) through (e) below. a. Find the required down payment. $ b. Find the amount of the mortgage. c. How much must be paid for the three points at closing? S (Round to the nearest dollar as needed.) d. Find the monthly payment (excluding escrowed taxes and insurance). S (Round to the nearest dollar as needed.) e. Find the total cost of interest over 30 years. (Round to the nearest dollar as needed.)
Suppose you take out a $185,500 mortgage for 30 years at 5.15% interest. (a) Find the monthly payment on this mortgage. S (b) Fill out the first two rows of the amortization schedule below. Round your answers to the nearest dollar. Payment Number Interest Payment Principal Payment Balance of Loan 1 2 Question Help: D Video M Message instructor D Post to forum
Please build an excel spreadsheet and show the formulas to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
1. Consider a home mortgage of $150,000 at a fixed APR of 4.5% 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. 2. Someone needs to borrow $11,000 to buy a car and the person has determined that monthly payments of $225 are affordable. The bank offers a 3-year loan at 7% APR, a 4-year loan at 7.5%, or a 5-year loan at 8% APR. Which loan best meets the person's needs? Explain. Question content area bottom Part 1 Which loan best meets the person's needs? (Round to the nearest cent as needed.) A. The first loan best meets the person's needs because the monthly payment of $enter your response here is less than the maximum budgeted amount of $225 per month. B. The second loan best meets the person's needs because the monthly payment of $enter your response here…
1. Assuming the cost of mortgage is $400,000, and the owner of the house makes a down payment of $40,000, with 8% interest rate and 10 years repayment plan. a. calculate the total amount of loan, monthly rate, number of payment periods, monthly payment, total interest paid, and amount borrowed. b. With the aid of what PMT function in a one variable condition, calculate monthly payment, total amount payable, total interest payable for: 12 yrs, 16 yrs, 20 yrs ,25 yrs, 30 yrs, 35 yrs mortgage.
You can afford a $1200 per month mortgage payment. You've found a 30 year loan at 6.1% interest. a) How big of a loan can you afford? (Round to the nearest cent, as needed.) b) How much total money will you pay the loan company? (Round to the nearest cent, as needed.) S c) How much of that money is interest? (Round to the nearest cent, as needed.) Question Help: Video 1 Submit Question Video 2 Search wwww.gar a
1. You plan to buy a $100,000 home using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8.25 percent. You will make a down payment of 20 percent of the purchase price. 1. Calculate your monthly payments on this mortgage. 2. Calculate the amount of interest and, separately, the principal paid in payment 25. 3. Calculate the amount of interest and, separately, the principal paid in payment 225. 4. Calculate the amount of interest paid over the life of this mortgage.
You plan to purchase a S100,000 house using a 30-ycar mortgage obtained from your local credit union. The mortgage rate offered to you is 8.25 percent. You will make a down payment of 20 percent of the purchase price. 1. (LG 7-4) a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, princi- pal paid in thc 25th payment. e. Caleulate the amount of interest and, separately, princi- pal paid in the 225th payment. d. Calculate the amount of interest paid over the life of this mortgage.
Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's monthly payments be on his mortgage? b. Amortize the loan and determine: Interest expense for the first quarter of the loan. Cash flows for the first quarter of the loan. Loan balance at the end of the first quarter of the loan. Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.
Suppose that you decide to borrow $13,000 for a new car. You can select one of the following loans, each requiring regular monthly payments. Installment Loan A: three-year loan at 6.3% Installment Loan B: five-year loan at 4.8% P. Use PMT = to complete parts (a) through (c) below. - nt 1- a. Find the monthly payments and the total interest for Loan A. The monthly payment for Loan A is $. (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for Loan A is $. (Round to the nearest cent as needed.) b. Find the monthly payments and the total interest for Loan B. The monthly payment for Loan B is $. (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for Loan B is $. (Round to the nearest cent as needed.) MacBook Air
You own a home that was recently appraised for $370,000. The balance on your existing mortgage is $117,350. If your bank is willing to loan up to 70% of the appraised value, what is the potential amount (in $) of credit available on a home equity loan? $ Need Help? Read It Watch It Master It

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