Our Services

Get 15% Discount on your First Order

Assignment Details Good cash management is impossible without an analysis

February 10, 2022

Assignment Details

Good cash management is impossible without an analysis of the cash collections and cash disbursements of a company. Cash budgets provide a gauge for determining credit, disbursement, and discount policies. Cash budgets are effective control devices for monitoring cash and determining financing requirements.

Cash budgets are essential to all small businesses. In this assignment, you are required to do the following:

Develop a spreadsheet with a cash budget with lagging collections
Determine the net cash flows for the year
Forecast the cumulative dollar amount of the external financing required for the year

You are also required to prepare a 3-page analysis of the results of your cash budget.

Middletown Construction, Inc. has estimated the following sales forecast over the next 12 months (they close in the winter):

January$0February$0March$275,000April$275,000May$312,000June$417,000July$714,000August$611,000September$827,000October$500,000November$116,000December$0

The company also gathered the following collection estimates regarding the forecast sales:

Payment collection within the month of sale = 20%
Payment collection the month following sales = 60%
Payment collection the second month following sales = 20%

Payments for raw materials and labor costs are paid the month after the purchase and are estimated as follows:

March$220,000April$240,000May$225,000June$287,000July$350,000August$415,000September$242,000October$214,000November$222,000

Additional financial information is as follows:

Administrative salaries will approximately amount to $30,000 a month.
Lease payments are around $10,000 a month.
A one-time new plant investment for $23,000 is expected to incur and be paid in June.
Income tax payments estimated to be around $50,000 will be due in both June and September.
Miscellaneous costs are estimated to be around $5,000 a month.
Cash on hand on March 1 will be around $50,000, and a minimum cash balance of $50,000 shall be on hand at all times.

To receive full credit on this assignment, please show all work, including formulas and calculations used to arrive at the financial values.

Prepare a monthly cash budget for Middletown Construction, Inc. for the 12-month period of January through December.
Use Excel to prepare the monthly cash budget with the use of this template.

Based on your cash budget findings, answer the following questions in a 3-page analysis:

Will the company need any outside financing?
When is the line of credit the highest for MCI will need?
If you were a bank manager, would you want MCI as your client? Why or why not?

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Introduction to Indigenous Studies: Higher rates of

PART 1: INTRODUCTION AND ANNOTATED BIBLIOGRAPHY 20% INTRODUTION: (1-2 paragraphs) Write a preliminary introduction outlining the value and relevancy of the topic you will explore in your paper What is your topic area? Define it clearly. Ensure to frame the topic clearly, using research to define the value and importance

For this assignment, you will conduct a detailed SWOT analysis

For this assignment, you will conduct a detailed SWOT analysis of your chosen healthcare organization for your Final Project. Discuss your selected organization’s strengths, weaknesses, opportunities, and possible threats.  The SWOT analysis should include the following five components: • Strengths – An organization’s resources and capabilities that can be used as

The marketing plan must be written to the parent company

The marketing plan must be written to the parent company board of directors in the simulation. The marketing plan is to be written in formal business language as an executive summary and will include the following: A financial and market performance report to date. Strengths, weakness, opportunities, and threats (SWOT)

Describe two different strategies associated with incremental change and radical

Describe two different strategies associated with incremental change and radical change. Provide one example where incremental change is a better solution and one example where radical change should be considered. Describe a scenario where a push or pull innovation would provide a competitive advantage. Include two outcomes that would support your chosen strategy.

Sally Haslanger claims that since gender (men, women, nonbinary, etc.)

Sally Haslanger claims that since gender (men, women, nonbinary, etc.) and race (black, white, etc.) are socially constructed, we should define and understand these terms in ways that are useful to society. In your post, (1) describe how she wants to redefine (or stipulate the meaning of) these terms, and

Please answer the questions with at least 250 words 4 in text citations and 4 references 1.At what stage in a company’s life cycle is its structure most

