Forest outfitters is a retailer that is preparing its

Reference no: EM13483264

Forest Outfitters 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	$ 434,000	$ 687,000	$ 421,000	$ 515,000
Total cash disbursements	$ 528,000	$ 409,000	$ 422,000	$ 474,000

The company's beginning cash balance for the upcoming fiscal year will be $57,900. The company requires a minimum cash balance of $30,200 and may borrow any amount needed from a local bank at a quarterly interest rate of 1.7%. 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.

Required:

Complete the company's cash budget for the upcoming fiscal year. (Input all amounts as positive values except cash deficiency, repayments, and interest, which should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to the nearest dollar amount. Omit the "$" sign in your response.)

Forest Outfitters Cash Budget
	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Year
Cash balance, beginning	$	$	$	$	$
Total cash receipts

Total cash available
Less total cash disbursements

Excess (deficiency) of cash available over disbursements

Financing:
Borrowings (at beginning)
Repayments (at ending)
Interest

Total financing

Cash balance, ending	$	$	$	$	$

Reference no: EM13483264

Questions Cloud

If fixed costs are 500000 and the unit contribution margin : 1. the debit to factory overhead for the cost of indirect materials is obtained from the summary of the materials

Jodi horton president of the retailer crestline products : jodi horton president of the retailer crestline products has just approached the companys bank with a request for a

Ernings rate of your retirement portfolio is 6 per year : earnings rate of your retirement portfolio is 6 per year. ? you will receive an annual raise on your salary of 3 per

The saunders investment bank has the following financing : the saunders investment bank has the following financing outstanding. what is the wacc for the company? debt 40000

Forest outfitters is a retailer that is preparing its : forest outfitters is a retailer that is preparing its budget for the upcoming fiscal year. management has prepared the

What is the net operating profit after taxes nopat for 2002 : you have just obtained financial information for the past 2 years for powell panther corporation. answer the following

What is the total amount of amortization expense that would : in early january burger mania acquired 100 of the common stock of the crispy taco restaurant chain. the purchase price

El tapitio purchased restaurant furniture on september 1 : el tapitio purchased restaurant furniture on september 1 2012 for 36400. residual value at the end of an estimated

Repair of damage incurred in reconditioning the press a : carl warren tina chester owns and operates pinebush print co. during september pinebrush print co. incurred the

User Account

All Pages