None Exp22_Excel_Ch02_HOE - Townsend Mortgage CompanyProject Description:You are an assistant to Yui Matheson, a mortgage broker at the Townsend Mortgage Company. Yui spends days reviewingmortgage rates and trends, meeting with clients, and preparing paperwork. Yui relies on your expertise in using Excel to helpanalyze mortgage data. Today, Yui provided you with sample mortgage data: loan number, house cost, down payment,mortgage rate, and the length of the loan in years. She asked you to perform some basic calculations so that the outputprovided by her system can be checked to verify that it is calculating results correctly. You have also been tasked withcalculating the amount financed, the periodic interest rate, the total number of payment periods, the percentage of the housecost financed, and the payoff year for each loan. In addition, you will calculate totals, averages, and other basic statistics.Furthermore, Yui asked you to complete another worksheet that uses functions to look up interest rates from a separate table,calculate the monthly payments, and determine how much (if any) the borrower will have to pay for private mortgage insurance(PMI).Steps to Perform:

My job as Townsend Mortgage Company mortgage broker assistant Yui Matheson's helper is essential to…

Answered: Exp22_Excel_Ch02_HOE - Townsend…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

See pictures
What should an investment analyst look into before recommending an investment to clients? How should a commercial loan officer analyze a loan application that includes 3 years' worth of financial statements?
A borrower has two alternatives for a loan: (1) issue a $630,000, 75-day, 6% note or (2) issue a $630,000, 75-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar. for each alternative. b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar. < (1) $630,000, 75-day, 6% interest-bearing note: $ (2) $630,000, 75-day note discounted at 6%: $ c. Alternative is more favorable to the borrower because the borrower
Problem: You are a mortgage broker at your local bank. Your cousin submitted an application for a mortgage with a monthly PITI of $1,319. His financial other obligations total $744.50. Your cousin earns a gross income of $5,005. (a) What is your cousin's expense ratio? (b) What is his total obligations ratio? (c) According to the Lending Ratio Guidelines in your textbook (Chapter 14, section II), for type of mortgage would Bool qualify, if any? Explain. (d) If your cousin decided to get a part-time job so he can qualify for conventional mortgage, how much additional monthly income would he need? (Set up an equation and solve it.)
We will now verify your results using an online Amortization Calculator. Return to www.bankrate.com (Links to an external site.), scroll down the home page and select Amortization Calculator (Links to an external site.) under the Mortgages heading. Enter the amount, time, and rate for the original loan to begin with and click CALCULATE. Your monthly payments will appear on the side. Click Show Amortization Schedule to see the month-to-month breakdown of your loan payments over the entire term of the loan.
A borrower has two alternatives for a loan: (1) issue a $360,000, 75-day, 6% note or (2) issue a $360,000, 75-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ ________________________ Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $360,000, 75-day, 6% interest-bearing note: $___________________________ (2) $360,000, 75-day note discounted at 6%: $ _________________________
Jamison is looking at the historical prepayment for a passthrough security. He finds the following: mortgage balance in month 42 = $260,000,000 scheduled principal payment in month 42 = $1,000,000 prepayment in month 42 = $2,450,000 What is the SMM for month 42? How should Mr. Jamison interpret the SMM computed? What is the CPR for month 42?
A borrower has two alternatives for a loan: (1) issue a $420,000, 30-day, 6% note or (2) issue a $420,000, 30-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ fill in the blank 2 for each alternative. Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $420,000, 30-day, 6% interest-bearing note: $ fill in the blank 3 (2) $420,000, 30-day note discounted at 6%: $ fill in the blank 4 Alternative 1 is more favorable to the borrower because the borrower receives more cash .
Write an appropriate word in the blank so that the resulting statement is true. A monthly mortgage payment is used to repay the principal plus interest. In addition, lending institutions can require monthly deposits into an account, an account used by the lender to pay real estate taxes and insurance.
Participation #3: Discuss mortgage loans in terms of the time value of money and loan amortization. What important points should every homeowner know about how mortgages work? (Hint: Think about taxes and getting the mortgage paid off.)
help
First-time homeowners often use FHA loans to finance their home. Go to fha-home-loans.com and find out the current requirements to qualify for an FHA loan. They may differ slightly from that described in the book because the underwriting requirements frequently change. Summarize the types of loans that are currently available. What is the highest loan-to-value ratio that you could obtain?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS