During the annual budget preparation TechnoBrix Industries created a cash budget for the winter months (January,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
During the annual budget preparation TechnoBrix Industries created a cash budget for the winter months (January, February, March). The company has a line of credit at Leadership Bank. They can borrow up to $200,000 at an annual rate of interest of 10%. They can only borrow in increments of $1,000. So far for the year they have not had to borrow anything from the line of credit, so the outstanding balance on the loan will be zero on December 31. The company's cash balance on December 31, will be $96,000. If they do end up borrowing from the line of credit, they will pay back as much as possible as soon as they can since interest is charged and must be paid monthly. They do have to maintain a minimum cash balance of $90,000 at the end of each month. If they are below that, they must borrow from the line of credit, but if they are above that they can repay any loan balance with excess cash. *Collections: 35% of the current month's sales budget and 65% of the previous month's sales budget. *Accounts Payable Disbursements: 20% of the current month's accounts payable budget and 80% of the previous month's accounts payable budget. *All other expenses are paid in the month in which they are budgeted Budget Information December January February March Sales $85,000 $90,000 $100,000 $115,000 Accounts Payable $26,000 $36,000 $45,000 $40,000 Payroll $40,000 $50,000 $45,000 $40,000 Rent $12,000 $12,000 $12,000 $12,000 Misc Expenses $3,000 $3,500 $4,000 $4,500 Depreciation $2,000 $2,000 $2,000 $2,000 Create a Cash Budget for January, February, March During the annual budget preparation TechnoBrix Industries created a cash budget for the winter months (January, February, March). The company has a line of credit at Leadership Bank. They can borrow up to $200,000 at an annual rate of interest of 10%. They can only borrow in increments of $1,000. So far for the year they have not had to borrow anything from the line of credit, so the outstanding balance on the loan will be zero on December 31. The company's cash balance on December 31, will be $96,000. If they do end up borrowing from the line of credit, they will pay back as much as possible as soon as they can since interest is charged and must be paid monthly. They do have to maintain a minimum cash balance of $90,000 at the end of each month. If they are below that, they must borrow from the line of credit, but if they are above that they can repay any loan balance with excess cash. *Collections: 35% of the current month's sales budget and 65% of the previous month's sales budget. *Accounts Payable Disbursements: 20% of the current month's accounts payable budget and 80% of the previous month's accounts payable budget. *All other expenses are paid in the month in which they are budgeted Budget Information December January February March Sales $85,000 $90,000 $100,000 $115,000 Accounts Payable $26,000 $36,000 $45,000 $40,000 Payroll $40,000 $50,000 $45,000 $40,000 Rent $12,000 $12,000 $12,000 $12,000 Misc Expenses $3,000 $3,500 $4,000 $4,500 Depreciation $2,000 $2,000 $2,000 $2,000 Create a Cash Budget for January, February, March
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Winston Attoh is considering investing and he obtained the following data from a financial market data provider. Bloomers and Gringos are two firms listed on the stock market. State of Economy...
-
What Is the roll of Human Resource in micro organization. Do human Resource supports in organization Behavior
-
Altec Manufacturing Inc. is a company that manufactures and sells a single product, which they call an Altec. For planning and control purposes they utilize a monthly master budget, which is usually...
-
Suppose that for a sample of n = 11 measurements, we find that n = 72 and s = 5. Assuming normality, compute confidence intervals for the population mean with the following levels of confidence: a....
-
Derive a (1 ) 100% confidence interval for Y|x0, the mean of Y at x = x0, by solving the double inequality t/2,n2 < t < t/2, n2 with t given by the formula of Exercise 14.23.
-
How do repurchases help firms manage the signaling effect of dividends.
-
The Sargent Metal Fabricators has been manufacturing machine tools for a number of years and has an industrywide reputation for high-quality work. The company has been faced with irregularity of...
-
Intermountain Delivery Company acquired an adjacent lot to construct a new warehouse, paying $100,000 and giving a short-term note for $700,000. Legal fees paid were $5,000, delinquent taxes assumed...
-
Consider the graph of the function f(x) x+4x-5 x-6 Determine the x-intercept(s) of f by finding the real zeros of the numerator. Determine the vertical asymptote(s) of f by finding the real zeros of...
-
Write a personal reflection paper on the "Heinz Dilemma" on p. 22 of Applied Professional Ethics. Students will typically write between a half-page to a page in this assignment.
-
CASE: The Caribbean is a diverse region with significant economic potential and growth opportunities. Gross National Income (GNI) per capita varies from around US$800 to over US$30,000 and most...
-
Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for 2022 are presented below. End of Year Beginning of Year Cash and cash...
-
A chemical reagent has a density of 804 kg/m. If the container is filled with a chemical reagent to a height of 1.6 m, what is the pressure at bottom? Round off answer to the nearest whole number....
-
What "turns" did rural sociology take in the 1980s and 1990s? Questions about rural sociology 1.Trends in farming, number of farmers, farm families, # of farms vs. acres farmed, regional differences...
-
Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company's current assets, current liabilities, and sales over the last five years...
-
You are considering investing in a mutual fund. The fund is expected to earn a return of 16 percent in the next year. If its annual return is normally distributed with a standard deviation of 23...
-
Define deferred revenue. Why is it a liability?
-
Depreciation in Germany, like most German accounting practices, is based on: a. The Plan Comptable b. The Autobahn c. The rules laid out in the tax code d. GAAP as commonly agreed by accountants e....
-
Greg Carnes is confused about under- and overapplied manufacturing overhead. Define the terms for Greg, and indicate the balance in the manufacturing overhead account applicable to each term.
-
"Under- or overapplied overhead is reported in the income statement when monthly financial statements are prepared." Do you agree? If not, indicate the proper presentation.
Study smarter with the SolutionInn App