Project Costs

Initial Investment Cost

For fixed assets, machinery includes musical instruments, industrial coffee machines, and freezers, while equipment includes cooking utensils, drink dispensers, shop lighting, and vases. Furniture includes sofas, tables, chairs, and flat utensils such as forks, spoons, and glasses.

For current assets, cash is used as working capital. This is because the cost of food ingredients and the cost of drinks provide same-day delivery, so we don't have anything in stock.

Capital Structure

Therefore, accounting for all the assets results in requirement of the total initial investment of 5,574,300 baht, which will be finance by 62.79% debt (3,500,000 baht) and 37.21% owners equity (2,074,300 baht)

We also tried to change the capital structure by consider renting a place and renovate, instead of building a new one, and reducing the numbers of machines and equipment to reduce the initial investment. However, due to the high-cost nature of the business, the initial investment cost is reduced to roughly 3 million, which we still find it not possible to be financed solely on owners equity.

From the data given above calculate Sources and User of Funds, By offering the land that we owned as a collateral, we managed to get the bank loan of 3,500,000 baht with the interest rate of 6% per year, and 5 years loan duration.

this is an example of it, please provide an excel like this and how to calculate thanks.

Sources and Uses of Funds \begin{tabular}{|l|r|} \hline Fixed Assets & Baht \\ \hline Building Construction costs + Decoration & 3,500,000 \\ \hline Equipment & 290,000 \\ \hline Machine & 340,000 \\ \hline Furniture (Tables and Chairs) + Flatware & 260,000 \\ \hline Licensing and Documentary & 30,000 \\ \hline Current Assets & 4,420,000 \\ \hline Cash & \multicolumn{2}{|c|}{ Baht } \\ \hline & 1,154,300 \\ \hline Total Initial Investment & 1,154,300 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \hline & & & \\ \hline THB & Percentage & \\ \hline Total debt & 3,500,000 & 62.79% & \\ \hline Total Initial Investment & 5,574,300 & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular}