Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. Ifnecessary, the company borrows to meet this requirement at a cost of 2% interest per month (paid at the end of each month). Anypreliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $30,000, and thecompany has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loanactivity) follow.Cash receiptsCash paymentsBeginning cash balanceJuly August$ 81,000 $ 107,000109,00095,900Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should beindicated with minus sign. Round your final answers to the nearest whole dollar.)Total cash availableMOTORS CORPORATIONCash BudgetTotal cash paymentsPreliminary cash balanceAdditional loan (loan repayment)Ending cash balanceLoan activityLoan balance, beginning of MonthAdditional loan (loan repayment)Loan balance, end of monthSeptember$ 146,000123,400$$July000August September0 $0$$00000$$$000000

For a company or an organization cash is an important source which are are used by the company to…

Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 2% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $30,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Cash receipts Cash payments Beginning cash balance July $ 81,000 109,000 Total cash available Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) August $ 107,000 95,900 Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan activity Loan balance, beginning of Month Additional loan (loan repayment) Loan balance, end of month MOTORS CORPORATION Cash Budget September $ 146,000 123,400 $ $ July 0 0 0 August September 0 $ 0 $ $ 0 0 0 0 $ 0 $ 0 $ 0 0 0 0 0 0

Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 2% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $30,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Cash receipts Cash payments Beginning cash balance July $ 81,000 109,000 Total cash available Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) August $ 107,000 95,900 Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan activity Loan balance, beginning of Month Additional loan (loan repayment) Loan balance, end of month MOTORS CORPORATION Cash Budget September $ 146,000 123,400 $ $ July 0 0 0 August September 0 $ 0 $ $ 0 0 0 0 $ 0 $ 0 $ 0 0 0 0 0 0

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter16: Working Capital Policy And Short-term Financing

Section: Chapter Questions

Problem 26P

See similar textbooks

Similar questions

Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Scrimiger Paints wants to upgrade its machinery and on September 20 takes out a loan from the bank in the amount of $500,000. The terms of the loan are 2.9% annual interest rate and payable in 8 months. Interest is due in equal payments each month. Compute the interest expense due each month. Show the journal entry to recognize the interest payment on October 20, and the entry for payment of the short-term note and final interest payment on May 20. Round to the nearest cent if required.
Whole Leaves wants to upgrade their equipment, and on January 24 the company takes out a loan from the bank in the amount of $310,000. The terms of the loan are 6.5% annual interest rate, payable in three months. Interest is due in equal payments each month. Compute the interest expense due each month. Show the journal entry to recognize the interest payment on February 24, and the entry for payment of the short-term note and final interest payment on April 24. Round to the nearest cent if required.
Homeland Plus specializes in home goods and accessories. In order for the company to expand its business, the company takes out a long-term loan in the amount of $650,000. Assume that any loans are created on January 1. The terms of the loan include a periodic payment plan, where interest payments are accumulated each year but are only computed against the outstanding principal balance during that current period. The annual interest rate is 8.5%. Each year on December 31, the company pays down the principal balance by $80,000. This payment is considered part of the outstanding principal balance when computing the interest accumulation that also occurs on December 31 of that year. A. Determine the outstanding principal balance on December 31 of the first year that is computed for interest. B. Compute the interest accrued on December 31 of the first year. C. Make a journal entry to record interest accumulated during the first year, but not paid as of December 31 of that first year.
Sub-Cinema Inc. borrowed $10,000 on Jan. 1 and will repay the loan with 12 equal payments made at the end of the month for 12 months. The interest rate is 12% annually. If the monthly payments are $888.49, what is the journal entry to record the cash received on Jan. 1 and the first payment made on Jan. 31?
Pickles R Us is a pickle farm located in the Northeast. The following transactions take place: A. On November 6, Pickles borrows $820,000 from a bank to cover the initial cost of expansion. Terms of the loan are payment due in six months from November 6, and annual interest rate of 3%. B. On December 12, Pickles borrows an additional $200,000 with payment due in three months from December 12, and an annual interest rate of 10%. C. Pickles pays its accounts in full on March 12, for the December 12 loan, and on May 6 for the November 6 loan. Record the journal entries to recognize the initial borrowings, and the two payments for Pickles.
On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.
Now assume that it is several years later. The brothers are concerned about the firm’s current credit terms of net 30, which means that contractors buying building products from the firm are not offered a discount and are supposed to pay the full amount in 30 days. Gross sales are now running $1,000,000 a year, and 80% (by dollar volume) of the firm’s paying customers generally pay the full amount on Day 30; the other 20% pay, on average, on Day 40. Of the firm’s gross sales, 2% ends up as bad-debt losses. The brothers are now considering a change in the firm’s credit policy. The change would entail: (1) changing the credit terms to 2/10, net 20, (2) employing stricter credit standards before granting credit, and (3) enforcing collections with greater vigor than in the past. Thus, cash customers and those paying within 10 days would receive a 2% discount, but all others would have to pay the full amount after only 20 days. The brothers believe the discount would both attract additional customers and encourage some existing customers to purchase more from the firm—after all, the discount amounts to a price reduction. Of course, these customers would take the discount and hence would pay in only 10 days. The net expected result is for sales to increase to $1,100,000; for 60% of the paying customers to take the discount and pay on the 10th day; for 30% to pay the full amount on Day 20; for 10% to pay late on Day 30; and for bad-debt losses to fall from 2% to 1% of gross sales. The firm’s operating cost ratio will remain unchanged at 75%, and its cost of carrying receivables will remain unchanged at 12%. To begin the analysis, describe the four variables that make up a firm’s credit policy and explain how each of them affects sales and collections.
McMasters Inc. specializes in BBQ accessories. In order for the company to expand its business, they take out a long-term loan in the amount of $800,000. Assume that any loans are created on January 1. The terms of the loan include a periodic payment plan, where interest payments are accumulated each year but are only computed against the outstanding principal balance during that current period. The annual interest rate is 9%. Each year on December 31, the company pays down the principal balance by $50,000. This payment is considered part of the outstanding principal balance when computing the interest accumulation that also occurs on December 31 of that year. A. Determine the outstanding principal balance on December 31 of the first year that is computed for interest. B. Compute the interest accrued on December 31 of the first year. C. Make a journal entry to record interest accumulated during the first year, but not paid as of December 31 of that first year.
On January 1, a flower shop contracts with customers to provide flowers for their wedding on June 2. The total contract price is $3,000, payable in equal installments for the next six months on the first of each month (with the first payment due January 1). How much will be recorded as revenue during the month of April?
Able Transport operates a tour bus that they lease with terms that involve a fixed fee each month plus a charge for each mile driven. Able Transport drove the bus 7,000 miles and paid a total of $1,360 in June. In October. Able Transport paid $1,280 for the 5,000 miles driven. If Able Transport uses the high-low method to analyze costs, how much would Able Transport pay in December, if they drove 6,000 miles?