Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(PLEASE WRITE NEATLY, COULD NOT READ PREVIOUS ANSWER) There are many different scenarios that we have to determine the most productive way of deploying capital,

(PLEASE WRITE NEATLY, COULD NOT READ PREVIOUS ANSWER)

There are many different scenarios that we have to determine the most productive way of deploying capital, such as: buying versus leasing a car, buying insurance whole life versus term, and of course buying versus renting a home.

You are to create a spreadsheet that tracks the cash flows on a monthly basis of a person that had a home buying experience over a 10 year period and determine whether they would have been better off buying or leasing their home and investing in some other investment.

The scenario is as follows:

Pick a house from Zillow, Realtors.com, or any other website that sold in 2008. Include a print of the page. Assume you sell the property today based on current estimate.

The house was bought with an 80% mortgage with an 4% interest rate and 30 year amortization. Taxes and insurance in the first year were 2.2% of the purchase price. Initial rent is based on estimate by Zillow as a percentage of your current value.

The investment can be anything you like, S&P Index, Bitcoin, Home Depot Stock, gold, etc (if you pick specific stocks, a stock cannot be more than 25% of your total portfolio). If you use a specific stock, you must track price, splits and dividends.

Take the cash flows from the houses over time and compare that to the cash flows that you would have received had you not bought a house but rented a home and invested instead. Essentially, the scenario that provides you the greatest wealth at the end of the period is theoretically the better strategy.

(PLEASE WRITE NEATLY, COULD NOT READ PREVIOUS ANSWER)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets Instruments And Institutions

Authors: Anthony M. Santomero, David Babbel

2nd Edition

0072358688, 9780072358681

More Books

Students also viewed these Finance questions