Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

How to create a cash budget in excel

06/10/2021 Client: muhammad11 Deadline: 2 Day

For this assignment you will utilize the excel template to create cash budgets using the example presented in the Chapter 16 PowerPoint. Your assignment will consist of the following:

1) You will create a sheet that prepares the monthly cash budget using the data below as well as the other data provided in the spreadsheet. (44.25 pts)

May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17
Anticipated level of sales $15,000 $20,000 $30,000 $50,000 $40,000 $20,000 $10,000 $5,000 $15,000 $25,000 $40,000 $35,000 $15,000
Estimated labor and raw materials $3,000 $25,000 $38,000 $30,000 $10,000 $5,000 $3,000 $12,000 $14,000 $31,000 $29,000 $14,000 $7,000
2) You will create a sheet that reflects the following changes: management believes that it can increase cash sales from 30% to 60% while reducing the desired level of cash to $4,000 for all months. (21.75 pts)

3) You will create a separate sheet to complete the following:

a) Provide an analysis of the results from the original cash budget created during step 1. The analysis will include a discussion of the anticipated sales in relation to the estimated labor and materials, as well as the overall month to month surplus cash or loan needed and what appears to be attributing to the surplus or need. The analysis should also include a discussion of the implications for the business as presented in the results.(6 pts)

b) If management increases cash sales from 30% to 60%, what type of investment policy does this action typically reflect? What reasons would management have for increasing the anticipated cash sales? Explain and support your response to each question. (4 pts)

c) Using the data, explain how the changes to cash sales and target cash balance would impact the need for external funds each month. What are the potential advantages and disadvantages of implementing the actions without adjusting overall sales? Your response should include a discussion of the goals of cash management, the goal of each action individually, as well as the combined effect on the external funds needed. (4 pts)

Monthly Cash Budget Example

Input Data
Anticipated level of sales

Estimated labor and raw materials

Cash sales 30%
Collections during month after sale

90%
Collections during second month after sale

10%
Other cash receipt - Treasuries (Jun-16)

$10,000
Other cash receipt - Tax refund (Dec-16)

$1,000
Target cash balance (May thru Jan)

$10,000
Target cash balance (Feb thru April)

$6,000
Interest, rent and administrative expenses

$3,000
Other cash disbursement - income tax payments (Sep-16)

$2,500
Other cash disbursement - retire debt issue (Aug-16)

$1,000
Other cash disbursement - retire loan (Jan-17)

$25,000
Cash on hand (May 1, 2016)

$12,000
Prepare a monthly cash budget for the next thirteen months.

Anticipated Sales

Sales (gross)
Cash sales
Collections
During 1st month after sale

During 2nd month after sale

Other cash receipts

Total Cash Receipts

Disbursements
Variable: Labor and raw materials

Fixed: inteerst, rent, and admin expenses

Other cash disbursements

Total cash disbursements

Cash Surplus (or Loan Requirement)

Cash gain (or loss) during the month

Cash position at beginning of month

Cash position at end of month

Target cash balance

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quick Mentor
Engineering Solutions
Finance Homework Help
Homework Tutor
Top Academic Guru
Financial Hub
Writer Writer Name Offer Chat
Quick Mentor

ONLINE

Quick Mentor

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$27 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$34 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

I have read your project details. I can do this within your deadline.

$29 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$28 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I have read and understood all your initial requirements, and I am very professional in this task.

$24 Chat With Writer
Financial Hub

ONLINE

Financial Hub

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$48 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Difference between shuttle and shuttleless loom - Strategic planning for public and nonprofit organizations 4th edition pdf - How many categories are located in the mediastinum subheading - Anatomy drill level 1 anatomical models heart structures internal view - Malcolm x coming to an awareness of language essay - Reclaiming social work aberdeen - Police systems & Practices - Genie wiley case study - Wileyplus accounting answers chapter 1 - Monitoring toddlers and technology thesis statement - Unit 2 assignment public administration - History assignments - Anatomical reference planes and axes - I understand why stars twinkle hogan - Multi touch screens vs mouse driven screens - Bbq roll for left horizontal canal bppv - Why did jesus fold the cloth - Creating bell curve in excel 2007 - AMERICA HISTORY (H101) - College Algebra Homework and Quiz - Westjet case study - Alfred doolittle middle class morality - Assignment help - The mission film guide - Ikea invades america - Gang Activity - The gilda stories chapter 2 summary - Questions to ask during musculoskeletal assessment shadow health - Ut austin turing scholars college confidential - Business strategy game low cost strategy - Bookkeeping for dummies cheat sheet - Sherry turkle no need to call sparknotes - Warwick university it services - Karla tanner opens a web consulting business income statement - Quiksilver dfo south wharf - Genetic theory holds that criminality producing traits are - Clinical Significance - Determination of water hardness by edta titration lab report - The average cost of production is constant along an isoquant. - Samsung model ln t4061f recall - 1.5x iqr rule calculator - Sherman alexie at navajo monument valley tribal school analysis - Life of pi chapters - Simultaneous measurements of position and velocity mastering physics - Research paper 3000 words - Acceptance and commitment therapy for eating disorders - Z score practice worksheet answers - CJ 3200 MOD 3 DB 1 - Marzano's nine high yield instructional strategies - Assume that denis savard inc. has the following accounts at the end of the current year. - How many people per square mile in the world - PSY 104 - Discussion: Policy Proposals-WK6 - Amoeba sisters mitosis and meiosis - Sir joseph hotung net worth - What is a courtroom work group - Three assignments and due dates - Ethical dilemma examples in pediatric nursing - Sustainable assignment - Vital strength define woolworths - Zimmer implant drill sequence - Gender and women's studies hobbs 2nd edition pdf - Discussion Post - Weighted average contribution margin per unit - Sigma aldrich msds sheets - Follansbee trick or treat times - Residency - 2so2 o2 2so3 redox reaction - Cisco ise policy sets - Western leopard toad diet - Human resource management applications nkomo answers - Heady radcliffe funeral home & cremation services - Measurable organizational value example - Discussion 1 250 words by 08/18/20 at 6:00 pm please add references and citations - DBA Assistance - Advantages of a multicultural society and labor force - Swahili gcse - World Civilization and Pre History (2) - Persuasive essay on vaccines - Correct spelling of buffalo plural - Nyc acs code of conduct - Discussion 1 - Hole size m8 tap - Temptation island season 2 episode 9 reddit - Regression movie rotten tomatoes - A new bakery opens downtown. which circumstance would most likely be a negative externality? - Molecular formula of 2 2 dimethylpropane - Johnson beverage inc case study - Partex board price list in bangladesh - American airlines value pricing case analysis - Important lab safety rules - StrategicHumanResourcesManagement_Assessment1 - Week 5 Part 2 - Business Research Methodology - Clues brothers munno para - Need Help with my Research Question and Hypothesis Exercise - Who are the key competitors for uhc medicare supplement product - Oracle number of employees - Pearl e white orthodontist specializes in correcting misaligned teeth - How big is 400 square miles