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 3% 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 $43,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 July August $ 94,000 $120,000 122,000 108,900 September $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.

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 3% 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 $43,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 July August $ 94,000 $120,000 122,000 108,900 September $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter17: The Management Of Cash And Marketable Securities

Section: Chapter Questions

Problem 10P

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?
and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts Cash payments $ 517,000 409,500 480,000 $ 459,400 351,900 524,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Answer is complete but not entirely correct. KAYAK COMPANY Beginning cash balance Add: Cash receipts Cash Budget January February March SA 40,000 $ 40,000 $ 74,168 517,000 409,500 480,000 557,000 449,500…
Prime Products hopes to borrow $73,000 on April 1 and repay it plus interest of $1,080 on June 30. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $41,800. Accounts receivable on April 1 will total $182,000, of which $156,000 will be collected during April and $20,800 will be collected during May. The remainder will be uncollectible. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three-month period follow: April May June Sales (all on account) $316,000 $575,000 $264,000 Merchandise purchases $214,000 $193,000 $ 151,500 Payroll $ 34,200 $ 34,200 $27,300 Lease payments $31,600 $31,600 $ 31,600 Advertising $ 74,000 $ 74,000 $ 43,000 Equipment purchases $70,500 Depreciation…
Prime Products hopes to borrow $51,000 on April 1 and repay it plus interest of $860 on June 30. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $24,400. Accounts receivable on April 1 will total $151,200, of which $129,600 will be collected during April and $17,280 will be collected during May. The remainder will be uncollectible. b. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments April $285,000 $194,000 May $ 548,000 June $ 251,000 $ 179,000 $ 171,000 $ 35,400 $ 35,400 $ 19,900 $ 35,800 $ 35,800 $ 35,800 Advertising Equipment purchases Depreciation $ 64,400 $ 64,400 $…
Mike's Motors Corp. 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 cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $42,000, and the company has no outstanding loans at that time. Forecasted cash receipts and forecasted cash payments (other than for loan activity) are as follows. Cash Cash Receipts $ 93,000 July August September Payments $121,000 107,900 135,400 119,000 158,000 Prepare a cash budget for July, August, and September. (Negatlve balances and Loan repayment amounts (If any) should be Indicated with mlnus sign. Round your final answers to the nearest whole dollar.) Answer is complete but not entirely correct. MIKE'S MOTORS CORP. Cash Budget For July, August, and September July August September S 30,000 Beginning cash balance Cash receipts…
Ms. Wadeson obtained a $15,000 demand loan from TD Canada Trust on May 23 to purchase a car. The interest rate on the loan was prime plus 2%. The loan required payments of $700 on the fifteenth of each month, beginning June 15. The prime rate was 4.5% at the outset, dropped to 4.25% on July 26, and then jumped by 0.5% on September 14. Prepare a loan repayment schedule showing the details of the first four payments.
Prime Products hopes to borrow $87,000 on April 1 and repay it plus interest of $1,220 on June 30. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $39,000. Accounts receivable on April 1 will total $170,800, of which $146,400 will be collected during April and $19,520 will be collected during May. The remainder will be uncollectible. b. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation Required 1 Required 2 April $ 242,000 $ 213,000 $ 19,600 $ 29,200 $ 62,600 - Beginning cash balance Add receipts: Collections from customers May $…
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.
Karim Corp. requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $9,400, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 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.) KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $9,400 Total cash available Preliminary cash balance Ending cash…
Melody Dairy has a line of credit with its bank. The firm plans to borrow $400,000 at a rate of 10 percent. The bank requires a 15% compensating balance and the firm currently maintains $20,000 in its account at the bank that can be used to meet the compensating balance requirement. Determine the annual finance cost to Melody of this loan.
On March 1, Minnerly Motors obtains a business loan from a local bank. Theloan is a $25,000 interest-only loan with a nominal rate of 11%. Interest iscalculated on a simple interest basis with a 365-day year. What is Minnerly’sinterest charge for the first month (assuming 31 days in the month)?
Mel's Photography borrowed $15 OOO on March 10 on a demand note. The loan was repaid by payments of $4000 on June 20, $3000 on September 1, and the balance on November 15. Interest, calculated on the daily balance and charged to Mel's Photography current account on the last day of each month, was at 5.5% on March 10 but was changed to 6.25% effective June 1 and to 6% effective October 1. How much did the loan cost?