Lucinda Lacy purchased a house today for $105,500 by making a down payment of 15% of the purchase price and paying closing costs of 1.7% of purchase price Loan origination fee Appraisal fee Survey fee Attorney's fee Processing fee Escrow fee $325 210 420 300 240 Other miscellaneous costs 620 Lucinda has a mortgage loan with an interest rate of 3.9% APR, compounded monthly for 30 years. Her taxes and insurance are $375 per month. Lucinda has an estimate for a $8,500 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 $135,000. Her selling expenses would be 7% sales commission plus S1000 Manual Assignment 1. Determine manually (hand-written- not excel), by trial and error, Lucinda's rate of retun if she owns the house for 6 months. Show the manual calculations, including the ball-park Trial and Error method (from the text, p. 183) with appropriate cash flow diagrams Note: To get full credit, you must show ALL handwritten manual calculations (including the value of the factors from the tables) of how you got the ROR in #1. (10 Points) Note: The above calculations must be submitted in Isidore in hard copy Excel Assignment 2. Prepare an EXCEL spreadsheet to determine Lucinda's rate of return if she owns the house for 6 months. (5 points) 3. Use the Excel spreadsheet to determine the ROR if Lucinda keeps the house for 6 months and the selling price is actually $132,500 instead of $135,000. (5 points) Show the equations for the EXCEL program The Excel portion must be submitted in the Isidore drop box by the due date