Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cash flow budget excercise this is a cash flow budget excercise use the info in the first table(photo) to do the second and 3rd excell
Cash flow budget excercise
this is a cash flow budget excercise use the info in the first table(photo) to do the second and 3rd excell sheets
300 10% $20.00 60% 40% 310 10% $15.00 Information 1- Sales (units) a-Increase in sales from February 2-Sale price 3- Collection of sales Cash collections 30 day credit 4- Merchandise purchases (units) a- Increase in purchases from February 5- Purchase price 6- The provider allows you to pay: Cash payment 30 day credit 7- Administrative expenses 8- Monthly sales expenses 9-Depreciation of equipment and furniture 10 Loan (pay from February) a- Amortization b-interest February March 50% 50% $ 250.00 $ 230.00 $50.00 $ 2,100.00 $700.00 $ 504.00 $ 336.00 $ 168.00 April Cash Flow Budget januay febuary march april income Cash Sales Accounts Receivable Loan $ - $ $ $ - Total Income 1 Expenses Cash Purchases Debts to pay Administrative expenses Selling expenses TOTAL EXPENDITURE S - S - $ Economic Cash Flow $ $ S $ Amortization Interest Financial Cash Flow $ $ S $ Sales Budget january febuary march april units selling price TOTAL $0.00 $0.00 $0.00 $0.00 Collection Budget january febuary march april 60% counted 30 day credit 40% TOTAL $0.00 $0.00 $0.00 $0.00 Purchasing budget january febuary march april units purchase price TOTAL $0.00 $0.00 $0.00 $0.00 Payment Budget january febuary march april 50% counted 30 day credit 50% TOTAL $0.00 $0.00 $0.00 $0.00 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