You are applying for a conventional mortgage from the Americana Bank. Yourmonthly gross income is $3,500, and the bank uses the 28% housing expenseratio guideline.a. What is the highest PITI you can qualify for? Hint: Solve the housing expenseratio formula for PITI. (Remember, this is an application of the percentage formula,Portion = Rate x Base, where PITI is the portion, the expense ratio is the rate, andyour monthly gross income is the base.)b. Based on your answer from part a, if you are applying for a 30-year, 9% mortgage,and the taxes and insurance portion of PITI is $175 per month, use Table 14-1 tocalculate what size mortgage you qualify for. Hint: Subtract TI from PITI. Divide thePI by the appropriate table factor to determine how many $1,000s you qualify to borrow.c. Based on your answer from part b, if you are planning on a 20% down payment, whatis the most expensive house you can afford? Hint: Use the percentage formula again.The purchase price of the house is the base, the amount financed is the portion, andthe percent financed is the rate.

Gross Income- A mortgage loan can only finance movable property. Land, trees, buildings, and…

Answered: (ou are applying for a conventional…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Suppose you earn a gross income of $2,920.00 per month and apply for a mortgage with a monthly PITI of $908.12. You have other financial obligations totaling $169.36 per month. If the lending ratio guidelines are as given in the table below, what type of mortgage, if any, would you qualify for? Mortgage Type Housing Expense Ratio Total Obligations Ratio FHA 29% 41% Conventional 28% 36% A. FHA only B. Conventional only C. FHA and Conventional D. None of the above
Find the annual homeowners insurance premium on a masonry home located in zone 1 if the home is insured for $237,000. The owner chooses a $1,500 deductible and has good credit. E Click the icon to see a hypothetical table of Estimated Annual Homeowners Insurance Premium Rates per $100 of Face Value. The annual homeowners insurance premium is $ (Simplify your answer. Type an integer or a decimal.)
Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the information below! You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, use the PMT function to determine what your monthly payment will be. Submit the spreadsheet in Canvas.
Please build an excel spreadsheet and show the formulas to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
Estimate the affordable monthly mortgage payment, the affordable mortgage amount, and the affordable home purchase price for the following situation. Use Exhibit 7-6, Exhibit 7-7. (Round your intermediate and final answers to the nearest whole dollar.) Monthly gross income Other debt (monthly payment) 15-year loan at Down payment to be made (percent of purchase price) Monthly estimate for property taxes and insurance Affordable monthly mortgage payment Affordable mortgage amount Affordable home purchase $ 3,350 $ 200 7 percent 20 percent $ 250
Estimate the affordable monthly mortgage payment, the affordable mortgage amount, and the affordable home purchase price for the following situation. (Refer to Exhibit 9.8 and Exhibit 9-9.) Note: Round time value factor to 2 decimal places, Intermediate and final answers to the nearest whole number. Monthly gross income Down payment to be made (percent of purchase price) Other debt (monthly payment) Monthly estimate for property taxes and insurance 30-year loan Affordable monthly mortgage payment Affordable mortgage amount Affordable home purchase price Affordable Amount Mortgage Costs $ 5,150 20 Percent $ 300 $ 400 6.5 Percent
The following formula is used for figuring out a monthly home mortgage payment: 7(12t) r Lr1+ 12 M = 12t 12 1+ 12 -1 Where: L = the loan amount in dollars the annual interest rate expressed as decimal t = the number of years of the loan M= the monthly payment in dollars r = You are looking to buy a $275,599.00 home in Haverhill. If Bank of America will give them a 30-year mortgage at 6.75% annual interest rate for the cost of the house after they receive a 10% down payment. A. Determine the loan amount? B. How much their monthly payment will be? C. At the end of the 30-years, how much total money will you have paid to Bank of America for your home? In another word how much did the $275,599.00 house really cost the couple? D. How much interest will they have paid? E. How many of her monthly payment go toward the interest? F. What percent increase over the cost of the home does this interest represent? G. Redo and re-answer all questions, but this time for 15 years? Do analysis…
site, find another.) Type in a home price of $300,000. Leaving all other entries as they are, enter an interest of 3%. Then change it to 4%. Then change it to 5%. Record the monthly payment readouts for each interest rate. Be careful with your calculations below and accurate with your research so that this assignment is useful! 1a. What was the monthly payment fference cost between the 3% and 5% loans? 1b. Multiply that monthly cost difference by 360 (the number of months in a 30 year home loan). What is the result? This is what a borrower may be paying MORE than someone else over the life of that loan due to credit. 1c. Why are customers with high credit scores given loans with lower interest rates? Reference the notes above for help here. 1d. What does this research tell you about the importance of maintaining a "good" credit score (as best as
Give typing answer with explanation and conclusion Suppose your gross monthly income is $5,900 and your current monthly payments are $575. If the bank will allow you to pay up to 36% of gross monthly income (less current monthly payments) for a monthly house payment, what is the maximum loan you can obtain if the rate for a 30-year mortgage is 4.65%? (Round your answer to the nearest cent.)
When you use a mortgage to purchase a home, the lending institution effectively owns the home. You buy back part ownership in the home with each monthly payment. The part you have bought back is your equity in the home. If the mortgage amount is P dollars, the monthly interest rate is r as a decimal, and the term of the mortgage is t months, then your equity after k payments is E(k) = P((1 + r)k − 1) (1 + r)t − 1 dollars. In this exercise, assume that the mortgage amount is $150,000, the APR is 6% so r = 0.06 12 , and the term of the loan is 30 years (360 months). (a) Find a formula for the equity. E(k) =

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS