Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Multinational Finance

Authors: Michael Moffett

6th Global Edition

1292215216, 978-1292215211

More Books

Students also viewed these Finance questions