Please analyze, from the perspective of finance, the choice of buying a house vs renting an apartment. To make a quantitative analysis, suppose you have collected the following information: 1. If you rent a 1,000 sq ft two-bedroom apartment in RTP area, your monthly rent will be $900. The apartment is in move-in condition. You wont have any upfront expenses when you move in. 2. If you want to buy a house, a 2,000 sq ft three-bedroom townhouse in RTP area is sold at $200,000. To get your application for mortgage approved by a bank, you need to pay 20% down payment. In addition, there is $2,000 closing cost. Your mortgage bank gives you two offers for mortgage. Offer one is a 30-years fixed-rate mortgage at 7.5% APR. Offer two is a five-year floating-rate mortgage, ARM 5/1, at 5.875% interest rate. 3. A townhouse owner needs to pay $80 HOA fee each month. In addition, the property tax and house insurance together are about 1.5% of house value. In addition, you make the following assumptions to simplify the situation: 1. Suppose you will live in an apartment or a townhouse for five years only. After year five, you will either buy a larger single family house or move to another place. That means you need to resell your house at year five. 2. Based on the knowledge youve learned from economics courses, you think inflation rate might be around 3.5% in next five years. You anticipate your house value will increase at 4.5% each year. 3. The utility expense of a townhouse will be higher than that of an apartment. However, considering that the interest part of your monthly mortgage payment is tax-deductible, you simply assume the extra utility expense of a townhouse and the tax-saving due to mortgage interest expense are canceled out. That means you dont need to consider utility when you do your quantitative analysis. 4. If your resale price is higher than your purchase price, you make a profit from your sales of the house. The profit will be taxed at 15%. You will pay $6,000 transaction costs when you resell the house. 5. At time when you resell your house, your mortgage is not paid off yet. So you have to use the sales proceeds to pay off your mortgage first. You can find how much mortgage balance remains unpaid by checking the mortgage amortization table at www.bankrate.com. Go to this website, click calculator/mortgage calculator, then input your mortgage information and calculate monthly payment, lastly, click amortization table, you will find your mortgage balance at end of year five. 6. Your opportunity cost (required rate of return) is 8%.

You need to use spreadsheet to do capital budgeting analysis and calculate NPV or IRR. Then use the capital budgeting analysis result to answer the following questions in one or two sentences: based on your analysis, do you want to buy a house? Why?