Lucinda LacyLucinda Lacy purchased a house today for $111,500 by making a down payment of 15% of the purchase price and paying closing costs of:Loan origination feeÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ 1% of purchase priceAppraisal feeÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ $375Survey feeÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿ 325Attorney feeÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿ 475Processing feeÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿ 450Escrow feeÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿ 300Other misc. costsÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿ 875Lucinda has a bank loan of 3.5% APR, compounded monthly for 15 years.ÿ Her taxes and insurance are $495 per month.ÿ Lucinda has an estimate for an $18,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 $149,000.ÿ Her selling expenses would be 6.0% sales commission plus $1,500.Assignment1.ÿ Determine manually, by trial and error, Lucinda?s rate of return, if she owns the house for 6 months.ÿ Show the manual calculations, including the ball-park method.Note:ÿ This Part#1 must be ALL HAND CALCULATIONS ? none of Part#1 can be done by Excel.úÿÿÿÿÿ For interpolation using the trial and error method, you must use 2 adjacent interest rates; for example, 10% and 11%, not 10% and 15%.To get full credit, you must show ALL handwritten manual calculations (including the value of the factors) of how you got the ROR in Part#1. (10 Points)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 $145,500 instead of $149,000.ÿÿ (3 points)4.ÿ Use the Excel spreadsheet to determine the ROR if the sales price is $155,000 and the repairs take longer than expected and Lucinda keeps the house for 12 months before selling and the remodeling contract is for 12 months instead of 6.ÿ (2 points)Submit the actual EXCEL Spreadsheet fileStep-by-Step Procedure for Calculating Lucinda Lacy1-ÿÿÿ Calculate the monthly payment2-ÿÿÿ Calculate the amount of the loan payoff after she owns the house for 6 months3-ÿÿÿ Determine what she invested on day 04-ÿÿÿ Determine her monthly expenses5-ÿÿÿ Determine her return6-ÿÿÿ Use the Ball Park method to find i*

Leave a Reply

Your email address will not be published.