Chegg Writers

support@cheggwriters.com
  • Home
  • Services
    • Assignment Writing Services
      • Essays
      • Term Paper
      • Literature Review
      • Coursework
      • Case Study
      • Capstone Project
      • Speech Writing
    • Dissertation Writing Services
      • Dissertation Proposal
      • Dissertation Writing
      • Dissertation Editing/Proofreading
      • Grant Proposal
    • Report Writing Services
      • Critical Writing
      • Reflective Writing
    • Admission Writing Services
      • Personal Statement
      • Application Essay
      • Scholarship Essay
      • Curriculum Vitae (CV)
      • Other Services
  • How it Works
    • FAQs
  • Testimonials
  • About Us
    • Contact Us
  • Order Now
Place an Order
  • Home
  • blog
  • Prepare a monthly cash budget
 

Prepare a monthly cash budget

Thursday, 03 August 2017 / Published in Uncategorized

Prepare a monthly cash budget

Get An Answer to this Question.

lease read the relevant parts of your textbook, which refer to cash flow and financial planning.

To avoid any uncertainty regarding his business’ financing needs at the time when such needs may arise, Cyrus Brown wants to develop a cash budget for his latest venture: Cyrus Brown Manufacturing (CBM). He has estimated the following sales forecast for CBM over the next 9 months:

March $100,000
April $275,000
May $320,000
June $450,000
July $700,000
August $700,000
September $825,000
October $500,000
November $115,000

He has also gathered the following collection estimates regarding the forecast sales:

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

Payments for direct manufacturing costs like raw materials and labor are made during the month that follows the one in which such costs have been incurred. These costs are estimated as follows:
March $187,500
April $206,250
May $375,000
June $337,500
July $431,250
August $640,000
September $395,000
October $425,000

Additional financial information is as follows:

Administrative salaries will approximately amount to $35,000 a month.
Lease payments around $15,000 a month.
Depreciation charges, $15,000 a month.
A one-time new plant investment in the amount of $95,000 is expected to be incurred and paid in June.
Income tax payments estimated to be around $55,000 will be due in both June and September.
And finally, miscellaneous costs are estimated to be around $10,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.

Group Project Guidelines:

As a group, prepare a monthly cash budget for Cyrus Brown Manufacturing for the 9-month period of March through November.
Use Microsoft Excel to prepare the monthly cash budget.
Based on your cash budget findings, answer the following questions:
Will the company need any outside financing?
What is the minimum line of credit that CBM will need?
What do you think of CBM’s cash position during the budget period? Do you see any concerns for the company in this regard?
If you were a bank manager, would you want CBM as your client? Why or why not?
It is up to the members of the group to divide the assignment tasks evenly. You will be graded on group participation

Your submitted Group Project (200 points) must include the following:

100 Points. A Microsoft Excel spreadsheet that contains your group’s monthly cash budget for Cyrus Brown Manufacturing.
100 Points. A double-spaced Word document of 1–2 pages that contains your answers to the questions listed in the Assignment Guidelines.

Additional Requirements

Max Pages: 1
Level of Detail: Show all work
Other Requirements:

Please read the relevant parts of your textbook, which refer to cash flow and financial planning.

Place an Order Now

What you can read next

1/4c =6
Hi Please provide a tutorial for the attached lesson. I havesome understanding b
Florida National University Chemistry CHM 1033 Homework covering chapter 12

 Why Us

 Money-Back Guarantee 


 Plagiarism-free papers


 Affordable Prices and Discounts


 High Quality Papers


 FREE Revisions


 Professional Writers


 24/7 Support Team

We Accept these Payments

 Format and Free Features

 Approx. 275 words / page


 All paper formats (APA, MLA, Harvard, Chicago/Turabian)


 Font: 12 point Arial/Times New Roman


 Double and single spacing


 FREE bibliography page


 FREE title page


 Progressive Delivery

Secure and Confidential

Trusted

NEED HELP WRITING YOUR PAPER?

PLACE AN ORDER WITH US TODAY AND ENJOY A 10% DISCOUNT. USE DISCOUNT CODE: Disc10

Place an Order

CHEGG WRITERS

Our Company


About us 

Contact Us

Our Testimonials

How it Works

Faqs

Tools


Free Plagiarism Checker

Writing Style Guides

Bibliography Generator

Place an Order

Our Services 


Assignment Help & Services

Dissertation Writing Services

Report Writing Services

Admission Writing Services

Formatting/Editing/Proofreading

Payment Methods


Custom Writing Services

ARTS


Architecture
Art history
Aviation
Drama
Classic English literature
Culture
Film studies
Literature
Music
Philosophy
Poetry
Religious studies
Shakespeare studies
Theater studies
World literature

 

SOCIAL


Civics
Cognitive Science
Criminology
Education
Family and consumer science
Health
Journalism
Psychology
Sociology

LANGUAGES


English

ECONOMIC & FINANCE


Economics
Finance

HISTORY & POLITICS 


Political science
World affairs

LAW


Criminal Law
Business Law

HUMAN & NATURE


Anthropology
Archaeology
Astronomy
Biochemistry
Biology
Botany
Chemistry
Ecology
Environmental studies
Genetics
Geography
Medicine
Nursing
Physics
Urban Studies

 

COMPANY INFO

Live Chat 24/7 Availability

+1 (631) 573-5413

support@cheggwriters.com

DMCA.com Protection Status

© 2008— 2017 Chegg Writers. All Rights Reserved.

Attention!
Using services provided by Cheggwriters.com is LEGAL and IS NOT prohibited.

You are allowed to use the custom written papers we provide in the following ways:

  1. Get a better understanding of the topic or coursework
  2. Help you do your own research (if properly referenced)
  3. As a sample and guide for your research (see your school's definition of plagiarism)
  4. For referencing purposes (if referenced properly)
Thank you for choosing our service.

Disclaimer

Chegg Writers: Provides custom writing services including dissertations, research papers, article writing, term papers, coursework, blog content, and other content for research assistance purposes. Ensure you include proper reference for these material.

Cookie Policy

We use cookies to give you the best possible experience on our website. By continuing to browse and use Chegg Writers, you give consent for cookies to be used. We value your privacy and do not close anything to third parties. Thank you for choosing us.

TOP