Please show how to solve this step by step using Excel to answer a. and b.  You want to buy a house for main residence and have the following four choices of mortgage with monthly payments. Suppose that your marginal tax rate is 25% and the market index will stay 10.5% after year 5. a. If you hold the loan for the entire term, what is the annual effective cost of each mortgage before-tax? b. If you hold the loan for the entire term, what is the annual effective cost of each mortgage after-tax?

Suppose you need to borrow $200,000 to buy a home, and you are deciding between a 15 year mortgage and a 30 year mortgage. Research a bank offering 15 year and 30 year mortgage loans and find the interest rates on those loans. Use the techniques you learned in this Module to do the following:    1.  Calculate the monthly payment for a 15-year mortgage and for a 30-year mortgage.   2.  Find the total amount of interest you will pay on the 15 year mortgage and on the 30         year mortgage.   3.  Describe some of the factors (financial and non-financial) that can influence whether         to obtain a shorter term mortgage or a longer term mortgage.    4.  Which mortgage would you take, the 15 year or the 30 year? Explain your decision.

Suppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…

Please show how to solve this unsing excel and please show all formulas in the spreadsheet. You decide to buy a house with price of $500,000, You put 20% down payment and consider a 15-year fixed rate mortgage to pay the remaining balance. The lender offers you three choices of the mortgage with monthly payments shown in the table as a., b., and c. Assume that the origination cost is $8,000. A. If the loan will be outstanding for 15 years, what is the effective cost for each choice? Which choice is most ideal? explain? B. Which mortgage choices are not properly priced? explain?

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

Use the following to solve questions a. and b. with an excel spreadsheet and please show the formulas on the excel spreadsheet.  A house with price of $250,000 20% down payment, loan amount $200.000 30-year fixed rate mortgage with interest rate as follows: Suppose that there is $2,500 origination cost.  a. Which choice would you like to choose if you will live in the house for 30 years?  b. Which choice would you like to choose if you will live in the house for 5 years?

Suppose you purchase a house using a 30-year fixed rate mortgage. The APR on the loan is 3.2% and you will be required to make monthly payments of $3,700 what is the price you paid for your home?

Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission.      $808.28     $853.18     $527.78

(Q) You would like to purchase a home and are interested to find out how much you can borrow. When your lender calculates your debt to income ratio, he determines that your maximum monthly payment can be no more than $3, 200. You would like to have a 30 year fully amortizing loan and the interest rate offered on such a loan is currently 8.5%. Given these constraints, what is the largest loan you can obtain?

Suppose your gross monthly income is $5,200 and your current monthly payments are $425. 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.) Need Help? Read It Submit Answer