When is the line of credit the highest for mci will need

Assignment Help Business Law and Ethics

Reference no: EM133256836

Case: 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 to 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 an 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):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

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?

Reference no: EM133256836

Questions Cloud

Provide a strategy for overcoming your second challenge : HUM 200 Southern New Hampshire University - Provide a strategy for overcoming your second challenge, which was:I read the given document and learned

How was one of america''s first nationalistic writers : Based on what we've read about Wheatley in the Introduction and in her own writings, was she one of America's first Nationalistic writers? If so, how?

Explain the most applicable tort samsung : BUS 1044 George Brown College Canada Explain the most applicable tort Samsung may have committed in relation to its S7 product

What circumstances should a good samaritan be allowed : MGT 2050 Salt Lake Community College discuss your opinion on whether cases like this should be allowed to be brought. Under what circumstances

When is the line of credit the highest for mci will need : FINA 425 American InterContinental University When is the line of credit the highest for MCI will need? If you were a bank manager, would you want MCI as your

Examples of culturally relevant teaching : Pulling from the article Diaz Rico chapter 9, list three specific examples of culturally relevant teaching (CRT).

Describe any ethical difficulties with these scenarios : LSTD 100 American Public University describe any ethical difficulties with these scenarios and provide a brief explanation of the federal legislation pertaining

How national security strategy should address fragile state : Quirk (2021) Why and how the National Security Strategy should address fragile states (Brookings Institute Blog).

Explain why you sustain this position : HTM 450 Seneca College Explain why you sustain this position and highlight which are the 6 elements of the contract traceable in this case

User Account

All Pages