Hedonic Research Paper

!! You will need to go to http://www.realtor.com/homesforrent/94544/type-house-rentals? pgsz=50&ml=3and search !! look at the value of property on the market. What the restroom and bedroom how many of it. we look at lease market !! This have 59 result .. that you need to enter it excel and make it look like the research on the example that i attach in here … ! ! – It should have ! ! ! data sources ! ! – methodology – semi log form ! ! – result – minimum price .. median price . and maximum price in city ! ! Area map of the area ! ! – table of the result ! ! – original data ! ! – the descriptive statistic! ! – Type and Lot Size do not need to enter it … !! ! !

hedonic data

Hedonic Regression Example omitted Bed2, Bath1, Strutype for Multi
Price lnPrice Bed0 Bed1 Bed3 Bedge4 Bath15 Bath2 Bath3 Sqft Age AgeSq Strutype
115000 11.6526874073 1 0 0 0 0 0 0 650 63 3969 0
120000 11.6952470218 1 0 0 0 0 0 0 684 62 3844 0
133000 11.7981044072 1 0 0 0 0 0 0 718 61 3721 0
138575 11.8391669743 1 0 0 0 0 0 0 752 60 3600 0
144150 11.8786097031 1 0 0 0 0 0 0 884 59 3481 1
149725 11.9165555571 1 0 0 0 0 0 0 918 58 3364 1
205575 12.2335662098 0 1 0 0 1 0 0 952 57 3249 1
211150 12.2603240604 0 1 0 0 1 0 0 986 56 3136 1
216725 12.2863845477 0 1 0 0 1 0 0 1020 55 3025 1
222300 12.3117831 0 1 0 0 1 0 0 1054 54 2916 1
227875 12.336552512 0 1 0 0 1 0 0 1088 53 2809 1
233450 12.3607232004 0 1 0 0 1 0 0 1122 52 2704 1
239025 12.384323428 0 1 0 0 1 0 0 1156 51 2601 1
244600 12.4073795022 0 1 0 0 1 0 0 1190 50 2500 0
250175 12.429915952 0 1 0 0 1 0 0 1224 49 2401 0
305575 12.6299505266 0 0 0 0 0 1 0 1258 48 2304 0
311150 12.64803039 0 0 0 0 0 1 0 1292 47 2209 0
316725 12.6657891685 0 0 0 0 0 1 0 1326 46 2116 0
322300 12.6832380678 0 0 0 0 0 1 0 1360 45 2025 0
327875 12.7003877172 0 0 0 0 0 1 0 1394 44 1936 0
333450 12.7172482081 0 0 0 0 0 1 0 1428 43 1849 1
339025 12.73382913 0 0 0 0 0 1 0 1462 42 1764 1
344600 12.7501396031 0 0 0 0 0 1 0 1496 41 1681 1
350175 12.7661883085 0 0 0 0 0 1 0 1530 40 1600 1
355750 12.781983516 0 0 0 0 0 1 0 1564 39 1521 1
361325 12.7975331093 0 0 0 0 0 1 0 1598 38 1444 1
366900 12.8128446103 0 0 0 0 0 1 0 1632 37 1369 1
372475 12.8279252005 0 0 0 0 0 1 0 1666 36 1296 1
378050 12.842781741 0 0 0 0 0 1 0 1700 35 1225 1
383625 12.8574207919 0 0 0 0 0 1 0 1734 34 1156 1
389200 12.8718486293 0 0 0 0 0 1 0 1768 33 1089 1
394775 12.8860712613 0 0 0 0 0 1 0 1802 32 1024 1
455575 13.0293156364 0 0 1 0 0 1 0 1836 31 961 1
461150 13.0414786487 0 0 1 0 0 1 0 1870 30 900 1
466725 13.0534954981 0 0 1 0 0 1 0 1904 29 841 1
472300 13.0653696559 0 0 1 0 0 1 0 1938 28 784 1
477875 13.077104471 0 0 1 0 0 1 0 1972 27 729 1
483450 13.0887031759 0 0 1 0 0 1 0 2006 26 676 1
489025 13.1001688919 0 0 1 0 0 1 0 2040 25 625 1
494600 13.1115046341 0 0 1 0 0 1 0 2074 24 576 1
500175 13.1227133162 0 0 1 0 0 1 0 2108 23 529 1
505750 13.133797755 0 0 1 0 0 1 0 2142 22 484 1
511325 13.1447606748 0 0 1 0 0 1 0 2176 21 441 1
516900 13.1556047112 0 0 1 0 0 0 0 2210 20 400 1
522475 13.1663324148 0 0 1 0 0 0 1 2244 19 361 1
528050 13.1769462552 0 0 1 0 0 0 1 2278 18 324 1
533625 13.1874486241 0 0 1 0 0 0 1 2312 17 289 1
539200 13.1978418386 0 0 1 0 0 0 1 2346 16 256 1
544775 13.2081281444 0 0 1 0 0 0 1 2380 15 225 1
655575 13.3932679921 0 0 0 1 0 0 1 3000 14 196 1
661150 13.401736022 0 0 0 1 0 0 1 3034 13 169 1
666725 13.410132946 0 0 0 1 0 0 1 3068 12 144 1
672300 13.4184599485 0 0 0 1 0 0 1 3102 11 121 1
677875 13.4267181841 0 0 0 1 0 0 1 3136 10 100 1
683450 13.4349087796 0 0 0 1 0 0 1 3170 9 81 1
689025 13.4430328338 0 0 0 1 0 0 1 3204 8 64 1
694600 13.4510914193 0 0 0 1 0 0 1 3238 7 49 1
700175 13.4590855828 0 0 0 1 0 0 1 3272 6 36 1
705750 13.4670163461 0 0 0 1 0 0 1 3306 5 25 1
711325 13.474884707 0 0 0 1 0 0 1 3340 4 16 1

