mortgage IO and PO computer assignment - HW

✅✅✅✅✅✅✅✅

Payment # Payment Interest Debt Payment Balance 1 1,167.34 540.54 626.80 259,873.20 2 1,167.34 539.24 628.10 259,245.10 3 1,167.34         With the exception of column one, all amounts are in dollars. Calculate the annual interest rate on this loan.

Question Consider the first payment against a $200,000 mortgage that last for 25 years. Fixed repayments are made on a monthly basis. The first row of the amortization schedule is shown below. Payment # 1 2 Payment d Interest 716.67 ... Debt Payment P1 Calculate d, the fixed monthly payments that are made. Round your answer to the nearest cent. Balance b₁ Ih

Question content area top Part 1 Calculate the monthly payments of a 3030​-year ​fixed-rate mortgage at 6.006.00 percent for ​$136 comma 200136,200. How much interest is paid over the life of the​ loan?   ​Note: Round intermediate computations to at least five​ (5) decimal places. Click on the table icon to view the Monthly Installment Loan Payment Factor​ (MILPF) table: LOADING... .       Question content area bottom Part 1 The monthly payments of a 3030​-year ​fixed-rate mortgage at 6.006.00​% for ​$136 comma 200136,200 is ​$817.2817.2. ​(Round to the nearest​ cent.) Part 2 The amount of interest paid over the life of the loan is ​$enter your response here. ​(Round to the nearest​ cent.)

ONLINE 721757 K Complete the first month of the amortization schedule for a fixed-rate mortgage. Mortgage: $110,000 Interest rate: 6.5% Term of loan: 25 years Click the icon to view the Real Estate Amortization Table. Payment Number 1 Amortization Schedule Total Payment Interest Payment Principal Payment Balance of Principal (a) $ (b) $ (b) $ (d) $

Hai Mortgage Icepts Excel Assignment: Module 7 1. Origination Fees and Discount Points without Prepayment A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800 origination fee and 2.5 discount points. A borrower wants a loan for $538,000. What is the yield to the lender, the effective borrowing cost to the borrower, and the APR assuming the loan is held to maturity? Use both the IRR and RATE functions in the green highlighted cells as indicated. Loan Amount Annual Interest Rate Origination Fee Discount Points Maturity (in years) Periods per year $538,000.00 4.50% $800.00 2.50% Month 30 12 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Cash Flow -$523,750.00 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2,725.97 $2.725.97 Using IRR Function Yield to Lender Effective borrowing cost to borrower APR Using…

