As a graduating senior with a promising career in finance, Central Bank offers you a mortgage of $200,000. You may choose between a 30-year mortgage with an interest rate of 4.375% or a 15-year mortgage at 3.500%. Both interest rates are annual stated rates with interest compounded monthly. Assume that for 30-year mortgage, the bank requires you to pay 1% point. Compute an amortization table that shows the amount of interest you can report for taxes and amount of principal payment each year for each loan. Use two different ways to do it as we did in class: with and without using the functions PPMT and IPMT. PLEASE USE EXCEL and show functions

You purchase a home costing $480,000 with a 20% down payment. After shopping around for a mortgage, you select a lender who offers you two options for 30-year mortgages with monthly payments: Option I: A rate of 2.75% (APR) and an upfront fee (due immediately) of $3,840 Option II: A rate of 2.65% (APR) and an upfront fee (due immediately) of $9,600. a. Compute the monthly loan payment for each option. b. Compute the outstanding loan balance after 10 years for each option. c. If you prefer a lower true interest rate, which one should you choose? d. If you anticipate staying in the house for 10 years, which option should you choose?

You have just purchased a home and taken out a $550,000 mortgage. The mortgage has a 30-year term with monthly payments and an annual percentage rate (APR) (with semi-annual compounding) of 6.80%. (Note: Be careful not to round any intermediate steps less than six decimal places.) a. How much will you pay in interest, and how much will you pay in principal, during the first year? b. How much will you pay in interest, and how much will you pay in principal, during the twentieth year (i.e., between 19 and 20 years from now)? a. How much will you pay in interest, and how much will you pay in principal, during the first year? During the first year, you will pay an interest payment of $ (Round to the nearest dollar.) During the first year, you will pay a principal payment of $ (Round to the nearest dollar.)

You can afford a $1300 per month mortgage payment. You've found a 30 year loan at 6% interest.a) How big of a loan can you afford?$b) How much total money will you pay the loan company?$c) How much of that money is interest?

A lender offers you a $125,000, 30 year mortgage with monthly payments of $769.65. What’s the interest rate?

Assume that a broker agent introduces you to a local bank, and that bank offers you their lowest interest rate at 3.25% APR, with a 10-year fixed interest rate or 20-year fixed interest rate. 1)  If you want a 10-year, fixed mortgage loan, find the monthly mortgage payment for a house that you will borrow $500,000 with no down payment. 2)  Determine the total amount paid over the full term of the loan. 3)  How much interest will be paid on the loan over the 10 years?

Your bank offers the following options on a $100,000 mortgage: i) A 15-year, 4% loan with no points ii) A 15-year, 3.5% loan, with 1.5 discount points If you plan to repay the loan in five years, what is the present value of the savings from having a lower outstanding balance at the end of the 5 years if you choose the option with points? (Use the 3.5% interest rate to discount the savings). [Hint: you first need to compute the outstanding balance at the end of year 5 for each option] $765.87 None of the above. $643.08 $1,000 please typing format

Suppose that you take out an unsubsidized Stafford loan on September 1 before your junior year for $45004500 and plan to begin paying it back on December 1 after graduation and grace period 27 months later. The interest rate is 6.8%. How much of what you will owe will be interest?$Round your answer to the nearest cent.

You obtain a 15-year loan at a fixed annual 6% on a $100,000 condo with no required down payment. Calculate your monthly mortgage payment.

Please eolve this question on excell and show formulas please.