How to solve with step by step instructions, ty

All applicable Cases are available in Connect. .39 Case study-NPV of opening a small business Jinny Buffett recently retired as a Lo 7 flight attendant and is interested in opening a fitness center and health spa exclusively for women in Grand Cayman, where she resides. After careful study, she is somewhat puzzled as to how to proceed. In her words, "I see my business going in one of two directions: Either I open the fitness center and health spa all at once, or I start with the health spa and hold off on the fitness center for a while. Either way, it should be a success because women on this island love to be pampered. My only concern about the fitness center is the initial cost, but if the projections look good enough, I know some investors in Phoenix who can help me get started. In any event, I plan to retire permanently in 10 years," The following information is available: - Jinny has identified a suitable location for her business in a new shopping center in George Town, capital of the Cayman Islands. The developer has units of 1,000 square feet and 2,500 square feet available and is willing to sell either unit for CI\$150 per square foot (CI\$1.00=US\$1.25). Alternatively, the space can be leased at a cost of CIS1.80 per square foot per month, on an annual basis. - Commercial real estate values have mare than doubled in Grand Cuymes during the past 10 years, with no slewdown in sight. As a result. Jinny is thore attracted to the purchase option because she expects the price per square toot to be C1s 300 by the time she is ready to sell her unit ia 10 years, Exercise machines and other equipment necessary to open the fitness center Would cost USS50,000. In addition. USS35,000 would necd to be invested in cybipment related to the health spa. The useful life for all such equipment is 10 yeins; and the expected saivage value is not lagge enoagit to be concertied about. In didition, US\$8.000 would need to be invested in an inventory of conmetics in shaik carc products necessary to operate the health spa. This level of inentify woald need to be maintained throughout the 10-year pertod and will be: givel awiny tis loyal customers when Jinty retires permancintly. - The bealti spa can be operated in the 1,000 -squarc-foot unit. Variable operating: costs would inclute CIS0,10 per square foot per monh for cleaning and Cl50.40 persquare soot per month for utilities. The 2.500-square-foot unit is large enowgh to operate bosh the firness center and health 58a,and and the CIS0.10 rate per square foot for clesning would not change. However. if the 2,900-squate-foot unit were used, the health spa would be located in an open loft that would need to be aircoaditioned at all times. As a resti, utility costs are expected to be CISO. 60 per sguare foot per month under this option. Jinny is a certifned aesthetician and expects to do most of the makeovers. tacials, and peels herself, but she needs a qualified assistant for the health spa. She estimates that hiring an appropriate person will cost [iSS25,000 per year. Likewise, for the fntness center. two full-time acrobics instructors would bc wired tor USS20,000 each per year, and a physical trainer wotald be hired for USS30.d00 peryear. - Additional fixed costs include LSS3.000 per year for advertising and USS4.500 per year for maintenance, insurance, and other items. These costs will be incurred without respect to the size of operations. - Annual membership fees to the fitness center will be CIS300, and a preliminary market survey shows a demand of approximately 500 initial members. Although members tead to come and go, the net change in membership from year to year is not expected to be significant. No adiditional fees will be charged to fitmess center members. - Health spa fees are assessed on a user basis, although the steam room facilities are avalable at no charge to fitness center members. The net cash inflow from cosmetics and skin care products (after deducting the cost of inventory used and sold) is expected to be Cl$8,000 per month. - Jinay's cost of capital is 12%, and there are no taxes in the Cayman Islands. Required: a. Calculate the net present value in USS of an investment in the health spa only, assuming that the 1,000 -square-foot unit is purchased and then resold at the end of 10 years. (Hinf Before making your present value calculations, multiply all amounts expressed in CIS by $1.25 to convert into US\$.) b. Calculate the net present value in USS of an investment in the fitmess center and health spa, assuming that the 2,500 -square-fowt-unit is purchased and then resold at the end of 10 years. c. Jinny is quite concerned about possible forecasting errors and has asked you to prepare a more conservative estimate. Repeat part b, assuming that the fitness center attracts only 300 members per year (rather than 500 ); that the net cash inflow per month from cosmetics and skin care products is only CI\$6,000 per month (rather than CIS8,000 per month); and that commercial real estate values in Grand Cayman at the end of 10 years are only CI\$200 per square foot (rather than CI\$300 per square foot). d. Explain why it might be in Jinny's best interest to lease (rather than purchase) the 1,000 -square-foot unit if she initially decides to open the health spa only. Although no calculations are required, you should consider both quantitative and qualitative factors in your response. e. What is your overall recommendation? Include an explanation of any additional factors that you would consider in making your recommendation. Keep in mind that Jinny has not given herself a salary in her projections. Assume that a reasonable salary would be CIS4,000 per month