results

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9998465151
R Square 0.9996930537
Adjusted R Square 0.9996227119
Standard Error 0.0084735828
Observations 60
ANOVA
df SS MS F Significance F
Regression 11 11.22482849 1.0204389536 14211.9240726682 2.45938154696426E-80
Residual 48 0.003446477 0.0000718016
Total 59 11.2282749671
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Halverson and Palmquist correction
Intercept 11.892214007 0.2872673828 41.3977176688 3.24949295705939E-39 11.3146245608 12.4698034531 11.3146245608 12.4698034531
Bed0 -0.4634856209 0.0137703379 -33.6582606477 4.83688490084012E-35 -0.4911727246 -0.4357985172 -0.4911727246 -0.4357985172 -0.3709129395
Bed1 -0.1696613886 0.007758989 -21.8664297041 1.32527530344873E-26 -0.1852618725 -0.1540609047 -0.1852618725 -0.1540609047 -0.1560494605
Bed3 0.0000082026 0.0057365058 0.0014298966 0.9988650342 -0.0115258087 0.0115422139 -0.0115258087 0.0115422139 0.0000082026
Bedge4 0.1088997018 0.0099596859 10.9340498564 0 0.088874423 0.1289249807 0.088874423 0.1289249807 0.1150505072
Bath15 0.021267993 0.0090238407 2.3568670764 0.0225574467 0.0031243559 0.0394116301 0.0031243559 0.0394116301 0.0214957687
Bath2 0.0152165246 0.0054959804 2.7686642715 0.0079758698 0.0041661218 0.0262669274 0.0041661218 0.0262669274 0.0153328854
Bath3 -0.0080779166 0.0057272912 -1.4104253358 0.164861998 -0.0195934007 0.0034375674 -0.0195934007 0.0034375674 -0.0080453779
Sqft 0.000471539 0.0000999666 4.7169666405 0.0000209855 0.0002705428 0.0006725351 0.0002705428 0.0006725351
Age 0.0104562467 0.0033440741 3.1267987415 0.0029994122 0.003732539 0.0171799543 0.003732539 0.0171799543
AgeSq -0.0001647862 0.0000130876 -12.5909794975 8.01593886273043E-17 -0.0001911007 -0.0001384718 -0.0001911007 -0.0001384718
Strutype -0.0143459911 0.005727557 -2.5047312873 0.0157035012 -0.0258620095 -0.0028299728 -0.0258620095 -0.0028299728 -0.0142435777

raw data

Price beds baths sq feet year built

Finding Your Best Bank

LASA: Finding Your Best Bank

