Question
3. Fill in the blanks of Table 1: Monthly Cash Outflows and Table 2: Monthly Cash Inflows. Then, use the information to generate Table3: Pro-Forma
3. Fill in the blanks of Table 1: Monthly Cash Outflows and Table 2: Monthly Cash Inflows. Then, use the information to generate Table3: Pro-Forma Cash Flow Budget and answer the following questions. (10 points in total) Table 1: AgBiz Estimated Monthly Cash Outflows (Jan. Apr.) Item Jan Sales $12,000 Feb $10,000 Mar Apr Purchases($) $3,500 $8,000 $10,000 $15,000 Payment of $7,000 Account Payable Payment of $2,000 $2,000 $2,000 $2,000 Overhead Total Cash Outflows Inventory Levels $11,000 $11,500 Assumptions: 1. The inventory turnover rate is 6. 2. Inventory is equal to current month's purchases+previous month's purchases 3. Cost of goods sold-40% of sales 4. Account payable turnover ratio=12
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started