Using a spreadsheet, prepare a cash budget for New Tech for the next year (January through December)
Question:
Using a spreadsheet, prepare a cash budget for New Tech for the next year (January through December) based on the following information.
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment. Its primary purpose is to provide the...
Transcribed Image Text:
New Tech Oct Nov Dec Sales (Prior Year) 325 325 325 Purchases 59.2 Payment Schedule Cash Sales 10% 30 day payment 70% 60 day payment 20% Purchase Schedule Paid first 30 days 40% Paid second 60 days 60% Jan Feb Мы May Jun Jul Aug Sep Oct Nov Dec Apr Sales 325 300 275 325 350 375 400 375 350 300 275 250 Purchases 59 59.2 59.2 59.2 59.2 59.2 59.2 59.2 59.2 59.2 59.2 59.2 Disbursements Freight in 4.2 5.1 5.4 7.3 6.5 6.7 6.6 6.1 5.8 5.7 Labor 40 39 38 42 38.4 44.3 42.5 41 38 39 39.5 38 Utilities 2.5 2.2 2.4 2.5 2.5 2.8 2.7 2.5 2.6 2.6 2.6 2.4 Salaries (Sales) 60 62 65.8 62.8 62.7 67.9 71.6 62.8 64.9 66.9 68 65 Commissions 5.9 5.8 6.8 6.9 7.4 7.8 6.5 6.8 6.4 6.4 Travel 7.1 6.9 6.8 7.6 7.8 8.4 7.5 7.7 7.7 7.9 7.4 Advertising 6.5 8.5 8.7 8.3 S.1 7.2 7.5 Other charges 40 50 21.5 18.3 18.7 18.9 16 8.5 14 Selling Salaries (Admin) 35 35 34 33 36 36 38 39 35 33 32 34 Leasing 5.8 5.8 5.8 5.8 5.8 5.8 5.8 5.8 5.8 3.8 5.8 3.8
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 63% (11 reviews)
Need for external financing When January February March April May June July August September October November December Total 10 decrease in sales 4094 1118 784 37226 50557 2279 3639 6721 6503 3880 105...View the full answer
Answered By
Sigei Kipngeno
I am a professional writer with more than 2 years of writing experience. I will always deliver a grade A paper with zero plagiarism . Thanks in advance.
4.70+
175+ Reviews
311+ Question Solved
Related Book For
Question Posted:
Students also viewed these Managerial Accounting questions
-
Prepare a Cash Budget for the months of July and August 2017 Assume any interest will be paid at the end of the month that follows the month when the money was borrowed Also assume that any surplus...
-
Prepare a cash budget for the Ace Manufacturing Company, indicating receipts and disbursements for May, June, and July. The firm wishes to maintain at all times a minimum cash balance of $20,000....
-
Prepare monthly cash budget for 6 months beginning April 2020. 1. Estimated sales Month Sales (Rs.) Jan20 100,000 Feb20 120,000 March20 140,000 April20 80,000 May20 60,000 June20 80,000 July20...
-
1.The purpose of using a balanced scorecard is for: Multiple Choice A.companies to make sure their business activities align with strategy. B.companies to compare themselves with their competitors....
-
What is the difference between social realism and socialistic realism? Cite examples for each. Social realism
-
In Problems 26, P is a transition matrix for a Markov chain. Identify any absorbing states and classify the chain as regular, absorbing, or neither. P= A .4 1 B .6 0
-
Automobile Injury Insurance Claims. Refer to the description in Exercise 1.5 .We consider \(n=1,340\) bodily injury liability claims from a single state using a 2002 survey conducted by the Insurance...
-
Rouse Manufacturing Limited produces and sells one product, a three-foot Canadian flag. During 20X0, the company manufactured and sold 65,000 flags at $27 each. Existing production capacity is 75,000...
-
Image transcription text PLAN VILL 2010 30 0 I SUGGESTED FIXING POINTS # x MIG TAPPED HOLES, 20 MIN FULL THREAD EQUI SP ON PCD 900 1700 300 1000 DIA MINIMUM CEILING HEIGHT ELECTRONIC CONTROL...
-
For SO2 at 600 K and 300 bur. determine good estimates of the fugacity and of GR/RT.
-
Using a spreadsheet, prepare a cash budget for New Tech for the next year (January through December) based on the following informations. Show you calculation in detail New Tech Oct Nov Dec Sales...
-
Examine the issues associated with a bank merger on various stakeholders . The impact can be substantial for employees of the acquiring and acquired companies, shareholders, customers, and...
-
Suppose initially that inflation is at the central banks target and the output gap is zero. Then, government spending goes down. Deter-mine, with the aid of diagrams, how the degree of price...
-
A child, hunting for his favorite wooden horse, is running on the ground around the edge of a stationary merry-go-round. The angular speed of the child has a constant value of 0.222 rad/s. At the...
-
An accretion disk around a black hole consists of particles in approximately circular orbits about a central mass. The solar system is made up of planets ( made of particles ) in orbit about a...
-
How much energy can be obtained from the U235 in 1 kilogram of natural uranium? Keep in mind that in nature U235 only makes up 0.7% of the total sample. How many grams of the 1 kg sample are...
-
5. (10 points) The quasar 3C273 has a luminosity of 2 x 1039 W. Assuming that 10% of the mass that falls onto the accretion disk is converted into luminosity, how fast is 3C273 accreting gas? Give...
-
A 35.30 kg box is attached to a light rope that is wound around a frictionless cylindrical spool of radius 10.0 cm and moment of inertia of 4.00 kg m2. The reel is suspended from the ceiling and then...
-
Fill in the blank with an appropriate word, phrase, or symbol(s). A voting method that always satisfies the majority criterion and head-to-head criterion, but may not satisfy any other criterion, is...
-
Smthe Co. makes furniture. The following data are taken from its production plans for the year. Required: 1. Determine the hazardous waste disposal cost per unit for chairs and for tables if costs...
-
Using Mohrs circle, determine the moments of inertia and the product of inertia of the area of Problem 9.72 with respect to new centroidal axes obtained by rotating the x and y axes 45 clockwise.
-
Using Mohrs circle, determine the moments of inertia and the product of inertia of the area of Problem 9.73 with respect to new centroidal axes obtained by rotating the x and y axes through 30 o...
-
Using Mohrs circle, determine the moments of inertia and the product of inertia of the area of Problem 9.75 with respect to new centroidal axes obtained by rotating the x and y axes through ugh 60 o...
-
* Write an ARMv8 assembly code to compute the equation y = 12 n=1n5. Assume the value of a is stored in register X20 and is a 64-bit non-zero positive integer. Store the computed value y in X21. Do...
-
Our friend River wrote the code shown with the intention of printing out a message to the user if the variable letter was a lowercase letter. However, upon testing it with the character 'A', the code...
-
The output of the code below is #include #include int main(){ float x; x = floor(7.5); printf("%.2f ",x); return 0;}
Study smarter with the SolutionInn App