You have been hired by the company LA PLANEACIÓN, S.A., for your track record in Cash Management and for being a CETYS student. With the following information, prepare a Cash Budget by the input-output method: (IMAGE)  ( I think it is easy to understand, especially for a bartleby expert.) The budgeted monthly sales for the following fiscal year are: January - 500000 February - 600000 March - 725000 April - 650000 May - 700000 June - 600000 July - 500000 August - 550000 Sales are made: 35% cash and 65% on credit which are collected in the following month. The outstanding receivables from 2020 are on the balance sheet. The amount of bad debts is insignificant. Purchases are made two months in advance of what is to be sold. The purchase conditions with suppliers are: 40% of purchases are paid in cash, 30% in the month following the purchase and 30% after two months. The balance payable on the account at December 31 consists of credit purchases in November and credit purchases in December. Cost of goods sold is 55% of sales. Salaries and commissions are divided into two parts $35,500 of fixed monthly salaries and commissions of 5% of sales for the month. The commission is paid the following month. The partners are expected to make a stock sale that would bring in $250,000 in April. There will be an extraordinary income in March of $18,000. Provisional payments equal to 2.25% of the sales of a month are made, deferring the payment to the first 15 days of the following month. The balance of taxes payable at December 31 consists of 75% income tax and 25% employee profit sharing, payable in March and May, respectively. On February 1, 2021, a new truck will be purchased for cash at a value of $280,000, which has a useful life of four years and a salvage value of $30,000. Other monthly expenses are: Rent is $58,000; miscellaneous expenses: 15% of cash sales. Depreciation excluding the new truck: $75,000 The company wants to maintain a minimum cash balance of $25,000 at the end of the month. The interest rate is 12% per annum for financing and 9% for investments. Loans are borrowed on the 1st of the month in which they are needed and repaid on the 30th of the month in which there is excess cash. IT IS REQUESTED: To carry out the six schedules that form the budget of inflows and outflows for the first half of 2021. (Six schedules, i mean...): -Cedula cobranza (Collection form) -Cedula entrada (Incoming invoice) -Cedula proveedores (Supplier spreadsheet) -Cedulas salidas (Outgoing spreadsheets) -Presupuesto efectivo (Cash budget) -Presupuesto financiero (Financial budget) IN THE OTHER IMAGE, IS THE PROGRESS I HAVE OF THE EXERCISE IN EXCEL, SO YOU CAN GUIDE YOURSELF (it is in Spanish, but it is easy to understand, please understand, I know you are capable :)) -(Please understand, if you know finance, you know what I am doing in excel.) Note: I want to send more images, so you can better understand what I want you to get (more organized I mean), but bartleby won't allow me to...  If you like you can reject this question to send you more images by posting the same question, what do you think bartleby expert :)?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

You have been hired by the company LA PLANEACIÓN, S.A., for your track record in Cash Management and for being a CETYS student. With the following information, prepare a Cash Budget by the input-output method:

(IMAGE)  ( I think it is easy to understand, especially for a bartleby expert.)

The budgeted monthly sales for the following fiscal year are:

January - 500000
February - 600000
March - 725000
April - 650000
May - 700000
June - 600000
July - 500000
August - 550000

Sales are made: 35% cash and 65% on credit which are collected in the following month. The outstanding receivables from 2020 are on the balance sheet.

The amount of bad debts is insignificant.

Purchases are made two months in advance of what is to be sold. The purchase conditions with suppliers are: 40% of purchases are paid in cash, 30% in the month following the purchase and 30% after two months. The balance payable on the account at December 31 consists of credit purchases in November and credit purchases in December.

Cost of goods sold is 55% of sales.

Salaries and commissions are divided into two parts $35,500 of fixed monthly salaries and commissions of 5% of sales for the month. The commission is paid the following month.

The partners are expected to make a stock sale that would bring in $250,000 in April. There will be an extraordinary income in March of $18,000.

