Energy

profileepmitco64
Ennegy.xlsx
Home>Business & Finance homework help>Energy

M3,A2

M3, A2 Template
Genesis Cash Budget
Year 0
Argosy: Argosy: Note, the percentages used in Year0 may be different from those estimated in the budget.		 Monthly Cash Budget Year 1 Monthly Cash Budget Year 2
Dec Jan Feb March April May June July Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Inflow
Sales (Reference only) 300,000 350,000 350,000 400,000 400,000 300,000 350,000 450,000 550,000 600,000 700,000 750,000 600,000 550,000 500,000 450,000 450,000 450,000 500,000 550,000 600,000 750,000 800,000 800,000 600,000
Cash Collections on Sales
10% in month of sale 30,000
25% in first month after sale 75,000
35% in second month after sale 105,000
30% in third month after sale 90,000
Other Cash Receipts 12,500
Total Cash Inflow 312,500 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Cash Outflows
Material Purchases (Reference only) 150,000
Payment for Material Purchase
100% in month after purchase - 0 150,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Other Cash Payments:
Other production cost 30%
of Material cost paid month
after Purchase
Selling and Marketing Expense 15,000
General and Administrative expenses 60,000
Interest Payment 75,000
Tax Payment .
Dividend Payment - 0
Total Cash Outflows 150,000 150,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Net Cash Gain/(Loss) 162,500 (150,000) - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Cash Flow Summary
Cash Balance start of the month 10,000
Net Cash Gain/loss
Cash Balance at end of month 10,000
Minimum Cash Balance desired
Surplus cash (deficit)
External Financing Summary
External Financing Balance
at start of month - 0
New Financing Required
negative amount from cash
surplus (deficit)
External Financing Requirement
External Financing Balance

Sheet1