Forest outfitters is a retailer that is preparing its

Assignment Help Accounting Basics

Reference no: EM13577589

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	$ 411,000	$ 676,000	$ 428,000	$ 515,000
Total cash disbursements	$ 523,000	$ 403,000	$ 401,000	$ 490,000

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

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: EM13577589

Questions Cloud

The average number of phone calls at a particular phone : the average number of phone calls at a particular phone booth is 6 per hour. if someone arrives immediately ahead of

013 current liabilities short-term borrowings 250 accounts : the liabilities section of the companys most recent consolidated balance sheets is provided belowking cotton company

The producers of a new toothpaste claim that it prevents : the producers of a new toothpaste claim that it prevents more cavities than other brands of toothpaste. a random sample

You are considering an investment opportunity that would : you are considering an investment opportunity that would give you 20000 per year at the end of each of the next 5

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

A random sample of 33 adult men had a mean weight of 1825 : a random sample of 33 adult men had a mean weight of 182.5 pounds and a standard deviation of 22.5 pounds. find a 99

Assuming that the salaries of production managers with over : a sample of 9 production managers with over 15 years of experience has an average salary of 71000 and a sample standard

Bernice dies and under a will passes real estate to her : bernice dies and under a will passes real estate to her surviving husband. the real estate is subject to a mortgage.

The slots are normally distributed with length 10025 in : a pipe is normally distributed with mean length 25 in standard deviation 0.06 in. four are joined and fitted into a

User Account

All Pages