Download Bài tập tính cash flow and more Exercises Project Management in PDF only on Docsity!
The following Hotel project includes several related information: Value Unit Note 1 Land use 37,500 Million VND 1,500m2 of land use, unit price: 25 2 Construction Developing 2a Construction Works The hotel has 5 floors Building Foundation 3,000 Million VND (^) 80% of land use area, unit price 2. Hotel Building 24,000 Million VND Rooftop 1,440 Million VND (^) 80% of land use area, unit price 1. Ancillary works 510 Million VND Trees and ancillary facilities: 20% Completion costs 869 Million VND 3% of 2a-construction works 2b Equipment costs Machinery and equipment 15,000 Million VND 2c Management and consulting costs during 600 Million VND 3 Other Costs 3a Construction Insurance Costs 596 Million VND 2% of 2a-construction works 3b Additional Costs (Invoices available) 200 Million VND Reasonable expenses incurred 4 Provision Expenses 10% Total cost (excluding interest payment) 5 Working Capital Minimum Cash 5% Revenue Payable 20% Food + Beverage Cost Receivable 10% Revenue Inventory (raw material for restaurant wor 30% Food + Beverage Cost NO Finished Goods Inventory (Assumptio 0 6.1 Room Rental Revenue 6.1.1 Standard Room A Standard Room has square of Unit Price 1.5 Mill/day Quantity 30 Rooms 6.1.2 Superior Room A Superior Room has square of 6 Unit Price 2.3 Mill/day Quantity 40 Rooms 6.1.3 Deluxe Room A Deluxe Room has square of 80m Unit Price 2.8 Mill/day Quantity 15 Rooms 6.1.4 Suite Room A Suite Room has square of 100m Unit Price 4.0 Mill/day Quantity 12 Rooms Note Average Capacity 02 first years 70% Room Rental Revenue 80% of the land use area, Unit pric floors * land use area
From the 3th year 75% Room Rental Revenue Number of operating days per year 365 days 6.2 Restaurant Revenue Average 30% Total Revenue 6.3 Other services Revenue 10% Total Revenue Spa, laundry, tourguide… 6.4 Revenue Deduction 5% Total Revenue For discounts & promotions 7 Cost of goods & services production 7.1 Employees 21% Total Revenue 7.2 Material (food & beverage) 18% Total Revenue 7.3 General Manufacturing costs 12% Total Revenue 8 Management and sales costs 8.1 Management costs 7% Total Revenue 8.2 Marketing & Distribution costs 3% Total Revenue 8.5 Maintenance and Servicing costs 5% Total Revenue 9 Depreciation period 9.1 Construction 5 Years Straight-line depreciation 9.2 Machinery and Equipment 5 Years Straight-line depreciation 10 Other Parameters 10.1 Initial working capital 8,000 Mill 10.2 Long-term loans 40,000 Mill 10.3 Interest payment during construction perio 4,000 Mill Grace period: interest adds to Origi 10.4 Interest rate 10% Years refers to a specified period during w 10.5 Repayment period 5 Years 10.6 Expected return on equity 15% Years 10.7 Construction period 1 Years 10.8 Operating phase/stage 5 Years 10.9 Tax 20% Years 10.10 Liquidation values Fixed assets 5,000 Mill Land use 37,500 Mill FINANCIAL ANALYSIS
1. TOTAL INVESTMENT Year Land use transferation Construction development costs Machinery and Equipment costs Management and consulting costs during construction Other costs Interest payment during construction period Initial working capital Provision Expenses Total investment
- DEBT REPAYMENT SCHEDULE (Equal annual principal payment, decreased interest on balance, interest is grace Year 0 1 2 Debt at beginning period Increased Debt in the period Interest Payment Debt Payment Debt and Interest Payment Debt at ending period 4a. REVENUE PLAN Year 0 1 2 1. Room Rental Revenue Standard class Superior class Deluxe class Suite class **2. Restaurant Revenue
- Other services Revenue Total Revenue Revenue Deduction NET REVENUE** 4b. COST PLAN Year Cost of goods & services production Employees Material (food & beverage) General Manufacturing costs Management and sales costs Management costs Marketing & Distribution costs Maintenance and Servicing costs 4c. Earning After Tax Year NET REVENUE Cost of goods & services production Management and sales costs Depreciation EBIT I EBT
Loss Carried Forward Accumulated Loss Tax EAT
- WORKING CAPITAL PLAN Year Minimum Cash Payable Receivable Inventory Working Capital
- CASH FLOW I. TIPV Ia. Direct method Year 0 Net Revenue Recievable in DIFFERENCE (-) Fixed Assets Liquidation Initial Working Capital Liquidation Cash inflows Investing - Cost of goods & services production Management and sales costs Minimum Cash in DIFFERENCE (+) Payable in DIFFERENCE (-) Inventory in DIFFERENCE (+) Cash outflows - Cash Flow before TAX - Tax - - NET CASH FLOW - - - Ib. Indirect Method Year - 1 2 1. Operating CF EAT Depreciation Interest Payment Net Working Capital in DIFFERENCE (-) OCF 2. Investing CF Investing Fixed Assets Liquidation Initial Working Capital Liquidation
of land use, unit price: 25m/m has 5 floors and use area, unit price 2.5 mill/m and use area, unit price 1.2 mill/m d ancillary facilities: 20% of land use area, unit price 1.7 mill/m -construction works -construction works ble expenses incurred ard Room has square of 40m or Room has square of 60m e Room has square of 80m Room has square of 100m he land use area, Unit price 4 mill/m2 for each floorspace, Note: Total Floorspace = number of and use area
dry, tourguide… unts & promotions ine depreciation ine depreciation riod: interest adds to Original loan value a specified period during which a certain requirement or payment is extended without penalty
n balance, interest is graced during construction period) 3 4 5 3 4 5
