Answered step by step
Verified Expert Solution
Link Copied!

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, TerryABC COMPANY - P & L STATEMENT
REVENUERevenue $ 821,500

Discounts & Allowances $ (21,500)



Total
 $ 800,000



COST OF GOODSDirect labor $ 202,210

Material Purchase $ 292,500
Sub Total
 $ 494,710



Operating ExpensesAccounting 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



PayrollAdministrative $ 44,000

Management $ 50,000

Overtime $ 13,600

Payroll Taxes $ 15,000
Sub Total
 $ 122,600



DepreciationBuilding $ 20,000

Equipment $ 16,000

Vehicle $ 8,000
Sub Total
 $ 44,000



Total Operating Expenses300,310



Other ExpensesInterest 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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Document Format ( 1 attachment)

Excel file Icon
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

Recommended Textbook for

Managerial Accounting Creating Value in a Dynamic Business Environment

Authors: Ronald Hilton, David Platt

10th edition

78025664, 978-0078025662

More Books

Students also viewed these Accounting questions