Rosey's Roses Cash Budget Prior Year 1 2 3 Operating activitie
Question # 00155664
Posted By:
Updated on: 12/19/2015 12:09 PM Due on: 01/18/2016

Rosey's Roses | |||||||
Cash Budget | Prior Year | 1 | 2 | 3 | |||
Operating activities | |||||||
Operating cash receipts | |||||||
Product sales revenue | 150,000 | ||||||
Collections in the year of sale | 127,500 | ||||||
Collections in the year following sale | 16,000 | ||||||
Operating cash receipts | 143,500 | ||||||
Operating cash payments | |||||||
Purchases | |||||||
Cost of expected sales | 90,000 | ||||||
Required ending inventory | 20,700 | ||||||
Beginning inventory | (18,000) | ||||||
Purchases | 92,700 | ||||||
Payments in the year of purchase | 83,430 | ||||||
Payments in the year following purchase | 6,000 | ||||||
Cash payments for purchases | 89,430 | ||||||
Expenses | |||||||
Advertising expense | 15,000 | ||||||
Interest expense | - | ||||||
Wages expense | 20,000 | ||||||
Supplies expense | 1,000 | ||||||
Utilities expense | 3,300 | ||||||
Expenses | 39,300 | ||||||
Operating cash payments | 128,730 | ||||||
Cash from (to) operating activities | 14,770 | ||||||
Investing activities | |||||||
Equipment purchases | |||||||
Equipment sales | |||||||
Cash from (to) investing activities | |||||||
Financing activities | |||||||
Loan proceeds | |||||||
Loan payments | |||||||
Cash from (to) financing activities | |||||||
Change in cash | 14,770 | ||||||
Beginning cash | 5,430 | ||||||
Ending cash | 20,200 | ||||||
Assumptions | |||||||
Sales growth each year | |||||||
Expense growth each year | |||||||
Collections in the year of sale | |||||||
Collections in the year following sale | |||||||
Payments in the year of purchase | |||||||
Payments in the year following purchase | |||||||
Cost of expected sales | |||||||
Required ending inventory | |||||||
Beginning inventory | |||||||
Interest expense | |||||||
Loan proceeds | |||||||
Annual loan payment | |||||||
Annual equipment purchases | |||||||
Annual equipment sales | |||||||
Year 1 equipment purchase | |||||||

-
Rating:
5/
Solution: Rosey's Roses Cash Budget Prior Year 1 2 3 Operating activitie