Make the company cash budget for the upcoming fiscal year

Reference no: EM132699479

Problem - 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	$180,000	$330,000	$210,000	$230,000
Total cash disbursements	$260,000	$230,000	$220,000	$240,000

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 repaid. For simplicity, assume that interest is not compounded.

Required - Make the company's cash budget for the upcoming fiscal year.

Reference no: EM132699479

Questions Cloud

Compare and contrast mitosis and meiosis : Compare and contrast mitosis and meiosis.

Differences in the rates or respiration in pinto beans : Describe what evidence you have that cellular respiration occurred in at least some of the beans? Explain using some of your lab data.

Determine the minimum number of employees : Determine the minimum number of employees to schedule that meets the minimum staffing requirements - Create the spreadsheet model and use Solver to solve

Firm after-tax cost of debt-rattle me bones inc : Rattle me Bones, Inc. sold a 20-year bond issue 10 years ago. It pays a 10% semi-annual coupon and has a $1,000 face value. If the current price per bond

Make the company cash budget for the upcoming fiscal year : Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Make the company cash budget for the upcoming fiscal year

What is the project npv : A project requires an investment in fixed asset of $1,400,000. This cost will be depreciated straight-line to zero over the project's ten-year life.

Define value of nursing documentation in healthcare planning : "Nursing Documentation: Is it valuable?" Discuss the value of nursing documentation in healthcare planning. Compare these purposes with the documentation format

What is the project ocf assuming a tax rate : The project is expected to generate annual sales of $60,000 with the variable costs of $20,000 and fixed costs of $5,000. What is the project's OCF assuming a t

What is the actual amount borrowed : Anna Conda purchased a new Toyota Tundra pickup truck for $45,000 and financed $41,000 with a 5 year, 3.5% loan. Following the format of the loan disclosure sta

User Account

All Pages