Project requires you to compare renting versus owning home

Assignment Help Financial Management

Reference no: EM131606218

This project requires you to compare renting versus owning a home. Assume a property can be rented for $12,000 per year ($1,000 per month) or purchased for $150,000 with $30,000 down and financed with a fully amortizing mortgage loan of $120,000 at 7 percent interest for 30 years. Other costs associated with owning include maintenance costs of $500, insurance costs of $500, and property taxes of 2% of the purchase price. Assume the federal income tax rate is 28 percent. Growth rates for expenses (insurance, maintenance, property taxes), rents, and property value are a constant 2 percent per year. Afterfive years, the property will be sold. Selling expenses of 7 percent would have to be paid at that time. Be sure to show your work in Excel. In other words, do not simply type values into the boxes, but reference prior cells when calculating results. In your report, identify how much money is saved from owning relative to renting after selling the house in year 5. If an annual after-tax return of 15% is available on an investment of comparable risk, which is the better option, owning or renting?

Part 1: Monthly Payment Fill in the two tables, for property information and loan information, respectively.

Part 2: CPM Loan Fill in the loan schedules and property data.

Part 3: CAM Loan Fill in the cash flow tables.

Reference no: EM131606218

Questions Cloud

Propose a plan for protecting your intellectual property : Please propose a plan for protecting your intellectual property. What is your product or service? Give a brief description.

Identify perspectives that are used to define management : Identify the main perspectives that are used to define management whilst Identifying the main perspectives that are used to define leadership

Determine the amount of impairment loss : Determine the amount of impairment loss. If a loss is indicated, where would it appear in General Optic’s multiple-step income statement?

Conducting post-project audits of capital budgeting projects : List and describe the objectives of a controller conducting post-project audits of capital budgeting projects.

Project requires you to compare renting versus owning home : This project requires you to compare renting versus owning a home. CPM Loan Fill in the loan schedules and property data.

Delivery of computer peripheral devices to consumers : Zowie is a six-year-old company that specializes in immediate (less than two hours) delivery of computer peripheral devices to consumers.

The additional profit contribution from additional sales : Initiating cash discount Gardner Company currently makes all sales on credit and offers no cash discount. additional profit contribution from additional sales.

What effective annual rate will the firm pay for financing : What effective annual rate will the firm pay for financing with commercial paper, assuming that it is rolled over every 130 days throughout the year?

Evaluate proposed relaxation-make recommendation to firm : Evaluate the proposed relaxation, and make a recommendation to the firm. The additional profit contribution from an increase in sales is $.

User Account

All Pages