Question

Accountancy

This project requires you to compare renting versus owning a home. Assume a property can be rented for $13,200 per year ($1,100 per month) or purchased for $160,000 with $30,000 down and financed with a fully amortizing mortgage loan of $130,000 at 3 percent interest for 30 years. Other costs associated with owning include maintenance costs of $500, insurance costs of $500, and property taxes of 3 percent of the purchase price. Assume the federal income tax rate is 22 percent. Growth rates for expenses (insurance, maintenance, property taxes), rents, and property value are a constant 2 percent per year. After five years, the property will be sold. Selling expenses of 5 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 percent is available on an investment of comparable risk, which is the better option, owning or renting?

Part 3: Cash Flow Analysis

Fill in the cash flow tables. Property taxes in year 1 are calculated as purchase price * property tax rate. Property taxes in future years grow at 2 percent per year. Note that tax deductions include property taxes and interest. Tax savings are calculated as total tax deductions * income tax rate. After-tax cash flows are calculated as tax savings – cash outflows before taxes. After tax cash flows from owning are calculated as after-tax cash flows + rent saved. Before-tax cash flow from sale can be calculated property value – selling costs – mortgage balance. The after-tax cash flow from sales are identical to the before-tax cash flow from sales due to exclusions. (25 points)

Part 3) Cash Flow Analysis














Before-Tax Cash Flows-Owner














Year12345

Property taxes




Hint: Use the FV formula for one period
Insurance




Hint: Use the FV formula for one period
Maintenance




Hint: Use the FV formula for one period
Principal and Interest




Hint: The annual payment on the loan
Cash Outflows before taxes




Hint: Sum the values above








Tax Deductions-Owner














Year12345

Property taxes




Hint: Reference same values calculate above
Interest




Hint: Reference same values from the yearly summary loan schedule
Total tax deductions




Hint: Sum of property taxes and interest
Tax savings




Hint: Total tax deductions * income tax rate








Rents






Year12345

Rents




Hint: Reference same values from yearly property data above








Net Cash Flows-Owning














Year12345

Cash outflows before taxes




Hint: Reference from above
Tax savings




Hint: Reference from above
After-tax cash flows




Hint: Tax savings - cash outflows before taxes
Rent saved (Rents)




Hint: Reference from above
After tax cash flows-owning




Hint: After-tax cash flows + Rent saved








Before-Tax Cash Flows-Sales














Year12345

Property value






Selling costs






Mortgage balance (Balance)






Before-tax cash flow from sale






After-tax cash flow from sale


0 0
Request Professional Answer

Request Answer!

We need at least 9 more requests to produce the answer.

1 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Accountancy
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • IRR

    You are considering an option to purchase or rent a single residential property. You can rent it for $2,000 per month and the owner would be responsible for maintenance, property insurance, and property taxes. Alternatively, you can purchase this property for $200,000 and finance it with an 80 percent mortgage loan at 4 percent interest that will fully amortize over a 30-year period. The loan can be prepaid at any time with no penalty.You have done research in the market...

  • Accountancy

    Please help with this questionsA family currently live in an apartment whose monthly rent is $1050. They are thinking of buying a house would cost $250,000. They plan to live in this house for 5 years and sell it at the end of the 5th year. They would put a down payment of $25,000 and finance the balance through a mortgage at 3% interest rate. The mortgage is to be repaid in 5 annual installments (which include both principal and...

  • Based on the following data, would you recommend buying or renting? Rental costs Annual rent Insurance...

    Based on the following data, would you recommend buying or renting? Rental costs Annual rent Insurance Security deposit (9,650 16 interest) $ 7,530 $ 16e $ 725 Buying costs Annual mortgage payments Property taxes Down payment/closing costs Growth in equity Insurance/maintenance Estimated annual appreciation $10, 180 $ 1,840 $ 4, sae $ 458 $ 1,200 $ 1,850 Assume an after-tax savings interest rate of 5 percent and a tax rate of 26 percent. Assume this individual has other tax deductions...

  • Valuation fundamentals Personal Finance Problem Imagine that you are trying to evaluate the economics of purchasing...

    Valuation fundamentals Personal Finance Problem Imagine that you are trying to evaluate the economics of purchasing a condominium to live in during college rather than renting an appartment. If you buy the condo, during each of the next 4 years you will have to pay property taxes and maintenance expenditures of about $6,000 per year, but you will avoid paying rent of $10,000 per year. When you graduate 4 years from now, you expect to sell the condo for $123,000...

  • Warren Company plans to open a new repair service center for one of its electronic products....

    Warren Company plans to open a new repair service center for one of its electronic products. The center requires an investment in depreciable assets costing $420,000. The assets will be depreciated on a straight-line basis, over four years, and have no expected salvage value. The annual income statement for the center is given below. Revenues $350,000 Less: Cash operating expenses (140,000) Depreciation (105,000)   Income before income taxes $105,000 Less: Income taxes (@40%) 42,000   Net income $63,000 Required: 1. Using the...

  • After-Tax Cash Flows Warren Company plans to open a new repair service center for one of...

    After-Tax Cash Flows Warren Company plans to open a new repair service center for one of its electronic products. The center requires an investment in depreciable assets costing $480,000. The assets will be depreciated on a straight-line basis, over four years, and have no expected salvage value. The annual income statement for the center is given below. Revenues $360,000 Less: Cash operating expenses (150,000) Depreciation (120,000)   Income before income taxes $90,000 Less: Income taxes (@40%) 36,000   Net income $54,000 Required:...

  • please answer this in the same format. 9 French Corporation wishes to hire Leslie as a...

    please answer this in the same format. 9 French Corporation wishes to hire Leslie as a consultant to design a comprehensive staff training program. The project is expected to take one year, and the parties have agreed to a tentative price of $68,000. French Corporation has proposed payment of one-half of the fee now, with the remainder paid in one year when the project is complete. Use Appendix A and Appendix B. 5 a. If Leslie expects her marginal tax...

  • After-Tax Cash Flows Below is a list of aspects of various capital expenditure proposals that the...

    After-Tax Cash Flows Below is a list of aspects of various capital expenditure proposals that the capital budgeting team of Anchor, Inc., has incorporated into its net present value analyses during the past year. Unless otherwise noted, the items listed are unrelated to each other. All situations assume a 40% income tax rate and an 11% minimum desired rate of return. 1. Pre-tax savings of $4,000 in cash expenses will occur in each of the next three years. 2. A...

  • Open spreadsheet a. What is the initial investment outlay for the spectrometer, that is, what is...

    Open spreadsheet a. What is the initial investment outlay for the spectrometer, that is, what is the Year O project cash flow? Round your answer to the nearest cent. Negative amount should be indicated by a minus sign. b. What are the project's annual cash flows in Years 1, 2, and 37 Round your answers to the nearest cent. In Year 1$ In Year 2 $ In Year 3$ c. If the WACC is 11%, should the spectrometer be purchased?...

  • 9. Tom paid $17,000 in mortgage interest and $8,000 in property taxes last year. His average...

    9. Tom paid $17,000 in mortgage interest and $8,000 in property taxes last year. His average tax rate is 21.5%, his marginal tax rate is 28%. Compute Tom's tax shield from the mortgage interest and property tax deduction. 10. Jill buys a house for $800k, lives there for exactly 10 years and sells it. Suppose Jill's annual cost of ownership is exactly equal to the annual rent she would have paid to live in the same house. Suppose the price...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT