Question
Below, various data from a budget of the company ABC S.A., for the first quarter of 2023 ENERO FEBRERO MARZO Team investments 50 75 10
Below, various data from a budget of the company ABC S.A., for the first quarter of 2023
| ENERO | FEBRERO | MARZO |
Team investments | 50 | 75 | 10 |
Interest on old loans | 5 | 5 | 5 |
Salaries and administrative | 150 | 150 | 175 |
Sales | 1000 | 1200 | 1500 |
Shopping | 400 | 500 | 700 |
The company charges 40% cash, of 60% of credit sales, 5% is considered uncollectible and 35% is charged at 30 days and 20% at 60 days. Credit purchases, given the company's bargaining power, are made in a 60-day term and only 10% of the purchase is paid in cash.
By the beginning of January, the company will have $5,500 in cash in its accounts; in December sales were 1,500, with credit purchases for that month being 65% of that value; purchases in November were the same as those in December.
With these data, make a cash budget detailing its components:
1. Beginning balance
2. Income
3. Expenditures
4. Closing balance
Finally, make an investment or financing plan, considering that:
In the future, the company wants to keep 25% of the budgeted expenses for the following month in cash.
That the resources can be invested at a 6% annual rate.
That financing costs 12% annual rate.
That all investments and financing are always settled in the following month (do not forget the new interest generated).
If you require any additional information, please include it and detail it.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started