LASA 1—Genesis Cash Budget Report

profilesumahill

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 
  •  
    • 9 years ago
    • 25
    Answer(3)

    Purchase the answer to view it

    • attachment
      auo_b6022_m3_a2_cash_budget_1_explain.xlsx

    Purchase the answer to view it

    NOT RATED
    • attachment
      calculations_with_original_data.xlsx
    • attachment
      copy_of_copy_of_copy_of_auo_b6022_m3_a2_cash_budget.xlsx
    • attachment
      genesis_analysis-1.docx

    Purchase the answer to view it

    NOT RATED
    • attachment
      answer.zip