Jim has an annual income of $300,000. Jim is looking to buy a house that has monthly property taxes of $1,200 and monthly homeowner's insurance of $300. Jim has $1,500 in monthly student loan payments and an average monthly credit card bill of $1,000. Apple bank has a maximum front end DTI limit of 25% and a maximum back end DTI limit of 35%. Jim will make the biggest mortgage payment he can that satisfies both the front end DTI limit and the back end DTI limit. Jim will get a fully amortizing 30 year FRM at an annual rate of 3.40%, with monthly payments, compounded monthly. What is the biggest mortgage loan Jim can get? O A. $1,071,071.25 O B. $139,705.05 OC. $1,973,025.99 OD.$1,409,304.28

Jim has an annual income of $300,000. Jim is looking to buy a house that has monthly property taxes of $1,200 and monthly homeowner's insurance of $300. Jim has $1,500 in monthly student loan payments and an average monthly credit card bill of $1,000. Apple bank has a maximum front end DTI limit of 25% and a maximum back end DTI limit of 35%. Jim will make the biggest mortgage payment he can that satisfies both the front end DTI limit and the back end DTI limit. Jim will get a fully amortizing 30 year FRM at an annual rate of 3.40%, with monthly payments, compounded monthly. What is the biggest mortgage loan Jim can get? O A. $1,071,071.25 O B. $139,705.05 OC. $1,973,025.99 OD.$1,409,304.28

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Ann will prepay the new loan 3 years after refinancing. She will save $4,000 on her loan balance when she prepays. What is Ann's annualized IRR from refinancing? QUESTION 17 Jim has an annual income of $300,000. Jim is looking to buy a house with monthly property taxes of $1200 and monthly homeowner's insurance of $300. Jim has $1,500 in monthly student loan payments and an average monthly credit card bill of $1,000. Apple bank has a maximum front end DTI limit of 28% and a maximum back end DTI limit of 36%. Considering both the front end DTI limit and the back end DTI limit, what is the most they will allow Jim to spend on a monthly mortgage payment? O A. $5,000.00 O B. $82,500.00 OC.$7,000.00 OD. $5,500.00 Click Save and Submit to save and submit. Click Save All Answers to save all answers.
3. What house value can Betty afford? Betty's annual income is $90,000 and she has monthly credit payments of $500. She is looking for a house financed by 30 year 6% mortgage with 20% down payment. Property tax and insurance on the home is expected to be $300 per month. Calculate the value of the house she can afford.
Patty purchases a $240,000 house. She pays $40,000 down and takes out a 25 year mortgage with monthly payments, at an interest rate of 12% interest compounded monthly. How much money will Patty have to pay each month?
Nabil is considering buying a house while he is at university. The house costs $200 000 today. Renting out part of the house and living in the rest over his five years at school will net, after expenses, $2260 per month. He estimates that he will sell the house after five years for $192400. If Nabil's MARR is 5 percent compounded monthly, should he buy the house? Use annual worth, and enter YES or NO in the units box.
Tobin is buying a new apartment. He can afford a mortgage payment of $1990 a month, and a down payment of $11000. He obtained a 16-year loan at 6.05% compounded monthly. Use Excel to determine what the most expensive apartment he can buy under these terms. How much will Tobin pay in interest over the 16-year years? Apartment price = $ Interest paid = $
Fatimah pays monthly rent of $520 for her townhouse. If she bought the property, the mortgage loan, property tax, and utilities would cost her $920 per month. Using the current mortgage loan rate of 6.6% compounded semi-annually, calculate how much money Fatima could accumulate over 10 years if she continues to rent and invests the $400 per month difference. $77,085 $47,845 $67,768 $56,299
Nabil is considering buying a house while he is at university. The house costs $200 000 today. Renting out part of the house and living in the rest over his five years at school will net, after expenses, $2000 Nabil's MARR is 6 percent compounded monthly, should he buy the house? Use present worth per month He estimates that he will sell the house after five years for $210 000. If
Adrian wants to have $16 500 in 4 years to start a mechanic shop. He plans to save the money by making regular deposits into an annuity that earns 10.9% per year compounded semi-annually. What semi-annual deposits does Adrian have to make?
Patty purchases a $190,000 house. She pays $50,000 down and takes out a 15-year mortgage with monthly payments, at an interest rate of 12% Interest. Find Patty's monthly payment. Patty will have to pay $ each month. (Round to the nearest cent as needed.)
Max wants to buy a house, to put on his lot, to hold his giant cheese refrigerator. Max buys a$2,000,000 house and makes a $500,000 down payment. Themortgage is for 30 years at 4% compounded monthly. The first payment will be made one month after thepurchase of the house.a) How much are Max’s monthly payments?b) How much of the 300the payment goes to the principal and how much goes to interest? TVM FORMULA
How much should Bianca's dad invest into a savings account today, to be able to pay for Bianca's rent for the next two years if rent is $850 payable at the beginning of each month? The savings account earns 2.50% compounded monthly Courtney set up a savings fund for his son's education so that he would be able to withdraw $1,600 at the beginning of every month for the next 4 years. The fund earns 4.89% compounded quarterly. a. What amount should he deposit today to allow for the $1,600 periodic withdrawals? $57,837.41 $69,654.42 $69,937.11 $58,544.47 b. How much interest would he earn in this investment? $69,937.11 $6,862.89 $76,800.00 $7,145.58
Nabil is considering buying a house while he is at university. The house costs $200 000 today. Renting out part of the house and living in the rest over his five years at school will net, after expenses, $2000 per month. He estimates that he will sell the house after five years for $210 000. If Nabil’s MARR is 6 percent compounded monthly, should he buy the house? Use annual worth.