Vivian Koyama founded in Your Home, Inc $($IYH$)$ just ten years ago when she was having trouble finding in$-$home support services for her aging parents. She struggleed because her parents wished to stay in their own home, but really weren't ready for a nursing home, bu they were older and needed help with cleaning, cooking, and home upkeep plus someone to drive them to appointments, social events, and shopping when the weather was bad. Vivian, an only child couldn't find anyone reliable and trustworthy to help her out. So shestarted IYH to meet the need. Over the past ten years, demand for the service has skyrocketed and revenues are now just over $$5$ million. The key to the company's success is a group of dedicated employees who treat the clients as if they were their own parents. It had been a great year and things were looking good for the future so Vivian had an idea for rewarding the care givers and shared it with you, the leadership team. The company would buy a piece of real estate in a desirable vacation location. The property would be fully furnshed including linens, dishes, etc. As a reward, Vivian wants to give each of the $40$ employees the use of the propoerty free of charge$-$ maybe one week a year or every other year, just depends on the property. When an employee isn't using the property, Vivian hopes it could be rented to geerate almost enough income to cover the costs. She has worked with the accountant and determined that were is about $$375,000$ cash to spend. Anything above that price will have to be financed. IYH's borrowing rate is $4\mathrm{.}5\%$ and the company can take on up to another $$375,000$ in debt without violating exisiting debt covenats. $*$ Your leadership team is given the task of doing research resulting in a proposal for a property purchase. While you can ignore income tax implications, the report should contain analisys of $1.$ Qualitative aspects of the property. $2.$ Cost analysis including insurance, property taxes, property management fees, upkeep, utilities, etc. $3.$ Possible rental incom, including the break$-$even point between rental income and costs. $4.$ Comprehensive budget and cash flow projections for the first three years. $*$ Assignemnt Requirements: For this task, your group is to research two or three specific properties and choose the one you think will best meet the following requirements: $1.$ Stay within the financing guidelines. $2.$ Be perceived by employees as desirable for family vacation. $3.$ Located in a place with a reputation for good rental income. $4.$ Any other considerations you think are importnant. Travel locations are: Houston Texas, Weather $-$ high and lows by Month in Farenheit. Slowest month for rentals$-$ January. Difference in avergae daily rate between peak months and slowest: $$13.$ Average occupancy rate in slowest month: $50\%.$ Average daily rate: $$116.$ Average Home Price: Approx $$263,147$ and $$325,000.$Year$-$Over$-$Year Medican House Price$-$ doawn $6\mathrm{.}0\%.$ Housing Price index Q$2$: $2013-195\mathrm{.}04.2018-266\mathrm{.}73.2023-387\mathrm{.}43.$ Taxes: No State income tax. Average county tax rate$-2\mathrm{.}130\%.$ Raleigh, North Carolina. Slowest month for rentals$-$ Janurary. Difference in average daily rate between peak months and lsowest: $$14.$ Average occupancy rate in slowest month: $62\%.$ Average daily rate: $$113.$ Average Home Price: Approx $$433,120$ and $$489,000.$ Year$-$Over$-$Year Median House Price$-$ Up $5\mathrm{.}2\%.$ Housing Price Index Q$2$:$2013-154\mathrm{.}60.2018-203\mathrm{.}68.2013-348\mathrm{.}03.$ Taxes: Incole tax$-5\mathrm{.}2\%.$ Average county tax rate$-0\mathrm{.}960\%.$ Clermont, Florida: SLowest month for rentals $-$ September. Difference in average daily rate between peak months and loswest: $$33.$ Average occupancy rate in slowest month: $60\%.$ Average daily rate: $$160.$ Average Home Price: Approx $$329,640$ and $$425,867.$ Year$-$Over$-$Year Median House Price$-$ Up $8\mathrm{.}8\%.$ Housing Price Index Q$2$: $2013-159\mathrm{.}23.2018-250\mathrm{.}26.2023-422\mathrm{.}12.$ Taxes: No state income tax. Average county tax rate$-1\mathrm{.}060\%$