LASA 1—Genesis Cash Budget Report

LASA 1—Genesis Cash Budget Report

Question
	
The Genesis management team held a brainstorming session to chart a plan of action, which is detailed here.
Evaluate historical data and prepare assumptions that will drive the planning process.
Produce a detailed cash budget that summarizes cash inflow, outflow, and financing needs.
Identify and compare interest rates, both short-term and long-term, using debt and equity.
Analyze the financing mix (short/long) and the cost associated with the recommendation.

Sales: The marketing expert and the newly created customer service personnel developed sales projections based on historical data and forecast research.
Other cash receipt: Rental income $15,000 per month.
Production material: The production manager forecasted material cost based on cost quotes from reliable vendors, the average of which is 50 percent of sales.
Other production cost: Based on historical cost data, this cost on an average is 30 percent of the material cost and occurs in the month after material purchase.
Selling and marketing expense: Five percent of sales
General and administrative expense: Twenty percent of sales
Interest payments: Payable in December – $75, 000
Tax payments: Quarterly due 15th of April, July, October, and January – $15,000
Minimum cash balance desired: – $ 25,000 per month
Cash balance start of month (December):$15,000
Available short-term annual interest rate is 8 percent, long-term debt rate is 9 percent, and long-term equity is 10 percent. All funds would be available the first month when the firm encounters a deficit.
Dividend payment: None