Please use Excel to calculate and write the formula

Many thx

The following is the latest Statement of Financial Position of Luxury Hotel and Resort, Queensland, Australia Luxury Hotel and Resort Statement of Financial Position As at 31 Dec 2019 S'000 S'000 As at 31 Dec 2018 S'000 S'000 Non-current assets (net) Plant, Property & Equipment 246,553 148,734 Current Assets Inventory Accounts Receivable Prepayments Cash and Cash equivalents 19 30 1 5,055 35 10 156 7,125 5,105 251,658 Total Assets 7,326 156,060 Equity and Liabilities Equity Share capital 12% Preference shares Retained earnings 60,000 40,000 51,658 60,000 70,000 21.000 151,538 151,000 Non-current Liabilities Medium-term bank loan at 8% 20,000 2,000 7% Bond (irredeemable, maturity Dec 2025) 30,000 3,000 10% Bond (irredeemable, maturity Dec 2030 50,000 0 100,000 5,000 Current Liabilities Accounts Payables 70 50 Accruals 50 10 60 Total Equity and Liabilities 251,658 156,060 Additional information: 1. Luxury Hotel and Resort will be paying shortly ordinary dividend of $0.15 per share. The dividend growth rate is 4% 120 2. Luxury Hotel and Resort has a beta value of 1.4 and the risk-free rate is 4%. The market return is 10% 3. The par value of the ordinary and preference shares are $1.00 4. Ordinary shares are currently traded at $3.20 while the preference shares are traded at $2.10 (all ex-div prices) 5. The market value of the 7% irredeemable bond is 80% of its face value and the 10% irredeemable bond is 90% of its face value. The face value of both the bonds is $1,000. 6. The tax rate is 25%. Generate the WACC (book value basis and market value basis) by synthesizing the cost of individual capital structure components Appraise the WACC (book value basis) with the WACC (market value basis)