Construct a spreadsheet illustrating the steps Blades treasurer would need to follow in order to speculate on expected movements in the bahts value over the next 30 days. Also show the speculative profit (in dollars) resulting from each scenario. Use both of Ben Holts examples to illustrate possible speculations. Assume the Blades can borrow either $10 million or baht equivalent of this amount. Furthermore, assume that the following short-term interest rates (annualized) are available to Blades:
CURRENCY LENDING RATE BORROWING RATE
Dollars 8.10% 8.20%
Thai baht 14.80% 15.40%