1: Set up a generic amortization schedule in Excel for a 30 conventional fixed rate mortgage, use reference cells everywhere possible. 2: Calculate Lenders Yield & Borrower's EBC Use the following data for part 2: Purchase price: 850,000 LTV = 75% 30 year mortgage, monthly payments Contract Interest Rate: 5.75% Points paid by borrower: 2% Other fees paid to third parties: Appraisal fee = 1000 Title Insurance = 2000

1: Set up a generic amortization schedule in Excel for a 30 conventional fixed rate mortgage, use reference cells everywhere possible. 2: Calculate Lenders Yield & Borrower's EBC Use the following data for part 2: Purchase price: 850,000 LTV = 75% 30 year mortgage, monthly payments Contract Interest Rate: 5.75% Points paid by borrower: 2% Other fees paid to third parties: Appraisal fee = 1000 Title Insurance = 2000

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 13P

See similar textbooks

Similar questions

1. A loan with the following terms is being made: Fixed rate, constant payment 9% interest rate $70,000 desired mortgage amount. $1,500 loan discount points paid by the buyer/borrower to the lender 25-year term, monthly payments a. Calculate the APR for federal truth-in-lending purposes (assume that the discount points are paid up front by the borrow and rolled into the loan principal). b. Do you think that the APR calculated in (a) reflects the likely return that the lender will receive over the term of the loan? List specific reasons that the lender's actual return might be different than the APR.
Calculation need to be done in "Excel format"
1. Excel: Complete the amortization table provided in the Excel document posted in Ivylearn in the homework area by setting the appropriate values for a $165,000, 30-year mortgage at 4.5% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: a. How much of the first payment goes towards the principal? How much goes toward the interest? b. How much of the last payment goes towards the principal? How much goes toward the interest? c. Find the total interest paid by the end of the mortgage. d. How much will be owed on the mortgage after making payments for 10 years (hint this is 120 months)? e. How much interest has been paid total on the mortgage at the end of 10 years? f. How many months will it take to pay at least half of the principal?
please answer in excel
3. Find the payment necessary to amortize the following loans using the amortization table, and round to the nearest cent if needed. Amount of Loan: $12000 Interest Rate: 6% Payments Made: semiannually Number of Years: 8
Using this table as needed, calculate the required information for the mortgage. (Round dollars to the nearest cent.) Amount Interest Financed Rate $169,300 7.25% Need Help? Read It Submit Answer Term of Loan (years) 15 Number of $1,000s Financed tA Table Factor (in $) tA Monthly Payment (in $) LA Total Interest (in $)
TASK: 2 are mu pare Apply your understanding about the present value and future value of annuities and prepare TWO Loan EMI (EMI = Equated Monthly Installments) payment schedules based on the following instructions: 1. Loan Summary and schedule of Short term loan (20 marks) 2. Loan Summary and schedule of Long term loan (20 marks) Guidelines: 1. Suggested Short term Loan period is 1 year to 3 years 2. Suggested Long term Loan period is 7 years and above 3. Each loan summary should contains following points: a. What type of loan is chosen? b. Why it is chosen? C. Interest rate, number of years (loan period) and loan amount to be assumed and clearly stated d. Starting date and ending date of the loan period is to be mentioned 4. The payment schedule should cover the following: a. Serial No. b. Date (period) c. EMI amount (EMI = Equated Monthly Installments) d. Principal component of the EMI e. Interest component of the EMI f. Interest paid to date g. Principal paid- to date h. Principal…
4. Consider the following financing information for a loan of $103,000: Item Value Loan amount $103,000 2 years Loan length Contractual interest rate 8% Origination fee Payment type 4.3% Quarterly payments, equally amortized Find the actuarial interest te, the annual percentage interest rate, and the effective interest rate.
Using this table as needed, calculate the required information for the mortgage. Amount Interest Financed Rate $88,500 8.00% Need Help? Read It Submit Answer Term of Loan (years) 30 Number of $1,000s Financed 88.5 Table Factor (in $) 7.34 Monthly Payment (in $) X LA Total Interest (in $) X
I need the excel function typed out? Example =RATE???? G. Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate! INPUTS: OUTPUT: Period 27 Rate is APR Payment 2229.45 Loan amount 358000
Calculating interest and APR of installment loan. Assuming that interest is the only finance charge, how much interest would be paid on a 5,000 installment loan to be repaid in 36 monthly installments of 166.10? What is the APR on this loan?
Subject: