Complete company cash budget for the upcoming fiscal year

Assignment Help Financial Accounting

Reference no: EM131212865

Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $300,000 $420,000 $350,000 $370,000 Total cash disbursements $358,000 $328,000 $318,000 $338,000 The company’s beginning cash balance for the upcoming fiscal year will be $35,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 repaid. For simplicity, assume that interest is not compounded. Required: Complete the company's cash budget for the upcoming fiscal year. (Cash deficiency, repayments, and interest, should be indicated by a minus sign.)

Reference no: EM131212865

Questions Cloud

Credit to allowance for doubtful accounts : An account written off in the prior year is to be reinstated. The company uses the allowance method for uncollectibles. The journal entry will require a debit to Bad Debts Expense and a credit to Allowance for Doubtful Accounts. Accounts Receivable a..

Discuss their expansion strategy : Alla Aeroshoes is planning to market and sell its new Bluetooth-enabled shoe in two markets: national and international. The local market will require an initial investment and will have cash inflows for three years. Assume a MARR of 10% and a risk-f..

Unfavorable sales price flexible budget variance : Capilla Company experienced an unfavorable sales volume variance and an unfavorable sales price flexible budget variance. Which of the following is a logical explanation for these variances?

What is the cost of goods sold for the current period : The beginning inventory for North Company consists of 150 units valued at $25 each. Four purchases of 50 units each were made during the year at $25.50, $26, $27, and $29 per unit, respectively. what is the cost of goods sold for the current period?

Complete company cash budget for the upcoming fiscal year : Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Complete the company's cash budget for the upcoming fiscal year.

Income statement approach in estimating uncollectibles : Peterson Company uses the income statement approach in estimating uncollectibles. At the end of the year, Peterson Corporation estimates that 3% of its credit sales of $500,000 will be uncollectible. Allowance for Doubtful Accounts has a debit balanc..

Reported as cash outflow in the cash flow : A company has a net cash inflow from operating activities of $795,000, a net cash outflow of $62,000 from investing activities and a net cash inflow of $101,000 from financing activities. The cash dividends of $206,000 paid will be reported as a cash..

Federal income tax withholding : n December 2009, Homer Simpson worked for Springfield Power and earned $5,000, which will be paid on January 15, 2010. Federal income tax withholding is 15%. The FICA rate is 6.2% and the Medicare tax is 1.45%. How much cash will Springfield Power pa..

Compute the payback period for the machine : (Ignore income taxes in this problem.) Vander Company is considering purchasing a machine that would cost $454,140 and have a useful life of 8 years. The machine would reduce cash operating costs by $84,100 per year. Compute the payback period for th..

User Account

All Pages