Question: Develop a cash budget for the next two months using the information provided below. -Monthly sales forecasts are $210,000 an $30,000 for the ent two

Develop a cash budget for the next two months using the information provided below.

-Monthly sales forecasts are $210,000 an $30,000 for the ent two months

-The current month's sales were $140,000

-80% of sales are collected in the month of sale, with the remainder collected in the following month

-cost of goods sold equal 70% of sales

-the monthly lease payment is $75,000

-the cash position at the end of the current month is $70,000

-the target cash balance is $40,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

4. Develop a cash budget for the next two months using the information provided below. Monthly sales forecasts are $210,000 and $30,000 for the next two months The current month's sales were $140,000...

Q:

Develop a cash budget for the next two months using the information provided below Monthly sales forecast are $210,000 and $30,000 for the next two months The current month's sales were $140,000 80%...

Q:

Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $ 1 5 0 , 0 0 0 , $ 1 8 0 , 0 0 0 , and $ 6 0 , 0 0 0 ( June , July, August ) The...

Q:

Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000. The current month's sales are $120,000 Cost of goods...

Q:

Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000. The current months sales are $120,000 Cost of goods...

Q:

Develope a Cash budget for the next two months using the information provided below Monthly sales forecasts are 210,000 and 30,000 for the next two months The current months sales were 140,000 80% of...

Q:

Develop a cash budget for the next three months using the information provided below Monthly sales forcast are 1 5 0 , 0 0 0 , 1 8 0 , 0 0 0 and 6 0 , 0 0 0 current months sales are 1 2 0 , 0 0 0...

Q:

Develop a cash budget for the next three months using the information provided below Monthly sales forcast are 1 5 0 , 0 0 0 , 1 8 0 , 0 0 0 and 6 0 , 0 0 0 current months sales are 1 2 0 , 0 0 0...

Q:

FIN 370 Excel Assignment 3 (25 points) Use Excel to calculate the solutions to the following problems. Your worksheet will be graded on accuracy, dynamic calculations, and presentation of solutions...

Q:

1. Develop a cash budget for the next 12 months using the information below. (All numbers are in thousands) Monthly sales are forecasted to be $200, $215, $175, $125, $200, $250, $300, $125, $50,...

Q:

Determine whether the 2nd order Runge-Kutta method is consistent, convergent and stable.

Q:

Given B - X = [11]. 10 Solve 2X+B=C 8 and C = -3 14] 100 -3 10

Q:

Field Construction Inc. contants with Mesa Ranch to build a new burs on Mesa's property for which Mesa agress to pry . If this is a valid contract, it will be parity becouse it includes the clement...

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

What are intangible assets? How are they influenced by human resource management practices?

Q:

Staffing, training, compensation, and performance management are important HRM functions. How can each of these functions help companies succeed in meeting the global challenge, the challenge of...

Q:

Many companies have dress codes that require men to wear suits and women to wear dresses. Is this discriminatory according to disparate treatment theory? Why?