LHC is a major hotel chain. The company operates 35 hotels of which 14 are owned by it and the rest are owned by others but managed by LHC. LHC's operating revenues and expenses for the just concluded year (year 0) were
CS Professional · Valuations & Business Modelling · PYQS · June 2021
LHC is a major hotel chain. The company operates 35 hotels of which 14 are owned by it and the rest are owned by others but managed by LHC. LHC's operating revenues and expenses for the just concluded year (year 0) were as follows: Particulars in Million Operating Revenues Room rent 1043 Food and beverages 678 Management fee for managed properties 73 Operating Expenses Materials 258 Personnel 258 Upkeep and services 350 Sales and general administration 350 Assets Net fixed assets (Gross Block 2110, Dep 600) 1510 Net current assets 516 Liabilities Net worth 1126 Debt 900 LHC has no non-operating assets. At the beginning of year 0, LHC owned 2190 rooms. It has planned the following additions for next 7 years. Most of the land needed by the company for these additions has been already acquired. Year Rooms (in numbers) Investment in ₹ Millions 1 90 200 2 130 300 3 80 240 4 130 500 5 186 800 6 355 1400 7 150 1300 A good portion of investment in year 7 would be towards purchase of land. It is assumed that the addition will take place at the beginning of the year. For developing the financial projections of LHC, the following assumptions may be made: the occupancy rate will be 60% for year one and thereafter it will increase by 1% per year for next 6 years. the average room rent per day will be ₹ 2500 for year one and it is expected to increase at the rate of 15% per year till year 7. food and beverage revenue is expected to be 65% of the room rent. material expenses, personal expenses, upkeep & service expenses, and sales & general administration expenses will be respectively 15, 15, 18 and 18 percent of the revenues excluding the management fee. working capital investment is expected to be 30% of the revenue from owned properties. the management fee for the managed properties will be 7% of room rent. Room rent from managed properties will be equal to the room rent from owned properties. depreciation is expected to be 7% of net fixed assets. effective tax rate 20%. The market value of equity at the end of year zero is ₹3050 million. The imputed market value of debt is ₹900 million. Stock has a beta 0.921. Risk free rate of return is 12% and the market risk premium is 8%. Post tax cost of debt is 9%. FCF is expected to grow at a rate of 10% per annum after 7 years. Build projections for next 7 years.
Answer & Explanation:
Answer 1(a) Build projections for next 7 years Particulars 1 2 3 4 5 6 7 A. Rooms (in numbers) 2280 2410 2490 2620 2806 3161 3311 B. Occupancy rate 60% 61% 62% 63% 64% 65% 66% C. Average room rent 2500 2875 3306 3802 4373 5028 5783 D. Room rent from owned properties 1248 1543 1863 2291 2867 3771 4613 E. Food and beverage revenues 811 1003 1211 1489 1864 2451 2998 F. Revenue from owned properties (D+E) 2059 2546 3074 3780 4731 6222 7611 G. Management fee from management properties 87 108 130 160 200 264 323 H. Total Revenue (F+G) 2146 2654 3204 3940 4931 6486 7934 I. Material expenses 309 382 461 567 710 933 1142 J. Personnel expenses 309 382 461 567 710 933 1142 K. Upkeep and service expenses 371 458 553 680 852 1120 1370 L. Sales and general admin expenses 371 458 553 680 852 1120 1370 M. Total operating expenses 1360 1680 2028 2494 3124 4106 5024 N. EBIDT (H-M) 786 974 1176 1446 1807 2380 2910 O. Depreciation 120 132 140 166 210 293 329 P. EBIT 666 842 1036 1280 1597 2087 2581 Q. Net operating profit after taxes 533 674 829 1024 1278 1670 2065 R. Gross cash flow (Q+O) 653 806 969 1190 1488 1963 2394 S. Gross investment (Fixed Assets + Current Assets) 302 446 398 712 1085 1848 1716 T. Free cash flow from operations (R-S) 351 360 571 478 403 115 678 U. Net current assets 618 764 924 1134 1419 1867 2283 V. Net current assets addition 102 146 158 212 285 448 416 W. Gross block 2310 2610 2850 3350 4150 5550 6850 X. Capital expenditure 200 300 240 500 800 1400 1300 Y. Accumulated depreciation 720 852 984 1150 1360 1653 1982 Z. Net block 1890 1998 2366 3000 4190 4697 4868 AA. Depreciation 120 132 140 166 210 293 329
Topics: Financial Modeling
Related Questions in this Topic
- A banker is reviewing your proposal for grant of long term loan and working capital facilities. What are the key ratios ...
- Explain the concepts of percentage of sales method and regression analysis method in estimating working capital with the...
- Prepare cash flow statement from the table and information given below: Liabilities 31st March, 2000 31st March, 2...
- Explain the business model followed by Netflix.
- List down the business models for a start-up business. Write a short note on "On demand model".