Case scenario-cash flow and financial planning

Assignment Help Accounting Basics
Reference no: EM131701325

Case Scenario: CASH FLOW AND FINANCIAL PLANNING

White Ltd generated sales revenues of $325,000 and $375,000 in March and April, and projected sales of $375,000, $400,000, $450,000 and $500,000 for May to August, respectively.

1) Twenty per cent of the firm's sales is for cash, 40% collected 1 month later and the remaining 40% is collected two months later.

2) The firm expects to receive a monthly income of $12,500 attributable to interest and dividends.

3) The firm's purchases during March and April were $200,000 each month and are expected to be $225,000, $250,000, $275,000 and $325,000 during May to August, respectively.

4) Ten percent of the firm's purchases are for cash, 40% is paid one month later and the remaining 50% is paid after a two-month lag.

5) Wages and salaries can be found for each month by adding 10% of the previous month's sales to a fixed $50,000 charge.

6) Monthly office and warehouse rents of $40,000 must be paid.

7) Cash dividends of $20,000 will be paid in May and August.

8) Taxes of $37,500 will be paid in May and August.

9) A loan payment of $75,000, which includes principal and interest, must be made in July.

10) A cash payment of $125,000 will be completed for a new machine in June.

11) The firm's cash balance at the end of April was $87,500.

12) The policy requires a minimum cash balance of $50,000.

Requirements: a) Prepare a cash budget for May, June, July and August.

b) Comment on the firm's cash status forecast for May, June, July and August.

Reference no: EM131701325

Questions Cloud

Discuss the different aspects of the law covered : Discuss the different aspects of the law covered in this course, and how it all comes together to impact the individuals and organizations in society.
Explain the idea of the one big theory : Explain the idea of the One Big Theory. Identify three reasons why separate paradigms are useful in personality psychology.
What might happen to their blood glucose levels : Explain what might happen to their blood glucose levels, their blood glucagon levels, their blood insulin levels and their glycogen stores.
What symptoms either biological or psychological : What symptoms, either biological or psychological, help a clinician create a clinical picture for a particular patient?
Case scenario-cash flow and financial planning : White Ltd generated sales revenues of $325,000 and $375,000 in March and April, and projected sales of $375,000, $400,000, $450,000 and $500,000.
How to protect your small business from cybercrime : What are some key points that you found interesting and can be used in a managerial capacity?
What is average flow time of unit in seconds per student : The school is planning for the next commencement and has the following estimates to work with. What is the average flow time of a unit in seconds per student?
Define the components of whole blood : Define the components of whole blood. What components do you find in the formed element portion of whole blood?
What are the physical characteristics of blood : 1. What are the physical characteristics of blood? What are the functions of blood?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd