Prepare an excel amortization chart

Assignment Help Operation Management

Reference no: EM131716013

Lucinda Lacy purchased a house today for $107,000 by making a down payment of 10% of the purchase price and paying closing costs of:

Loan origination fee 1.5% of purchase price

Appraisal fee $350

Survey fee 200

Attorney’s fee 400

Processing fee 300

Escrow fee 225

Other miscellaneous costs 520

Lucinda has a mortgage loan with an interest rate of 3.9% APR, compounded monthly for 30 years. Her taxes and insurance are $352 per month. Lucinda has an estimate for a $11,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 $137,500. Her selling expenses would be 7% sales commission plus $1000.

Manual Assignment

1. 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: show ALL handwritten manual calculations (including the value of the factors) of how you got the ROR in #1.

Excel Assignment

2. Prepare an Excel Amortization chart that shows the first six months payments.

3. Prepare an EXCEL spreadsheet to determine Lucinda’s rate of return if she owns the house for 6 months.

4. 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 $137,500.

5. Use the Excel spreadsheet to determine the ROR if the sales price is $150,000 and the repairs take longer than expected and Lucinda keeps the house for 9 months before selling and the remodeling contract is for 9 months instead of 6.

Show the equations for the EXCEL program.

Reference no: EM131716013

Questions Cloud

How do we upgrade an aging software plant : 1) How do we upgrade an aging "software plant"? 2) How do we avoid disastrous time delays?

Explain how a proposed change in institutional policy : Explain how a proposed change in institutional policy or practice guidelines related to an existing health care policy or law would affect a stakeholder group

What are ways marketing executives manage a products life : What are ways marketing executives manage a product's life cycle?

Find the mean of the cholesterol-level population : Make a 95% confidence interval for the mean of the cholesterol-level population using each of the samples gathered in Exercise, assuming that you know.

Prepare an excel amortization chart : Prepare an Excel Amortization chart that shows the first six months payments.

In what ways do pricing constraints impact price setting : In what ways do pricing constraints impact price setting?

Discuss worker has had a record of frequent absence : An office worker has had a record of frequent absence. He has used all his vacation and sick-leave days

Write journal entry that latham would make to record return : On September 1, Latham Company sold goods on account to Yeager Company. Write the journal entry that Latham would make to record the return

Locate a print advertisement for a consumer business : Describe the chosen advertisement, content on the advertisement, text, pictures, length of advertisement;

User Account

All Pages