Question

In: Finance

Ann wants a mortgage to buy a house. Ann gives the following information to the bank:...

Ann wants a mortgage to buy a house. Ann gives the following information to the bank: Income: $240k/year or 20k/month Average monthly debt: $2k Estimated monthly Taxes + Insurance: $700 Down-payment: $50k saved -Ann’s down-payment will be $50k, she will take out a mortgage for the remainder Ann qualifies for a 30 year FA-CPM-FRM (monthly payments & monthly compounding) with: Annual interest rate: 4% Income test: (28%/36%) Collateral test: Closing costs + buy-down points: $5,000 + 1.75% of the balance at origination. -Example: if Ann gets a $100k mortgage, she will pay $5k + $1.75k=$6.75k at origination. 1 Underwriting 1.1: Fill in the spreadsheet (sheet “Underwriting”) for Ann. 1.2: based on the FE DTI what is the biggest payment Ann can make? 1.3: based on the BE DTI what is the biggest payment Ann can make? 1.4: based on both the FE & BE DTI what is the biggest payment Ann can make? 1.5: based on both the FE & BE DTI what is the biggest loan Ann can get? 1.6: based the LTV test and Ann’s $50k down-payment, what is the biggest loan Ann can get? 1.7: based on the income & collateral tests, what is the biggest loan Ann can get? 1.8: based on the income & collateral tests, what is the biggest payment Ann can make? 1.9: if Ann makes a 50k down-payment, how much house can Ann afford? 1.10: how much are Ann’s total mortgage closing costs?

Solutions

Expert Solution

2)FE-DTI

It is the ratio of housing expenses divided by gross income

so 6750 plus477.4 =6272.6 are mortgage payment

gross income=240000-(24000+8400+50000)

=157600

=6272.6/157600=3.98%

so this payment can be made by Ann

3)while in the back end the gross income is divided by other debt

157600/24000=6.56%

4)max 6.56+3.98=10.54

5)loan amount 100000

down payment 50000

6)LTV ratio=50%

so mac 150000 loans she can get

7)28% of income is the amount for which loan can be taken

8)240000*28%=172800

9)172800-50000=122800

10)closing cost should be 2%to 5% of the loan

1)loan

so 2456 to 6140


Related Solutions

You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge...
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge interest at the rate of 9% annually and requires a minimum monthly payment of $500. At the end of five years, you must pay off the entire mortgage by a “balloon payment”. You plan to pay only the minimum amount each month and then pay off the loan with the final payment. Find this balloon payment. (Answer: $49966.07) please answer in excel format
The bank has agreed to give you a mortgage for $400,000 to buy a new house....
The bank has agreed to give you a mortgage for $400,000 to buy a new house. Current mortgage rates have an APR of 4% compounded semi-annually for a term of 25 years. How much interest will you pay in total over the life of the loan? Select one: a. $121,433.25 b. $143,645.25 c. $231,224.25 d. $237,378.25 e. None of the above.
Susan wants to buy a house for $200,000. US Bank will give her the loan at...
Susan wants to buy a house for $200,000. US Bank will give her the loan at 3.5% for 30 years if she puts 20% down and Dacotah Bank will give her the loan at 3.8% for 30 years if she puts 10% down. There are NO other options. (15 PTS) a. Which loan should she sign up for? Pick one, no explanation needed. What is her monthly payment? (5 PTS) b. After 5 years, Susan is approached by a philanthropic...
Susan wants to buy a house for $200,000. US Bank will give her the loan at...
Susan wants to buy a house for $200,000. US Bank will give her the loan at 3.5% for 30 years if she puts 20% down and Dacotah Bank will give her the loan at 3.8% for 30 years if she puts 10% down. There are NO other options. (15 PTS) a-Which loan should she sign up for? Pick one, no explanation needed. What is her monthly payment? (5 PTS) b-After 5 years, Susan is approached by a philanthropic group known...
James wants to buy a house worth $1,000,000. To do so, he takes out a mortgage...
James wants to buy a house worth $1,000,000. To do so, he takes out a mortgage loan equal to the price of the house. The mortgage has to be repaid after 15 years and make monthly payments with an APR of 10%. Given this information, answer the following (a) 5 points. Draw the timeline that describes all cash flows (paid and received) throughout the duration of the loan. On the timeline, you must also indicate what is the last period/payment!...
Ann wants to buy a building. The annual NOI will be $100,000 She wants a 30...
Ann wants to buy a building. The annual NOI will be $100,000 She wants a 30 year fully amortizing fixed rate mortgage at an annual rate of 5% with compounding monthly payments. The lender has a minimum DSCR of 1.2. If Ann gets a 50% LTV loan for $500,000 what is her DCSR?
You are looking for a $312,598 mortgage to buy a house. The mortgage has a 7...
You are looking for a $312,598 mortgage to buy a house. The mortgage has a 7 year term with a 22 year amortization. The rate on the mortgage is 2.75% APR with monthly compounding and monthly payments. What is the balloon payment on the mortgage? Round your answer to 2 decimal places. (For example 2.437 = 2.44)
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and...
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and wish to repay the mortgage loan and the interest in 5 equal annual payments, the first one being payable on 12/31/20x1. The mortgage loan bears interest at 7%.         a) Calculate the annual mortgage payment required. Round off to the nearest cent (e.g.,    $112,753.32). b) Construct the mortgage payment schedule to see if the loan and interest will be paid    in full...
QUESTION 25 Ann wants to buy a building. The annual NOI for the building will be...
QUESTION 25 Ann wants to buy a building. The annual NOI for the building will be $100,000. She wants to get a 30 year, fully amortizing, fixed rate mortgage at an annual rate of 5% with monthly compounding and monthly payments to buy the building. The lender has a minimum Debt Service Coverage Ratio (DSCR) of 1.20. If Ann gets a 50% LTV loan for $500,000, what is her DSCR? A. 4.00 B. There is not enough information to compute...
Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000....
Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remainder. It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding. The annual interest rate is 4.50%. She will pay $5,000 in closing costs at origination. She will also pay 1.75% of the balance in buy-down points at origination. Note: the home is bought and the loan is taken in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT