Your sister is considering the purchase of a home rather than renewing the lease on her two-bedroom apartment. She can afford $675 per month. Her bank offers first-time home buyers (with good credit) a 30-year mortgage at a fixed rate of 5.49%. Use Excel's PV function to determine what the most expensive house she can afford would be. (round to the hundredths places)

Your sister is considering the purchase of a home rather than renewing the lease on her two-bedroom apartment. She can afford $675 per month. Her bank offers first-time home buyers (with good credit) a 30-year mortgage at a fixed rate of 5.49%. Use Excel's PV function to determine what the most expensive house she can afford would be. (round to the hundredths places)

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Billy Dan and Betty Lou were recently married and want to start saving for their dream home. They expect the house they want will cost approximately $255,000. They hope to be able to purchase the house for cash in 7 years. To determine the appropriate discount factor(s) using tables, click here to view Tables I. II. II. or IV in the appendix. Alternatively, if you calculate the discount factor(s) using a formula, round to six (6) decimal places before using the factor in the problem. Required a. How much will Billy Dan and Betty Lou have to invest each year to purchase their dream home at the end of 7 years? Assume an interest rate of 9 percent. b. Billy Dan's parents want to give the couple a substantial wedding gift for the purchase of their future home. How much must Billy Dan's parents give them now if they are to reach the desired amount of $255,000 in 9 years? Assume an interest rate of 9 percent. Complete this question by entering your answers in the tabs below. Required A…
Rachel purchased a car for $17,500 three years ago using a 4-year loan with an interest rate of 10.8 percent. She has decided that she would sell the car now, if she could get a price that would pay off the balance of her loan. What is the minimum price Rachel would need to receive for her car? Calculate her monthly payments, then use those payments and the remaining time left to compute the present value (called balance) of the remaining loan.
your dad wants to purchase a new house and lot in zamboanga city, so he decide to apply for housing loan from landBank using his existing house and lot collateral. the bank conducted an appraisal of his existing house an lot and came up with 2,000,000 appraised value. Your dad will pay the developer 20% down payment. The fair market value of the new house and lot is 1,500,000. What is the loan collateral ratio?
A friend of yours just bought a new sports car with a $5,000 down payment,and her $30,000 car loan is financed at an interest rate of 0.75% per month for 48 months. After two years, the “Blue Book” value of her vehicle in the used-car marketplace is $15,000. Solve, a. How much does your friend still owe on the car loan immediately after she makes her 24th payment? b. Compare your answer to Part (a) to $15,000. This situation is called being “upside down.” What can she do about it? Discuss your idea(s) with your instructor.
Ginny, who lives in Houston, is trying to decide between the following car models: Brand and Model Chevy Sonic Toyota Camry Ford Escape Hybrid Dodge 1500 Pickup Cost $14,255 17,950 30,570 37,590 She's currently accumulated a down payment of $5,000 and she has determined that she can afford maximum payments of $375 per month. Her initial research on the current cost of auto loans has found that her lowest cost loan would be made by a bank and would require an interest rate of 6% for five years. Given this information, the maximum amount that Ginny can afford to pay for her new car is can afford to purchase, without stretching her budget, is: OOO The Chevy Sonic The Toyota Camry The Dodge 1500 Pickup The Ford Escape Hybrid I and the most expensive car that she
Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Thomas decides to buy a house with price of $450,000. Thomas puts 20% down payment and considers a 30-year fixed rate mortgage to pay the remaining balance. The lender offers Thomas two choices of the mortgage with monthly payments shown in the table as choice 1 and choice 2, assume that the origination cost is $6,000. A. If you hold the loan for 30 years, what is the effective cost for each choice? B. How about the effective cost for each choice if the loan will only be outstanding for 5 years (60 months) (i.e. the borrow will pay off the loan at the end of 60 months)?
Please answer all subparts with explanation. I know it's not according to your guidelines. Thanks I will really upvote
A couple visits an open house and fall in love with the floor plan and location. They tell the host they would love to buy the house but do not know if they can afford it. In the conversation, the broker learns that they are currently paying $1750 per month for rent. Would the principal and interest payments be within the amount of their current rent if the price is $249,000 with interest rates for a zero down, 30 years mortgage at 5% interest? Note: 30 years of 5% interest is $5.37. A. Only if they have a 20% down payment. B. No, the payment is more than their current rent amount C. There is not enough information to determine an answer D. Yes, the payment is within the range of their current rent amount.
Read the passage and answer the following question(s). dis ins Homeowner and Renters Insurance: Protect Your Belongings You may be able to save hundreds of dollars a year on homeowners insurance by shopping around. You can also save money with these tips: Consider a higher deductible. Increasing your deductible by just a few hundred dollars can make a big difference in your premium. Ask your insurance agent about discourks. You may be able to get a lower premium if your home has safety features such as dead-bolt locks, smoke detectors, an alarm system, storm shutters or fire retardant roofing material. Persons over 55 years of age or long-term customers may also be offered discounts. OD. Insure your house NOT the land under it. After a disaster, the land is still there. If you don't subtract the value of the land when deciding how much homeowners insurance to buy, you will pay more than you should. Don't wait till vou have lor
A family wishes to buy a $235,900 home. - If a conventional lender is willing to loan the family 87% of the price of the home, what will the loan amount be? What will be the down payment with the loan? - If the family decides to obtain an FHA loan instead, what will the minimum down payment be? (FHA loan down payments are 3.5% of the first $25,000 and 5.2% of the balance of the loan). What is the maximum FHA loan the family can obtain?
Congratulations on finding your dream home! The 4-bedroom, 3-bath home is perfect for you and your family. You have negotiated a great price with the seller of 159,000.Youhave10,000 saved to put down on this investment (down payment). You have decided that your monthly budget for a mortgage will be no more than $775. You have been talking with two different lenders to help you mortgage your dream home. Lender #1 will lend you up to $150,000 at 5% for 25 years. Lender #2 will lend you $159,000 at 4.5% for 30 years. a) Which lender would you use? Why? Calculate the monthly payment under each lender option. Use Table 14-1 to find the appropriate table factors. Label and show all of your work. b) Remembering your budget of $775 per month, how would your lender choice change if you did not have any money to use as a down payment? Recalculate the monthly payment under each lender option. Label and show all of your work.
LaMar and Louise Hubbs moved from Alabama to the heart of Texas. They were delighted to find a Southern-style house for needed to borrow $150,000 and decided to obtain a 20-year loan at a 9.5% interest rate. However, the monthly payments were higher than they could afford, so they decided on a 30-year loan to obtain lower monthly payments. (Round your final answers to two decimal places.) (a) Find the monthly payments for the 20-year and the 30-year loans. 20-year loan $ 30-year loan $ (b) Find the total amount paid over the life of each loan. 20-year loan 30-year loan $ $ (c) Find the savings per month by going to the 30-year loan. $ (d) Find the increased total cost by going to the 30-year loan. $ Matumials A

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS