In this practical case students assume the role of Finance Manager of the Turrones del Mediterráneo company. Students will work through three sections completing the following tasks: the monthly forecasts of the profit and loss account and the balance sheet the analysis of the working capital and the preparation of the cash budget.
The three parts of this multimedia documentation can be studied individually or together in sequence. Each section contains downloadable Excel files with templates.
This interactive tutorial allows students to understand several important financial concepts such as the present value the future value interest and time amongst others. It shows the relationship between these concepts and how to calculate each.
In order to reach this objective charts with definitions and equations interactive graphs and exercises are included.
This interactive tutorial teaches students the procedures that need to be followed to make financial forecasts. This multimedia resource comprises brief theoretical explanations graphs and an interactive exercise. The exercise will be solved step-by- step as students advance through the program starting with an analysis of the historical data and finishing with the calculation of the funds required.
At the end of this multimedia tool a sensitivity analysis allows students to identify the changes in their forecasts (funds needed or excess funds) that would have occurred had some of the important variables been modified. For example increases or decreases in the cost of goods sold changes in the average collection period of clients changes in the average payment period to suppliers etc.