Question: Can anyone help me using formulas in excel please. The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget
Can anyone help me using formulas in excel please.
- The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget for July to December 2017. The staff has projected the following cash collections and payments:
| Month | Collections | Payments | |||
| Cash Sales | Credit Sales | Purchases | Wages | Miscellaneous Expenses | |
| July | $10,000 | $20,000 | $15,000 | $6000 | $1,500 |
| August | $12,000 | $24,000 | $18,000 | $7,200 | $2,000 |
| September | $14,000 | $28,000 | $21,000 | $8,400 | $2,500 |
| October | $16,000 | $32,000 | $24,000 | $9,600 | $3,000 |
| November | $20,000 | $40,000 | $30,000 | $12,000 | $4,000 |
| December | $25,000 | $50,000 | $37,500 | $15,000 | $4,500 |
- If the ending cash balance as of June 30, 2017 was $10,000, determine the firms forecasted monthly cash balance.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock