Question: 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

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. b) From there calculate Net Present Value (NPV) and Internal Rate of Return (IRR) This is the teacher's example of this part, please do the same.

And show it in Excel for me, with the formula to calculate it, thanks a lot.
\begin{tabular}{|l|l|l|} \hline & THB & Percentage \\ \hline Total debt & 3,500,000 & 62.79% \\ \hline Total equity & 2,074,300 & 37.21% \\ \hline Total Initial Investment & 5,574,300 & \\ \hline Tax rate & & \\ \hline Risk premium & & ? \\ \hline Risk-free rate & & ? \\ \hline Beta & & ? \\ \hline Weightage of equity & ? & \\ \hline Cost of equity & & \\ \hline Weightage of debt & ? & \\ \hline Cost of debt & & \\ \hline \end{tabular} Af bu
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
