Question: Try to complete this excel sheet . UU E3 > f 150% D H 1 150% 100% 150% June April May 50% August 70096 1508

 Try to complete this excel sheet . UU E3 > f

150% D H 1 150% 100% 150% June April May 50% August

70096 1508 September October 200% 30% November Decemt $325,000 $25,000 $350,000 3

Sales Percent Year 1 4 5 Beginning Cash Balance 6 Cash inflows

Try to complete this excel sheet .

UU E3 > f 150% D H 1 150% 100% 150% June April May 50% August 70096 1508 September October 200% 30% November Decemt $325,000 $25,000 $350,000 3 Sales Percent Year 1 4 5 Beginning Cash Balance 6 Cash inflows (Sales) 7 Total Cash 8 9 Cash Outflows (Expenses) 10 Rent 11 Utilities 12 Advertising 13 Inventory Purchases 14 Operating Supplies 15 Payroll 16 Payroll Expenses 17 Sales Commissions 18 Maintenance 19 Professional Fees 20 Communications Equp 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 75 Sheet1 Sheet $6,000 $500 $25,000 SO $600 $6,000 $2,000 $375 5800 $150 $200 $100 $500 $5,500 SO Sheets B D E 3 Sales Percent Year 1 150% June 150% April May $325,000 $25,000 $350,000 4 5 Beginning Cash Balance 6 Cash Inflows (Sales) 7 Total Cash 8 9 Cash Outflows (Expenses) 10 Rent 11 Utilities 12 Advertising 13 Inventory Purchases 14 Operating Supplies 15 Payroll 16 Payroll Expenses 17 Sales Commissions 18 Maintenance 19 Professional Fees 20 Communications Equp. 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 75 Citata! Sheet1 Sheet2 $6,000 $500 $25,000 $0 $600 $6,000 $2,000 $375 $800 $150 $200 $100 $500 $5,500 SO Sheets 11 - A A 29 Wrap Text General A.EE Merge & Center - $ -% - Clipboard Font Alignment Conditional Formatas Cell Formatting - Table - Styles Style Number 140 f G H 1 K 19 Professional Fees 20 Communications Equp. 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 25 Subtotal 26 Capital Purchases 27 Owner's Draw 28 Subtotal N9 Total Cash Outflows 30 Ending Cash Balance 31 32 Commissions 33 Taxes 34 Inventory 15% of Sales 35 Inventory 10% of Sales 30 37 3 39 D $150 $200 $100 $500 $5,500 SO $47,725 SO $3,500 $1,500 $51,225 $298.775 1 50% 2296 15% 10 Sheet1 Sheets File Home Insert Page Layout Formulas Data Keview at Calibri -11-AA | E-a-A- Paste BIU Clipboard Font Alignment E40 : D E B 19 Professional Fees 20 Communications Equp. 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 25 Subtotal 26 Capital Purchases 27 Owner's Draw 28 Subtotal 29 Total Cash Outflows 30 Ending Cash Balance 31 32 Commissions 33 Taxes 34 Inventory 15% of Sales 35 Inventory 10% of Sales 36 37 38 39 $150 $200 $100 $500 $5,500 $0 $47,725 $0 $3,500 $3,500 $51,225 $298,775 1.50% 2296 15% 10% 40 1 Sheet1 Sheet Sheet COM UU E3 > f 150% D H 1 150% 100% 150% June April May 50% August 70096 1508 September October 200% 30% November Decemt $325,000 $25,000 $350,000 3 Sales Percent Year 1 4 5 Beginning Cash Balance 6 Cash inflows (Sales) 7 Total Cash 8 9 Cash Outflows (Expenses) 10 Rent 11 Utilities 12 Advertising 13 Inventory Purchases 14 Operating Supplies 15 Payroll 16 Payroll Expenses 17 Sales Commissions 18 Maintenance 19 Professional Fees 20 Communications Equp 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 75 Sheet1 Sheet $6,000 $500 $25,000 SO $600 $6,000 $2,000 $375 5800 $150 $200 $100 $500 $5,500 SO Sheets B D E 3 Sales Percent Year 1 150% June 150% April May $325,000 $25,000 $350,000 4 5 Beginning Cash Balance 6 Cash Inflows (Sales) 7 Total Cash 8 9 Cash Outflows (Expenses) 10 Rent 11 Utilities 12 Advertising 13 Inventory Purchases 14 Operating Supplies 15 Payroll 16 Payroll Expenses 17 Sales Commissions 18 Maintenance 19 Professional Fees 20 Communications Equp. 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 75 Citata! Sheet1 Sheet2 $6,000 $500 $25,000 $0 $600 $6,000 $2,000 $375 $800 $150 $200 $100 $500 $5,500 SO Sheets 11 - A A 29 Wrap Text General A.EE Merge & Center - $ -% - Clipboard Font Alignment Conditional Formatas Cell Formatting - Table - Styles Style Number 140 f G H 1 K 19 Professional Fees 20 Communications Equp. 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 25 Subtotal 26 Capital Purchases 27 Owner's Draw 28 Subtotal N9 Total Cash Outflows 30 Ending Cash Balance 31 32 Commissions 33 Taxes 34 Inventory 15% of Sales 35 Inventory 10% of Sales 30 37 3 39 D $150 $200 $100 $500 $5,500 SO $47,725 SO $3,500 $1,500 $51,225 $298.775 1 50% 2296 15% 10 Sheet1 Sheets File Home Insert Page Layout Formulas Data Keview at Calibri -11-AA | E-a-A- Paste BIU Clipboard Font Alignment E40 : D E B 19 Professional Fees 20 Communications Equp. 21 Office Supplies 22 Business Phone 23 Taxes 24 Other 25 Subtotal 26 Capital Purchases 27 Owner's Draw 28 Subtotal 29 Total Cash Outflows 30 Ending Cash Balance 31 32 Commissions 33 Taxes 34 Inventory 15% of Sales 35 Inventory 10% of Sales 36 37 38 39 $150 $200 $100 $500 $5,500 $0 $47,725 $0 $3,500 $3,500 $51,225 $298,775 1.50% 2296 15% 10% 40 1 Sheet1 Sheet Sheet COM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!