FIN 315 - Real Estate Finance Fundamentals: Buying a Home

Mr. and Mrs. ______ have out grown their 1,000 sq.ft. apartment they rented when they got married.

The Petersons have a combined annual gross ______ of $250,000.

Their combined student loan plus a car loan ______ will be $1,200 a month for the next five years.

The Petersons have saved $275,000 to use for a down ______ and/or an investment portfolio.

The average annual property tax and homeowner’s insurance ______ expenses run around 4.0 percent of the value of the house.

They were told that they could borrow a maximum of $766,550 at 8.75% with a 30-year ______.

If they want to make a lower down payment (but not less than ______%) they would have to pay an extra 125 bps for mortgage insurance for the life of the loan.

New Jersey homeowners paid an average property tax bill of ______%

If they put less than 20% down with the minimum down payment of ______%, they also must pay an extra 1.5% for mortgage insurance for the life of the loan.

The ideal ______-to-income ratio is below 43% in order not to have any other excessive fees.

For either of the two fixed rate mortgages, the Petersons can pay up front one ______ (1% of the mortgage amount) and receive a reduction in the mortgage rate by 50-basis points (.50%).

They could take out a ______-year mortgage with 100 basis points (1%) lower interest rate across the board.

There are many assumptions about your clients (their financial status and ______) and the capital markets.

2 3 Fin 315 - Comprehensive Final Case 1 – Spring 2024 can help your clients by analyzing the ______ markets.

All Excel sheets must be in ONE excel file with five tabs – (1) Option 1, (2) Option 2, (3) Option 3, (4) What-if ______ analysis, and (5) Summary.

The template provides a structure for analyzing the costs of a 30 Year ______ or a 15 Year Mortgage.

The table includes a column for the Loan Amount in ______.

The total payment includes the PMT/Month, Property Taxes/Month, Mortgage insurance, and ______ expenses.

The condo has ______ service and the elevators require a key fob to keep non-residents from wandering around the building.

The condo rents for $3,000 a month including a $200 monthly ______ fee.

If you lease the property for a year, it comes with 1-month free rent upfront and you will pay the rent for only ______ months.

The rent will go up by ______% every year.

Housing prices have been increasing at about ______% to 8% annually.

The condo has a fitness center and an outdoor pool that is located on the roof of the ______ floor.

The Petersons have asked you to do a financial analysis of the three ______ presented above.

If the Petersons decide on the condo ______, how much will their current savings grow to in five years?

How much would a house like the two-housing ______ cost in five years?

If the Petersons are in the 30% marginal tax ______, how would this fact alter your projections?

Every Excel sheet must be ______.

You must create an excel file with all calculations/equation/models are available for the instructor to ______.