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
-
A company has projected sales of $ 1 5 5 . 5 million next year. Costs are expected to be $ 1 0 0 million and net investment is expected to be $ 1 7 . 5 million. Each of these values is expected to...
-
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...
-
A corporation has three factories that manufacture acoustic guitars and electric guitars. The production levels are represented by A. (a) Interpret the value of a22. (b) How could you find the...
-
Cross Rates and Intermarket Arbitrage. Why are cross currency rates of special interest when discussing intermarket arbitrage?
-
George Stamper, a credit analyst with Micro-Encapsulators Corp. (MEC), needed to respond to an urgent e-mail request from the southeast sales office. The local sales manager reported that she had an...
-
Using the financial data provided for Bank of America Corporation, create a comprehensive income statement for the fiscal year. Include all relevant revenue streams and expenses such as interest...
-
1. How do small businesses manage the trade-offs between social, environmental, and financial performance in a retail industry 2. How do retail firms manage sustainable management accounting...
-
Discuss some of the academic requirements for a modern internal auditor and explain why they are desirable.
-
We are often told that packaging is a major problem for waste disposal. Why is there so much packaging, and how can the amount be reduced?
-
Which of the following best illustrates an internal auditor's professional proficiency? a. An independent mental attitude. b. The ability to plan audits ancj to meet schedules. c. The ability to...
-
Which of the following items would be the best criterion for evaluating a staff auditor's work performance? a. Number of deficiency findings reported. b. Ability to get along with auditees. c....
-
Automation is bound to give the most efficient warehouses, so everyone should move in this direction. Will all warehouses eventually be automated?
-
A business operated at 100% of capacity during its first month and incurred the following costs: Production costs (21,000 units): Direct materials $182,000 Direct labor 225,300 Variable factory...
-
A test car is driven a fixed distance of n miles along a straight highway. (Here n Z+.) The car travels at one mile per hour for the first mile, two miles per hour for the second mile, four miles...
-
What role does growth-need strength play in the job characteristics model?
-
Explain the difference between halo errors and recency errors in performance appraisal.
-
When is a team effective?
Study smarter with the SolutionInn App