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

Community bursing - What is a wall of fire rising about - 300 word essay - Angle of elevation and depression - Apqc process classification framework - East kilbride rugby club - Essays - What is an era in psychology - Kent wildlife trust jobs - Bioman enzymatic game - Biggest domino track in the world - Best vi cheat sheet - Services and amenities fee unsw - Sandtoft 20 20 minimum pitch - 5 Best WaysTo Treat Your Mental Health Issues - Entire class work - Presentation on social change - Never wed an outlaw nicole snow epub - Fault current calculation formula - Evolution concept map answer key - Essays - Human family maya angelou - Dupli color selection guide - Advantages of non renewable energy - Exponential smoothing problems and solutions - 77 annie street auchenflower - Finance analyst job description - Pneumonia nursing diagnosis and interventions - Reflection and Discussion Forum Week 4 - Op - Disadvantages of advertising to consumers - Standardization of sodium hydroxide naoh solution - Themes in so long a letter by mariama ba pdf - VT #3 - 351 - Hoop dream classic tulsa ok 2018 - Crime short stories for high school - Assignment - Andrew esherick cause of death - Health Assessments - Ts eliot essays hsc - Calculate cash paid to suppliers - Peanut company acquired 90 percent of snoopy company's outstanding - Economics is best described as - Uny group holdings co ltd - Apply tort and criminal law irac case brief - Tae10 training package introductory sections - Reflection - Discussion answers - Types of secondary industry - 7-2 Final Project I Submission: Final Accounting Workbook - Conducting a Needs Assessment - Taylor classical mechanics chapter 10 solutions - Keppel island construction and electrical inc - Week6 assign eco - Mission Observation Proposal - Jane marko buys a car - Miles away from the earth is the moon - Module 13 Writing Assignment - How are cis trans isomers used for night vision - Aqa religious studies a level grade boundaries - Columbine shooting pictures gore - Not all companies are viewed as equal - Full wave rectifier without filter - Which of the following is true regarding diabetes in children - Emerging Threats counterness - Common ions in water - Selected transactions for sophie’s dog care are as follows during the month of march. - Suppose that xtel currently is selling - BE - Journal Analysis 4 - Interview and reflection assignment - Homework - Introductory Paragraph/Outline and body paragraph .My title is COVID 19 factors of risks on jail. - News Analysis 2 - Mail clerk pay scale - Programmed and nonprogrammed decision making ppt - What is the dividend growth model - Stronger faster and more beautiful sparknotes - Late submission penalty unimelb - 370 jingaling brook road - Passion flower adaptations in the rainforest - Charles river cse certificate of analysis - What are exclusive concurrent and residual powers - Prepare a horizontal analysis of the balance sheet - Balance day adjustments examples - Librarian in shawshank redemption - Where does our food come from - Book fair report writing - Earth science lab locating the epicenter of an earthquake - International Business - Case study - Which of the following is considered a hybrid organizational form - Intrafamilial and extrafamilial abuse definition - Define critical self reflection - Dunkin donuts structure - Unsolved mysteries in physics - 26.2 miles as a mixed number in simplest form - Tertiary student concession card nsw - Tung wah group of hospitals chang ming thien college - Scientific Research Paper on Human Population - Liana karapetyan el dorado hills - MKT 630 IP3