Question

In: Accounting

Inputs: Purchase Price = $200,000, Down Payment = $10,000 (5%), Start Interest Rates = 4%, Loan...

Inputs: Purchase Price = $200,000, Down Payment = $10,000 (5%),

Start Interest Rates = 4%, Loan Term = 30 years, Monthly Liabilities = $450 (car loan),

Under Monthly Housing Expense input Real Estate Taxes + $3,000 annually, Hazard Insurance = $800 annually, Dues or Fees = $0. Click “Calculate”. Click “View Report”.

What is the required annual income required for a 4% loan? ___________

What is the required annual income required for a 5% loan? ___________

What is the Private Mortgage Insurance (PMI) monthly payment?

Change the loan term to 15 years, keeping all other amounts the same.

What is the required annual income required for a 4% loan? ___________

What is the required annual income required for a 5% loan? ___________

From the report can you provide the maximum debt to income ratio for the PITI (Principal, Interest, Taxes, Insurance)?

D/I = ____%

Expert Solution

1. The required annual income required for a 4% loan for a loan term of 30 years is $52,875.

2. The required annual income required for a 5% loan for a loan term of 30 years is $56,638.

3. Private Mortgage insurance (PMI) costs between 0.5% and 1% of the mortgage annually and is usually included in the monthly payment. PMI can be removed once a borrower pays down enough of the mortgage's principal.

4. The required annual income required for a 4% loan for a loan term of 15 years is $70,053

5. The required annual income required for a 5% loan for a loan term of 15 years is $74,215

Debt to income ratio:

A debt to income ratio is a comparison of monthly debt to income. Values less than 43% are acceptable , but 36% or less is preffered by lenders. For a mortgage loan, mortgage lenders generally follow a guideline of 28/36 when it comes to debt-to-incomes ratios. The numbers 28 and 36 are the ideal maximum numbers many lenders want when extending a mortgage loan.

Debt to income ratio = Total fixed monthly expenses / gross monthly income

ekkarill92 answered 1 year ago

What is the annual payment on a $10,000 loan, 7% interest for 5 years?

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year...

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year for 10 years, starting on 1/1/2010. All calculations must be shown, i.e., do not use a “package” to complete this question. Loan period starts from 1/1/2010. I mean the first payment is to be made on 1/1/2010.

3. Loan Interest. Sharon is considering the purchase of a car. After making the down payment,...

3. Loan Interest. Sharon is considering the purchase of a car. After making the down payment, she will finance $11,450.00. Sharon is offered 3 maturities. On a four-year loan she will pay $284.93 per month. On a five-year loan, Sharon’s monthly payment will be $237.68. On a six-year loan they will be $206.39. Sharon rejects the four-year loan, as it is not within her budget. How much interest will Sharon pay over the life of the five-year loan? Of the...

Loan Interest. Sharon is considering the purchase of a car. After making the down payment, she...

Loan Interest. Sharon is considering the purchase of a car. After making the down payment, she will finance $10,050. Sharon is offered these three maturities. On a four year loan, sharon will pay $240.66 per month, on a five-year loan, Sharons monthly payments will be $199.00. On a six-year loan, they will be $171.34. Sharon rejects the four year loan, as it is not within her budget. So, Sharon would pay $1,890.00 in interest over the life of the five...

Find the monthly payment for a 25-year fixed-rate loan of $200,000 at 5% annual interest.

You are comparing different loan rates and terms on a home purchase. The inputs are the...

You are comparing different loan rates and terms on a home purchase. The inputs are the price, percent down payment, annual interest rate and length of the loan (in months). Price 275,000 Down Pmt 20% Interest rate 4% Terms (months) 360 Given the above, calculate the loan amount, the monthly payment, total cost (the down payment and the total amount of principle and interest paid). Do scenario analysis (via a data tables) as follows: Vary the down payment from 10%...

Sarah purchased a condo for $200,000 with a $45,000 down payment and a $155,000 bank loan....

Sarah purchased a condo for $200,000 with a $45,000 down payment and a $155,000 bank loan. The mortgage is to be amortized in just 15 years with an interest rate of 3% per year, compounded monthly. 10 years later, the value of her condo has risen to $260,000 and she would like to sell her property. How much does she still owe on her mortgage? What is her equity in the condo at this point? Please show your work and...

You are given a $200,000 loan to start a business with the interest rate of 3%....

You are given a $200,000 loan to start a business with the interest rate of 3%. How would you invest this money to be able to pay back the loan in 5 years and also make as much profit as you can? Describe the type of business that you would start and include the estimation of one-time cost and recurring cost. Your projects cannot be similar; otherwise, all similar projects will receive zero credit. Show your calculations; explain the basis...

Most banks will charge a ___ interest rate on a $160,000 purchase loan with $200,000 purchase...

Most banks will charge a ___ interest rate on a $160,000 purchase loan with $200,000 purchase price and appraised value than on a $160,000 refinance loan remaining principle on old loan $120,000, with $200,000 appraised value A. Lower B. Higher

You put 20% down on a home with a purchase price of $250,000. The down payment...

You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a balance owed of $200,000. A bank will loan you this remaining balance at 3.91% APR. You will make monthly end-of-the-period payments with a 30-year payment schedule. What is the monthly annuity payment under this schedule?