A loan officer states, "Thousands of dollars can be saved by switching to a 15-year mortgage from a 30-year mortgage." Calculate the difference in required monthly payments on a 30-year mortgage loan at a rate of 3.5% vs. a 15-year mortgage at a rate of 3.0%. Assume both mortgages are for $100,000 and require monthly payments.  Then, comment on what you notice and where do the "savings" come fro

Use the advice given in the text from most financial advisors regarding mortgages to solve the problem. 1) Suppose that your gross annual income is $108,000. 1) (a) What is the maximum amount you should spend each month on a mortgage payment? (b) What is the maximum amount you should spend each month for total credit obligations? (c) If your monthly mortgage payment is 75% of the maximum amount you can afford, what is the maximum amount you should spend each month for all other debt? A) (a) $2520; (b) $3240; (c) $1350 B) (a) $2520; (b) $3240; (c) $90 C) (a) $2520; (b) $3240; (c) $1890 D) (a) $30,240; (b) $38,880; (c) $16,200 Use the preference table to answer the question. 2) The preference table shows the results of an election among A, B, and C. 42 C B A First choice Second choice A A B Third choice B C C nothed who is the winner and (b) Is the majority criterion satisfied? Number of votes 10 2)

Suppose your gross monthly income is $5,300 and your current monthly payments are $525. If the bank will allow you to pay up to 36% of gross monthly income (less current monthly payments) for a monthly house payment, what is the maximum loan you can obtain if the rate for a 30-year mortgage is 4.65%? (Round your answer to the nearest cent.)

You can afford a $1400 per month mortgage payment. You've found a 30 year loan at 7.9% 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.)$c) How much of that money is interest? (Round to the nearest cent, as needed.)$

Please show how to solve this using an Excel spreadsheet and please show the formulas. The maturity of the balloon loan is 5 years, amortization period is 30 years, loan amount is $85,000 with annual interest rate 4.5% and monthly payments. What is the monthly payment for this balloon mortgage? What is the balloon payment at the end of five years for this balloon mortgage?

You can afford a $1500 per month mortgage payment. You've found a 30 year loan at 5.7% 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.)c) How much of that money is interest? (Round to the nearest cent, as needed.)

You can afford an $800 per month mortgage payment. You found a 30-year loan at 6% interest. How big of a loan can you afford?  How much will you pay the loan company? How much of that money is interest?

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)?

The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-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 advice about which mortgage to choose. G. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.

Please provide answer to part b of the question. Please answer by using formula, not excel.