# Unit 2 Case Study by shuifanglj

VIEWS: 6 PAGES: 1

• pg 1
```									Unit 2 Case Study

Karla and David’s combined income is \$68,000 a year. Their banker told them that the most they
should spend for a home is 2.5 times their annual income.
1. Determine the maximum amount that Karla and David should spend on their future
home. (2.5 times their annual income.)
2. Help Karla and David decide what features they should take into consideration when they
buy a home. Create a list of the features. Then, write a two-paragraph description of their
future home. Draw a floor plan of the home they should buy.
3. Use the Internet to locate an ad for a home in Karla and David’s price range.
4. Use the Bankrate.com mortgage calculator to calculate, create, copy and save an
amortization table of their loan amount.
5. Estimate cost of insurance at \$2500 per year.
6. Estimate cost of utilities at \$300 per month.
7. Karla and David have budgeted approximately \$10,000 to furnish their home. Using the
Internet, research prices of furnishings and create a spreadsheet list of furnishings for
their new home. List each item/furnishing and its price.
8. Prepare a budget for Karla and David for their first year as homeowners. Use an Excel