John and his wife, Joanne, both work and have a combined gross income of $115000 per year. They estimate the property taxes on their condo will be $1250 and insurance would be about $1700 per year. John takes the bus to work, but Joanne has a car payment of $235 per month, and they are both still paying off student loans for a combined total of $300 per month. Use this information to answer the questions below. Express your answers rounded correctly to the nearest cent! ) Determine how much of a monthly mortgage John and Joanne can afford. (Use the Total Expense Ratio from your class materials.) Payment = $ %3D (ii) If the couple can get a 10-year mortgage with a fixed rate of 4.15%, use Excel's PV function to determine how much house they could afford Amount to Borrow = $

John and his wife, Joanne, both work and have a combined gross income of $115000 per year. They estimate the property taxes on their condo will be $1250 and insurance would be about $1700 per year. John takes the bus to work, but Joanne has a car payment of $235 per month, and they are both still paying off student loans for a combined total of $300 per month. Use this information to answer the questions below. Express your answers rounded correctly to the nearest cent! ) Determine how much of a monthly mortgage John and Joanne can afford. (Use the Total Expense Ratio from your class materials.) Payment = $ %3D (ii) If the couple can get a 10-year mortgage with a fixed rate of 4.15%, use Excel's PV function to determine how much house they could afford Amount to Borrow = $

CONCEPTS IN FED.TAX.,2020-W/ACCESS

20th Edition

ISBN:9780357110362

Author:Murphy

Publisher:Murphy

Chapter6: Business Expenses

Section: Chapter Questions

Problem 69P

See similar textbooks

Similar questions

Donald and Alex have a combined gross monthly income of $5500. They want to buy a house in a neighborhood where the average monthly heating cost is $200 and monthly property taxes are $325. a) Calculate the maximum monthly mortgage payment they can afford, based on the gross debt service ratio. Show your work. b) Based on the maximum monthly mortgage payment in a), their bank has offered them a 25 year mortgage at an interest rate of 3.5%, compounded semi-annually. If they saved $20,000 for a down payment, what would be the maximum house price they can afford? Show your work.
Philip works at a nursing home as an aide and earns $27,000 a year. IF he went to school to get a nursing degree he could earn $50,000 in the first year. Philip knows this but he also knows that tuition and fees at a nearby college could cost about $45,000(total). He can get a student loan for 5% with 10 years to repay the loan. What is the total cost of the student loans?
Rachel and Alexander Harrison need to calculate the amount they can afford to spend on their first home. They have a combined annual income of $67,500 and have $37,000 available for a down payment and closing costs. The Harrisons estimate that homeowner's insurance and property taxes will be $150 per month. They expect the mortgage lender to use a 28 percent (of monthly gross income) mortgage payment affordability ratio, to lend at an interest rate of 6 percent on a 30-year mortgage, and to require a 10 percent down payment. Based on this information, use the home affordability analysis form in Worksheet 5.3 to determine the highest-priced home the Harrisons can afford. Assume that closing costs are one-half of the down payment. Round the answer to the nearest dollar. $
Jose and Rosa are looking for a condo. Their combined gross annual income is $61,000. The best mortgage rate offered by their bank is a 3.12 percent, five-year fixed rate compounded semi-annually with a 20-year amortization. The annual property taxes are estimated at $1,360, and the annual heating costs are $1,340. Their personal debt consumption is $500 per month. Condo fees are estimated at $700 per month. The bank's guideline for TDS is 30 percent. Based on this information, what is the maximum monthly mortgage payment they could afford? The maximum monthly mortgage payment they could afford is $ (Round to the nearest cent.)
Steven is thinking about buying a duplex. His monthly expenses will be $888 for the mortgage, $480 for taxes, and $420 for insurance period he also needs to pay a yearly association fee of $888.00. If he can rent out 1/2 of the unit for $1535 per month, how much will he make or lose per month? Loss of $60. Loss of $1120. Loss of $327.
John and Marsha are buying their first home. It has three bedrooms, two baths, and a two car garage. The total cost is $266,500. They have $35,000 for the down payments. They can finance the difference through their local credit union with a 30 year loan at 3.95%. What will their monthly payment be?
The Jacksons want to buy a condo in Langley. This will be their first property. Their combined gross annual salary is $108,000. They estimate that the property taxes are $2,400/year, strata fees $200/month and heating costs average $50/month. Banks use the affordability rule: no more than 32% of gross monthly hosehold income can go tawards paying the mortgage, property taxes, heating costs and 50% of the condo fees. What is the maximum monthly mortgage payment they could afford? Your Answer: Answer
Deb and Rusty have just gotten married and wish to buy a home. They both work in Boston and have a combined income of $90,000. They found a modest starter house which they are buying for $350,000. 1. They plan to use their $40,000 is savings to cover the closing costs the bank will charge them, which are 1% of the amount they borrow from the bank. The rest of the savings will be used as a down payment. Determine the largest amount they can use for a down payment and still pay the closing costs. 2. Using the amount Deb and Rusty have to borrow from part 1, open Excel and create a 20-year amortization schedule, giving monthly payments for the amount they borrowed at a 4.5% annual interest rate. You must use the pmt function in Excel to compute the monthly payment. Title this worksheet Amortization. For your answer to this question write “See Excel Workbook”. 3. Use the amortization schedule to compute the total amount of interest they will pay to the bank over the 20 years. 4. Create a…
Sam and Deb have a weekly net income of $1700. Their monthly expenses, not related to housing, are $2875. They have savings of $32 000. They are considering two housing options: Option 1: Renting a 2-bedroom condo for $1650 a month, plus utilities averaging $210 a month Option 2: Buying a 2-bedroom condo for a down payment of $24 500, bi-weekly mortgage payments of $1100, and a monthly condo fee of $475 a) Determine the monthly cost of each housing option. Which one can Sam and Deb afford? Which would you recommend? b) Suppose Sam’s mother falls ill and he has to pay $575 every two weeks to cover her expense. Calculate the additional monthly expenses. Based on your answer in a), would your recommendation change? Explain
1) Calculate: Rimi currently earns $2,500 per month. She has the following monthly debt payment expenses: $75 for credit cards, $125 for student loans, and a $235 car payment. She is looking to buy a house. The monthly mortgage, including principal, insurance, and taxes, is $900. Does Rimi meet the FHA housing payments-to-income ratio guideline? O O O O Yes, because her ratio is less than 31%. No, because her ratio is greater than 31%. Yes, because her ratio is less than 43%. No, because her ratio is greater than 43%.
S Felice bought a duplex apartment at a cost of $210,000. Her mortgage payments on the property are $1.420 per month, $648 of which can be deducted from her income taxes. Her real estate taxes total $1,740 per year, and insurance costs $1,044 per year. She estimates that she will spend $1,092 each year per apartment for maintenance, replacing appliances, and other costs. The tenants will pay for all utilities. What monthly rent must she charge for each apartment to break even? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Ignore any tax effects. Rent per apartment to break even
Jack and Jill purchase a house and finance $375,000 at 2.8% for 30 years. Their annual insurance is $1,225 and their annual property tax is $5212. How much is their PITI payment each month? Remember, that amount includes principal, interest, property taxes and insurance. You must show the formulas with the values filled in.