Lucinda Lacy purchased a foreclosed house today for $105,500 by making a down pa
ID: 2777613 • Letter: L
Question
Lucinda Lacy purchased a foreclosed house today for $105,500 by making a down payment of 15% of the purchase price and paying closing costs of:
Loan origination fee 1.7% of purchase price
Appraisal fee $325
Survey fee 210
Attorney’s fee 420
Processing fee 300
Escrow fee 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 contract for $8,500 firm, fixed price 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 $1000.
Assignment
1. Determine manually (handwritten), by trial and error, Lucinda’s rate of return, if she owns the house for 6 months.
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 a typed Amortization chart that how much would be owed at the end of each month for six months and the amount of the payoff value.
3. Prepare an EXCEL spreadsheet to determine Lucinda’s rate of return if she owns the house for 6 months (comparable to number 1).
4. Use the spreadsheet to determine the ROR if Lucinda keeps the house for 6 months and the selling price is $132,500 instead of $135,000.
5. Use the spreadsheet to determine the ROR if the sales price is $131,500 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.
Explanation / Answer
Lucinda Lacy purchased a foreclosed house today for $105,500 by making a down payment of 15% of the purchase price and paying closing costs of:
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 contract for $8,500 firm, fixed price 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 $1000.
1. Determine manually (handwritten), by trial and error, Lucinda’s rate of return, if she owns the house for 6 months.
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 a typed Amortization chart that how much would be owed at the end of each month for six months and the amount of the payoff value.
3. Prepare an EXCEL spreadsheet to determine Lucinda’s rate of return if she owns the house for 6 months (comparable to number 1).
4. Use the spreadsheet to determine the ROR if Lucinda keeps the house for 6 months and the selling price is $132,500 instead of $135,000.
5. Use the spreadsheet to determine the ROR if the sales price is $131,500 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.
Lucinda Lacy purchased a foreclosed house today for $105,500 by making a down payment of 15% of the purchase price and paying closing costs of:
Loan origination fee 1.7% of purchase price Appraisal fee $325 Survey fee 210 Attorney’s fee 420 Processing fee 300 Escrow fee 240 Other miscellaneous costs 620Lucinda 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 contract for $8,500 firm, fixed price 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 $1000.
Assignment1. Determine manually (handwritten), by trial and error, Lucinda’s rate of return, if she owns the house for 6 months.
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 a typed Amortization chart that how much would be owed at the end of each month for six months and the amount of the payoff value.
3. Prepare an EXCEL spreadsheet to determine Lucinda’s rate of return if she owns the house for 6 months (comparable to number 1).
4. Use the spreadsheet to determine the ROR if Lucinda keeps the house for 6 months and the selling price is $132,500 instead of $135,000.
5. Use the spreadsheet to determine the ROR if the sales price is $131,500 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.
1) Loan Amount = $105,500 - (1 - 15%) $89,675.00 Rate = 3.9%/12 0.32% NPER = 30 years x 12 months 360 Periods Payment each month(PMT) $422.97 Amount he spent on buying the house Loan origination fee = 1.7% x $105,500 $1,793.50 Appraisal fee $325.00 Survey fee $210.00 Attorney’s fee $420.00 Processing fee $300.00 Escrow fee $240.00 Other miscellaneous costs $620.00 Down Payment = $105,500 x 15% $15,825.00 Tax and Insurance = 6 x $375 $2,250.00 Remodellling House $8,500.00 Sales commission = 7% x 135,000 $9,450.00 Sales commission $1,000 Payment made for 6 months $2,538 Total cost $43,471.31 Sales $135,000 less Expenses -$43,471.31 $91,528.69 Loan repayment 89,247.96 Profit $2,280.73 2) Payment Date Beginning Balance Total Payment Principal Interest Ending Balance 1 $89,675.00 $422.97 $422.16 $0.81 $89,252.84 2 $89,252.84 $422.97 $422.16 $0.81 $89,252.03 3 $89,252.03 $422.97 $422.16 $0.81 $89,251.22 4 $89,251.22 $422.97 $422.16 $0.81 $89,250.41 5 $89,250.41 $422.97 $422.15 $0.81 $89,249.60 6 $89,249.60 $422.97 $422.15 $0.82 $89,248.78 7 $89,248.78 $422.97 $422.15 $0.82 $89,247.96 Rate of Return = 2,280.73/ 43,471.31 5.25%Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.