Please answer the questions with at least 250 words 4 in text citations and 4 references 1.At what stage in a company’s life cycle is its structure most likely to begin driving its strategy? Why? How do business leaders align structure and strategy most effectively at this stage of the

In three to five paragraphs answer the following questions. Define

In three to five paragraphs answer the following questions. Define in your own words “ethical nursing practice.” Describe the basis or framework you used for your definition. Explain the difference between legal and ethical nursing practice. Discuss one ethical or bioethical dilemma a nurse may encounter and describe how

Explain the different ways in which HR objectives can be delivered in

Activity 1 (1000 words) Question 1) Explain the different ways in which HR objectives can be delivered in organisations. HR Generalist , HR Specialist, the role of line managers, Shared Services Model, Outsourcing HR services, Ulrich 3-legged model Question 2) What is the business case for delivering the HR

After reviewing and studying this module’s content, answer the following

After reviewing and studying this module’s content, answer the following questions. Be sure to complete all lab activities and attend/watch all live lectures before completing this assignment. All of your answers should be written in your own words, using full sentences, correct terminology, and proper spelling and grammar. Explain

Technological Pedagogical Content Knowledge (TPACK)

The classroom is Elementary English containing students of Grade 2. As such, the classroom environment has twenty students of whom ten are boys, and ten are girls. The locality of the community is organized with low-class and middle-class families. It means that the children within the learning environment are diverse.

apa format 100-150 word minimum Peer Reply. Watch one student’s

apa format 100-150 word minimum Peer Reply. Watch one student’s video and offer feedback. Please respond to these questions as you provide feedback: What are some items that stood out to you from a delivery standpoint? What did you learn from the speech? Which main point(s) stood out to

Creating lesson plans that align the English Language Proficiency (ELP)

Creating lesson plans that align the English Language Proficiency (ELP) Standards and content standards is a requirement of educators who have English language learners in their classrooms. Among the most important aspects of English language development are the integration of language instruction and practice across the content areas, which includes

Respective to Walter Mosley’s Black Betty, to receive full credit for this assignment, Write/type out an entry in your journal

Respective to Walter Mosley’s Black Betty, to receive full credit for this assignment, Write/type out an entry in your journal after you read two or three chapters. There are 41 chapters, so you would include between 15 to 20 detailed and complete responses to the following prompts. a. What is the

Cather’s “Neighbor Rosicky” (1841); Frost’s “The Road Not Taken” (1887)

Cather’s “Neighbor Rosicky” (1841); Frost’s “The Road Not Taken” (1887) and “Desert Places” (1891); Sandburg’s “Chicago” (1917) and “Grass” (1918); Fitzgerald’s s “Babylon Revisited” (2143); O’Neil’s Long Day’s Journey into Night (2005); and Hughes’ “The Negro Speaks of Rivers” (2227), “I, Too” (2228), and “Song for a

You will assume the role of “management consultant” (one who

You will assume the role of “management consultant” (one who is hired from outside the organization—to remain objective—to analyze, strategize, investigate, and make suggestions on how to improve return on investment [ROI], production, efficiency, or make a team more effective [that is the one you will undertake]). You will

Scenario – Your hospital has recently revised its CQI(Continuous Quality

Scenario – Your hospital has recently revised its CQI(Continuous Quality Improvement) vision and aims based on the work done on the Quality Chasm series. As nurse manager in an ED (Emergency department) you need to take this information and make it “real” for staff in the ED. You and the

For this Discussion you will respond to the following scenario:

For this Discussion you will respond to the following scenario: Imagine that you are an employee in the Health and Human Services Agency (HHSA) of your county. Your department is launching a campaign to increase quality services to the underserved in your community. You are tasked with developing a media

Use the Internet, research and read about various approaches to

Use the Internet, research and read about various approaches to interventions and various settings in which these interventions can occur. You can also visit your local or state health department’s websites or look for journal articles that address the approaches to interventions. Based on your research, express your views on