Reference no: EM133371173
Case Study: Please only provide a solution if you are certain of it; otherwise, it will not be accepted.
Please fill in the green boxes on the spreadsheet attached to this message that are specific to the property you selected during Phase I. These responses will automatically populate Tables 1, 2, and 3. Link to Property: When conducting a CAPEX analysis, what assumptions are necessary? https://www.point2homes.com. Please explain each of your contributions in great detail and cite all of the sources you used.
The assumptions you make will help with the net present value, modified internal rate of return, economic value added, and discounted payback period calculations.
Short-term rentals' operational cash flow, including the average daily rate, management fee, and vacancy rate, as well as financing through buying and selling. The required rate of return, which is also called the discount rate, the growth rate, the financing rate, which is also called the mortgage interest rate, the closing cost, and the reinvestment rate are all included in this.
Taxes: The method of depreciation used-straight or double declining-is worth ten points and about one-third of a page. A built-in function for obtaining test results is included in the student Excel file. Entities' rates of federal and state taxation.
Table 1:
Table 2 of Operational Net Cash Flow:
Table 3: Terminal Cash Flow The summaries are Year 10 Operational Net Cash Flow.
Questions:
A. In the Fort Myers area, what is the typical daily rate for short-term rental properties?
B. In what ways does the management fee for short-term rentals impact the cash flow from operations?
C. What is the anticipated vacancy rate for Fort Myers' short-term rental properties?
D. In the Fort Myers region, what are the mortgage financing rates?
E. For this property investment, what is the required rate of return or discount rate?
F. How does the property's rate of growth influence the investment?
G. How much will it cost to sell the property and close on it?
H. What is the investment's reinvestment rate?
I. How are taxes for this property calculated using depreciation?
J. What are the property owner's rates of federal and state taxation?