Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare a Six-Week Cash Flow Forecast. Lloyd, Terry ABC COMPANY - P & L STATEMENT REVENUE Revenue $ 821,500 Discounts & Allowances $ (21,500) Total
Prepare a Six-Week Cash Flow Forecast.
Lloyd, Terry | ABC COMPANY - P & L STATEMENT | |
REVENUE | Revenue | $ 821,500 |
Discounts & Allowances | $ (21,500) | |
Total | $ 800,000 | |
COST OF GOODS | Direct labor | $ 202,210 |
Material Purchase | $ 292,500 | |
Sub Total | $ 494,710 | |
Operating Expenses | Accounting Fees | $ 6,000 |
Sales Commissions | $ 40,000 | |
Bank Fees | $ 4,450 | |
Equipment Maintenance | $ 18,690 | |
Repair & Maintenance | $ 21,250 | |
Rent | $ 30,000 | |
Dues & Subscriptions | $ 620 | |
Advertising | $ 7,500 | |
Freight out | $ 5,200 | |
Sub Total | $ 133,710 | |
Payroll | Administrative | $ 44,000 |
Management | $ 50,000 | |
Overtime | $ 13,600 | |
Payroll Taxes | $ 15,000 | |
Sub Total | $ 122,600 | |
Depreciation | Building | $ 20,000 |
Equipment | $ 16,000 | |
Vehicle | $ 8,000 | |
Sub Total | $ 44,000 | |
Total Operating Expenses | 300,310 | |
Other Expenses | Interest Expense | $ 4,000 |
Taxes | $ 800 | |
Discounts on Materials | $ (8,520) | |
Total Other Expenses | $ (3,720) | |
PROFIT OR LOSS | $ 8,700 |
Step by Step Solution
★★★★★
3.37 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
Forecasted Cash Flow ABC Company Six Weeks Period Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Beginnin...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
Document Format ( 1 attachment)
6501b75024a6f_110954.xlsx
300 KBs Excel File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started