For this assignment, you will take on the role of a personal financial advisor and create a personal financial portfolio.

 

Step 1: Using the large National Bank, the Regional/Local Bank, and the Credit Union you identified in the Module 1 Assignment 2, compare and contrast each institution by completing the Module 3 Assignment 2 template.

 

Step 2: Once you have completed the Module 3 Assignment 2 template, create a financial portfolio. This financial portfolio is a professional one. Please follow the following instructions when preparing it:

 

  • Identify, describe, and explain the financial institution that would be the best fit for you. Be sure to justify your selection by referencing the information collected in your completed template.
  • Identify, describe, and explain which type of saving account would best fit your current financial position. Be sure to justify your selection by referencing the information collected in your completed template.
  • Analyze the following situation and answer the questions below:

 

After choosing a savings account with a 3% interest rate, you decide to invest $5,000 into the savings account.

  • Using the future value calculation, determine at an interest rate of 3%, what would be your total balance available at the end of five years if you leave the $5,000 untouched. Show your calculations, as well as, your answer in your portfolio.
  • How will this interest earned be reported on your federal income tax returns?

 

  • Be sure to include the following in your financial portfolio:

 

  • Contact information for the financial institutions
  • Show all steps of your future value calculations in Excel or Word format.
  • Support your statements with examples and at least three scholarly references.

 

Your financial portfolio should be presented as a 3–4-page paper in Word format. Be sure to also include the template you completed for step 1 of the assignment. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M3_A2.doc.

 

By Wednesday, May 28, 2014, deliver your assignment to the M3: Assignment 2 Dropbox.

 

Grading Criteria and Rubric

 

Assignment 2 Grading Criteria
Maximum Points
Completed template, comparing and contrasting the various checking and saving options available and the benefits of each for each institution, including details such as loans, automated teller machine (ATM) access, credit card rates, banking fees, and minimum balance requirements.
36
Identified, described, and explained which financial institution would be the best fit. Justified selection by referencing the information provided in completed template. Provided contact information for the financial institutions.
36
Identified, described, and explained which type of saving account would be the best fit for current financial position. Justified selection by referencing the information provided in completed template.
24
Calculated FV of $5000 at the rate of 3% for 5 years.
24
Discussed how income earned from savings option is reported on a federal tax return.
36
Writing Criteria:
Organization (12)
Style (4)
Usage and Mechanics (12)
APA Elements (16)
44
Total:
200
Click here to view the rubric for this assignment.

 

Note: This assignment is worth 200 points and will be graded using a rubric. Download and read the rubric to understand the expectations.

Which of the following categories of owners have limited liability?

1) Which of the following categories of owners have limited liability? A. General partners B. Sole proprietors C. Shareholders of a corporation D. Both a and b

 

2) The true owners of the corporation are the: A. holders of debt issues of the firm. B. preferred stockholders. C. board of directors of the firm. D. common stockholders.

 

3) In terms of organizational costs, which of the following sequences is correct, moving from lowest to highest cost? A. General partnership, sole proprietorship, limited partnership, corporation B. Sole proprietorship, general partnership, limited partnership, corporation C. Corporation, limited partnership, general partnership, sole proprietorship D. Sole proprietorship, general partnership, corporation, limited partnership

 

4) Which of the following would increase the need for external equity? A. Inadequate investment opportunities B. A slow-down in economic growth C. A reduction in corporate profits D. A seasonal reduction in sales revenues

 

5) When public corporations decide to raise cash in the capital markets, what type of financing vehicle is most favored? A. Retained earnings B. Preferred stock C. Common stock D. Corporate bonds

 

6) __________ is a method of offering securities to a limited number of investors. A. Public offering B. Initial public offering C. Syndicated underwriting D. Private placement

 

7) According to the agency problem, _________ represent the principals of a corporation. A. employees B. shareholders C. suppliers D. managers

 

8) Which of the following is NOT a principle of basic financial management? A. Efficient capital markets B. Risk/return tradeoff C. Profit is king D. Incremental cash flow counts

 

9) Difficulty in finding profitable projects is due to: A. ethical dilemmas. B. social responsibility. C. opportunity costs. D. competitive markets.

 