Provisional payments equal to 2.25% of the sales of a month are made, deferring the payment to the first 15 days of the following month. The balance of taxes payable at December 31 consists of 75% income tax and 25% employee profit sharing, payable in March and May, respectively.

On February 1, 2021, a new truck will be purchased for cash at a value of $280,000, which has a useful life of four years and a salvage value of $30,000.

Other monthly expenses are:

Rent is $58,000; miscellaneous expenses: 15% of cash sales. Depreciation excluding the new truck: $75,000 The company wants to maintain a minimum cash balance of $25,000 at the end of the month. The interest rate is 12% per annum for financing and 9% for investments. Loans are borrowed on the 1st of the month in which they are needed and repaid on the 30th of the month in which there is excess cash.

IT IS REQUESTED:
To carry out the six schedules that form the budget of inflows and outflows for the first half of 2021.

(Six schedules, i mean...):
-Cedula cobranza (Collection form)

-Cedula entrada (Incoming invoice)

-Cedula proveedores (Supplier spreadsheet)

-Cedulas salidas (Outgoing spreadsheets)

-Presupuesto efectivo (Cash budget)

-Presupuesto financiero (Financial budget)


IN THE OTHER IMAGE, IS THE PROGRESS I HAVE OF THE EXERCISE IN EXCEL, SO YOU CAN GUIDE YOURSELF (it is in Spanish, but it is easy to understand, please understand, I know you are capable :))


-(Please understand, if you know finance, you know what I am doing in excel.)

Note:
I want to send more images, so you can better understand what I want you to get (more organized I mean), but bartleby won't allow me to... 

If you like you can reject this question to send you more images by posting the same question, what do you think bartleby expert :)?

