Results Analysis
Ximena wants to open a home laundry service in Querétaro. Before spending her savings, she needs to know whether there will be customers; and a year later, whether things are really going well or she is just selling a lot. Making decisions without data is guessing: market research asks questions before launch, and financial statements tell what really happened. Learning to read both turns loose numbers into decisions.
Market Research: Sources and Questions
A market study is the research a company does to find out who its potential customers are, how much they would pay, what competition there is, and whether the business is viable. Its steps are: define the objective, choose the sample, prepare the questionnaire, collect the data, and analyze it to make a decision.
The sample is the group of people who are actually asked. For it to be useful, it must resemble the market you want to serve.
Explain what market research is and the difference between primary sources (own surveys and interviews) and secondary sources (already published statistics and reports),…
Explain what market research is and the difference between primary sources (own surveys and interviews) and secondary sources (already published statistics and reports), with one advantage of each type.
In a survey of 200 people in a town, 64 state that they would pay for a door-to-door laundry collection service. a) Calculate the percentage of interested people. b)…
In a survey of 200 people in a town, 64 state that they would pay for a door-to-door laundry collection service. a) Calculate the percentage of interested people. b) Reason what two additional questions you would ask before relying on this data to make an investment (price they would pay, frequency of use, how the sample was selected).
Design a mini market research study to validate opening a zero-waste refill shop in your town: define the objective of the study, the sample (who to ask and how many),…
Design a mini market research study to validate opening a zero-waste refill shop in your town: define the objective of the study, the sample (who to ask and how many), five key questionnaire questions, and how you would analyse the responses to make a decision.
The Income Statement: Taking In Money Is Not Earning It
In a company's income statement, the following appear: sales $\$1\,800\,000$, purchases $\$800\,000$, wages $\$500\,000$, and other expenses $\$200\,000$. Calculate the…
In a company's income statement, the following appear: sales $\$1\,800\,000$, purchases $\$800\,000$, wages $\$500\,000$, and other expenses $\$200\,000$. Calculate the profit or loss for the financial year and interpret its sign in one sentence.
The diagram compares a company's revenue and expenses over two years. Calculate the profit or loss for each year and explain what happened between them: why does the net…
The diagram compares a company's revenue and expenses over two years. Calculate the profit or loss for each year and explain what happened between them: why does the net result worsen if revenue increases?
Profit Margin and KPIs
Why is the margin useful? Because it answers how many cents of profit each peso sold leaves, and that makes it possible to compare a market stall with a chain of stores.
Profit margin on sales is calculated as $\text{margin} = \frac{\text{profit}}{\text{revenue}} \times 100$. Company A generates revenue of $\$4\,000\,000…
Profit margin on sales is calculated as $\text{margin} = \frac{\text{profit}}{\text{revenue}} \times 100$. Company A generates revenue of $\$4\,000\,000$ and makes a profit of $\$400\,000$; Company B generates revenue of $\$1\,600\,000$ and makes a profit of $\$240\,000$. a) Calculate the margin of each company. b) Reason which company is more efficient at turning sales into profit and why looking only at absolute profit can be misleading.
A company has total assets of $\$180,000$ financed with liabilities of $\$120,000$ (75 % of which are short-term) and equity of $\$60,000…
A company has total assets of $\$180,000$ financed with liabilities of $\$120,000$ (75 % of which are short-term) and equity of $\$60,000$. In the last financial year, it generated sales revenue of $\$150,000$ and total expenses of $\$140,000$. Its managing director states: «The year has been a resounding success: we have profits and equity is positive, so we can borrow another $\$40,000$ to open a branch». a) Refute the director's statement by jointly assessing the return on sales and the company's debt and liquidity structure. b) Justify what consequences taking out this new loan would have and propose two financial measures that the company should prioritize to clean up its balance sheet.
Budget Variances and the Risk of Growing Without Margin
A company increased its revenue by 10% over two years, but its profit fell by half. Propose two possible explanations (increase in costs, decrease in prices to gain…
A company increased its revenue by 10% over two years, but its profit fell by half. Propose two possible explanations (increase in costs, decrease in prices to gain market share) and explain which items in the income statement you would inspect to confirm each one.
“Growing in sales is always good news for any company.” Refute this statement with reasoned arguments: a) Justify through which economic and financial mechanism a rapid…
“Growing in sales is always good news for any company.” Refute this statement with reasoned arguments: a) Justify through which economic and financial mechanism a rapid increase in sales can lead to the technical bankruptcy or suspension of payments of a business (relate in your explanation the cash conversion cycle, working capital requirements, and the collection and payment structure). b) If you were the chief financial officer, which two balance sheet or treasury indicators would you monitor to detect this risk before a liquidity crisis occurs? Justify your answer.
Pareto, the Dashboard, and the Honesty of Numbers
A dashboard brings together on a single sheet a handful of KPIs (sales, margin, variances, retention) to monitor the business at a glance.
Back to the beginning: Ximena must survey potential customers (not just her friends), and then keep track of profit, margin, and variances, not just how much she sells.