Property -135 E Northcastle Cir, Conroe, TX 77384 | MLS #37911260 | Zillow

Please provide each all answer in excel sheet format. Need numerical calculation,facts based on US economy and inflation with proper refernces no generic annswer please.The US couple who have bought these proeprty is retired.

What assumptions must be considered to develop a CAPEX analysis? Please explain each of your inputs and reference all sources.

The goal of these assumptions is to help determine the net present value, modified internal rate of return, economic value added, and discounted payback period.

1. Short-term rental operational cash flow (15pts, approx 1 page)

Average daily rate (range)

Management fee (range)

Vacancy rate (range)

2. Financing, including purchasing and selling (25pts, approx 1.5 pages)

Required rate of return (or discount rate)

Growth rate

Financing rate (mortgage interest rate)

Closing cost

Reinvestment rate

3. Taxes (10pts, approx 2/3 page)

Depreciation method (straight or double declining). The student Excel file has a built-in function that allows students to test the results.

Entity federal and state tax rate.

4. Summaries (15pts, approx 1 page)

Table 1- Operational Net Cash Flow

Table 2- Terminal Cash Flow

Table 3- Year 10 Operational Net Cash Flow

Please provide each all answer in excel sheet format

Need numerical calculation,facts based on US economy and inflation with proper refernces no generic annswer please.The US couple who have bought these proeprty is retired.