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 informations. Show you calculation in detail
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: 88% (17 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
Utsab mitra
I have the expertise to deliver these subjects to college and higher-level students. The services would involve only solving assignments, homework help, and others.
I have experience in delivering these subjects for the last 6 years on a freelancing basis in different companies around the globe. I am CMA certified and CGMA UK. I have professional experience of 18 years in the industry involved in the manufacturing company and IT implementation experience of over 12 years.
I have delivered this help to students effortlessly, which is essential to give the students a good grade in their studies.
3.50+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Managerial Accounting questions
-
You have been asked to prepare a cash budget for Whitborrow plc for the next three months, October, November and December. The managers are concerned that they may not have sufficient cash to pay for...
-
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 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...
-
Track a futures contract for 5 consecutive days record the prices and write a short summary (150-200 words) describing how and why prices moved the way they did. You will be graded upon correctly...
-
Explain "less is more", a credo of Ludwig Mies van du Rohe and "form follows function" followed by Sullivan and Wright. Give examples
-
Rosman Company has an opportunity to pursue a capital budgeting project with a five-year time horizon. After careful study, Rosman estimated the following costs and revenues for the project: Cost of...
-
During a refrigeration cycle, heat is rejected by the refrigerant in (a) compressor (b) condenser (c) evaporator (d) expansion valve
-
Jane suffers from a degenerative spinal disorder. Her physician said that swimming could help prevent the onset of permanent paralysis and recommended the installation of a swimming pool at her...
-
Use the simulation Ladybug Revolution (https://phet.colorado.edu/en/simulation/legacy/rotation) Make sure your angle units are in radians. You can change this under the Rotation tab (angle units at...
-
Consider the following two least-squares estimates of the relationship between interest rates and the federal budget deficit in the United States: Model A: Y 1 = 0.103 - 0.079X 1 R 2 = .00 Where: Y 1...
-
Is the personal injury exclusion found in Sec. 104 limited to physical injury? Explain.
-
Using a spreadsheet, prepare a cash budget for New Tech for the next year (January through December) based on the following information. New Tech Oct Nov Dec Sales (Prior Year) 325 325 325 Purchases...
-
The Touch of Class Lounge is in a suburban shopping plaza, or strip mall, in Omaha, Nebraska. Patricia Bauer, the Lounges owner, does not own the parking lot, which is provided for the common use of...
-
What is Stock X's geometric returns if it has the following returns? Year 1 8% Year 2 -5% Year 3 10% Year 4 -6% Year 5 15%
-
Explain the three main types of agglomeration effects. What difficulties exist in identifying those different classifications? Which examples of industrial clusters in your region (Where you are now,...
-
How do individuals cultivate resilience in the face of adversity, drawing upon psychological, social, and neurobiological frameworks? Explain
-
State the reasons why you believe unemployment among high school graduates vs unemployment amongst college graduates (bachelor's or higher) represents a challenge for the economy?
-
TB MC Qu. 3-53 (Algo) Listed below are year-end account balances... Listed below are year-end account balances ($ in millions) taken from the records of Symphony Stores. Debit Credit Accounts...
-
To test if the graph of a polar equation may be symmetric with respect to the line = /2 , replace by_______.
-
Describe the Operations (+,,*,/) that can cause negligible addition (NA), error magnification (EM), or subtractive cancellation (SC) in calculating ?((x^2)+1) - x . Give the range of where they might...
-
For the angle cross section indicated, determine the orientation of the principal axes at the origin and the corresponding values of the moments of inertia. The L76 51 6.4-mm angle cross section of...
-
For the angle cross section indicated, determine the orientation of the principal axes at the origin and the corresponding values of the moments of inertia. The L5 3 1/2 -in. angle cross section of...
-
Using Mohrs circle, determine for the quarter ellipse of Problem 9.67 the moments of inertia and the product of inertia with respect to new axes obtained by rotating the x and y axes about O (a)...
-
An investment of $21700 is accumulated at 5.24% compounded quarterly for three and one-half years. At that time the interest rate is changed to 6.12% compounded monthly. How much is the investment...
-
5. Design a direct-mapped cache structure. The cache has the capacity of 8kB (kilo-byte), assuming 1 block is 512 bytes, and 1 valid bit, 1 tag bit. Calculate (S, E, B, m), draw and explain the cache...
-
Write a complete Python program that computes some measurements related to a swimming pool. Our pool does not have a shallow end, the depth is the same along the length of the pool. From a diving...
Study smarter with the SolutionInn App