CIA. PLANEACIÓN, S.A.
Balance Sheet as of December 31, 2020
Active:
Circulant:
Cash
Pasive:
Short-term:
Suppliers
$130,000
520,000
450,000
50,800
$1'150,800
$181,500
40,000
Accounts receivable
Inventory
Prepaid segment
Commissions payable
Taxes payable 110,000
Short-term loan 200,000
Total A.C.
Total Liabilities:
Stockholders' equity:
Contributed capital
Earned capital
Total Stockholders' Equity:
$531,500
Fixed Assets
Eq., Furniture and other $370,000
Accumulated depreciation $128,000
$800,000
61,300
$971,300
Total Fixed Assets:
$242,000
Total Assets:
$1'392,800
Liabilities + equity
$1'392,800
Transcribed Image Text:CIA. PLANEACIÓN, S.A. Balance Sheet as of December 31, 2020 Active: Circulant: Cash Pasive: Short-term: Suppliers $130,000 520,000 450,000 50,800 $1'150,800 $181,500 40,000 Accounts receivable Inventory Prepaid segment Commissions payable Taxes payable 110,000 Short-term loan 200,000 Total A.C. Total Liabilities: Stockholders' equity: Contributed capital Earned capital Total Stockholders' Equity: $531,500 Fixed Assets Eq., Furniture and other $370,000 Accumulated depreciation $128,000 $800,000 61,300 $971,300 Total Fixed Assets: $242,000 Total Assets: $1'392,800 Liabilities + equity $1'392,800
B49
v ! XV fx =B16*B11
A
B
G
25
330,000.00
<-Diciembre
26
275,000.00
<-Noviembre
27 a) Cédula Cobranza:
28 Ventas contado
Enero
Febrero
Marzo
Abril
Mayo
Junio
175,000.00
520,000.00
210,000.00
325,000.00
210,000.00
455,000.00
253,750.00
227,500.00
471,250.00
245,000.00
29 Crédito 30 días
390,000.00
422,500.00
30
31 TOTAL COBROS
695,000.00
535,000.00
643,750.00
698,750.00
667,500.00
665,000.00
32
33 b) Cédula Entradas:
Enero
Febrero
Marzo
Abril
Junio
Mayo
667,500.00
$0.00
34 Cobranza
535,000.00
$0.00
643,750.00
$18,000.00
695,000.00
698,750.00
$0.00
$250,000.00
665,000.00
$0.00
35 Otros Ingresos
$0.00
36 Venta de acciones
37 TOTAL ENTRADAS
695,000.00
535,000.00
661,750.00
698,750.00
667,500.00
665,000.00
38
39 c) Cédula Proveed:
Enero
Febrero
Marzo
Abril
Mayo
Junio
40 Compras contado
159,500.00
99,000.00
143,000.00
154,000.00
132,000.00
115,500.00
107,250.00
110,000.00
121,000.00
41 Compras crédito (30dias)
119,625.00
107,250.00
99,000.00
82,500.00
42 Compras credito (60dias)
99,000.00
262,61as00
82,500.00
119,625.00
115,500.00
209,000.00
99,000.00
43 PAGO PROVEEDOR
258,500.00
261,250.00
247,500.00
203,500.00
44
45 d) Cédula Salidas:
46 Compras
47 Sueldos y Salarios
Febrero
Marzo
Abril
Mayo
209,000.00
35,500.00
Junio
Enero
258,500.00
35,500.00
58,000.00
262,625.00
35,500.00
261,250.00
247,500.00
35,500.00
203,500.00
35,500.00
58,000.00
35,500.00
58,000.00
13,500.00
58,000.00
16,312.50
58,000.00
14,625.00
32,500.00
48 Rentas
58,000.00
11,250.00
25,000.00
280000
49 Pagos Provisionales
15,750.00
35,000.00
50 Comisones
40,000.00
30,000.00
36,250.00
51 Gastos Extraord.
52 Pago Anual ISR
Sheet1
Transcribed Image Text:B49 v ! XV fx =B16*B11 A B G 25 330,000.00 <-Diciembre 26 275,000.00 <-Noviembre 27 a) Cédula Cobranza: 28 Ventas contado Enero Febrero Marzo Abril Mayo Junio 175,000.00 520,000.00 210,000.00 325,000.00 210,000.00 455,000.00 253,750.00 227,500.00 471,250.00 245,000.00 29 Crédito 30 días 390,000.00 422,500.00 30 31 TOTAL COBROS 695,000.00 535,000.00 643,750.00 698,750.00 667,500.00 665,000.00 32 33 b) Cédula Entradas: Enero Febrero Marzo Abril Junio Mayo 667,500.00 $0.00 34 Cobranza 535,000.00 $0.00 643,750.00 $18,000.00 695,000.00 698,750.00 $0.00 $250,000.00 665,000.00 $0.00 35 Otros Ingresos $0.00 36 Venta de acciones 37 TOTAL ENTRADAS 695,000.00 535,000.00 661,750.00 698,750.00 667,500.00 665,000.00 38 39 c) Cédula Proveed: Enero Febrero Marzo Abril Mayo Junio 40 Compras contado 159,500.00 99,000.00 143,000.00 154,000.00 132,000.00 115,500.00 107,250.00 110,000.00 121,000.00 41 Compras crédito (30dias) 119,625.00 107,250.00 99,000.00 82,500.00 42 Compras credito (60dias) 99,000.00 262,61as00 82,500.00 119,625.00 115,500.00 209,000.00 99,000.00 43 PAGO PROVEEDOR 258,500.00 261,250.00 247,500.00 203,500.00 44 45 d) Cédula Salidas: 46 Compras 47 Sueldos y Salarios Febrero Marzo Abril Mayo 209,000.00 35,500.00 Junio Enero 258,500.00 35,500.00 58,000.00 262,625.00 35,500.00 261,250.00 247,500.00 35,500.00 203,500.00 35,500.00 58,000.00 35,500.00 58,000.00 13,500.00 58,000.00 16,312.50 58,000.00 14,625.00 32,500.00 48 Rentas 58,000.00 11,250.00 25,000.00 280000 49 Pagos Provisionales 15,750.00 35,000.00 50 Comisones 40,000.00 30,000.00 36,250.00 51 Gastos Extraord. 52 Pago Anual ISR Sheet1
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education