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
-
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....
-
Lopez Information Systems is planning to issue 10-year bonds. The going market yield for such bonds is 8.125 percent. Assume that coupon payments will be made semiannually. The firm is trying to...
-
Find f0.01 for F12,8.
-
JASPEN Development Sdn Bhd expert in construction of shop lots and shopping malls. The marketing manager identified a RM5,000 million project on development of a new shopping mall in Batu Kawan,...
-
Draw your net "payout" chart if today's stock price was $ 1 0 0 / share , you purchased a call option at strike price K c = $ 1 1 0 , and you purchased a put option at strike price K P = $ 9 0 .
-
A stock of a company will pay a dividend of $10 next year. Dividends will grow at a steady 10% rate indefinitely, with an expected stock return of 12,237%. Consider a bond that has the same price as...
-
Is the relationship between franchisor and franchisee a fiduciary relationship?
-
What are the possible legal consequences when a false statement is made in a prospectus?
-
On what grounds may the registration of a trademark be opposed?
-
When is reinstatement an unlikely remedy for wrongful dismissal?
-
What factors have encouraged the growth of public regulation of land use?
-
Assume that you and another accounting student are working on a class project together. This project involves reviewing a set of accounting records to look for errors. She has just prepared a trial...
Study smarter with the SolutionInn App