Both homes are in the same school district and the same city with the same property...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Both homes are in the same school district and the same city with the same property tax rate (2% of the house value). Other things remain the same. Buy House A: It is a lovely 3,500 sq. ft. single family home on 0.85 acres. It is recessed and private with lush landscaping. It has 4 bedrooms and 3 full and one-half bathrooms. This house was built in 2005. The current owners have undertaken extensive renovations. There is a new wood deck and two new patios. It is in the exclusive neighborhood of historic North Shore. There is convenient access to shopping, dining, and other amenities. There are too many upgrades to count. This house looks brand new. The asking price is $750,000 and the house has been on the market for 63 days. Buy House B: It is a completely updated 2,800 sq. ft. single family home. A 2005 total rehab transformed this home that was built in 1980. It has 3 bedrooms and 3 bathrooms. It sits on a .34-acre lot with easy access to the expressway close to historic North Shore. It is in a great location in a walking community. The asking price is $500,000. It has only been on the market for one week. Rent Condo A: A third option for the Shillers is to rent a condo now and to put off purchasing a home until they have a family. There is a 2500 sq. ft. condo for rent on the top floor of a new high rise. This option has 3 bedrooms and 2 bathrooms. It comes with two parking spaces in an enclosed garage. It has additional storage space in a secured area in the basement. The condo has concierge service and the elevators require a key fob to keep non- residents from wandering around the building. There is a fitness center and an outdoor pool that is located on the roof of the 20th floor. This condo rents for $2200 a month including a $200 monthly residents' association fee to cover the cost of the concierge, pool and gym maintenance, and the cleaning of the communal areas. If the Shillers purchase one of the two houses, they plan to use the entire $120,000 for a down payment. If they end up renting, they will invest this amount of money is some index funds that are expected to earn no less than 6% annually. A possible cost of delaying the purchase of a home is that housing prices have been increasing at about 3% annually. Even if the Shillers end up renting a large condo, they know that when they have children, they will have to purchase a house. It is just a question of whether they should do that now or at some time in the future. Your Assignment The Shillers have turned to you for advice. They would like you to do a financial analysis of the three options presented above. They have asked you to complete the Excel spreadsheets below. Both homes are in the same school district and the same city with the same property tax rate (2% of the house value). Other things remain the same. Buy House A: It is a lovely 3,500 sq. ft. single family home on 0.85 acres. It is recessed and private with lush landscaping. It has 4 bedrooms and 3 full and one-half bathrooms. This house was built in 2005. The current owners have undertaken extensive renovations. There is a new wood deck and two new patios. It is in the exclusive neighborhood of historic North Shore. There is convenient access to shopping, dining, and other amenities. There are too many upgrades to count. This house looks brand new. The asking price is $750,000 and the house has been on the market for 63 days. Buy House B: It is a completely updated 2,800 sq. ft. single family home. A 2005 total rehab transformed this home that was built in 1980. It has 3 bedrooms and 3 bathrooms. It sits on a .34-acre lot with easy access to the expressway close to historic North Shore. It is in a great location in a walking community. The asking price is $500,000. It has only been on the market for one week. Rent Condo A: A third option for the Shillers is to rent a condo now and to put off purchasing a home until they have a family. There is a 2500 sq. ft. condo for rent on the top floor of a new high rise. This option has 3 bedrooms and 2 bathrooms. It comes with two parking spaces in an enclosed garage. It has additional storage space in a secured area in the basement. The condo has concierge service and the elevators require a key fob to keep non- residents from wandering around the building. There is a fitness center and an outdoor pool that is located on the roof of the 20th floor. This condo rents for $2200 a month including a $200 monthly residents' association fee to cover the cost of the concierge, pool and gym maintenance, and the cleaning of the communal areas. If the Shillers purchase one of the two houses, they plan to use the entire $120,000 for a down payment. If they end up renting, they will invest this amount of money is some index funds that are expected to earn no less than 6% annually. A possible cost of delaying the purchase of a home is that housing prices have been increasing at about 3% annually. Even if the Shillers end up renting a large condo, they know that when they have children, they will have to purchase a house. It is just a question of whether they should do that now or at some time in the future. Your Assignment The Shillers have turned to you for advice. They would like you to do a financial analysis of the three options presented above. They have asked you to complete the Excel spreadsheets below.
Expert Answer:
Answer rating: 100% (QA)
Financial Analysis for the Shillers Heres a breakdown of how to analyze the three options for the Shillers 1 Assumptions Down payment120000 for houses ... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-1259103292
4th Canadian edition
Authors: Fred Phillips, Robert Libby, Patricia Libby, Brandy Mackintosh
Posted Date:
Students also viewed these finance questions
-
DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...
-
for this case study carefully read the article titled "The Case for Reparations" The Atlantic Introduction Provide an overview of the situation Identify critical issues underlying the problems...
-
On November 1, 2018, the following were the account balances of Mountain Equipment Repair Limited. Mountains year-end is October 31 and it records adjusting entries monthly. Enter the November 1...
-
You have recently won the super jackpot in the Set for Life lottery. On reading the fine print, you discover that you have the following two options: a. You will receive 31 annual payments of...
-
According to one estimate, more than half of the jobs created in India since 1991 have been in the informal sector. a. What is the informal sector? Why might businesses choose to operate in the...
-
Why would two businesses that are identical except for the fact that one is publicly traded and one is privately owned have two different values?
-
You are given the following payoff table (in units of thousands of dollars) for a decision analysis problem: (a) Which alternative should be chosen under the maximin payoff criterion? (b) Which...
-
The script should run every 30 minutes using a cron job under user "bill" and work exactly as described in the man page accompanying this exercise. When a zombie is detected a log message is appended...
-
A quality control technician is checking the weights of a product. She takes a random sample of 10 units and weighs each unit. The observed weights (in ounces) are shown below. Assume the population...
-
Distinguish between theoretical methods, discretionary methods, and machine learning methods of developing asset pricing models. What are examples of each of these methods?
-
An efficient capital market is one in which the market portfolio contains no systematic risk. Is this statement correct? Explain.
-
Consider a long-run event study of SEO events with abnormal returns defined as the difference between the returns of the event firm and its matched control firm. What would you consider to be a major...
-
A particular professionally managed UK equity investment fund produced better returns last year than any of its rivals. This means that it is likely to outperform its rivals again this year. Comment...
-
According to Modigliani and Miller, shareholders are indifferent between a dividend and a capital gain. Comment on this statement, which you have overheard.
-
Find the work done in pumping all the oil (density S = 50 pounds per cubic foot) over the edge of a cylindrical tank that stands on one of its bases. Assume that the radius of the base is 4 feet, the...
Study smarter with the SolutionInn App