Clayton State Total Cash Inflows Worksheet Solution

Clayton State Total Cash Inflows Worksheet

Table of Contents

Order ID# 45178248544XXTG457	Plagiarism Level: 0-0.5%	Writer Classification: PhD competent
Style: APA/MLA/Harvard/Chicago	Delivery: Minimum 3 Hours	Revision: Permitted
Sources: 4-6	Course Level: Masters/University College	Guarantee Status: 96-99%

Instructions

Clayton State Total Cash Inflows Worksheet

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%

Clayton State Total Cash Inflows Worksheet

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. (Template attached)

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?

Clayton State Total Cash Inflows Worksheet

RUBRIC
Excellent Quality 95-100%	Introduction 45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.		Literature Support 91-84  points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.			Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score 50-85%	40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.		83-76  points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.			52-49  points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality 0-45%	37-1 points The background and/or significance are missing. No search history information is provided.		75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.			48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.perfectacademic.com/orders/ordernow or www.crucialessay.com/orders/ordernow Clayton State Total Cash Inflows Worksheet

Clayton State Total Cash Inflows Worksheet

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!