Cash Budgets case study accounting

Submission file format: Word Document with all the answers plus the EXCEL file used to perform your calculations

Calculation results HAVE TO be explained and the calculation steps explained

Don't use plagiarized sources. Get Your Custom Essay on
Cash Budgets case study accounting
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay

1) Lewis Printing has projected its sales for the first 8 months of 2014 as follows:
Lewis collects 20 percent of its sales in the month of the sale, 50 percent in the month following the sale, and the remaining 30 percent 2 months
following the sale. During November and December of 2013, Lewis’s sales were $220,000 and $175,000, respectively. Lewis purchases raw materials 2
months in advance of its sales. These purchases are equal to 65 percent of its final sales. The supplier is paid 1 month after delivery. Thus, purchases for
April sales are made in February and payment is made in March. In addition, Lewis pays $10,000 per month for rent and $20,000 each month for other
expenditures. Tax prepayments of $22,500 are made each quarter beginning in March. The company’s cash balance as of December 31, 2013, was
$28,000; a minimum balance of $25,000 must be maintained at all times to satisfy the firm’s bank line of credit agreement. Lewis has arranged with its
bank for short-term credit at an interest rate of 12 percent per annum (1 percent per month) to be paid monthly. Borrowing to meet estimated monthly
cash needs takes place at the end of the month, and interest is not paid until the end of the following month. Consequently, if the firm needed to
borrow $50,000 during April, then it would pay $500 (=0.01*$50,000) in interest during May. Finally, Lewis follows a policy of repaying its outstanding
short-term debt in any month in which its cash balance exceeds the minimum desired balance of $25,000.
a) Lewis needs to know what its cash requirements will be for the next 6 months so that it can renegotiate the terms of its short-term credit agreement
with its bank, if necessary. To evaluate this problem, the firm plans to evaluate the impact of a ±20 percent variation in its monthly sales efforts.
Prepare a 6-month cash budget for Lewis and use it to evaluate the firm’s cash needs.
b) Lewis has a $20,000 note due in June. Will the firm have sufficient cash to repay the loan?
2) Extract Gross Margin and Cost of Goods Sold from part 1. Assume that their relationship to sales doesn’t change over the contemplated period.
a) Determine Inventory turnover and AR turnover
b) How long is the operating cycle?
c) Assume the operating cycle increases by 20% (x1,2) due to unforeseen reason, how will that impact the cash budget?
d) What would be the probable effect on a firm’s cash position of the following events?
1) Rapidly rising sales
2) A delay in the payment of payables
3) A more liberal credit policy on sales (to the firm’s customers)
4) Holding larger inventories
What conclusions can you draw from this exercise?

Homework Market
Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Since all our papers are written from scratch, the papers we submit are plagiarism free and we strictly adhere to lecturer’s instructions. Our writers are highly qualified from all over the world and include graduates and professors from most of the largest and known universities in the world. Once you have assigned us your assignment, we select the most qualified and reliable writer to handle your assignment.

Money-back guarantee

Unlike other writing companies, we encourage clients to draw back their money at any stage of the writing process if they experience any uncertainties with the quality of generated content. However, you will hardly have to make this decision because of our business approach that suits your needs.

Zero-plagiarism guarantee

We have an advanced plagiarism-detection system that flags any work that fails to meet the required academic expectations. Our company thrives in honesty, and as such, you will be guaranteed to achieve a paper that meets your expectations.

Timely delivery of urgent papers

At we have online agents that you can chat with to have your assignment taken care of with the little remaining time. Also, we have professional academic writers who will work on your assignment providing you with a high-quality paper at the same time. We can take care of your urgent assignments in less than 5 hours.

Privacy policy

We uphold confidentiality and privacy through our interactions with clients, an aspect that has enhanced our relationship with prospective customers seeking for assignment help. We do not disclose your information with third-parties; neither do we share your work with any other person apart from you.

We do not offer pre-written essays

We do not resell previously-done tasks delivered to other clients. When we deliver orders to our clients, we safeguard their privacy and confidentiality by ensuring the third party does not access the work. By writing the papers from scratch, we have managed to maintain a certain level of originality, which defines our business model. Our qualified editors proofread all submitted work to eliminate mistakes that can interfere with the credibility of the assignment.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
× How can I help you?