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 Attorneys 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, Lucindas 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 Lucindas rate of return if she owns the house for 6 months (comparable to problem number 1 above 5 points). 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 (5 points). 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 points). 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 (5 points). Show the equations for the EXCEL program