Lucinda Lacy purchased a house today for $103,000 by making a down payment of $11,000 and paying closing costs of:
• Loan origination fee 1% of purchase price
• Appraisal fee $300
• Survey fee 250
• Attorney's fee 350
• Processing fee 400
• Escrow fee 250
• Other miscellaneous costs 620
Lucinda has a mortgage loan with an interest rate of 7.5% APR, compounded monthly for 30 years. Her taxes and insurance are $292 per month. Lucinda has an estimate for a $12,000 firm, fixed price contract to remodel the house and this expense will be equally distributed over the period of her ownership. After remodeling, she estimates that she could sell the house for $138,000. Her selling expenses would be 7% sales commission plus $1000.
Assignment
1. Determine manually (handwritten), by trial and error, Lucinda's rate of return, if she owns the house for 6 months. (5 points)
Note: To get full credit, you must show the manual (handwritten), calculations, including the ball-park method with all the appropriate cash flow diagrams.
2. Prepare an EXCEL spreadsheet to determine Lucinda's rate of return if she owns the house for 6 months
3. Use the Excel spreadsheet to determine the ROR if Lucinda keeps the house for 6 months and the selling price is $130,000 instead of $138,000
4. Use the Excel spreadsheet to determine the ROR if the sales price is $138,000 and the repairs take longer than expected and Lucinda keeps the house for 12 months before selling
5. Prepare an Excel Amortization chart that shows how much would be owed at the end of each month for six months and the amount of the payoff value if she purchased the house for $103,000 and paid $11,000 down