10) Another name for the acid test ratio is the: A. inventory turnover ratio. B. current ratio. C. average collection period. D. quick ratio.

 

11) Marshall Networks, Inc. has a total asset turnover of 2.5% and a net profit margin of 3.5%. The firm has a return on equity of 17.5%. Calculate Marshall’s debt ratio. A. 50% B. 30% C. 60% D. 40%

 

12) The accounting rate of return on stockholders’ investments is measured by: A. operating income return on investment. B. return on assets. C. realized rate of inflation. D. return on equity.

 

13) If you are an investor, which of the following would you prefer? A. Earnings on funds invested would compound daily. B. Earnings on funds invested would compound annually. C. Earnings on funds invested would compound monthly. D. Earnings on funds invested would compound quarterly.

 

14) When George Washington was president of the United States in 1797, his salary was $25,000. If you assume an annual rate of inflation of 2.5%, how much would his salary have been in 1997? A. $954,719 B. $2,525,548 C. $1,025,000 D. $3,489,097 E. $4,085,920

 

15) Edward Johnson decided to open up a Roth IRA. He will invest $1,800 per year for the next 35 years. Deposits to the Roth IRA will be made via a $150 payroll deduction at the end of each month. Assume that Edward will earn 8.75% over the life of the IRA. How much will he have at the end of 35 years? A. $250,321 B. $125,250 C. $363,000 D. $414,405

 

16) Which of the following is NOT a basic function of a budget? A. Budgets provide the basis for corrective action when actual figures differ from the budgeted figures. B. Budgets indicate the need for future financing. C. Budgets compare historical costs of the firm with its current cost performance. D. Budgets allow for performance evaluation.

 

17) Which of the following statements about the percent-of-sales method of financial forecasting is true? A. It is a much more precise method of financial forecasting than a cash budget would be. B. It is the least commonly used method of financial forecasting. C. It involves estimating the level of an expense, asset, or liability for a future period as a percent of the forecast for sales revenues. D. It projects all liabilities as a fixed percentage of sales.

 

18) All of the following are found in the cash budget EXCEPT: A. new financing needed. B. a net change in cash for the period. C. cash disbursements. D. inventory.

 

19) Which of the following is a non-cash expense? A. Administrative salaries B. Depreciation expenses C. Packaging costs D. Interest expense

 

20) A plant can remain operating when sales are depressed: A. unless variable costs are zero when production is zero. B. if the selling price per unit exceeds the variable cost per unit. C. in an effort to cover at least some of the variable cost. D. to help the local economy.

 

21) The break-even model enables the manager of a firm to: A. determine the optimal amount of debt financing to use. B. calculate the minimum price of common stock for certain situations. C. determine the quantity of output that must be sold to cover all operating costs. D. set appropriate equilibrium thresholds.

 

22) Which of the following is the formula for compound value? A. FVn = P(1+i)-n B. FVn = P(1+i)n C. FVn = P/(1+i)n D. FVn = (1+i)/P

 

23) At what rate must $400 be compounded annually for it to grow to $716.40 in 10 years? A. 8% B. 6% C. 7% D. 5%

 

24) How long will it take $750 to double at 8% compounded annually? A. 12 years B. 6.5 years C. 9 years D. 48 months

 

25) A toy manufacturer following the hedging principle will generally finance seasonal inventory build-up prior to the Christmas season with: A. selling equipment. B. trade credit. C. common stock. D. preferred stock.

 

26) Which of the following is considered to be a spontaneous source of financing? A. Accounts receivable B. Inventory C. Operating leases D. Accounts payable

 

27) Which of the following is NOT considered a permanent source of financing? A. Common stock B. Preferred stock C. Corporate bonds D. Commercial paper

 

28) Dieyard Battery Recyclers is considering a project with the following cash flows: Initial outlay = $13,000 Cash flows: Year 1 = $5,000 Year 2 = $3,000 Year 3 = $9,000 If the appropriate discount rate is 15%, compute the NPV of this project. A. -$466 B. $27,534 C. $4,000 D. $8,891

 

29) We compute the profitability index of a capital-budgeting proposal by: A. dividing the present value of the annual after-tax cash flows by the cost of capital. B. dividing the present value of the annual after-tax cash flows by the cost of the project. C. multiplying the IRR by the cost of capital. D. multiplying the cash inflow by the IRR.

 

