Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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 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 the 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, Home Depot Stock, gold, etc (if you pick a stock, it 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. 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. Please answer help me to make excel file
What percentage of the company's capital structure consists of debt?
You are considering the purchase of a common stock that just paid a dividend of $2.00. You expect this stock to have a growth rate of 30 percent for the next 3 years, then to have a long-run normal growth rate of 10 percent thereafter. If you require..
Assume that the risk-adjusted discount rate on Newco stock is 12%. How much should you be willing to pay for a 10% stake in Newco?
The treasurer of a large corporation wants to invest $33 million in excess short-term cash in a particular money market investment. The prospectus quotes the instrument at a true yield of 4.21 percent; that is, the EAR for this investment is 4.21 per..
What additional sum paid with the last withdrawal will exhaust the fund? What sum paid one year after the last full withdrawal will exhaust the fund?
Park Equipment Leasing purchased a new milling machine for $1.8 million. They depreciate it using MACRS (5-year property). They lease it to Valles Global Industries for $550,000 a year for eight years. Under the Park-O-Matic leasing option, Valles Gl..
prepare a PowerPoint presentation with a maximum of 20 slides outlining what you think that pension fund should do, highlighting both the opportunities
You bought a stock for $37.80 and sold it 7 months later for $40.18 with no dividends paid. What is your (a) Dollar gain or loss; and (b) HPR? You bought a stock for $37.80 and sold it 7 months later for $40.18 with no dividends paid. What is your (a..
defined benefit pension plan and cash balance pension plan
Operating income is not affected by: a. depreciation b. cost of goods sold c. rent payments d. interest earned advantages of the corporation form of business include:
What are the dividend yields on the common stock of Duke energy, johnson & johnson, and the Sara Lee?- What possible explanation can you give for the differences in the common stock dividend yields observed in Part a?
You purchased land 3 years ago for $40000 and believe its market value is now $75000. You are considering building a hotel on this land instead of selling it. To build the hotel, it will initially cost you $165000, an expense that you plan to depreci..
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd