Question: Does someone know where i did wrong? Would someone help me and teach me how i would do this in excel? Requirement 2 : Cash

Does someone know where i did wrong?
Would someone help me and teach me how i would do this in excel?
Requirement 2:
Cash balance, beginning
Add receipts from customers
Total cash available
Less disbursements:
Merchandise purchases
Advertising
Rent
Salaries
Commissions (4% of sales)
Utilities
Equipment purchases
Dividends paid
Total disbursements
Excess (deficiency) of receipts over disbursements
Financing:
Borrowings
Repayments
Interest
Total financing
Cash balance, ending
EARRINGS UNLIMITED
Cash Budget
For the Three Months Ending June 30
\table[[April,May,June,Quarter],[$74,000,$50,000,$40,000,$74,000
 Does someone know where i did wrong? Would someone help me

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!