Assignment Details Good cash management is impossible without an analysis

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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

20/20 – A Story of Transgender Children

2020 A Story of Transgender Children CC YouTube URL: http://www.youtube.com/watch?v=jWKR2wI6OMU In a minimum two-page academic paper, illustrate your personal understanding and ability to apply what you have learned from this week’s assigned video in your future professional role. Further consider how your observations of the week’s topics will enhance your

Dependence structure modelling (with emphasis on Multivariate Count

Interested in the Methodology section which should include the mathematical derivations and proofs. Also based on reviewed methodology s(h)e should propose a novel class of model(s) which is/are efficient, unbiased and robust satisfying all the asymptotic properties backed with proofs, algorithms and simulations. Software for analysis is R or Python

n epidemiology, meta-analyses are becoming a common research design. They

  n epidemiology, meta-analyses are becoming a common research design. They are also “the most frequently cited form of clinical research,” and as such are an important type of study for the advanced practice nurse to be familiar with (Haidich, 2010). For this Assignment, you will analyze a meta-analysis article

Overview & Background For this assignment, we will be focusing

  Overview & Background For this assignment, we will be focusing on one of the goals of the Los Angeles River Revitalization Master Plan: to revitalize the river by improving water quality and restoring a functional ecosystem.  For this assignment, you will again focus on the animal species you selected

Their Eyes Were Watching God, Zora Neale Hurston is the

Their Eyes Were Watching God, Zora Neale Hurston is the book  For each text read this semester, we will be writing a reading response. These are one-page, double-space responses (think around 300 words), in which you pick a short quotation from the book that you think exemplifies some larger theme

“An old formula (Maier, 1967) tells us that Performance =

 “An old formula (Maier, 1967) tells us that Performance = Ability X Motivation. IF you have both talent and desire, you’ll do well. Theories of motivation seek to explain the desire part of that formula (Bolman & Deal, 2017).Select one theory of motivation and discuss two insights it provides into motivating employees.

Book review: “The Distance Between Us” by Reyna Grande

Description Guidelines for a book review: “The Distance Between Us” by Reyna Grande Reviews must include a brief biographical sketch of the author, a brief summary of the book, and a substantial analysis of its contents. INSTRUCTIONS: ****NO DIRECT QUOTATIONS FROM THE BOOK: your writing should reflect your understanding of

Review Chapter 9 of the course text to learn about

  Review Chapter 9 of the course text to learn about methods for measuring outcomes.  Consider the outcomes that you have crafted for your proposed program and how you might measure the extent to which the program is achieving those outcomes. Use the Walden Library link in the Learning Resources

There’s no one-size-fits-all answer to this question, as there are

  There’s no one-size-fits-all answer to this question, as there are a variety of different types of blogs out there on the internet. However, a good place to start looking for blogs related to your niche or problems is by using a search engine like Google.  There are many blogging

Find the Best Facility Location Your boss has given you

  Find the Best Facility Location Your boss has given you the task of recommending a location for a new warehouse in the country of Luxembourg. Your company is a wholesaler of fruit and needs to supply all of the stores of a major food chain in Luxembourg. Currently, all

Explain how you performed your research for the project with

   Explain how you performed your research for the project with the use of a minimum of 5 different research sources. The names of these research sources can be a website, a book, an eBook, a journal or a newspaper article. Do not give the website URL address in this

Your son is graduating from high school and is about

  Your son is graduating from high school and is about to enter the work force. He has developed a strong curiosity about our economic system and how it works. Because you have a good understanding of basic economics, he has asked you to explain several concepts that are essential

Topic: Heart Disease among older adults In week 1, you

 Topic:  Heart Disease among older adults In week 1, you selected a topic and developed a research question for that topic. Then, you developed a data gathering instrument to measure the question either quantitatively or qualitatively. Now that you have had the opportunity to read how scholarly methodologies are written,

Analysis of John Steinbeck’s The Harvest Gypsies

Our second paper is an analysis of John Steinbeck’s The Harvest Gypsies. This will be a paper of approximately five pages in length. Some questions you will want to entertain include the following: 1. How did Steinbeck find out about the plight of the “Okies” and conditions at the camps?

Director’s Presentation: The director of a preschool program that

You are the director of a preschool program that serves children ages three to five. You are giving a presentation to teachers and parents to encourage partnerships in the education of the whole child. The objective of your presentation is to encourage adaptive skills and to facilitate strategies in which

British Musicals from 1950 till 1960

 Your completed essay will include two components, as outlined below:. 1. Critical analysis of specific period, artist or work From across the history of musical theatre as a genre, select for examination and analysis ONE OF THE FOLLOWING upon which to focus your writing: 1. A specific period or focus