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
-
A companys brand (X) has 20% of the market. A market research firm finds that if a person uses brand X, the probability is .7 that he or she will buy it next time. On the other hand, if a person does...
-
The race track is a fascinating example of financial market dynamics at work. Let's go to the track and make a wager. Suppose that, from a field of 10 horses, we simply want to pick a winner. In the...
-
Quest Computers, Inc., makes microprocessor chips and personal computers. Its Microprocessor Division makes the chips and supplies them to the Personal Computer Division. The Personal Computer buys...
-
Question 31 Identify FIVE (5) specific situations that constitute a fire hazard under the Fire Safely Act. Question 32 Must rate the mode of evacuation for a 20-storey commercial building. Question...
-
Find the relative permittivity (E,) of the dielectric material present in a parallel-plate capacitor if: (a) S = 0.12 m2 , d = 80 m, Vo= 12 V and the capacitor contains 1uJ of energy (b) The stored...
-
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...
-
Give examples of four fair disciplinary practices.
-
Changes in economic policies will often have an impact on the unemployment rate. Explain whether each of the policy changes described is likely to affect frictional or structural unemployment and...
-
Bill, age 27, earns a salary of $100,000 in 2020 when the consumer price index was 258. Bill's father earned a salary of 30,000 when the consumer price index was 85.5. As for 2020, who earned a...
-
why accrual journal entries are required and what would happen if we didn't record them at the end of the period. Give at least two examples.
-
If the Rydberg energy is 1 3 . 6 eV , what is the wavelength of light emitted when the electron drops from confined level n = 2 to n = 1 ?
-
"I had an empire of the sun. It was happy and large. White people took it away from me. Little charango. My defeated race cries, defeated by another civilization." What historical and political event...
-
Fill in the blank with an appropriate word, phrase, or symbol(s). The apportionment method that requires rounding the standard quota down to the lower quota is called ________ method.
-
Write a paper about medication error system 2016.
-
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)...
-
Ramirez Company installs a computerized manufacturing machine in its factory at the beginning of the year at a cost of $45,300. The machine's useful life is estimated at 10 years, or 403,000 units of...
-
14. (3 points) Write a program that ask the user for 1. their first name and 2. their last name, Enter first name: Matt Enter last name: Priem Hello Matt Priem! and then outputs a greeting similar to...
-
Given a sorted array 2, 5, 8, 12, 16, 18, 22, 25, 29, 32 and the following interpolation search algorithm. Show the steps of the algorithm when 25 is searched. Also, when 26 is searched. array a,...
Study smarter with the SolutionInn App