Amortization table (mortgage principal and interest per $1,000) [¹ Rate 2.000 2.125 2.250 2.375 2.500 2.625 2.750 2.875 3.000 3.125 3.250 3.375 3.500 3.625 3.750 3.875 4.000 4.125 4.250 4.375 4.500 4.625 4.750 4.875 5.000 5.125 5.250 5.375 5.500 5.625 5.750 5.875 6.000 6.125 6.250 6.375 6.500 6.625 6.750 6.875 Interest Only 0.16667 0.17708 0.18750 0.19792 0.20833 0.21875 0.22917 0.23958 0.25000 0.26042 0.27083 0.28125 0.29167 0.30208 0.31250 0.32292 0.33333 0.34375 0.35417 0.36458 0.37500 0.38542 0.39583 0.40625 0.41667 0.42708 0.43750 0.44792 0.45833 0.46875 0.47917 0.48958 0.50000 0.51042 0.52083 0.53125 0.54167 0.55208 0.56250 057292 10 Year 9.20135 9.25743 9.31374 9.37026 9.42699 9.48394 9.54110 9.59848 9.65607 9.71388 9.77190 9.83014 9.88859 9.94725 10.00612 10.06521 10.12451 10.18403 10.24375 10.30369 10.36384 10.42420 10.48477 10.54556 10.60655 10.66776 10.72917 10.79079 10.85263 10.91467 10.97692 11.03938 11.10205 11.16493 11.22801 11.29130 11.35480 11.41850 11.48241 11 54653…

B 9

What is the difference in interest paid between a 30-year mortgage loan and a 15-year mortgage loan both of $72700 if the annual interest rate is 5% a. $27262.50 b. $54525.00 c. $37012.40 d. $10348.38

Financial accounting question

Subparts A-C are completed, please only complete D - G. Previous subpart answers: A. $ 851.68 B. $147,797 C. 7.50% Assume the following for a one-year adjustable rate mortgage loan that is tied to the one-year Treasury rate: Loan amount: Annual rate cap: Life-of-loan cap: Margin: First-year contract rate: One-year Treasury rate at end of year 1: One-year Treasury rate at end of year 2: Loan term in years: Required: Given these assumptions, calculate the following: a. Initial monthly payment. b. Loan balance end of year 1. $ 150,000 2% 5% 2.75% 5.50% 5.25% 5.50% 30 c. Year 2 contract rate, assuming the annual cap applies to the teaser rate. d. Year 2 monthly payment. e. Loan balance end of year 2. f. Year 3 contract rate, assuming the annual cap applies to the teaser rate. g. Year 3 payment.

excel 7. Using a Spreadsheet to Calculate Mortgage Payments: What is the monthly payment on a $150,000, 30-year mortgage if the mortgage rate is 5.75 percent? 6.25 percent? 7.5 percent? 9 percent? (LG 7-4) Periods Present Interest Rate The Payment Will Be Value $150,000 30 x 12 5.75%/12 150,000 30 x 12 6.25%/12 150,000 150,000 30 x 12 30 x 12 7.50%/12 9.00%/12 $ 875.36 923.58 1,048.82 1,206.93

Please help

Help please

ch 3. A fully amortizing mortgage is made for $100,000 at 6.5% interest. If the monthly payments are $1000 per month, then when will the loan be repaid? 4. A partially amortizing mortgage loan is made for $60,000 for a term of 10 years. The borrower and lender agree that a balance of $20,000 will remain and be repaid as a lump sum at that a. If the interest rate is 7%, what must monthly payments be over the 10 year term? b. If the borrower chooses to repay the loan after five years instead of at the end of year 10, then what will the loan balance be at the end of year 5? 5. A fully amortizing CAM loan is made for $125,000 at 11 percent interest for 20 years. a. What will be the monthly payments and remaining loan balances for the first six months? b. c. What would monthly payments be if the loan were CPM instead? If both loans (the CAM and CPM) are repaid at the end of year 5, would the lender earn a higher rate of interest on either loan? Which one and why? Use Excel. 6. A $100,000…

Question 7: Answer

6

K Make an amortization table to show the first two payments for the mortgage. Amount of mortgage Annual interest rate Years in mortgage Monthly payment $407,292 5.50% 35 $2187.22 Monthly End-of-month Month Interest Principal payment principal 1 $2187.22 2 $2187.22 $ (Round to the nearest cent as needed.)

Question content area top Part 1 Make an amortization table to show the first two payments for the mortgage.   Amount of mortgage Annual interest rate Years in mortgage Monthly payment ​$405,398 5.25​% 35 ​$2111.08

Based on Exhibit 7-7, what would be the monthly mortgage payments for each of the following situations? (Round your answers to 2 decimal places.) a. A $161,000, 15-year loan at 5.5 percent. b. A $216,000, 30-year loan at 6 percent. c. A $192,000, 20-year loan at 5.5 percent.

K Use PMT= 31¬ [₁-3] a. Find the monthly payments and the total interest for the loan. b. Prepare a loan amortization schedule for the first three months of the mortgage. to determine the regular payment amount, rounded to the nearest cent. The cost of a home is financed with a $130,000 20-year fixed-rate mortgage at 4.5%. nt a. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) 1 2 The total interest for the loan is $ (Use the answer from part a to find this answer. Round to the nearest cent as needed.) b. Fill out the loan amortization schedule for the first three months of the mortgage below. Payment Number Interest $1 $ 3 $ (Use the answer from part a to find these answers. Round to the nearest cent as needed.) Principal $ $ $ Loan Balance $ S 4

Help me get correct answer A thru D