Whаt cinemаtic techniques аre used tо cоntrast Mоnica’s emotions before and after her first intimate encounter with Clinton?
This essаy questiоn is wоrth 40 pоints in totаl. In this question, we hаve a property 49B Wickliffe, Newark, NJ, for sale as shown in the attached MLS file 102025~2.PDF. A couple is deciding to rent a similar property or purchase this property with 20% down payment and financed with a constant monthly payment fully amortizing mortgage loan at a fixed interest rate for 30 years. Other costs associated with owning include maintenance, insurances, Home Owner Association (HOA) fee, and property taxes. These expenses would not have to be paid if renting is chosen. All other expenses would have to be paid regardless of whether the property is owned or rented, such as utilities, and so on. Because they offset, they don’t have to be included in the analysis. Other assumptions include The couple is estimating the purchase price as the asking price of $265,000, Based on market estimation, the initial rent is $2100 per month, Growth rate in rents, and property value is 2% per year, Insurance for the first year is $960, The maintenance cost is assumed to be $5300 for the first year. In addition, there is a Home Owner Association (HOA) fee $395 per month, Escalation in expenses at 3% per year for the coming 5 years, A marginal income tax rate of 30%, The property tax rate is calculated as $1350 over the sale price, A 1-5-year period of analysis, at the end of which, the property would be sold if owned. Selling expenses of 7% would have to be paid at that time, and The 30-year fixed mortgage rate is 6.2% per year quoted as an Annual Percentage Rate (APR) for the couple. a). Based on the information, what’s the internal rate of return for the couple if they purchase the property and sell it in 1, 2, 3, 4, and 5 years respectively? (3 points for each answer) b). What’s the dollar amount of Net Present Value (NPV) for the couple if they purchase the property and sell it in 1, 2, 3, 4, and 5 years respectively? (3 points for each answer) c). If the couple is planning to stay in the property for 3 years, should they purchase or rent the property? (5 points) d). If the couple is planning to stay in the property for 5 years, should they purchase or rent the property? (5 points) (Hint: You may use the excel template file provided to finish this question. If you need any other assumptions, please list them at the bottom of the template sheet explicitly.) Extra point Question: If the couple wants to breakeven in buying the property and selling it in three years, what is the maximum offer price of the property? (one extra point) If you have used the Excel Template file Template_Midterm_Single Family Rent vs Own-2.xlsx, please upload your finished Excel file at the end of the exam for this question using the “Insert” function at the top of this question. (You can name your file in the format of "[LastName][FirstName]MidtermEssay.xlsx".) If you haven't used the Excel file, you can also type your answer for this question in the text field.