hello pls I need help and steps on how to do this, this is the 2nd time I'm posting it, it wasn't correct. chapter 22 accounting I find it complicated, unlike other chapters. I will highly appreciate it, secondly the steps and making sure is correct as I'm struggle with it.
You recently began a job as an accounting intern at River Golf Park. Your first task was to help prepare the cash budget for April and May. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a paper copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget. LOADING...(Click the icon to view the cash budget.)
Golf Park eliminates any cash deficiency by borrowing the exact amount needed from First Street Bank, where the current interest rate is
8 % per year. River Golf Park first pays interest on its outstanding debt at the end of each month. The company then repays all borrowed amounts at the end of the month with any excess cash above the minimum required but after paying monthly interest expenses. River does not have any outstanding debt on April
1.
Complete the cash budget. Round interest expense to the nearest whole dollar.
River Golf Park |
||
Cash Budget |
||
Two Months Ended May 31 |
||
April |
May |
|
Beginning cash balance |
$16,700 |
$ ? |
Cash receipts |
? |
81,000 |
Cash from sale of plant assets |
0 |
2,200 |
Cash available |
107,200 |
? |
Cash payments: |
||
Purchase of inventory |
? |
44,000 |
Selling and administrative expenses |
47,400 |
? |
Interest expense |
? |
? |
Total cash payments |
98,000 |
? |
Ending cash balance before financing |
? |
22,200 |
Minimum cash balance desired |
(20,000) |
(20,000) |
Cash excess (deficiency) |
? |
? |
Financing: |
||
Borrowing |
? |
? |
Principal repayments |
? |
? |
Total effects of financing |
? |
? |
Ending cash balance |
? |
? |
PrintDone
(Complete all input boxes. Enter a "0" for zero balances. Enter cash deficiencies with a minus sign or parentheses. Enter the net total effects of financing with a minus sign when the amount is a net outflow. Round interest expense to the nearest whole dollar.)
River Golf Park |
||
Cash Budget |
||
Two Months Ended May 31 |
April |
|
Beginning cash balance |
$16,700 |
Cash receipts |
|
Cash from sale of plant assets |
0 |
Cash available |
107,200 |
Cash payments: |
|
Purchase of inventory |
|
Selling and administrative expenses |
47,400 |
Interest expense |
|
Total cash payments |
98,000 |
Ending cash balance before financing |
|
Minimum cash balance desired |
(20,000) |
Cash excess (deficiency) |
|
Financing: |
|
Borrowing |
|
Principal repayments |
|
Total effects of financing |
|
Ending cash balance |
April:
Beginning Loan Balance = $0
Interest Expense = $0
May:
Beginning Loan Balance = $10,800
Interest Expense = $10,800 * 8% * 1/12
Interest Expense = $72
hello pls I need help and steps on how to do this, this is the 2nd...
Hex Company requires a minimum cash balance of $3,500. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed from the previous month's principal balance is paid on the first of the month at 14% per year. The company has already completed the budgeting process for the first quarter for cash receipts and cash payments for all expenses except...
23,300 Call levelpis Cash available Cash payments All expenses except interest 36,000 35,000 40,000 111,000 Interest expense 36,000 Total cash payments Ending cash balance before financing 300) 300) Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance Hudak Company requires a minimum cash balance of $4,300. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used...
Hopp Company requires a minimum cash balance of $3,100. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed from the previous month's principal balance is paid on the first of the month at 17% per year. The company has already completed the budgeting process for the first quarter for cash receipts and cash payments for all expenses except...
You recently began a job as an accounting intern at Rocky Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget. (Click the icon...
i Reference Marlin Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) i (Click the icon to view the additional information.) January February March Total Complete a cash budget for M More Info Cash payments: Purchases of direct materi Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Direct labor...
Harley Company requires a minimum cash balance of $5,000. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed from the previous month's principal balance is paid on the first of the month at 12% per year. The company has already completed the budgeting process for the first quarter for cash receipts and cash payments for all expenses except...
The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is...
A) Prepare Drew Consulting's cash budget for January AND February B) How much cash will Drew borrow in February if cash receipts from customers that month total $39,000 instead of $49,000 Assume Drew Consulting began January with $15,000 cash. Management forecasts that cash receipts from credit customers will be $48,000 in January and $49,000 in February. Projected cash payments include equipment purchases ($18,000 in January and $41,000 in February) and selling and administrative expenses ($3,000 each month). Drew's bank requires...
Could you fill out the financing section for me? need help with borrowing, repayment, and interest 3. Cash Budget April May June Quarter $ 8,000.00 $ 4,000.00 $ 4,000.00 $ 8,000.00 $56,000.00 $ 67,200.00 $82,800.00 $206,000.00 $64,000.00 $ 71,200.00 $86,800.00 $222,000.00 Beginning Cash Balance Add: Cash Collections Total Cash Available Less: Cash Disbursements Materials Selling and administrative Equipment purchase Total Disbursements Excess (Deficiency) Financing: Borrowing Repayment Interest Total Financing Ending Cash Balance $47,850.00 $ 58,500.00 $53,550.00 $159,900.00 $13,300.00 $ 15,460.00...
Yosko has $14,500 in cash on hand on January 1 and has collected the following budget data: (Click on the icon to view the budget data.) Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Yosko has cash payments for selling and administrative expenses including salaries of $55,000 per month plus commissions that are 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $15,000....