a) As requested by our teacher, we opened a coffee shop in Thailand, from the data provided, calculate the Key Ratios, Weighted Average Cost of Capital (WACC) and answer the question mark to complete the table below. And show it in Excel for me, with the formula to calculate it, thanks a lot.

THB PercentageTotal debt3,500,000 62.79%Total equity2,074,300 37.21%Total Initial Investment5,574,300 Tax rate 20%Risk premium ?Risk-free rate ?Beta ? Weightage of equity? Cost of equity ? Weightage of debt? Cost of debt ?

b) From there calculate Net Present Value (NPV) and Internal Rate of Return (IRR) And show it in Excel for me, with the formula to calculate it, thanks a lot. This is the teacher's example of this part, please do the same.

Af bu