30) For the NPV criteria, a project is acceptable if the NPV is __________, while for the profitability index, a project is acceptable if the profitability index is __________. A. greater than zero, greater than one B. greater than one, greater than zero C. less than zero, greater than the required return D. greater than zero, less than one

 

31) Which of the following is considered to be a deficiency of the IRR? A. It is not useful in accounting for risk in capital budgeting. B. It could produce more than one rate of return. C. It fails to properly rank capital projects. D. It fails to utilize the time value of money.

 

32) Which of the following statements about the MIRR is false? A. A project’s MIRR could be lower than a project’s IRR. B. If a project’s MIRR exceeds the firm’s discount rate, the project is acceptable. C. The MIRR has the same reinvestment assumption as the IRR. D. The MIRR has the same reinvestment assumption as the NPV.

 

33) Many firms today continue to use the payback method but employ the NPV or IRR methods as secondary decision methods of control for risk. A. True B. False

 

34) ABC Service can purchase a new assembler for $15,052 that will provide an annual net cash flow of $6,000 per year for five years. Calculate the NPV of the assembler if the required rate of return is 12%. (Round your answer to the nearest $1.) A. $6,577 B. $4,568 C. $1,056 D. $7,621

 

35) The firm should accept independent projects if: A. the NPV is greater than the discounted payback. B. the profitability index is greater than 1.0. C. the payback is less than the IRR. D. the IRR is positive.

 

36) The NPV assumes cash flows are reinvested at the: A. cost of capital. B. NPV. C. IRR. D. real rate of return.

 

37) Cost of capital is: A. the average cost of the firm’s assets. B. a hurdle rate set by the board of directors. C. the coupon rate of debt. D. the rate of return that must be earned on additional investment if firm value is to remain unchanged.

 

38) The marginal cost of preferred stock is equal to: A. the preferred stock dividend divided by the net market price. B. the preferred stock dividend divided by its par value. C. the preferred stock dividend divided by market price. D. (1 – tax rate) times the preferred stock dividend divided by net price.

 

39) The average cost associated with each additional dollar of financing for investment projects is: A. the marginal cost of capital. B. risk-free rate. C. beta. D. the incremental return.

 

40) Given the following information, determine the risk-free rate. Cost of equity = 12% Beta = 1.50 Market risk premium = 3% A. 7.5% B. 7.0% C. 6.5% D. 8.0%

 

41) J & B, Inc. has $5 million of debt outstanding with a coupon rate of 12%. Currently, the yield to maturity on these bonds is 14%. If the firm’s tax rate is 40%, what is the cost of debt to J & B? A. 14.0% B. 8.4% C. 5.6% D. 12.0%

 

42) Shawhan Supply plans to maintain its optimal capital structure of 30% debt, 20% preferred stock, and 50% common stock far into the future. The required return on each component is: debt–10%; preferred stock–11%; and common stock–18%. Assuming a 40% marginal tax rate, what after-tax rate of return must Shawhan Supply earn on its investments if the value of the firm is to remain unchanged? A. 13.0% B. 10.0% C. 14.2% D. 18.0%

 

43) Zybeck Corp. projects operating income of $4 million next year. The firm’s income tax rate is 40%. Zybeck presently has 750,000 shares of common stock which have a market value of $10 per share, no preferred stock, and no debt. The firm is considering two alternatives to finance a new product: (a) the issuance of $6 million of 10% bonds, or (b) the issuance of 60,000 new shares of common stock. If Zybeck issues common stock this year, what will projected EPS be next year? A. $2.96 B. $2.33 C. $1.67 D. $2.10

 

44) Lever Brothers has a debt ratio (debt to assets) of 20%. Management is wondering if its current capital structure is too conservative. Lever Brothers’s present EBIT is $3 million, and profits available to common shareholders are $1,680,000, with 457,143 shares of common stock outstanding. If the firm were to instead have a debt ratio of 40%, additional interest expense would cause profits available to stockholders to decline to $1,560,000, but only 342,857 common shares would be outstanding. What is the difference in EPS at a debt ratio of 40% versus 20%? A. $1.95 B. $1.16 C. $0.88 D. $2.12

 

