Determine the ror if lucinda keeps the house for 6 months

Reference no: EM131018284

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

Reference no: EM131018284

Questions Cloud

Structure of the united nations human rights council : Research the organizational structure of the United Nations Human Rights Council. What are the goals of the organization? How is it structured to accomplish those goals?

How has the work of this person impacted your life : Be sure to check out the findings of your classmates, and have a conversation about the new things you learned. With everyone investigating different people, you will likely be surprised by the findings.

Journalistic interviewing techniques : Imagine that you have been granted an interview by a world-renowned, female religious leader. What would you like to know concerning her beliefs, her struggles, and her successes?

Summarize how you would troubleshoot : Suppose you receive a phone call from a client in Sales who cannot print a report on a printer in the Research and Development department. The report is from a database created on a server located at headquarters. The client tells you that other m..

Determine the ror if lucinda keeps the house for 6 months : 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

How business leaders demonstrated leadership characteristics : Choose two business leaders either living or deceased, and provide three examples that illustrate how they demonstrated leadership characteristics.

Define what is meant by a process in a process model : Define what is meant by a process in a process model. How should the process be named? What information about a process should be stored in the CASE repository?

Identify two potential barriers that could occur : Identify two potential barriers that could occur in your communication scenario and then explain how you would overcome them. Write your answer(s) below.

What software did you use to draw data flow diagrams : What did you think of the different data flow diagrams levels and what they represent? How do you think they could be improved? What software did you use to draw data flow diagrams?

User Account

All Pages