The below provided details are for the ABC Company Actual Sales-Month 01 $30,000 Actual Sales-Month 02...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The below provided details are for the ABC Company Actual Sales-Month 01 $30,000 Actual Sales-Month 02 $40,000 Forecasted Sales-Month 03 $50,000 Forecasted Sales - Month 04 $65,000 Forecasted Sales-Month 5 $75,000 . . The Opening Cash Balance is $5,000 and the company wishes to maintain this balance. The ABC Company's policy and past pattern indicate the following for every month . Cash sales in the month of sale 30% Collected in the 1st month after sale 40% Collected in the 2nd month after sale 30% Other income is $1,00 per month received in cash. ABC companies puthases are made all paid fully in the month of sale and are $30,000 for Month 03, $50,000 for Month 04 and $60,000 for Month 05. Rent amounts to $2,000 per month. Wages are 10% of the current month's sales. A dividend of $4,000 will be paid in Month 04. A capital expenditure on Machinery is budgeted for Month 05, amounting to $10,000. Taxes are $1,000 and are due to be paid in Month 05. a. Prepare the cash budget for Month 03, 04 & 05 using the template provided below. (20 marks) b. Recommend 5 strategies the company could adopt to improve the cash position that you have calculated (5 marks) Sales Cash Sales (30%) Lag 1 month (40%) Lag 2 months (30 %) Other Income Total Cash Receipts Disbursements Purchases Rent Wages & Salaries Dividends Capital Expenditure Taxation Total Cash Disbursements Total Cash Receipts. Total Cash Disbursements Net Cash Flow Add: Beginning Cash Ending Cash Minimum Balance Required Funding (Notes Payable) Excess Cash (Marketable Securities) The below provided details are for the ABC Company Actual Sales-Month 01 $30,000 Actual Sales-Month 02 $40,000 Forecasted Sales-Month 03 $50,000 Forecasted Sales - Month 04 $65,000 Forecasted Sales-Month 5 $75,000 . . The Opening Cash Balance is $5,000 and the company wishes to maintain this balance. The ABC Company's policy and past pattern indicate the following for every month . Cash sales in the month of sale 30% Collected in the 1st month after sale 40% Collected in the 2nd month after sale 30% Other income is $1,00 per month received in cash. ABC companies puthases are made all paid fully in the month of sale and are $30,000 for Month 03, $50,000 for Month 04 and $60,000 for Month 05. Rent amounts to $2,000 per month. Wages are 10% of the current month's sales. A dividend of $4,000 will be paid in Month 04. A capital expenditure on Machinery is budgeted for Month 05, amounting to $10,000. Taxes are $1,000 and are due to be paid in Month 05. a. Prepare the cash budget for Month 03, 04 & 05 using the template provided below. (20 marks) b. Recommend 5 strategies the company could adopt to improve the cash position that you have calculated (5 marks) Sales Cash Sales (30%) Lag 1 month (40%) Lag 2 months (30 %) Other Income Total Cash Receipts Disbursements Purchases Rent Wages & Salaries Dividends Capital Expenditure Taxation Total Cash Disbursements Total Cash Receipts. Total Cash Disbursements Net Cash Flow Add: Beginning Cash Ending Cash Minimum Balance Required Funding (Notes Payable) Excess Cash (Marketable Securities)
Expert Answer:
Answer rating: 100% (QA)
Month 1 Month 2 Month 03 Month 04 Month 05 Sales 30000 40000 50000 65000 75000 Cash Sales 30 9000 12... View the full answer
Related Book For
Business Forecasting with ForecastX
ISBN: 978-0073373645
6th edition
Authors: Holton wilson, barry keating, john solutions inc
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
a. Consider the general effect of the discount rate on the dynamic efficient allocation of a depletable resource across time. Suppose we have two versions of the two-period model discussed in this...
-
The Black Diamond Company mines coal. It would like to build a processing plant right next to its major mine. The location of this mine is relatively remote and is not near other coal mines. Tax...
-
What are the major types of costs? Which costs are controllable by the project manager?
-
Great Wall Chinese Cuisine had \($93,000\) of total assets and \($31,000\) of total stock holders equity at May 31,2010. At May 31, 2011, Great Wall Chinese Cuisine had assets totaling \($147,000\)...
-
1. Which principles of globalization did NR and his colleagues follow when they were growing Infosys into a global powerhouse? 2. According to Hofstedes research, India has a high score on the power...
-
1. A structural beam made of 7075-T6 aluminum has a rectangular cross section 10 mm thick and 100 mm deep. It is subjected to a 3-point bending with a mid-point loading P. The span (distance between...
-
Euro Corporation, a U.S. corporation, operates through a branch in Germany. During 2022, the branch reported taxable income of $1,000,000 and paid German income taxes of $300,000. In addition, Euro...
-
Using a diagram of the Process Control Block (PCB) and a memory map for a process, itemize all of the information that needs to be stored by an Operating System for every process. Give a brief...
-
1 . A 1 . 1 - m - long spring with a spring constant of 6 2 N / m is hanging from the ceiling. It is initially in its equilibrium position. A 0 . 8 2 - kg mass is attached to the end of the spring...
-
Write a job advertisement for an External Auditor. Be sure to include the necessary skills and qualifications, duties and responsibilities for the auditor.
-
You purchase one Blue Bell Inc. September 120 put contract for a premium of $3.17. You hold the option until the expiration date when Blue Bell stock sells for $128.84 per share. Calculate gain/loss...
-
A firm has 10,000,000 shares of common stock outstanding, each with a market price of $15.00 per share. It has 80,000 bonds outstanding, each selling for $1020. The bonds mature in 15 years, have a...
-
A potential difference of 5.60 10 V is used to accelerate a proton initially at rest in a region of space with a 0.420-T uniform magnetic field. What are the following magnetic forces the proton can...
-
If company is incorporated before April 26, 1965 there are four tests to determine the residence of the company. Which one of the following is not a test: Group of answer choices a) where the books...
-
Provide an example of an aggressive accounting practice. Why is this practice aggressive?
-
The United States Department of Agriculture's Child and Adult Care Food Program (CACPF) plays a vital role in improving the quality of day care and making it more affordable for many low-income...
-
Use the second naive forecasting model presented in this chapter to answer parts (a) through (c) of Exercise 2. Use P = 0.2 in preparing the forecast. Which model do you think works the best? Explain...
-
For a data mining classification technique the validation data set lift charts are shown below. What confidence in the model would you express given this evidence?
-
Consider observations \(\left(Y_{i t}, X_{i t} ight)\) from the linear panel data model \[ Y_{i t}=X_{i t} \beta_{1}+\alpha_{i}+\lambda_{i} t+u_{i t} \] where \(t=1, \ldots, T ; i=1, \ldots, n ;\)...
-
In a study of the effect on earnings of education using panel data on annual earnings for a large number of workers, a researcher regresses earnings in a given year on age, education, union status,...
-
Suppose a linear probability model yields a predicted value of \(Y\) that is equal to 1.3. Explain why this is nonsensical.
Study smarter with the SolutionInn App