45) Lever Brothers has a debt ratio (debt to assets) of 40%. Management is wondering if its current capital structure is too conservative. Lever Brothers’s present EBIT is $3 million, and profits available to common shareholders are $1,560,000, with 342,857 shares of common stock outstanding. If the firm were to instead have a debt ratio of 60%, additional interest expense would cause profits available to stockholders to decline to $1,440,000, but only 228,571 common shares would be outstanding. What is the difference in EPS at a debt ratio of 60% versus 40%? A. $4.50 B. $2.00 C. $1.75 D. $3.25

 

46) _________ risk is generally considered only a paper gain or loss. A. Financial B. Translation C. Transaction D. Economic

 

47) Capital markets in foreign countries: A. offer lower returns than those obtainable in the domestic capital markets. B. provide international diversification. C. in general are becoming less integrated due to the widespread availability of interest rate and currency swaps. D. all of the choices.

 

48) A bond sold simultaneously in several different foreign capital markets, but denominated in a currency different from the country in which the bond is issued, is called a(n): A. Eurobond. B. international capital bond. C. world bond. D. floating bond.

 

49) The interplay between interest rate differentials and exchange rates such that both adjust until the foreign exchange market and the money market reach equilibrium is called the: A. arbitrage markets theory. B. balance of payments quantum theory. C. purchasing power parity theory. D. interest rate parity theory.

 

50) If the quote for a forward exchange contract is greater than the computed price, the forward contract is: A. at equilibrium. B. undervalued. C. overvalued. D. a good buy.

 

51) A spot transaction occurs when one currency is: A. traded for another at an agreed-upon future price. B. immediately exchanged for another currency. C. deposited in a foreign bank. D. exchanged for another currency at a specified price.

 

52) An important (additional) consideration for a direct foreign investment is: A. political risk. B. maximizing the firm’s profits. C. attaining a high international P/E ratio. D. all of the above.

 

53) One reason for international investment is to reduce: A. price-earnings (P/E) ratios. B. advantages in a foreign country. C. beta risk. D. portfolio risk.

 

54) Buying and selling in more than one market to make a riskless profit is called: A. arbitrage. B. international trading. C. cannot be determined from the above information. D. profit maximization.

Considering An Investment

2-3) In the spring of 2010, Jemison Electric was considering an investment in a new distribution center. Jemison’s CFO anticipates additional earnings before interest and taxes (EBIT) of $100,000 for the first year of operation of the center in 2011, and, over the next five years, the firm estimates that this amount will grow at a rate of 5% per year. The distribution center will require an initial investment of $400,000 that will be depreciated over a five-year period toward a zero salvage value using straight-line depreciation of $80,000 per year. Furthermore, Jemison expects to invest an amount equal to the firm’s annual depreciation expense to maintain the physical plant. These additional capital expenditures will also be depreciated over a period of five years toward a zero salvage value. Jemison’s CFO estimates that the distribution center will need additional net working capital equal to 20% of new EBIT (i.e., the change in EBIT from year to year).

Assuming the firm faces a 30% tax rate; calculate the project’s annual project free
cash flow (FCF) for each of the next five years.

2-7) CT Computers Inc. is considering whether to begin offering customers the option to have their old personal computers recycled when they purchase new systems. The recycling system would require CT to invest $600,000 in the grinders and magnets used in the recycling process. The company estimates that for each system it recycles. It would generate $1.50 in incremental revenues from the sale of scrap metal and plastics. The machinery has a five-year useful life and will be depreciated using straight-line depreciation toward a zero salvage value. CT estimates that in the first year of the recycling investment, it could recycle 100,000 PCs and that this number will grow by 25% per year over the remaining four-year life of the recycling equipment. CT uses a 15% discount rate to analyze capital expenditures and pays taxes equal to 30%.

a. What are the project cash flows? You can assume that the recycled PCs cost CT nothing.
b. Calculate the NPV and IRR for the recycling investment opportunity. Is the investment a good one based on these cash flow estimates?
c. Is the investment still a good one if the Year 1units recycled is only 75,000?
d. Redo your analysis for a scenario in which CT incurs a cost of $0.20 per unit to dispose of the toxic elements from the recycled computers. What is your recommendation under these circumstances?