+1-415-670-9189
info@expertsmind.com
Determine the most productive way of deploying capital
Course:- Financial Management
Reference No.:- EM13942998




Assignment Help
Assignment Help >> Financial Management

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 of a person that had a home buying experience over their lifetime 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:

House 1 Buys a house November 1991 for 170,000 Sells the house June 2003 for 650,000 The house was bought with an 80% mortgage with an 8% interest rate and 30 year amortization. Taxes in the first year were 6500 and rose 3% per year. Insurance was 900 for the year and increased 3% per year. Rent would have been 1500 per month.

House 2 Bought in June 2000 for 870,000 Sold November 2015 for 840,000 The house was bought with an 80% mortgage with a 5.25% interest rate and 30 year amortization. Taxes in the first year were 16000 and rose 3% per year. Insurance was 1500 and increase 3% per year. Rent would have been 5200 per month.

Capital. Assume that if you need capital you have it to put in you take it out of real estate then do not calculate returns after the distribution.

The investment can be anything you like, S&P Index, Home Depot Stock, gold, etc (if stock, not more than 25% can be in apple). 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. You should use various metrics to determine which worked out better. NPV, IRR, Annual Cash on Cash Return and any other metric that you decide is useful. If you have to add cash then add to your alternative investment if cash comes out of the real estate then it comes out for both investments.




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Financial Management) Materials
Wine and Roses, Inc. offers a 5.0 percent coupon bond with semiannual payments and a yield to maturity of 5.63 percent. The bonds mature in 5 years. What is the market price o
Both bond A and bond B have 10 percent coupons and are priced at par value. Bond A has 10 years to maturity, while bond B has 20 years to maturity. If interest rates suddenly
The Nullcom Inc. is considering to purchase a new machine. The cost of the machine is $200,000 and installation of $10,000. The machine will be depreciated straight-line to ze
You are a freshman in college and are planning a trip to Europe when you graduate from college at the end of four years. You plan to save the following amounts annually, start
What is internal growth rate for 2015?? Balance Sheet 2015 2014 2015 2014 Cash $ 32,300.00 $ 46,900.00 AP $ 58,900.00 $ 61,200.00 AR $ 50,700.00 $ 58,300.00 Notes Payable $ 20
General Energy Storage Systems (GESS) was founded in 2002 by Ian Redoks, a Ph.D. candidate in physics who was interested in “outside-the-box” solutions to the problem of stori
Orwell building supplies' last dividend was $1.75. Its dividend growth rate is expected to be constant at 14.00% for 2 years, after which dividends are expected to grow at a r
A firm can purchase new equipment for 16000.00 initial investment. The equipment generates an annual after tax cash inflow of 7000.00 for 4 years. Assuming that the firm has a